public Boolean ThemCSVC(CoSoVatChat_DTO csvc)
{
string sql = "INSERT INTO CoSoVatChat VALUES(N'" + csvc.IDCSVC + "', N'" + csvc.TenCSVC + "', N'" + csvc.MaLP
+ "', '" + csvc.SoLuong + "', N'" + csvc.TinhTrang + "', N'" + csvc.GhiChu + "')";
return(new ExecuteDB().ExecuteData(sql));
}
public Boolean SuaCSVC(CoSoVatChat_DTO csvc)
{
string sql = "UPDATE CoSoVatChat SET TenCSVC = N'" + csvc.TenCSVC + "', MaLP = N'" + csvc.MaLP
+ "', SoLuong = '" + csvc.SoLuong + "', TinhTrang = '" + csvc.TinhTrang + "', GhiChu = N'" + csvc.GhiChu
+ "'WHERE IDCSVC = N'" + csvc.IDCSVC + "'";
return(new ExecuteDB().ExecuteData(sql));
}
public Boolean SuaCSVC(CoSoVatChat_DTO csvc)
{
try
{
if (csvc.IDCSVC == "")
{
throw new Exception("Field \"IDCSVC\" không thể trống.");
}
return(new CoSoVatChat_DAL().SuaCSVC(csvc));
}
catch (Exception ex)
{
throw ex;
}
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
try
{
CoSoVatChat_DTO csvc = new CoSoVatChat_DTO(txtIDCSVC.Text, txtTenCSVC.Text, txtMaLP.Text, txtSoLuong.Text, txtTinhTrang.Text, txtGhiChu.Text);
if (MessageBox.Show("Lưu sửa đổi?", "Chú ý!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
BUS.SuaCSVC(csvc);
MessageBox.Show("Sửa thành công!");
dgvCSVC.DataSource = BUS.GetDataCSVC();
Init();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
