public bool AddDetailServiceBill(int idBill, int idService) { try { CHITIETSUDUNGDV detailServiceBill = db.CHITIETSUDUNGDVs.Where(p => p.MAHD == idBill && p.MADICHVU == idService).FirstOrDefault(); decimal? pice = db.DICHVUs.Where(p => p.MADICHVU == idService).Select(p => p.GIADV).SingleOrDefault(); if (detailServiceBill == null)//chua co chi tiet { detailServiceBill = new CHITIETSUDUNGDV(); detailServiceBill.MAHD = idBill; detailServiceBill.MADICHVU = idService; detailServiceBill.SOLUONG = 1; detailServiceBill.THANHTIEN = pice; db.CHITIETSUDUNGDVs.Add(detailServiceBill); db.SaveChanges(); } else { detailServiceBill.SOLUONG += 1; detailServiceBill.THANHTIEN = detailServiceBill.SOLUONG * pice; db.SaveChanges(); } return(true); } catch { return(false); } }
private void btnLap_Click(object sender, EventArgs e) { var result = from c in db.BaoCaoMDSDs select c; BaoCaoMDSD bc = new BaoCaoMDSD() { MaBaoCaoMDSD = "BCMD" + (result.Count() + 1), Thang = txtNhapThang.Text, Xoa = 0, Nam = txtNam.Text }; db.BaoCaoMDSDs.Add(bc); db.SaveChanges(); string mabc = "BCMD" + (result.Count() + 1); if (db.SaveChanges() == 0) { for (int i = 0; i < dgvCTBC.Rows.Count; i++) { var res = from c in db.CT_BaoCaoMDSD select c; CT_BaoCaoMDSD ct = new CT_BaoCaoMDSD() { MaCTBaoCaoMDSD = "CTMD" + (res.Count() + 1), MaBaoCaoMDSD = mabc, MaPhong = dgvCTBC[0, i].Value.ToString(), SoNgayThue = int.Parse(dgvCTBC[1, i].Value.ToString()), TyLe = dgvCTBC[2, i].Value.ToString() }; db.CT_BaoCaoMDSD.Add(ct); db.SaveChanges(); } } MessageBox.Show("Lập báo cáo thành công"); }
private void button2_Click(object sender, EventArgs e) { if (txtTenDm.Text == "") { MessageBox.Show("Bạn chưa đặt tên cho danh mục phòng này."); return; } if (dgvCT.Rows.Count - 1 == 0) { MessageBox.Show("Chưa có thông tin chi tiết danh mục phòng, không thể tạo danh mục phòng."); return; } string madmp = txtMaDM.Text; string tendmp = txtTenDm.Text; var checktendmp = from c in db.DanhMucPhongs where c.TenDMP == tendmp select c; if (checktendmp.Count() != 0) { MessageBox.Show("Tên danh mục này đã tồn tại."); return; } var checkdmp = from c in db.DanhMucPhongs where c.MaDMPhong == madmp select c; if (checkdmp.Count() != 0) { MessageBox.Show("Danh mục này đã tồn tại."); return; } var result = from c in db.DanhMucPhongs select c; DanhMucPhong dmp = new DanhMucPhong() { MaDMPhong = "DMP" + (result.Count() + 1), Xoa = 0, TenDMP = txtTenDm.Text }; db.DanhMucPhongs.Add(dmp); for (int i = 0; i < (dgvCT.Rows.Count - 1); i++) { var re = from c in db.Phongs select c; foreach (var a in re) { if (dgvCT[0, i].Value.ToString() == a.MaPhong) { a.MaDanhMucPhong = "DMP" + (result.Count() + 1); } } } db.SaveChanges(); MessageBox.Show("Lập danh mục phòng thành công"); }
private void btnLapHD_Click(object sender, EventArgs e) { var result = from c in db.HoaDonTTs select c; HoaDonTT hd = new HoaDonTT() { MaHoaDon = "HD" + (result.Count() + 1), MaKhachhang = txtMaKH.Text, NgayThanhToan = Convert.ToDateTime(txtNgayTT.Text), TriGia = float.Parse(txtTriGia.Text), Xoa = 0 }; db.HoaDonTTs.Add(hd); string mahoadon = "HD" + (result.Count() + 1); for (int i = 0; i < dgvHoaDon.Rows.Count; i++) { var re = from c in db.CT_HoaDon select c; CT_HoaDon ct = new CT_HoaDon() { MaCTHoaDon = "CTHD" + (re.Count() + 1), MaHoaDon = mahoadon, MaPhieuThuePhong = dgvHoaDon[0, i].Value.ToString(), SoNgayThue = int.Parse(dgvHoaDon[3, i].Value.ToString()), ThanhTien = float.Parse(dgvHoaDon[4, i].Value.ToString()), TriGia = float.Parse(dgvHoaDon[5, i].Value.ToString()) }; db.CT_HoaDon.Add(ct); db.SaveChanges(); } db.SaveChanges(); MessageBox.Show("Lập hóa đơn thành công"); }
private void button1_Click(object sender, EventArgs e) { var result = from c in db.Phongs select c; Phong ph = new Phong() { MaPhong = "PH" + (result.Count() + 1), TinhTrang = "Trống", MaLoaiPhong = cbbLP.SelectedValue.ToString(), TenPhong = txtTenPhong.Text }; db.Phongs.Add(ph); db.SaveChanges(); MessageBox.Show("Tạo phòng mới thành công"); }
private void button2_Click(object sender, EventArgs e) { DateTime ngbd = Convert.ToDateTime(txtNgayThue.Text); var count_ptp = from c in db.PhieuThuePhongs select c; PhieuThuePhong ptp = new PhieuThuePhong() { MaPhieuThuePhong = "PTP" + (count_ptp.Count() + 1), MaPhong = cbbP.SelectedValue.ToString(), NgayBatDauThue = ngbd.Date, Xoa = 0 }; db.PhieuThuePhongs.Add(ptp); Phong pg = db.Phongs.Find(cbbP.SelectedValue.ToString()); pg.TinhTrang = "Đang thuê"; string maptp = "PTP" + (count_ptp.Count() + 1); for (int i = 0; i < dgvKH.Rows.Count; i++) { string cmnd = dgvKH[2, i].Value.ToString(); string loaikh = dgvKH[1, i].Value.ToString(); var count_kh = from c in db.KhachHangs select c; var check_cmnd = from c in db.KhachHangs where c.CMND == cmnd select c; if (check_cmnd.Count() == 0) { var malkh = from c in db.LoaiKhachHangs where c.TenLoaiKhachHang == loaikh select c; KhachHang kh = new KhachHang(); kh.MaKhachHang = "KH" + (count_kh.Count() + 1); kh.TenKhachHang = dgvKH[0, i].Value.ToString(); kh.CMND = cmnd; kh.DiaChi = dgvKH[3, i].Value.ToString(); foreach (var b in malkh) { kh.MaLoaiKhachHang = b.MaLoaiKhachHang; } db.KhachHangs.Add(kh); var count_ct = from c in db.CT_PhieuThuePhong select c; CT_PhieuThuePhong ct = new CT_PhieuThuePhong() { MaCTPhieuThuePhong = "CTPTP" + (count_ct.Count() + 1), MaPhieuThuePhong = maptp, MaKhachHang = "KH" + (count_kh.Count() + 1) }; db.CT_PhieuThuePhong.Add(ct); } else { var kh = from c in db.KhachHangs where c.CMND == cmnd select c; foreach (var a in kh) { var count_ct = from c in db.CT_PhieuThuePhong select c; CT_PhieuThuePhong ct = new CT_PhieuThuePhong() { MaCTPhieuThuePhong = "CTPTP" + (count_ct.Count() + 1), MaPhieuThuePhong = maptp, MaKhachHang = a.MaKhachHang }; db.CT_PhieuThuePhong.Add(ct); } } db.SaveChanges(); } MessageBox.Show("Tạo phiếu thuê phòng thành công"); }
private void btnLap_Click(object sender, EventArgs e) { if (txtThang.Text != "" || txtMaBC.Text != "") { MessageBox.Show("Lỗi xảy ra"); return; } string mabc = txtNhapThang.Text; var check = from c in db.BaoCaoDoanhThus where c.Thang == mabc select c; if (check.Count() != 0) { MessageBox.Show("Báo cáo tháng " + mabc + "đã tồn tại."); return; } ; var result = from c in db.BaoCaoDoanhThus select c; int id = 0; foreach (var i in result) { id = id + 1; } BaoCaoDoanhThu bc = new BaoCaoDoanhThu() { MaBaoCaoDT = "BCDT" + (id + 1), Thang = txtNhapThang.Text, Nam = txtNam.Text, Xoa = 0 }; db.BaoCaoDoanhThus.Add(bc); db.SaveChanges(); if (db.SaveChanges() == 0) { for (int i = 0; i < (dgvCTBC.Rows.Count - 1); i++) { var re = from c in db.CT_BaoCaoDT select c; int id_ct = 0; foreach (var d in re) { id_ct = id_ct + 1; } string loaiphong = dgvCTBC[0, i].Value.ToString(); double doanhthu = double.Parse(dgvCTBC[1, i].Value.ToString()); string tyle = dgvCTBC[2, i].Value.ToString(); CT_BaoCaoDT ct = new CT_BaoCaoDT() { MaCTBaoCaoDT = "CTDT" + (id_ct + 1), MaBaoCaoDT = "BCDT" + (id + 1), MaLoaiPhong = loaiphong, DoanhThu = doanhthu, TyLe = tyle }; db.CT_BaoCaoDT.Add(ct); db.SaveChanges(); } MessageBox.Show("Lập báo cáo thành công"); } }