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