public ActionResult Create()
{
var assignment = new DOCUS_ASM_ASSIGNMENTS();
ViewData["TransactionType"] = "Create";
return(View(assignment));
}
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);
}
}
}
catch (Exception e)
{
throw e;
}
}
public bool Update([FromBody] DOCUS_ASM_ASSIGNMENTS assignmentsRequest)
{
bool result = true;
_repoObj.Update(assignmentsRequest);
return(result);
}
public ActionResult GetDetails(int assignmentId, int accountNumber, string type)
{
var details = new DOCUS_ASM_ASSIGNMENTS();
var results = new List <DOCUS_ASM_ASSIGNMENTS>();
if (TempData["Assignments"] != null)
{
results = TempData["Assignments"] as List <DOCUS_ASM_ASSIGNMENTS>;
}
else
{
results = _assignment.GetAssignments(accountNumber) as List <DOCUS_ASM_ASSIGNMENTS>;
}
details = results.Where(x => x.ACCOUNT_NUMBER == accountNumber && x.ASSIGNMENT_ID == assignmentId).FirstOrDefault();
ViewData["TransactionType"] = "Update";
if (type == "recordedAssignments")
{
details.IsNewRecordedAssignemnt = false;
return(PartialView("_RecordedAssignments", details));
}
else if (type == "newRecord")
{
details.IsNewRecordedAssignemnt = true;
return(PartialView("_RecordedAssignments", details));
}
return(PartialView("_AssignmentDetails", details));
}
private DOCUS_ASM_ASSIGNMENTS mock()
{
var obj = new DOCUS_ASM_ASSIGNMENTS();
obj.UPDATED_BY = "abcd";
obj.CREATED_BY = "bcde";
obj.DATE_CREATED = DateTime.Now;
obj.DATE_UPDATED = DateTime.Now;
return(obj);
}
public bool AddOrUpdate(DOCUS_ASM_ASSIGNMENTS assignment)
{
if (ModelState.IsValid)
{
return(_assignment.Update(assignment));
}
else
{
return(false);
}
}
public JsonResult AddOrUpdate(DOCUS_ASM_ASSIGNMENTS assignment)
{
JsonResult result = new JsonResult();
if (ModelState.IsValid)
{
var notesTobeSaved = new AssignmentNotes();
var notesResponse = true;
if (!assignment.Notes.IsNullOrWhiteSpace())
{
notesTobeSaved.ASSIGNMENT_ID = assignment.ASSIGNMENT_ID;
notesTobeSaved.NOTE = assignment.Notes;
}
//return _assignment.Create(assignment);
switch (assignment.TransactionType)
{
case "New Request":
// assignment.DATE_ENTERED = DateTime.Now.To
var response = _assignment.Create(assignment);
if (!assignment.Notes.IsNullOrWhiteSpace())
{
notesTobeSaved.ASSIGNMENT_ID = response;
notesResponse = _notes.SaveNotes(notesTobeSaved);
}
result =
Json(
new
{
data =
response > 0 && notesResponse ? "Record Created Successuflly" : "Error Occurred",
IsSuccess = result
});
//RedirectToAction("Index", "Home",new{ id = assignment.ACCOUNT_NUMBER});
break;
default:
var update = _assignment.Update(assignment);
if (!assignment.Notes.IsNullOrWhiteSpace())
{
notesResponse = _notes.SaveNotes(notesTobeSaved);
}
result = Json(new { data = update && notesResponse ? "Record Updated Successuflly" : "Error Occurred", IsSuccess = result });
//RedirectToAction("Index", "Home", new { id = assignment.ACCOUNT_NUMBER });
break;
}
}
else
{
var errors = ModelState.Where(x => x.Value.Errors.Count > 0);
result = Json(new { data = errors, IsSuccess = false });
}
return(result);
}
public ActionResult GetDetails(int assignmentId, int accountNumber)
{
var details = new DOCUS_ASM_ASSIGNMENTS();
var results = new List <DOCUS_ASM_ASSIGNMENTS>();
if (TempData["Assignments"] != null)
{
results = TempData["Assignments"] as List <DOCUS_ASM_ASSIGNMENTS>;
}
else
{
results = _assignment.GetAssignments(accountNumber) as List <DOCUS_ASM_ASSIGNMENTS>;
}
details = results.Where(x => x.ACCOUNT_NUMBER == accountNumber && x.ASSIGNMENT_ID == assignmentId).FirstOrDefault();
return(PartialView("_AssignmentDetails", details));
}
private DOCUS_ASM_ASSIGNMENTS mock()
{
var obj = new DOCUS_ASM_ASSIGNMENTS();
obj.UPDATED_BY = "abcd";
obj.CREATED_BY = "bcde";
var defaultDate = DateTime.Now.Date;
obj.DATE_ENTERED = defaultDate;
obj.REQUEST_DATE = defaultDate;
obj.DATE_CREATED = defaultDate;
obj.COLLATERAL_FILE_REQUEST_DATE = defaultDate;
obj.LAST_STATUS_DATE = defaultDate;
obj.FOLLOW_UP_DATE = defaultDate;
obj.SALE_DATE = defaultDate;
obj.DATE_UPDATED = DateTime.Now;
return(obj);
}
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);
}
private DOCUS_ASM_ASSIGNMENTS mock()
{
var obj = new DOCUS_ASM_ASSIGNMENTS();
obj.UPDATED_BY = "abcd";
obj.CREATED_BY = "bcde";
var defaultDate = DateTime.Now.Date;
obj.DATE_ENTERED = defaultDate.ToShortDateString();
//obj.LAST_STATUS_DATE = defaultDate.ToShortDateString();
// obj.REQUEST_DATE = defaultDate.ToShortDateString();
//obj.DATE_CREATED = defaultDate;
//obj.COLLATERAL_FILE_REQUEST_DATE = defaultDate.ToShortDateString();
//obj.LAST_STATUS_DATE = defaultDate.ToShortDateString();
//obj.FOLLOW_UP_DATE = defaultDate.ToShortDateString();
//obj.SALE_DATE = defaultDate.ToShortDateString();
//obj.DATE_UPDATED = defaultDate;
obj.MERS_INDICATOR = false;
obj.MERS_UPDATED = false;
return(obj);
}
public JsonResult AddOrUpdate(DOCUS_ASM_ASSIGNMENTS assignment)
{
JsonResult result = new JsonResult();
if (ModelState.IsValid)
{
//return _assignment.Create(assignment);
switch (assignment.TransactionType)
{
case "New Request":
var response = _assignment.Create(assignment);
result = Json(new { data = response ? "Record Created Successuflly" : "Error Occurred", IsSuccess = result });
break;
default:
var update = _assignment.Update(assignment);
result = Json(new { data = update ? "Record Updated Successuflly" : "Error Occurred", IsSuccess = result });
break;
}
}
return(result);
}
public int Insert(DOCUS_ASM_ASSIGNMENTS assignmentsRequest)
{
return(_repoObj.Insert(assignmentsRequest));
}
