public string DeleteAll(DTO_CTDV obj)
{
string query = string.Empty;
query += " DELETE FROM [TBL_CTDV] ";
query += " WHERE ";
query += " [MACTHD] = @MACTHD ";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@MACTHD", obj.Macthd);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
return("Deleting fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
private void bt_Them_Click(object sender, EventArgs e)
{
List <DTO_DichVu> lsobj_dv = new List <DTO_DichVu>();
string result = this.bus_dv.SelectAll(lsobj_dv);
var selectitemDV = from x in lsobj_dv
where x.Tendv == DropDown_DV.selectedValue
select new
{
MaDV = x.Madv,
TenDV = x.Tendv,
GiaDV = x.Giadv
};
foreach (var item in selectitemDV)
{
DTO_CTDV obj_ctdv = new DTO_CTDV();
obj_ctdv.Macthd = get_MaCTHD;
obj_ctdv.Madv = item.MaDV;
if (bus_ctdv.Insert(obj_ctdv) != "0")
{
MessageBox.Show("Đã thêm dịch vụ này", "Lỗi thêm dịch vụ");
return;
}
GUI_NghiepVuPhong.GUI_ListDV x1DV = new GUI_NghiepVuPhong.GUI_ListDV();
x1DV.lb_MaDV.Text = item.MaDV;
x1DV.lb_TenDV.Text = item.TenDV;
x1DV.lb_GiaDV.Text = item.GiaDV;
panel_ListDV.Controls.Add(x1DV);
x1DV.Dock = DockStyle.Top;
x1DV.Message = obj_ctdv.Macthd;
}
}
public string Insert(DTO_CTDV obj)
{
string query = string.Empty;
query += "INSERT INTO [TBL_CTDV] ([MACTHD], [MADV] ) ";
query += "VALUES (@MACTHD, @MADV)";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@MACTHD", obj.Macthd);
comm.Parameters.AddWithValue("@MADV", obj.Madv);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
return("Adding fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
private void bt_Huy_Click(object sender, EventArgs e)
{
if (txb_MaKH.Text == "")
{
MessageBox.Show("Chưa nhập thông tin đơn đặt phòng cần hủy", "Erro");
return;
}
DTO_CTHD obj_cthd = new DTO_CTHD();
DTO_CTDV obj_ctdv = new DTO_CTDV();
DTO_HoaDon obj_hd = new DTO_HoaDon();
obj_hd.MaCTHD = get_MACTHD;
obj_ctdv.Macthd = get_MACTHD;
obj_cthd.Macthd = get_MACTHD;
if (bus_ctdv.DeleteAll(obj_ctdv) != "0")
{
MessageBox.Show("Huy phong that bai");
return;
}
if (bus_hd.Delete(obj_hd) != "0")
{
MessageBox.Show("Huy phong that bai");
return;
}
if (bus_cthd.Delete(obj_cthd) != "0")
{
MessageBox.Show("Huy phong that bai");
return;
}
List <DTO_LoaiPhong> lsobj_lp = new List <DTO_LoaiPhong>();
List <DTO_Phong> lsobj_p = new List <DTO_Phong>();
string result = bus_p.SelectAll(lsobj_p);
string result1 = bus_lp.SelectAll(lsobj_lp);
var Malp = from x in lsobj_p
join y in lsobj_lp on x.Malp equals y.Malp
where x.Sophong == txb_SoPhong.Text
select new
{
SoPhong = x.Sophong,
TrangThai = "EMPTY",
MaLP = x.Malp,
};
DTO_Phong objp = new DTO_Phong();
foreach (var x in Malp)
{
objp.Sophong = x.SoPhong;
objp.Malp = x.MaLP;
objp.Status = x.TrangThai;
}
bus_p.Update(objp);
MessageBox.Show("Huy phong thanh cong");
}
private void bt_Xoa_Click(object sender, EventArgs e)
{
DTO_CTDV obj_ctdv = new DTO_CTDV();
obj_ctdv.Macthd = this.Message;
obj_ctdv.Madv = lb_MaDV.Text;
if (bus_ctdv.Delete(obj_ctdv) != "0")
{
MessageBox.Show("Lỗi xóa dịch vụ");
return;
}
this.Hide();
}
private void pictureBox1_Click(object sender, EventArgs e)
{
page_DatPhong.SetPage(1);
if (kt_DatPhong == true)
{
return;
}
else
{
DTO_CTDV obj = new DTO_CTDV();
obj.Macthd = get_MaCTHD;
bus_ctdv.DeleteAll(obj);
panel_ListDV.Controls.Clear();
}
}
public string selectAll(List <DTO_CTDV> lsObj)
{
string query = string.Empty;
query += "SELECT * FROM TBL_CTDV";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
try
{
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
if (reader.HasRows == true)
{
lsObj.Clear();
while (reader.Read())
{
DTO_CTDV obj = new DTO_CTDV();
obj.Madv = reader["MADV"].ToString();
obj.Macthd = reader["MACTHD"].ToString();
lsObj.Add(obj);
}
}
}
catch (Exception ex)
{
conn.Close();
return("Selecting fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
