public bool UpdateCustomerPriceList(CustomerPriceList updateCustomerPriceList, bool newVer = false) { try { if (updateCustomerPriceList == null) { throw new ArgumentNullException("updateCustomerPriceList"); } using (var db = new HKSupplyContext()) { using (var dbTrans = db.Database.BeginTransaction()) { try { updateCustomerPriceList.IdSubVer += 1; if (newVer == true) { updateCustomerPriceList.IdVer += 1; updateCustomerPriceList.IdSubVer = 0; } updateCustomerPriceList.Timestamp = DateTime.Now; CustomerPriceListHistory customerPriceListHistory = (CustomerPriceListHistory)updateCustomerPriceList; customerPriceListHistory.User = GlobalSetting.LoggedUser.UserLogin; //Con esto marcaremos todo el objeto como modificado y actualizará todos los campos. //En este caso nos interesa porque la mayoría de los campos de supplier se pueden modificar db.Entry(updateCustomerPriceList).State = EntityState.Modified; db.CustomersPriceListHistory.Add(customerPriceListHistory); db.SaveChanges(); dbTrans.Commit(); return(true); } catch (SqlException sqlex) { dbTrans.Rollback(); for (int i = 0; i < sqlex.Errors.Count; i++) { _log.Error("Index #" + i + "\n" + "Message: " + sqlex.Errors[i].Message + "\n" + "Error Number: " + sqlex.Errors[i].Number + "\n" + "LineNumber: " + sqlex.Errors[i].LineNumber + "\n" + "Source: " + sqlex.Errors[i].Source + "\n" + "Procedure: " + sqlex.Errors[i].Procedure + "\n"); switch (sqlex.Errors[i].Number) { case -1: //connection broken case -2: //timeout throw new DBServerConnectionException(GlobalSetting.ResManager.GetString("DBServerConnectionError")); } } throw sqlex; } catch (Exception ex) { dbTrans.Rollback(); _log.Error(ex.Message, ex); throw ex; } } } } catch (ArgumentNullException anex) { _log.Error(anex.Message, anex); throw anex; } }
public bool NewCustomerPriceList(CustomerPriceList newCustomerPriceList) { try { if (newCustomerPriceList == null) { throw new ArgumentNullException("newSupplierPriceList"); } using (var db = new HKSupplyContext()) { using (var dbTrans = db.Database.BeginTransaction()) { try { var tmpCustomerPriceList = GetCustomerPriceList(newCustomerPriceList.IdItemBcn, newCustomerPriceList.IdCustomer); if (tmpCustomerPriceList != null) { throw new Exception("Customer Price List already exist"); } newCustomerPriceList.IdVer = 1; newCustomerPriceList.IdSubVer = 0; newCustomerPriceList.Timestamp = DateTime.Now; CustomerPriceListHistory customerPriceListHistory = (CustomerPriceListHistory)newCustomerPriceList; customerPriceListHistory.User = GlobalSetting.LoggedUser.UserLogin; db.CustomersPriceList.Add(newCustomerPriceList); db.CustomersPriceListHistory.Add(customerPriceListHistory); db.SaveChanges(); dbTrans.Commit(); return(true); } catch (SqlException sqlex) { dbTrans.Rollback(); for (int i = 0; i < sqlex.Errors.Count; i++) { _log.Error("Index #" + i + "\n" + "Message: " + sqlex.Errors[i].Message + "\n" + "Error Number: " + sqlex.Errors[i].Number + "\n" + "LineNumber: " + sqlex.Errors[i].LineNumber + "\n" + "Source: " + sqlex.Errors[i].Source + "\n" + "Procedure: " + sqlex.Errors[i].Procedure + "\n"); switch (sqlex.Errors[i].Number) { case -1: //connection broken case -2: //timeout throw new DBServerConnectionException(GlobalSetting.ResManager.GetString("DBServerConnectionError")); } } throw sqlex; } catch (Exception ex) { dbTrans.Rollback(); _log.Error(ex.Message, ex); throw ex; } } } } catch (ArgumentNullException anex) { _log.Error(anex.Message, anex); throw anex; } }