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)); }