private void okbutton_Click(object sender, EventArgs e)
{
CSVC_DTO obj = new CSVC_DTO();
if (maptext.Text != "")
{
obj.MaPhong = Convert.ToInt32(maptext.Text);
}
obj.TenPhong = tenptext.Text;
obj.Tang = Convert.ToInt32(tangbox.SelectedItem);
obj.MaLoaiPhong = Convert.ToInt32(loaipbox.SelectedValue);
if (radio1.Checked == true)
{
obj.TrangThai = true;
}
else
{
obj.TrangThai = false;
}
obj.NgaySuDung = ngaypicker.Value;
if (OKclick != null)
{
OKclick.Invoke(obj);
}
this.Close();
}
public CSVC_DTO GetF_DAL(int id)
{
CSVC_DTO s = new CSVC_DTO();
string query = "select * from dbo.CSVC where MaPhong = " + id.ToString();
DataTable dt = helpF.GetTable(query);
s = GetF_DAL(dt.Rows[0]);
return(s);
}
private void AddCSVC(CSVC_DTO obj)
{
//CSVC_DTO i = new CSVC_DTO();
//i.TenPhong = obj.TenPhong;
//i.Tang = obj.Tang;
//i.MaLoaiPhong = obj.MaLoaiPhong;
//i.TrangThai = obj.TrangThai;
//i.NgaySuDung = obj.NgaySuDung;
blf.AddF_BLL(obj);
ShowData(blf.GetListF_BLL());
}
public CSVC_DTO GetF_DAL(DataRow d)
{
CSVC_DTO s = new CSVC_DTO();
s.MaPhong = Convert.ToInt32(d["MaPhong"]);
s.TenPhong = d["TenPhong"].ToString();
s.Tang = Convert.ToInt32(d["Tang"]);
s.MaLoaiPhong = Convert.ToInt32(d["MaLoaiPhong"]);
s.TrangThai = Convert.ToBoolean(d["TrangThai"]);
s.NgaySuDung = Convert.ToDateTime(d["NgaySuDung"]);
return(s);
}
public void AddF_DAL(CSVC_DTO i)
{
string query = "insert into dbo.CSVC values (@tenp,@tang,@malp,@tthai,@nsd)";
SqlCommand cmd = new SqlCommand(query, helpF.data);
cmd.Parameters.AddWithValue("@tenp", i.TenPhong);
cmd.Parameters.AddWithValue("@tang", i.Tang);
cmd.Parameters.AddWithValue("@malp", i.MaLoaiPhong);
cmd.Parameters.AddWithValue("@tthai", i.TrangThai);
cmd.Parameters.AddWithValue("@nsd", i.NgaySuDung);
helpF.ExcuteDB(cmd);
}
public void UpdateF_DAL(CSVC_DTO i)
{
string query = "update dbo.CSVC set TenPhong=@tenp,Tang=@tang,MaLoaiPhong=@malp,TrangThai=@tthai,NgaySuDung=@nsd where MaPhong=@map";
SqlCommand cmd = new SqlCommand(query, helpF.data);
cmd.Parameters.AddWithValue("@map", i.MaPhong);
cmd.Parameters.AddWithValue("@tenp", i.TenPhong);
cmd.Parameters.AddWithValue("@tang", i.Tang);
cmd.Parameters.AddWithValue("@malp", i.MaLoaiPhong);
cmd.Parameters.AddWithValue("@tthai", i.TrangThai);
cmd.Parameters.AddWithValue("@nsd", i.NgaySuDung);
helpF.ExcuteDB(cmd);
}
public void Show(int id)
{
CSVC_DTO room = blf.GetF_BLL(id);
maptext.Text = room.MaPhong.ToString();
tenptext.Text = room.TenPhong.ToString();
tangbox.SelectedItem = tangbox.Items[tangbox.Items.IndexOf(room.Tang.ToString())];
loaipbox.SelectedValue = room.MaLoaiPhong;
if (room.TrangThai == true)
{
radio1.Checked = true;
}
else
{
radio2.Checked = true;
}
ngaypicker.Value = room.NgaySuDung;
}
public void UpdateF_BLL(CSVC_DTO i)
{
daf.UpdateF_DAL(i);
}
public void AddF_BLL(CSVC_DTO i)
{
daf.AddF_DAL(i);
}
private void UpdateCSVC(CSVC_DTO obj)
{
blf.UpdateF_BLL(obj);
ShowData(blf.GetListF_BLL());
}
