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