public bool UpdateData(BaoHanhObj BHObj)
{
cmd.CommandText = string.Format("UPDATE tblBaoHanh SET MABH = '{0}', MAKH = '{1}', THOIGIANBH = {2}, MAXE = '{3}' WHERE (MABH = '{0}')", BHObj.MaBaoHanh, BHObj.MaKH, BHObj.ThoiGianBaoHanh, BHObj.MaXe);
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.openCon();
cmd.ExecuteNonQuery();
con.closeCon();
return(true);
}
catch (Exception ex)
{
string mes = ex.Message;
cmd.Dispose();
con.closeCon();
}
return(false);
}
public bool AddData(BaoHanhObj BHObj)
{
cmd.CommandText = string.Format("INSERT INTO tblBaoHanh (MABH, MAKH, THOIGIANBH, MAXE) VALUES ('{0}', '{1}', {2}, '{3}')", BHObj.MaBaoHanh, BHObj.MaKH, BHObj.ThoiGianBaoHanh, BHObj.MaXe);
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.openCon();
cmd.ExecuteNonQuery();
con.closeCon();
return(true);
}
catch (Exception ex)
{
string mes = ex.Message;
cmd.Dispose();
con.closeCon();
}
return(false);
}
public bool updateData(BaoHanhObj BHObj)
{
return(BHMod.UpdateData(BHObj));
}
public bool addData(BaoHanhObj BHObj)
{
return(BHMod.AddData(BHObj));
}
