#region AddRoom
        public bool AddRoom(AddRoomDetails Add)
        {
            SqlConnection con = new SqlConnection(@"server=DESKTOP-MS05MM5\SQLEXPRESS;Integrated Security=True;Database=abc");
            SqlCommand cmd = new SqlCommand("uspaddroom",con);
            SqlParameter p1=cmd.Parameters.Add("@RoomName",SqlDbType.VarChar,30);
            SqlParameter p2=cmd.Parameters.Add("@RoomType",SqlDbType.VarChar,30);
             SqlParameter p3=cmd.Parameters.Add("@City",SqlDbType.VarChar,30);
             SqlParameter p4=cmd.Parameters.Add("@Location",SqlDbType.VarChar,30);
             SqlParameter p5=cmd.Parameters.Add("@Block",SqlDbType.VarChar,30);
             SqlParameter p6=cmd.Parameters.Add("@Address",SqlDbType.VarChar,50);
             SqlParameter p7=cmd.Parameters.Add("@CoordinatorName",SqlDbType.VarChar,30);
             SqlParameter p8=cmd.Parameters.Add("@SeatingCapacity",SqlDbType.Int);
             SqlParameter p9=cmd.Parameters.Add("@TableType",SqlDbType.VarChar,30);
             SqlParameter p10=cmd.Parameters.Add("@NoOfMachines",SqlDbType.Int);
             SqlParameter p11=cmd.Parameters.Add("@Facilities",SqlDbType.VarChar,30);
             SqlParameter p12=cmd.Parameters.Add("@Remarks",SqlDbType.VarChar,30);
             SqlParameter p13=cmd.Parameters.Add("@NoOfParticipants",SqlDbType.Int);
            p1.Value=Add.RoomName;
            p2.Value=Add.RoomType;
            p3.Value=Add.City;
            p4.Value=Add.Location;
            p5.Value=Add.Block;
            p6.Value=Add.Address;
            p7.Value=Add.CoordinatorName;
            p8.Value=Convert.ToInt32(Add.SeatingCapacity);
            p9.Value=Add.TableType;
            p10.Value=Convert.ToInt32(Add.NoOfMachines);
            p11.Value=Add.Facilities;
            p12.Value=Add.Remark;
            p13.Value=Convert.ToInt32(Add.NoOfParticipants);
            con.Open();
            cmd.CommandType = CommandType.StoredProcedure;

            }
        #endregion
    }