public string Update(SLAValues sla) { var existingSLAValue = context.SLAValues.Find(sla.ID); if (existingSLAValue != null) { try { existingSLAValue.QuantityProcessed = sla.QuantityProcessed; existingSLAValue.QuantityOutsideofSLA = sla.QuantityOutsideofSLA; existingSLAValue.UpdatedBy = sla.UpdatedBy; existingSLAValue.UpdatedDate = sla.UpdatedDate; context.SaveChanges(); return(existingSLAValue.ID.ToString()); }catch (DbEntityValidationException ex) { return(ex.EntityValidationErrors.FirstOrDefault().ValidationErrors.FirstOrDefault().ErrorMessage + ":" + ex.EntityValidationErrors.FirstOrDefault().ValidationErrors.FirstOrDefault().PropertyName); } } return("Error-No matching record"); }
public string Insert(SLAValues slaValues) { try { var SLAValuesObj = new SLAValues() { SLAID = slaValues.SLAID, ReportingDate = slaValues.ReportingDate, QuantityProcessed = slaValues.QuantityProcessed, QuantityOutsideofSLA = slaValues.QuantityOutsideofSLA, UpdatedBy = slaValues.UpdatedBy, UpdatedDate = slaValues.UpdatedDate }; context.SLAValues.Add(SLAValuesObj); context.SaveChanges(); return("1"); } catch (DbEntityValidationException ex) { return(ex.EntityValidationErrors.FirstOrDefault().ValidationErrors.FirstOrDefault().ErrorMessage + ":" + ex.EntityValidationErrors.FirstOrDefault().ValidationErrors.FirstOrDefault().PropertyName); } }