public static bool deleteBaoHanh(EC_BaoHanh bh) { conn = GetData.KetNoi(); string sTruyVan = "BaoHanh_Delete"; cmd = new SqlCommand(sTruyVan, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MABH", SqlDbType.NVarChar).Value = bh.MaBH; cmd.ExecuteNonQuery(); cmd.Dispose(); conn.Close(); try { GetData.ThucThiTruyVanNonQuery(sTruyVan, conn); //Đóng kết nối GetData.DongKetNoi(conn); return(true); } catch (Exception ex) { //Đóng kết nối GetData.DongKetNoi(conn); return(false); } }
public static bool updateBaoHanh(EC_BaoHanh bh) { conn = GetData.KetNoi(); string truyvan = "BaoHanh_Update"; cmd = new SqlCommand(truyvan, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MABH", SqlDbType.NVarChar).Value = bh.MaBH; cmd.Parameters.Add("@MAKH", SqlDbType.NVarChar).Value = bh.MaKH; cmd.Parameters.Add("@MASP", SqlDbType.NVarChar).Value = bh.MaSP; cmd.Parameters.Add("@IMEI", SqlDbType.NVarChar).Value = bh.IMEI; cmd.Parameters.Add("@NGAYBD", SqlDbType.NVarChar).Value = bh.NgayBD; cmd.Parameters.Add("@NGAYKT", SqlDbType.NVarChar).Value = bh.NgayKT; cmd.Parameters.Add("@LOI", SqlDbType.NVarChar).Value = bh.Loi; cmd.Parameters.Add("@GHICHU", SqlDbType.NVarChar).Value = bh.GhiChu; cmd.ExecuteNonQuery(); cmd.Dispose(); try { GetData.ThucThiTruyVanNonQuery(truyvan, conn); GetData.DongKetNoi(conn); return(true); } catch (Exception ex) { GetData.DongKetNoi(conn); return(false); } }
public bool deleteBaoHanh(EC_BaoHanh bh) { return(DA_BaoHanh.deleteBaoHanh(bh)); }
public bool updateBaoHanh(EC_BaoHanh bh) { return(DA_BaoHanh.updateBaoHanh(bh)); }
public bool insertBaoHanh(EC_BaoHanh bh) { return(DA_BaoHanh.insertBaoHanh(bh)); }