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 btnXoa_Click(object sender, EventArgs e)
{
if (txtMaBC.Text == "")
{
return;
}
BaoCaoMDSD bc = db.BaoCaoMDSDs.Find(txtMaBC.Text);
bc.Xoa = 1;
db.SaveChanges();
MessageBox.Show("Xóa thành công");
}
private void txtMaBC_TextChanged(object sender, EventArgs e)
{
if (txtMaBC.Text == "")
{
return;
}
BaoCaoMDSD bc = db.BaoCaoMDSDs.Find(txtMaBC.Text);
txtThang.Text = bc.Thang + "/" + bc.Nam;
var result = from c in db.CT_BaoCaoMDSD where c.MaBaoCaoMDSD == bc.MaBaoCaoMDSD select c;
foreach (var i in result)
{
string[] row1 = new string[]
{
i.MaPhong,
i.SoNgayThue.ToString(),
i.TyLe
};
dgvCTBC.Rows.Add(row1);
}
}
