public bool UpdateData(ChiTietBaoHanhObj CTBHObj)
{
cmd.CommandText = string.Format("UPDATE tblChiTietBaoHanh SET MACTBH = '{0}', MABH = '{1}', MANV = '{2}', CONGVIEC = N'{3}', SOKM = {4} WHERE (MACTBH = '{0}')", CTBHObj.MaChiTietBaoHanh, CTBHObj.MaBaoHanh, CTBHObj.MaNV, CTBHObj.CongViec, CTBHObj.SoKM);
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(ChiTietBaoHanhObj CTBHObj)
{
cmd.CommandText = string.Format("INSERT INTO tblChiTietBaoHanh (MACTBH, MABH, MANV, CONGVIEC, SOKM) VALUES ('{0}', '{1}', '{2}', N'{3}', {4})", CTBHObj.MaChiTietBaoHanh, CTBHObj.MaBaoHanh, CTBHObj.MaNV, CTBHObj.CongViec, CTBHObj.SoKM);
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(ChiTietBaoHanhObj CTBHObj)
{
return(CTBHMod.UpdateData(CTBHObj));
}
public bool addData(ChiTietBaoHanhObj CTBHObj)
{
return(CTBHMod.AddData(CTBHObj));
}
