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();
}
}
