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);
}
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 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 <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);
}
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();
}
}
private void Start()
{
searchBox.TextChanged += (s, a) => Behavior.LightRowsForSearch(dataGridView1, searchBox);
searchBox.Enter += (s, a) => Behavior.PrepareForEnterText(searchBox);
searchBox.Leave += (s, a) => Behavior.ResetEnterText(searchBox);
teacherBox.DataSource = DBGate.GetColumnFromDB(Properties.Settings.Default.ConnectionString, "select login from Users where role = 3");
yearBox.DataSource = DBGate.GetColumnFromDB(Properties.Settings.Default.ConnectionString, "select name from Years where ID <> '12'");
classBox.DataSource = DBGate.GetColumnFromDB(Properties.Settings.Default.ConnectionString, "select name from Classes");
teachersList.DataSource = DBGate.GetColumnFromDB(Properties.Settings.Default.ConnectionString,
"select login from Users where role = '3' and (select count (*) from Teachers where Teachers.userID = Users.ID) = 0");
string query =
"select " +
"ID as 'ID', " +
"(select login from Users where Users.ID = Teachers.userID) as 'Логин', " +
"(select name from Users where Users.ID = Teachers.userID) as 'Имя', " +
"yearID as 'Год', " +
"(select name from Classes where Classes.ID = Teachers.classID) as 'Класс' " +
"from Teachers";
DataSet ds = DBGate.GetFilledDataSet(Properties.Settings.Default.ConnectionString, query);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[0].Visible = false;
}
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 <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 <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 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);
}
private void deleteCurrentRow_Click(object sender, EventArgs e)
{
try
{
string query = $"delete from Teachers where ID = '{dataGridView1.CurrentRow.Cells[0].Value.ToString()}'";
DBGate.NonQuery(Properties.Settings.Default.ConnectionString, query);
Start();
}
catch { }
}
private bool CheckEnter(string teacherID, string classID)
{
if (IsTeacherExist(teacherID))
{
string currentClass = "";
string query = $"select yearID from Teachers where userID = '{teacherID}'";
currentClass += DBGate.Scalar(Properties.Settings.Default.ConnectionString, query);
query = $"select name from Classes where ID = (select classID from Teachers where userID = '{teacherID}')";
currentClass += DBGate.Scalar(Properties.Settings.Default.ConnectionString, query);
DialogResult dr = new DialogResult();
dr = MessageBox.Show(
"Этот преподаватель уже умеет классное руководство в " +
$"{currentClass}.\r\n" +
"Каждый преподаватель может вести только один класс. \r\n" +
"Удалить существующую запись? (текущий класс останется без руководителя)",
"Запись существует",
MessageBoxButtons.YesNo,
MessageBoxIcon.Information);
if (dr == DialogResult.Yes)
{
query = $"delete from Teachers where userID = '{teacherID}'";
DBGate.NonQuery(Properties.Settings.Default.ConnectionString, query);
}
else
{
return(false);
}
}
if (IsClassExist(classID))
{
string currentTeacher = "";
string query = $"select (select login from Users where ID = Teachers.userID), userID from Teachers where classID = '{classID}' and yearID = '{yearBox.Text}'";
currentTeacher = DBGate.Scalar(Properties.Settings.Default.ConnectionString, query);
DialogResult dr = new DialogResult();
dr = MessageBox.Show(
"У выбранного класса уже есть классный руководитель, это " +
$"{currentTeacher}\r\n" +
"Удалить существующую запись?",
"Запись существует",
MessageBoxButtons.YesNo,
MessageBoxIcon.Information
);
if (dr == DialogResult.Yes)
{
query = $"delete from Teachers where classID = '{classID}' and yearID = '{yearBox.Text}'";
DBGate.NonQuery(Properties.Settings.Default.ConnectionString, query);
}
else
{
return(false);
}
}
return(true);
}
private void ActivatorClick(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows[0] != null)
{
int index = dataGridView1.SelectedRows[0].Index;
bool isTrue = (bool)dataGridView1.SelectedRows[0].Cells[5].Value;
DBGate.NonQuery(Properties.Settings.Default.ConnectionString,
$"update Users set active = {Convert.ToByte(!isTrue)} where ID = {dataGridView1.SelectedRows[0].Cells[0].Value}");
Start();
dataGridView1.Rows[index].Selected = true;
}
}
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();
}
}
private void payButton_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows[0] != null)
{
int index = dataGridView1.SelectedRows[0].Index;
bool isTrue = (bool)dataGridView1.SelectedRows[0].Cells[6].Value;
DBGate.NonQuery(Properties.Settings.Default.ConnectionString,
$"update Students set paySumm = {Convert.ToDouble(dataGridView1.SelectedRows[0].Cells[5].Value) - Convert.ToInt32(paySumm.Value)} where ID = {dataGridView1.SelectedRows[0].Cells[0].Value}");
Start();
dataGridView1.Rows[index].Selected = true;
}
}
private bool IsClassExist(string classID)
{
string query = $"select count(*) from Teachers where classID = '{classID}' and yearID = '{yearBox.Text}'";
if (Convert.ToInt32(DBGate.Scalar(Properties.Settings.Default.ConnectionString, query)) > 0)
{
return(true);
}
else
{
return(false);
}
}
private bool IsTeacherExist(string teacherID)
{
string query = $"select count(*) from Teachers where userID = '{teacherID}'";
if (Convert.ToInt32(DBGate.Scalar(Properties.Settings.Default.ConnectionString, query)) > 0)
{
return(true);
}
else
{
return(false);
}
}
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 Start()
{
Behavior.ResetEnterText(searchBox);
string query = "select ID as 'ID', " +
"login as 'Логин', " +
"password as 'Пароль', " +
"name as 'Имя', " +
"(select name from Roles where Roles.ID = Users.role) as 'Роль', " +
"active as 'Статус учетной записи' " +
"from Users";
DataSet ds = DBGate.GetFilledDataSet(Properties.Settings.Default.ConnectionString, query);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[0].Visible = false;
}
private bool InsertNewRow(string teacherID, string classID)
{
string query =
$"insert into Teachers (userID, yearID, classID) " +
$"values('{teacherID}', '{yearBox.Text}', '{classID}')";
Exception result = DBGate.NonQuery(Properties.Settings.Default.ConnectionString, query);
if (result != null)
{
MessageBox.Show(
$"Ошибка при добавлении.\r\n" +
$"{result.Message}",
"Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Information); return(false);
}
return(true);
}
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();
}
}
private void OK_Click(object sender, EventArgs e)
{
string query = $"select ID from Users where login = '******'";
string teacherID = DBGate.Scalar(Properties.Settings.Default.ConnectionString, query);
query = $"select ID from Classes where name = '{classBox.Text}'";
string classID = DBGate.Scalar(Properties.Settings.Default.ConnectionString, query);
if (CheckEnter(teacherID, classID))
{
InsertNewRow(teacherID, classID);
}
else
{
MessageBox.Show("Добавление невозможно.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
Start();
}
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);
}
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();
}
}
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 void Start()
{
searchBox.TextChanged += (s, a) => Behavior.LightRowsForSearch(dataGridView1, searchBox);
searchBox.Enter += (s, a) => Behavior.PrepareForEnterText(searchBox);
searchBox.Leave += (s, a) => Behavior.ResetEnterText(searchBox);
searchButton.Click += (s, a) => Behavior.DelRowsForSearch(dataGridView1, searchBox, comboBox1.Text);
Behavior.ResetEnterText(searchBox);
DataSet ds = DBGate.GetFilledDataSet(Properties.Settings.Default.ConnectionString, query);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[0].Visible = false;
comboBox1.Items.Clear();
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
comboBox1.Items.Add(dataGridView1.Columns[i].HeaderText);
}
comboBox1.SelectedIndex = 1;
}
