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