private void btBill_Click(object sender, EventArgs e)
{
DTO_HoaDon HoaDonFinal = (from DataRow dr in busBan.dtHoaDonTam(busBan.curBan(lbViTriBan.Text)).Rows
where string.Compare(dr[0].ToString(), hd.MaHD, true) == 0
select new DTO_HoaDon(dr[0].ToString(), NV.MaNV, (int)dr[1], float.Parse(dr[3].ToString()), dr[4].ToString())).FirstOrDefault();
HoaDonFinal.ThanhTien = (busBan.TongTienHDTam(hd) - busBan.TongTienHDTam(hd) * hd.KhuyenMai / 100);
if (string.IsNullOrWhiteSpace(HoaDonFinal.SDT_KH))
{
busBan.ThemHDFinalNoneKH(HoaDonFinal);
}
else
{
busBan.ThemHoaDonFinal(HoaDonFinal);
}
foreach (DataRow dr in busBan.dtHDCTFinal(hd.MaHD).Rows)
{
DTO_CTHD cthd = new DTO_CTHD(dr[0].ToString(), dr[1].ToString(), int.Parse(dr[2].ToString()));
DTO_Ban Ban = busBan.curBan(lbViTriBan.Text);
if (busBan.ThemCTHDFinal(cthd))
{
busBan.UpdateTrangThaiBan(Ban, 0);
(flpkvBan.Controls[IndexBan].Controls[0] as PictureBox).Image = Image.FromFile(startupPath + @"\image\banDong.png");
}
}
crtBaoCao();
busBan.ClearTemp(hd.MaHD);
txtSDTKH.Text = null;
FormKhuVucBan_Load(sender, e);
}
private void btRemove1_Click(object sender, EventArgs e)
{
if (dgvHDCT.Rows.Count > 1)
{
dgvHDCT.CurrentRow.Selected = true;
int rowindex = dgvHDCT.SelectedRows[0].Index;
DTO_ThucDon selectTD = busTD.curTD(dgvHDCT.Rows[rowindex].Cells["Column1"].FormattedValue.ToString());
if (busBan.DeleteCTHDSoluong(lbMaHD.Text, selectTD.MaTD, 1))
{
try
{
DTO_CTHD curCTHD = busBan.curCTHD(lbMaHD.Text, selectTD.MaTD);
if (!(curCTHD is null))
{
dgvHDCT.ReadOnly = false;
dgvHDCT.SelectedRows[0].Cells["Column2"].Value = curCTHD.SoLuong;
dgvHDCT.ReadOnly = true;
}
else
{
LoadCTHD();
if (dgvHDCT.Rows.Count > 1)
{
dgvHDCT.CurrentRow.Selected = true;
selectTD = busTD.curTD(dgvHDCT.SelectedRows[0].Cells[0].FormattedValue.ToString());
}
}
}
private void btOK_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Gộp " + OldBan.TenBan + " vào " + cbBan.Text + "?", "Confirm",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DTO_HoaDon oldHD = busBan.curhd(OldBan);
DTO_Ban NewBan = busBan.curBan(cbBan.Text);
DTO_HoaDon newHD = busBan.curhd(NewBan);
DataTable dtCTHDOld = busBan.CTHDtheoMaHD(oldHD.MaHD);
foreach (DataRow dr in dtCTHDOld.Rows)
{
DTO_CTHD cthd = new DTO_CTHD(newHD.MaHD, dr[1].ToString(), (int)dr[2]);
busBan.ThemCTHDTam(cthd).ToString();
busBan.DeleteCTHDSoluong(dr[0].ToString(), dr[1].ToString(), (int)dr[2]);
}
FormKhuVucBan.IndexBan = NewBan.IdBan - 1;
busBan.UpdateTrangThaiBan(OldBan, 0);
busBan.ClearTemp(oldHD.MaHD);
this.Close();
}
}
public bool ThemChiTietHoaDonTam(DTO_CTHD cthd)
{
try
{
_conn.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = _conn;
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "sp_themCTHDTam";
cm.Parameters.AddWithValue("MaHD", cthd.MaHD);
cm.Parameters.AddWithValue("MaTD", cthd.MaTD);
cm.Parameters.AddWithValue("SoLuong", cthd.SoLuong);
cm.Parameters.AddWithValue("MoTa", DBNull.Value);
if (cm.ExecuteNonQuery() > 0)
{
return(true);
}
}
finally
{
_conn.Close();
}
return(false);
}
//delete
private void pictureBox2_Click(object sender, EventArgs e)
{
page_DatPhong.SetPage(0);
if (kt_DatPhong == true)
{
return;
}
else
{
DTO_CTHD obj_cthd = new DTO_CTHD();
obj_cthd.Macthd = get_MaCTHD;
if (bus_cthd.Delete(obj_cthd) != "0")
{
MessageBox.Show("Lỗi");
}
//delete cthd
DTO_KhachHang obj_kh = new DTO_KhachHang();
obj_kh.Makh = txb_MaKH.Text;
if (bus_kh.Delete(obj_kh) != "0")
{
MessageBox.Show("Lỗi");
}
// delete kh
//update phong
objp.Status = "EMPTY";
bus_p.Update(objp);
}
}
public string Update(DTO_CTHD obj)
{
string query = string.Empty;
query += " UPDATE [TBL_CTHD] SET";
query += " [SOPHONG] = @SOPHONG";
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);
comm.Parameters.AddWithValue("@SOPHONG", obj.Sophong);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
return("Updating 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 btAdd1_Click(object sender, EventArgs e)
{
DTO_CTHD curCTHD = new DTO_CTHD(lbMaHD.Text, TD.MaTD, 1);
busBan.ThemCTHDTam(curCTHD);
LoadCTHD();
lbTongTien.Text = (busBan.TongTienHDTam(hd) - busBan.TongTienHDTam(hd) * hd.KhuyenMai / 100).ToString();
}
public DTO_CTHD curCTHD(string MaHD, string MaTD)
{
DTO_CTHD cthd = (from DataRow dr in dalBan.CTHD(MaHD, MaTD).Rows
select new DTO_CTHD
{
MaHD = dr[0].ToString(),
MaTD = dr[1].ToString(),
SoLuong = (int)dr[2]
}).FirstOrDefault();
return(cthd);
}
public string Search(string kq, List <DTO_CTHD> lsObj)
{
string query = string.Empty;
query += " SELECT [MAHD], [NGAYTHANHTOAN], [TRATRUOC], [MANV]";
query += " FROM [TBL_HOADON]";
query += " WHERE";
query += " [MAHD] = @MAHD ";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@MAHD", "%" + kq.ToString() + "%");
try
{
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
if (reader.HasRows == true)
{
lsObj.Clear();
while (reader.Read())
{
DTO_CTHD obj = new DTO_CTHD();
obj.Macthd = reader["MACTHD"].ToString();
obj.Makh = reader["MAKH"].ToString();
obj.Ngaynhanphong = reader["NGAYNHANPHONG"].ToString();
obj.Ngaydi = reader["NGAYDI"].ToString();
obj.Sophong = reader["SOPHONG"].ToString();
obj.Tratruoc = reader["TRATRUOC"].ToString();
lsObj.Add(obj);
}
}
}
catch (Exception ex)
{
conn.Close();
return("Searching fail fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
//Delete Chi Tiet Hoa Don
public bool DeleteCTHD(DTO_CTHD a)
{
try
{
CT_HD delete = db.CT_HDs.Where(p => p.MaHD == a.MaHD && p.MaHang == a.MaH).SingleOrDefault();
db.CT_HDs.DeleteOnSubmit(delete);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
private void btnSuaCTHD_Click(object sender, EventArgs e)
{
try
{
int tt = (int.Parse(txtThanhTien.Text));
DTO_CTHD cthd = new DTO_CTHD(int.Parse(txtMaHD.Text), int.Parse(cboTSP.SelectedValue.ToString()), int.Parse(num_SL.Value.ToString()), int.Parse(txtGiaBan.Text), tt);
bshd.UpdateCTHD(cthd);
XtraMessageBox.Show("Sửa thành công.");
gdvCTHD.DataSource = bshd.getCTHD(int.Parse(txtMaHD.Text));
}
catch
{
XtraMessageBox.Show("Sửa thất bại.");
}
}
//Update Chi Tiet Hoa Don
public bool UpdateCTHD(DTO_CTHD a)
{
try
{
CT_HD update = db.CT_HDs.Where(p => p.MaHD == a.MaHD && p.MaHang == a.MaH).SingleOrDefault();
update.SLBan = a.SLBan;
update.GiaBan = a.GiaBan;
update.ThanhTien = a.ThanhTien;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public string selectAll(List <DTO_CTHD> lsObj)
{
string query = string.Empty;
query += "SELECT * FROM TBL_CTHD";
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_CTHD obj = new DTO_CTHD();
obj.Macthd = reader["MACTHD"].ToString();
obj.Makh = reader["MAKH"].ToString();
obj.Manv = reader["MANV"].ToString();
obj.Ngaynhanphong = reader["NGAYNHANPHONG"].ToString();
obj.Ngaydi = reader["NGAYDI"].ToString();
obj.Sophong = reader["SOPHONG"].ToString();
obj.Tratruoc = reader["TRATRUOC"].ToString();
lsObj.Add(obj);
}
}
}
catch (Exception ex)
{
conn.Close();
return("Selecting fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
//insert chi tiet hoa don
public bool InsertCTHD(DTO_CTHD a)
{
try
{
CT_HD insert = new CT_HD();
insert.MaHD = a.MaHD;
insert.MaHang = a.MaH;
insert.SLBan = a.SLBan;
insert.GiaBan = a.GiaBan;
insert.ThanhTien = a.ThanhTien;
db.CT_HDs.InsertOnSubmit(insert);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
private void btnThemCTHD_Click(object sender, EventArgs e)
{
try
{
bool bien = true;
for (int i = 0; i < gdvCTHD.Rows.Count - 1; i++)
{
string masp = gdvCTHD.Rows[i].Cells["MaSP"].Value.ToString();
if (masp.Equals(cboTSP.SelectedValue.ToString()))
{
bien = false;
break;
}
else
{
bien = true;
}
}
if (bien)
{
int tt = (int.Parse(num_SL.Value.ToString()) * int.Parse(txtGiaBan.Text));
DTO_CTHD cthd = new DTO_CTHD(int.Parse(txtMaHD.Text), int.Parse(cboTSP.SelectedValue.ToString()), int.Parse(num_SL.Value.ToString()), int.Parse(txtGiaBan.Text), tt);
bshd.InsertCT_HD(cthd);
XtraMessageBox.Show("Thêm thành công.");
gdvCTHD.DataSource = bshd.getCTHD(int.Parse(txtMaHD.Text));
int sl = int.Parse(num_SL.Value.ToString());
string mah = cboTSP.SelectedValue.ToString();
hh.Updatesoluonggiam(int.Parse(mah), sl);
}
else
{
XtraMessageBox.Show("Đã có sản phẩm trong giỏ hàng.\n Bạn có thể sửa số lượng sản phẩm trong giỏ.");
}
}
catch
{
XtraMessageBox.Show("Thêm thất bại.");
}
}
public string Insert(DTO_CTHD obj)
{
string query = string.Empty;
query += "INSERT INTO [TBL_CTHD] ([MACTHD], [MAKH], [MANV], [NGAYNHANPHONG], [NGAYDI], [SOPHONG], [TRATRUOC] ) ";
query += "VALUES (@MACTHD, @MAKH, @MANV, @NGAYNHANPHONG, @NGAYDI, @SOPHONG, @TRATRUOC)";
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("@MAKH", obj.Makh);
comm.Parameters.AddWithValue("@MANV", obj.Manv);
comm.Parameters.AddWithValue("@NGAYNHANPHONG", obj.Ngaynhanphong);
comm.Parameters.AddWithValue("@NGAYDI", obj.Ngaydi);
comm.Parameters.AddWithValue("@SOPHONG", obj.Sophong);
comm.Parameters.AddWithValue("@TRATRUOC", obj.Tratruoc);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
return("Adding fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
private void btnXoaCTHD_Click(object sender, EventArgs e)
{
try
{
string masp = gdvCTHD.CurrentRow.Cells[0].Value.ToString();
string sl = gdvCTHD.CurrentRow.Cells["SL"].Value.ToString();
DTO_CTHD cthd = new DTO_CTHD(int.Parse(txtMaHD.Text), int.Parse(masp));
bool kq = bshd.DeleteCTHD(cthd);
if (kq == true)
{
XtraMessageBox.Show("Xóa thành công.");
}
else
{
XtraMessageBox.Show("Xóa thất bại.");
}
gdvCTHD.DataSource = bshd.getCTHD(int.Parse(txtMaHD.Text));
hh.Updatesoluongtang(int.Parse(masp), int.Parse(sl));
}
catch
{
XtraMessageBox.Show("Lỗi!");
}
}
//insert update delete CTHD
public bool InsertCT_HD(DTO_CTHD a)
{
return(dalhd.InsertCTHD(a));
}
private void bt_ToDichVu_Click(object sender, EventArgs e)
{
if (datetime_NgayNhanPhong.Value.ToString() == "")
{
MessageBox.Show("Chưa chọn ngày nhận phòng", "Erro");
return;
}
if (date_NgayDi.Value.ToString() == "")
{
MessageBox.Show("Chưa chọn ngày đi", "Erro");
return;
}
if (DropDown_LoaiPhong.selectedIndex == -1)
{
MessageBox.Show("Chưa chọn loại phòng", "Erro");
return;
}
if (DropDown_Phong.selectedIndex == -1)
{
MessageBox.Show("Chưa chọn phòng", "Erro");
return;
}
if (txb_TenKhach.Text == "")
{
MessageBox.Show("Chưa nhập tên khách hàng", "Erro");
return;
}
if (date_SinhNhat.Value.ToString() == "")
{
MessageBox.Show("Chưa chọn ngày sinh", "Erro");
return;
}
if (txb_CMND.Text == "")
{
MessageBox.Show("Chưa nhập CMND", "Erro");
return;
}
if (DropDown_GioiTinh.selectedIndex == -1)
{
MessageBox.Show("Chưa chọn giới tính", "Erro");
return;
}
if (txb_SDT.Text == "")
{
MessageBox.Show("Chưa nhập số điện thoại", "Erro");
return;
}
panel_ListDV.Controls.Clear();
//ThemKH
if (kt_DatPhong == false)
{
page_DatPhong.SetPage(1);
DTO_CTHD obj_cthd = new DTO_CTHD();
DTO_KhachHang obj_kh = new DTO_KhachHang();
obj_kh.Makh = txb_MaKH.Text;
obj_kh.Tenkh = txb_TenKhach.Text;
obj_kh.Cmnd = txb_CMND.Text;
obj_kh.Gioitinh = DropDown_GioiTinh.selectedValue;
obj_kh.Ngaysinh = date_SinhNhat.Value.ToString();
obj_kh.Sdt = txb_SDT.Text;
obj_kh.Quoctich = txb_QuocTich.Text;
obj_kh.Diachi = txb_DiaChi.Text;
if (bus_kh.Insert(obj_kh) != "0")
{
MessageBox.Show("Thêm khách hàng thất bại");
}
//Them cthd
obj_cthd.Macthd = bus_cthd.TaoMaCTHD();
get_MaCTHD = obj_cthd.Macthd;
obj_cthd.Makh = txb_MaKH.Text;
obj_cthd.Ngaynhanphong = date_NgayNhan.Value.ToString();
obj_cthd.Ngaydi = date_NgayDi.Value.ToString();
obj_cthd.Sophong = DropDown_Phong.selectedValue;
obj_cthd.Tratruoc = "0";
obj_cthd.Manv = Message;
if (bus_cthd.Insert(obj_cthd) != "0")
{
MessageBox.Show("Chọn phòng thất bại");
}
LoadDichVu();
txbDV_MaKH.Text = obj_kh.Makh;
txbTT_MaKH.Text = obj_kh.Makh;
//Update tinh trang phong
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 == obj_cthd.Sophong
select new
{
SoPhong = x.Sophong,
TrangThai = "USED",
MaLP = x.Malp,
};
foreach (var x in Malp)
{
objp.Sophong = x.SoPhong;
objp.Malp = x.MaLP;
objp.Status = x.TrangThai;
}
bus_p.Update(objp);
}
}
//public string LoadDichVu(List<DTO_CTHD> lsobj)
//{
// return dal.selectAll(lsobj);
//}
public string Delete(DTO_CTHD obj)
{
return(dal.Delete(obj));
}
public string Insert(DTO_CTHD obj)
{
return(dal.Insert(obj));
}
public string Update(DTO_CTHD obj)
{
return(dal.Update(obj));
}
public bool UpdateCTHD(DTO_CTHD a)
{
return(dalhd.UpdateCTHD(a));
}
public bool ThemCTHDFinal(DTO_CTHD cthd)
{
return(dalBan.ThemCTHDFinal(cthd));
}
private void BT_Chuyen_Click(object sender, EventArgs e)
{
DTO_CTHD obj_cthd = new DTO_CTHD();
obj_cthd.Macthd = get_MACTHD;
if (dropDown_Phong.selectedIndex != -1)
{
obj_cthd.Sophong = dropDown_Phong.selectedValue;
}
else
{
MessageBox.Show("Chưa chọn phòng chuyển đến", "Erro");
return;
}
if (bus_cthd.Update(obj_cthd) != "0")
{
MessageBox.Show("Chuyển phòng thất bại");
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);
var Malp1 = from x in lsobj_p
join y in lsobj_lp on x.Malp equals y.Malp
where x.Sophong == dropDown_Phong.selectedValue
select new
{
SoPhong = x.Sophong,
TrangThai = "USED",
MaLP = x.Malp,
};
DTO_Phong objp1 = new DTO_Phong();
foreach (var x in Malp1)
{
objp1.Sophong = x.SoPhong;
objp1.Malp = x.MaLP;
objp1.Status = x.TrangThai;
}
bus_p.Update(objp1);
MessageBox.Show("Chuyển phòng thành công, từ phòng " + txb_SoPhong.Text + " đến " + dropDown_Phong.selectedValue);
}
public bool DeleteCTHD(DTO_CTHD a)
{
return(dalhd.DeleteCTHD(a));
}
public bool ThemCTHDTam(DTO_CTHD cthd)
{
return(dalBan.ThemChiTietHoaDonTam(cthd));
}
