private void lblClickDeThemBaoHiem_Click(object sender, EventArgs e)
{
BAOHIEM bh = new BAOHIEM();
frmThongTinBaoHiem frm = new frmThongTinBaoHiem();
frm.btnBaoHiem_Sua.Enabled = false;
frm.btnBaoHiem_Xoa.Enabled = false;
if (frm.ShowDialog() == DialogResult.Yes)
{
bh.SoBH = frm.SoBaoHiem;
bh.NgayCap = frm.NgayCap;
bh.NoiCap = frm.NoiCap;
bh.NoiKhamBenh = frm.NoiKhamBenh;
bh.NgayHetHan = frm.NgayHetHan;
bh.MaNV = Convert.ToInt32(dgvNhanVien.SelectedRows[0].Cells["MaNV"].Value);
lstBaoHiem.Add(bh);
lblClickDeThemBaoHiem.Visible = false;
dgvBaoHiem.DataSource = typeof(List <BAOHIEM>);
dgvBaoHiem.DataSource = lstBaoHiem;
CustomDataGridViewBaoHiem();
BaoHiemBUL.Them(bh);
}
frm.btnBaoHiem_Sua.Enabled = true;
frm.btnBaoHiem_Xoa.Enabled = true;
}
private void dgvBaoHiem_Click(object sender, EventArgs e)
{
if (dgvBaoHiem.SelectedRows.Count > 0)
{
BAOHIEM bh = new BAOHIEM();
DataGridViewRow dgvRow = dgvBaoHiem.SelectedRows[0];
bh.SoBH = dgvRow.Cells["SoBH"].Value.ToString();
bh.NgayCap = Convert.ToDateTime(dgvRow.Cells["NgayCap"].Value);
bh.NoiCap = dgvRow.Cells["NoiCap"].Value.ToString();
bh.NoiKhamBenh = dgvRow.Cells["NoiKhamBenh"].Value.ToString();
bh.NgayHetHan = Convert.ToDateTime(dgvRow.Cells["NgayHetHan"].Value);
bh.MaNV = Convert.ToInt32(dgvRow.Cells["MaNV"].Value);
frmThongTinBaoHiem frm = new frmThongTinBaoHiem();
frm.SoBaoHiem = bh.SoBH;
frm.NgayCap = bh.NgayCap;
frm.NoiCap = bh.NoiCap;
frm.NoiKhamBenh = bh.NoiKhamBenh;
frm.NgayHetHan = bh.NgayHetHan;
DialogResult res = frm.ShowDialog();
if (res == DialogResult.Yes)
{
bh.SoBH = frm.SoBaoHiem;
bh.NgayCap = frm.NgayCap;
bh.NoiCap = frm.NoiCap;
bh.NoiKhamBenh = frm.NoiKhamBenh;
bh.NgayHetHan = frm.NgayHetHan;
bh.MaNV = Convert.ToInt32(dgvRow.Cells["MaNV"].Value);
lstBaoHiem.Add(bh);
dgvBaoHiem.DataSource = typeof(List <BAOHIEM>);
dgvBaoHiem.DataSource = lstBaoHiem;
CustomDataGridViewBaoHiem();
BaoHiemBUL.Them(bh);
}
else if (res == DialogResult.OK)
{
bh.SoBH = dgvRow.Cells[0].Value.ToString();
bh = lstBaoHiem.SingleOrDefault(i => i.SoBH == bh.SoBH);
bh.NgayCap = frm.NgayCap;
bh.NoiCap = frm.NoiCap;
bh.NoiKhamBenh = frm.NoiKhamBenh;
bh.NgayHetHan = frm.NgayHetHan;
dgvBaoHiem.DataSource = typeof(List <BAOHIEM>);
dgvBaoHiem.DataSource = lstBaoHiem;
CustomDataGridViewBaoHiem();
BaoHiemBUL.CapNhat(bh);
}
else if (res == DialogResult.No)
{
bh.SoBH = dgvRow.Cells[0].Value.ToString();
bh = lstBaoHiem.SingleOrDefault(i => i.SoBH == bh.SoBH);
lstBaoHiem.Remove(bh);
dgvBaoHiem.DataSource = typeof(List <BAOHIEM>);
dgvBaoHiem.DataSource = lstBaoHiem;
CustomDataGridViewBaoHiem();
BaoHiemBUL.Xoa(bh.SoBH);
}
}
}
public bool ThemBaoHiem(BAOHIEM p)
{
try
{
linq.BAOHIEMs.InsertOnSubmit(p);
linq.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool Xoa(string soBaoHiem)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
BAOHIEM bh = db.BAOHIEMs.SingleOrDefault(i => i.SoBH == soBaoHiem);
db.BAOHIEMs.Remove(bh);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool CapNhat(BAOHIEM bh)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
BAOHIEM bhUpdate = db.BAOHIEMs.SingleOrDefault(i => i.SoBH == bh.SoBH);
bhUpdate.NgayCap = bh.NgayCap;
bhUpdate.NoiCap = bh.NoiCap;
bhUpdate.NoiKhamBenh = bh.NoiKhamBenh;
bhUpdate.NgayHetHan = bh.NgayHetHan;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public static BAOHIEM Them(BAOHIEM bh)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
bh = db.BAOHIEMs.Add(bh);
if (bh != null)
{
db.SaveChanges();
return(bh);
}
return(null);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
return(null);
}
}
private void btnluu_Click(object sender, EventArgs e)
{
if (txtHoTen.Text.Length > 0 && txtMaBH.Text.Length > 0 && txtNoiCap.Text.Length > 0 && cboLoaiBH.Text.Length > 0 && dateEditNgayDK.DateTime.ToString() != "1/1/0001 12:00:00 AM" && dateEditNgayHH.DateTime.ToString() != "1/1/0001 12:00:00 AM")
{
BAOHIEM bAOHIEM = new BAOHIEM();
bAOHIEM.LOAIBAOHIEM = cboLoaiBH.Text;
bAOHIEM.MABAOHIEM = txtMaBH.Text;
bAOHIEM.MANV = NV;
bAOHIEM.NGAYDK = dateEditNgayDK.DateTime;
bAOHIEM.NGAYHH = dateEditNgayHH.DateTime;
bAOHIEM.NOICAP = txtNoiCap.Text;
bAOHIEM.NOIKHAM = txtnoikhams.Text;
if (bLL_NhanVien.BLL_ThemBaoHiem(bAOHIEM))
{
MessageBox.Show("Thành công"); return;
}
MessageBox.Show("Trùng khóa");
}
else
{
MessageBox.Show("Vui lòng nhập đủ dữ liệu");
}
}
public static bool CapNhat(BAOHIEM bh)
{
return(BaoHiemDAL.CapNhat(bh));
}
public static BAOHIEM Them(BAOHIEM bh)
{
return(BaoHiemDAL.Them(bh));
}
public bool BLL_ThemBaoHiem(BAOHIEM p)
{
return(dAL_NhanVien.ThemBaoHiem(p));
}
