public DAL.Status GetByID(int ID) { SqlConnection Connection = DBGate.GetConnection(); string SelectByID = "Select * from Status where ID = @ID "; SqlCommand cmd = new SqlCommand(SelectByID, Connection); cmd.Parameters.AddWithValue("@ID", ID); Status _obj = new Status(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { _obj.ID = int.Parse(reader["ID"].ToString()); _obj._Status = reader["Status"].ToString(); _obj.Color = reader["Color"].ToString(); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(_obj); }
public List <Facilities> GetFacilitiesName() { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select Facilities.id , FacilitiesType.Name as TypeName , Facilities.FacilitiesName as FacilitiesName from Facilities join Facilitiestype on FacilitiesType.ID = Facilities.FacilitiesTypeID"; SqlCommand cmd = new SqlCommand(SelectAll, Connection); List <Facilities> lst = new List <Facilities>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Facilities _obj = new Facilities(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.FacilitiesType = reader["TypeName"].ToString(); _obj.FacilitiesName = reader["FacilitiesName"].ToString(); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
public List <Unites> GetUnitName() { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select Unites.id , UniteType.UniteName as TypeName , Unites.UnitName as UnitName "; SelectAll += " from Unites join UniteType on UniteType.ID = Unites.UnitTypeID "; SqlCommand cmd = new SqlCommand(SelectAll, Connection); List <Unites> lst = new List <Unites>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Unites _obj = new Unites(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.TypeName = reader["TypeName"].ToString(); _obj.UnitName = reader["UnitName"].ToString(); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
bool valdation() { if (txtPartnerName.Text == "" || txtPartnerName.Text == null) { frmDone frmdone = new frmDone("Please Enter Partner Name "); frmdone.ShowDialog(); return(false); } if (txtServerName.Text == "" || txtPartnerName.Text == null) { frmDone frmdone = new frmDone("Please Enter Server Name "); frmdone.ShowDialog(); return(false); } if (txtDBName.Text == "" || txtPartnerName.Text == null) { frmDone frmdone = new frmDone("Please Enter DataBase Name "); frmdone.ShowDialog(); return(false); } if (txtUser.Text == "" || txtPartnerName.Text == null) { frmDone frmdone = new frmDone("Please Enter User Name "); frmdone.ShowDialog(); return(false); } if (txtPassword.Text == "" || txtPartnerName.Text == null) { frmDone frmdone = new frmDone("Please Enter Password "); frmdone.ShowDialog(); return(false); } return(true); }
public DAL.AmenitiesOfUnits GetByUnitIDandAmenitiesID(int _UnitID, int _AmenitiesID) { SqlConnection Connection = DBGate.GetConnection(); string SelectByID = "Select * from AmenitiesOfUnits where UnitID =@UnitID and AmenitiesID=@AmenitiesID "; SqlCommand cmd = new SqlCommand(SelectByID, Connection); cmd.Parameters.AddWithValue("@UnitID", _UnitID); cmd.Parameters.AddWithValue("@AmenitiesID", _AmenitiesID); AmenitiesOfUnits _obj = new AmenitiesOfUnits(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { _obj.ID = int.Parse(reader["ID"].ToString()); _obj.UnitID = int.Parse(reader["UnitID"].ToString()); _obj.AmenitiesID = int.Parse(reader["AmenitiesID"].ToString()); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(_obj); }
public List <AmenitiesType> GetAll() { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select * from AmenitiesType "; SqlCommand cmd = new SqlCommand(SelectAll, Connection); List <AmenitiesType> lst = new List <AmenitiesType>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { AmenitiesType _obj = new AmenitiesType(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.Name = reader["AmenitiesName"].ToString(); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
// private void Save(object sender, EventArgs e) { Save(); frmDone frm = new frmDone("Saved Done"); frm.ShowDialog(); }
public List <Pictures> GetImageByUnitID(int _UniteID) { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select * from Pictures where UniteID=@UniteID "; SqlCommand cmd = new SqlCommand(SelectAll, Connection); cmd.Parameters.AddWithValue("@UniteID", _UniteID); List <Pictures> lst = new List <Pictures>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Pictures _obj = new Pictures(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.UniteID = int.Parse(reader["UniteID"].ToString()); byte[] ImgBytes = (byte[])reader["Image"]; System.IO.MemoryStream Ms = new System.IO.MemoryStream(ImgBytes); _obj.Image = System.Drawing.Image.FromStream(Ms); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
public List <Status> GetAll() { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select * from Status "; SqlCommand cmd = new SqlCommand(SelectAll, Connection); List <Status> lst = new List <Status>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Status _obj = new Status(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj._Status = reader["Status"].ToString(); _obj.Color = reader["Color"].ToString(); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
public bool Delete(int ID) { SqlConnection Connection = DBGate.GetConnection(); string Delete = "Delete from Status where ID=@ID "; SqlCommand cmd = new SqlCommand(Delete, Connection); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID", ID); try { Connection.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); return(false); } finally { Connection.Close(); } }
// bool Collect() { try { currentobj.UnittypeID = (int)CMBUnitType.SelectedValue; currentobj.UniteName = txtApartmentName.Text; currentobj.SmokingPolicy = true; currentobj.PoolPolicy = true; currentobj.Size = txtUniteSize.Text; currentobj.ApartmentNumber = int.Parse(txtApartmentNumber.Text); currentobj.GustNumber = int.Parse(txtGustNumber.Text); currentobj.BedRoomNumber = int.Parse(txtBedRoomNumber.Text); currentobj.LivingRoomNumber = int.Parse(txtLivingRoomNumber.Text); currentobj.BedKind = CMBBedKind.SelectedIndex; currentobj.BedNumber = int.Parse(txtBedNumber.Text); currentobj.SofaBedNumber = int.Parse(txtSofaBedNumber.Text); currentobj.BathroomNumber = int.Parse(txtBathroomNumber.Text); currentobj.PrivateBathRoomNumber = int.Parse(txtPrivateBathRoomNumber.Text); return(true); } catch (SqlException ex) { frmDone frm = new frmDone(ex.ToString()); frm.ShowDialog(); return(false); } }
public List <Amenities> GetAllByAmenitiesTypeID(int _AmenitiesTypeID) { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select * from Amenities where AmenitiesTypeID=@AmenitiesTypeID"; SqlCommand cmd = new SqlCommand(SelectAll, Connection); cmd.Parameters.AddWithValue("@AmenitiesTypeID", _AmenitiesTypeID); List <Amenities> lst = new List <Amenities>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Amenities _obj = new Amenities(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.AmenitiesName = reader["AmenitiesName"].ToString(); _obj.AmenitiesTypeID = int.Parse(reader["AmenitiesTypeID"].ToString()); _obj.Statuis = bool.Parse(reader["Statuis"].ToString()); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
void Save() { if (Valadations()) { if (Collect()) { if (ID == 0) { bool check = currentobj.Add(); if (check) { frmDone frm = new frmDone("Saved Done"); frm.ShowDialog(); } } else { currentobj.ID = ID; bool check = currentobj.Update(); if (check) { frmDone frm = new frmDone("Update Done"); frm.ShowDialog(); } } } } }
bool Push() { try { currentobj = currentobj.GetByID(ID); CMBUnitType.SelectedValue = currentobj.UnittypeID; txtApartmentName.Text = currentobj.UniteName; currentobj.SmokingPolicy = true; currentobj.PoolPolicy = true; txtUniteSize.Text = currentobj.Size; txtApartmentNumber.Text = currentobj.ApartmentNumber.ToString(); txtGustNumber.Text = currentobj.GustNumber.ToString(); txtBedRoomNumber.Text = currentobj.BedRoomNumber.ToString(); txtLivingRoomNumber.Text = currentobj.LivingRoomNumber.ToString(); CMBBedKind.SelectedIndex = 0; txtBedNumber.Text = currentobj.BedNumber.ToString(); txtSofaBedNumber.Text = currentobj.SofaBedNumber.ToString(); txtBathroomNumber.Text = currentobj.BathroomNumber.ToString(); txtPrivateBathRoomNumber.Text = currentobj.PrivateBathRoomNumber.ToString(); return(true); } catch (SqlException ex) { frmDone frm = new frmDone(ex.ToString()); frm.ShowDialog(); return(false); } }
public Users GetByUserID(int UserID) { SqlConnection con = DBGate.GetConnection(); string Get = "select * from file3 where num = @num"; SqlCommand cmd = new SqlCommand(Get, con); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@num", UserID); Users _obj = new Users(); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { _obj.num = int.Parse(reader["num"].ToString()); _obj.name = reader["name"].ToString(); _obj.pw1 = reader["pw1"].ToString(); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { con.Close(); } return(_obj); }
public List <Unites> GetByFloorID(int _FloorID) { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select * from Unites where FloorID = @FloorID "; SqlCommand cmd = new SqlCommand(SelectAll, Connection); cmd.Parameters.AddWithValue("@FloorID", _FloorID); List <Unites> lst = new List <Unites>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Unites _obj = new Unites(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.UnitTypeID = int.Parse(reader["UnitTypeID"].ToString()); _obj.FloorID = int.Parse(reader["FloorID"].ToString()); _obj.StatusID = int.Parse(reader["StatusID"].ToString()); _obj.UnitName = reader["UnitName"].ToString(); _obj.StatusReason = reader["StatusReason"].ToString(); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
public bool Add() { SqlConnection Connection = DBGate.GetConnection(); string Add = "INSERT into " + " Unites " + " ( " + " UnitTypeID " + " ,FloorID " + " ,UnitName " + " ,StatusID " + " ,StatusReason " + " ) " + "VALUES " + " ( " + " @UnitTypeID " + " ,@FloorID " + " ,@UnitName " + " ,@StatusID " + " ,@StatusReason " + " ) " + ""; SqlCommand cmd = new SqlCommand(Add, Connection); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@UnitTypeID", UnitTypeID); cmd.Parameters.AddWithValue("@FloorID", FloorID); cmd.Parameters.AddWithValue("@UnitName", UnitName); cmd.Parameters.AddWithValue("@StatusID", StatusID); cmd.Parameters.AddWithValue("@StatusReason", StatusReason); try { Connection.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); return(false); } finally { Connection.Close(); } }
public bool Add() { SqlConnection Connection = DBGate.GetConnection(); string Add = "INSERT into " + " Pictures " + " ( " + " Image " + " ,UniteID " + " ) " + "VALUES " + " ( " + " @Image " + " ,@UniteID " + " ) " + ""; SqlCommand cmd = new SqlCommand(Add, Connection); cmd.Parameters.Clear(); // System.IO.MemoryStream Mem = new System.IO.MemoryStream(); Image.Save(Mem, System.Drawing.Imaging.ImageFormat.Png); byte[] Data = new byte[Mem.Length]; Data = Mem.ToArray(); // cmd.Parameters.AddWithValue("@Image", Data); cmd.Parameters.AddWithValue("@UniteID", UniteID); try { Connection.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); return(false); } finally { Connection.Close(); } }
private void Save(object sender, EventArgs e) { if (valdation()) { Collect(); Properties.Settings.Default.Save(); frmDone frmdone = new frmDone("Saved Done "); frmdone.ShowDialog(); Push(); } else { frmDone frmdone = new frmDone("Sorry Not Allow To Update"); frmdone.ShowDialog(); } }
private void btnDelete_Click(object sender, EventArgs e) { bool msg = currentobj.Delete(ID); if (msg == true) { frmDone frmdone = new frmDone("Delete Done"); frmdone.ShowDialog(); BindGrid(); } else { frmDone frmdone = new frmDone("Error"); frmdone.ShowDialog(); } }
public bool Update() { SqlConnection Connection = DBGate.GetConnection(); string Update = "update Unites " + " Set " + " UnitTypeID =@UnitTypeID " + " ,FloorID =@FloorID " + " ,UnitName =@UnitName " + " ,StatusID =@StatusID " + " ,StatusReason =@StatusReason " + " where " + " ID =@ID "; SqlCommand cmd = new SqlCommand(Update, Connection); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID", ID); cmd.Parameters.AddWithValue("@UnitTypeID", UnitTypeID); cmd.Parameters.AddWithValue("@FloorID", FloorID); cmd.Parameters.AddWithValue("@UnitName", UnitName); cmd.Parameters.AddWithValue("@StatusID", StatusID); cmd.Parameters.AddWithValue("@StatusReason", StatusReason); try { Connection.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); return(false); } finally { Connection.Close(); } }
void Updated() { currentobj.Name = txtName.Text; currentobj.ID = ID; bool msg = currentobj.Update(); if (msg == true) { frmDone frmdone = new frmDone("Update Done"); frmdone.ShowDialog(); BindGrid(); } else { frmDone frmdone = new frmDone("Error"); frmdone.ShowDialog(); } }
void Add() { currentobj.Name = txtName.Text; bool msg = currentobj.Add(); if (msg == true) { frmDone frmdone = new frmDone("Saved Done"); frmdone.ShowDialog(); BindGrid(); } else { frmDone frmdone = new frmDone("Error"); frmdone.ShowDialog(); } }
public DAL.UniteDetails GetByID(int ID) { SqlConnection Connection = DBGate.GetConnection(); string SelectByID = "Select * from UniteDetails where ID = @ID "; SqlCommand cmd = new SqlCommand(SelectByID, Connection); cmd.Parameters.AddWithValue("@ID", ID); UniteDetails _obj = new UniteDetails(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { _obj.ID = int.Parse(reader["ID"].ToString()); _obj.UnittypeID = int.Parse(reader["UnittypeID"].ToString()); _obj.UniteName = reader["UniteName"].ToString(); _obj.SmokingPolicy = bool.Parse(reader["SmokingPolicy"].ToString()); _obj.PoolPolicy = bool.Parse(reader["PoolPolicy"].ToString()); _obj.Size = reader["Size"].ToString(); // _obj.ApartmentNumber = int.Parse(reader["ApartmentNumber"].ToString()); _obj.GustNumber = int.Parse(reader["GustNumber"].ToString()); _obj.BedRoomNumber = int.Parse(reader["BedRoomNumber"].ToString()); _obj.LivingRoomNumber = int.Parse(reader["LivingRoomNumber"].ToString()); _obj.BedKind = int.Parse(reader["BedKind"].ToString()); _obj.BedNumber = int.Parse(reader["BedNumber"].ToString()); _obj.SofaBedNumber = int.Parse(reader["SofaBedNumber"].ToString()); _obj.BathroomNumber = int.Parse(reader["BathroomNumber"].ToString()); _obj.PrivateBathRoomNumber = int.Parse(reader["PrivateBathRoomNumber"].ToString()); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(_obj); }
public DAL.Reservations GetByID(int ID) { SqlConnection Connection = DBGate.GetConnection(); string SelectByID = "Select * from Reservations where ID = @ID "; SqlCommand cmd = new SqlCommand(SelectByID, Connection); cmd.Parameters.AddWithValue("@ID", ID); Reservations _obj = new Reservations(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { _obj.ID = int.Parse(reader["ID"].ToString()); _obj.FirstName = reader["FirstName"].ToString(); _obj.LastName = reader["LastName"].ToString(); _obj.Mobile = reader["Mobile"].ToString(); _obj.UniteName = reader["UniteName"].ToString(); // _obj.CheckIn = DateTime.Parse(reader["CheckIn"].ToString()); _obj.CheckOut = DateTime.Parse(reader["CheckOut"].ToString()); _obj.Bookedon = DateTime.Parse(reader["Bookedon"].ToString()); _obj.Status = reader["Status"].ToString(); _obj.Days = int.Parse(reader["Days"].ToString()); // _obj.TotalPrice = double.Parse(reader["TotalPrice"].ToString()); _obj.Commission = double.Parse(reader["Commission"].ToString()); _obj.RoomNo = reader["RoomNo"].ToString(); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(_obj); }
// FrontOffice Frm public List <Reservations> Search(DateTime _CheckOut) { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select * from Reservations where CheckOut >= @Out "; SqlCommand cmd = new SqlCommand(SelectAll, Connection); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Out", _CheckOut); List <Reservations> lst = new List <Reservations>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Reservations _obj = new Reservations(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.FirstName = reader["FirstName"].ToString(); _obj.LastName = reader["LastName"].ToString(); _obj.Mobile = reader["Mobile"].ToString(); _obj.UniteName = reader["UniteName"].ToString(); // _obj.CheckIn = DateTime.Parse(reader["CheckIn"].ToString()); _obj.CheckOut = DateTime.Parse(reader["CheckOut"].ToString()); _obj.Bookedon = DateTime.Parse(reader["Bookedon"].ToString()); _obj.Status = reader["Status"].ToString(); _obj.Days = int.Parse(reader["Days"].ToString()); // _obj.TotalPrice = double.Parse(reader["TotalPrice"].ToString()); _obj.Commission = double.Parse(reader["Commission"].ToString()); _obj.RoomNo = reader["RoomNo"].ToString(); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
void Add() { currentobj.FacilitiesTypeID = int.Parse(CMBType.SelectedValue.ToString()); currentobj.FacilitiesName = txtName.Text; bool msg = currentobj.AddFacilities(); if (msg == true) { frmDone frmdone = new frmDone("Saved Done"); frmdone.ShowDialog(); BindGrid(); } else { frmDone frmdone = new frmDone("Error"); frmdone.ShowDialog(); } }
void Updated() { currentobj.AmenitiesTypeID = int.Parse(CMBType.SelectedValue.ToString()); currentobj.AmenitiesName = txtName.Text; currentobj.ID = ID; bool msg = currentobj.Update(); if (msg == true) { frmDone frmdone = new frmDone("Update Done"); frmdone.ShowDialog(); BindGrid(); } else { frmDone frmdone = new frmDone("Error"); frmdone.ShowDialog(); } }
public List <UniteDetails> GetAll() { SqlConnection Connection = DBGate.GetConnection(); string SelectAll = " select * from UniteDetails "; SqlCommand cmd = new SqlCommand(SelectAll, Connection); List <UniteDetails> lst = new List <UniteDetails>(); try { Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { UniteDetails _obj = new UniteDetails(); _obj.ID = int.Parse(reader["ID"].ToString()); _obj.UnittypeID = int.Parse(reader["UnittypeID"].ToString()); _obj.UniteName = reader["UniteName"].ToString(); _obj.SmokingPolicy = bool.Parse(reader["SmokingPolicy"].ToString()); _obj.PoolPolicy = bool.Parse(reader["PoolPolicy"].ToString()); _obj.Size = reader["Size"].ToString(); // _obj.ApartmentNumber = int.Parse(reader["ApartmentNumber"].ToString()); _obj.GustNumber = int.Parse(reader["GustNumber"].ToString()); _obj.BedRoomNumber = int.Parse(reader["BedRoomNumber"].ToString()); _obj.LivingRoomNumber = int.Parse(reader["LivingRoomNumber"].ToString()); _obj.BedKind = int.Parse(reader["BedKind"].ToString()); _obj.BedNumber = int.Parse(reader["BedNumber"].ToString()); _obj.SofaBedNumber = int.Parse(reader["SofaBedNumber"].ToString()); _obj.BathroomNumber = int.Parse(reader["BathroomNumber"].ToString()); _obj.PrivateBathRoomNumber = int.Parse(reader["PrivateBathRoomNumber"].ToString()); lst.Add(_obj); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); } finally { Connection.Close(); } return(lst); }
public bool AddFacilities() { SqlConnection Connection = DBGate.GetConnection(); string Add = "INSERT into " + " AmenitiesType " + " ( " + " Name " + " ) " + "VALUES " + " ( " + " @Name " + " ) " + ""; SqlCommand cmd = new SqlCommand(Add, Connection); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Name", Name); try { Connection.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { frmDone frmerror = new frmDone(ex.ToString()); frmerror.ShowDialog(); return(false); } finally { Connection.Close(); } }