public int Insert(DOCUS_ASM_ASSIGNMENTS assignmentRequest) { try { // Your code... // Could also be before try if you know the exception occurs in SaveChanges _context.DOCUS_ASM_ASSIGNMENTS.Add(assignmentRequest); _context.SaveChanges(); var docusAsmAssignments = _context.DOCUS_ASM_ASSIGNMENTS.Where( reqId => reqId.ACCOUNT_NUMBER == assignmentRequest.ACCOUNT_NUMBER) .OrderByDescending(x => x.ASSIGNMENT_ID) .FirstOrDefault(); if (docusAsmAssignments != null) { var result = docusAsmAssignments.ASSIGNMENT_ID; return result; } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } //_context.DOCUS_ASM_ASSIGNMENTS.Add(assignmentRequest); // _context.SaveChanges(); // if (assignmentRequest != null) // DateTime.Now, assignmentRequest.CREATED_BY, assignmentRequest.UPDATED_BY); return 0; }
public int Insert(DOCUS_ASM_ASSIGNMENTS assignmentsRequest) { return _repoObj.Insert(assignmentsRequest); }
public void Update(DOCUS_ASM_ASSIGNMENTS assignmentRequest) { try { _context.Entry(assignmentRequest).State = EntityState.Modified; _context.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } }