private void btn_Sua_Click(object sender, EventArgs e)
{
if (KiemTra() && KiemTraCauHinh())
{
May may = new May();
LichSuCapNhat ls = new LichSuCapNhat();
may.MaMay = Convert.ToInt32(txtMaMay.Text);
may.TenMay = txtTenMay.Text;
may.MaPhong = Convert.ToInt32(cboPhong.SelectedValue);
may.MaCauHinh = Convert.ToInt32(cboCauHinh.SelectedValue);
may.TrangThai = Convert.ToInt32(cboTrangThai.SelectedValue);
may.GhiChu = rtbGhiChu.Text;
ls.MaCapNhat = lsCNCtrl.GetID() + 1;
ls.TenMay = txtTenMay.Text;
ls.MaPhongMay = may.MaPhong;
ls.MaMay = may.MaMay;
ls.MaCauHinh = may.MaCauHinh;
ls.GhiChu = may.GhiChu;
ls.TenDangNhap = user.TenTK;
ls.NgayCapNhat = DateTime.Now;
MessageBox.Show("Cập nhập khoa thành công.", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Information);
mayCtrl.CapNhatMay(may);
lsCNCtrl.ThemMoi(ls);
LamMoi();
}
}
public int ThemChiTietLSCapNhat(LichSuCapNhat lsCapNhat)
{
SqlCommand cmd = new SqlCommand();
string insert = "INSERT INTO dtb_ChiTietCapNhat(MaCapNhat, TenMay, MaCauHinh, GhiChu) ",
values = "VALUES (@maCapNhat, @tenMay, @maCauHinh, @ghiChu)";
cmd.CommandText = insert + values;
cmd.Parameters.Add("maCapNhat", SqlDbType.Int).Value = lsCapNhat.MaCapNhat;
cmd.Parameters.Add("tenMay", SqlDbType.NVarChar).Value = lsCapNhat.TenMay;
cmd.Parameters.Add("maCauHinh", SqlDbType.Int).Value = lsCapNhat.MaCauHinh;
cmd.Parameters.Add("ghiChu", SqlDbType.NVarChar).Value = lsCapNhat.GhiChu;
return(cls.CapNhatDL(cmd));
}
public int ThemLSCapNhat(LichSuCapNhat lsCapNhat)
{
SqlCommand cmd = new SqlCommand();
string insert = "INSERT INTO dtb_LichSuCapNhat(MaCapNhat, MaPhongMay, MaMay, TenDangNhap, NgayCapNhat, GhiChu) ",
values = "VALUES (@maCapNhat, @maPhong, @maMay, @tenDangNhap, @ngayCapNhat, @ghiChu)";
cmd.CommandText = insert + values;
cmd.Parameters.Add("maCapNhat", SqlDbType.Int).Value = lsCapNhat.MaCapNhat;
cmd.Parameters.Add("maPhong", SqlDbType.Int).Value = lsCapNhat.MaPhongMay;
cmd.Parameters.Add("maMay", SqlDbType.Int).Value = lsCapNhat.MaMay;
cmd.Parameters.Add("tenDangNhap", SqlDbType.VarChar).Value = lsCapNhat.TenDangNhap;
cmd.Parameters.Add("ngayCapNhat", SqlDbType.Date).Value = lsCapNhat.NgayCapNhat;
cmd.Parameters.Add("ghiChu", SqlDbType.NVarChar).Value = lsCapNhat.GhiChu;
return(cls.CapNhatDL(cmd));
}
private void ThemMoi(string tenMay)
{
May may = new May();
LichSuCapNhat ls = new LichSuCapNhat();
may.MaMay = mayCtrl.GetID() + 1;
may.TenMay = tenMay;
may.MaPhong = Convert.ToInt32(cboPhong.SelectedValue);
may.MaCauHinh = Convert.ToInt32(cboCauHinh.SelectedValue);
may.TrangThai = Convert.ToInt32(cboTrangThai.SelectedValue);
may.GhiChu = rtbGhiChu.Text;
ls.MaCapNhat = lsCNCtrl.GetID() + 1;
ls.TenMay = txtTenMay.Text;
ls.MaPhongMay = may.MaPhong;
ls.MaMay = may.MaMay;
ls.MaCauHinh = may.MaCauHinh;
ls.GhiChu = may.GhiChu;
ls.TenDangNhap = user.TenTK;
ls.NgayCapNhat = DateTime.Now;
mayCtrl.ThemMoi(may);
lsCNCtrl.ThemMoi(ls);
}
public void ThemMoi(LichSuCapNhat lsCapNhat)
{
lsCNData.ThemLSCapNhat(lsCapNhat);
lsCNData.ThemChiTietLSCapNhat(lsCapNhat);
}
