public ActionResult DeleteConfirmed(int ApplicationId, int?InspectorId, string EmailId)
{
LoanForm loanForm = db.LoanForms.Find(ApplicationId);
loanForm.Status = "Rejected";
db.LoanForms.Attach(loanForm);
var entry = db.Entry(loanForm);
entry.Property(e => e.Status).IsModified = true;
//db.LoanForms.Remove(loanForm);
//change in status table
StatusTrack status = new StatusTrack();
status.ApplicationId = ApplicationId;
var user = db.UserRegisters.Where(x => x.EmailId == EmailId).FirstOrDefault();
status.UserId = user.UserId;
status.AuthorityId = 1;
status.Date = DateTime.Now.Date;
status.Status = "Application Rejected";
db.StatusTracks.Add(status);
db.SaveChanges();
string mailbody = " < br />< br /> We are very sorry to inform you that your Appliction is rejected on<strong> Santander UK </ strong > " +
"<br><br> You can try again later!!";
string subjectmail = "your Application is rejected";
SendEmail(loanForm.EmailId, mailbody, subjectmail);
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
StatusTrack statusTrack = db.StatusTracks.Find(id);
db.StatusTracks.Remove(statusTrack);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "StatusId,ApplicationId,UserId,AuthorityId,Date,Status")] StatusTrack statusTrack)
{
if (ModelState.IsValid)
{
db.Entry(statusTrack).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AuthorityId = new SelectList(db.AdminDetails, "Id", "Name", statusTrack.AuthorityId);
ViewBag.ApplicationId = new SelectList(db.LoanForms, "ApplicationId", "Name", statusTrack.ApplicationId);
ViewBag.UserId = new SelectList(db.UserRegisters, "UserId", "FullName", statusTrack.UserId);
return(View(statusTrack));
}
// GET: StatusTracks/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StatusTrack statusTrack = db.StatusTracks.Find(id);
if (statusTrack == null)
{
return(HttpNotFound());
}
return(View(statusTrack));
}
// GET: StatusTracks/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StatusTrack statusTrack = db.StatusTracks.Find(id);
if (statusTrack == null)
{
return(HttpNotFound());
}
ViewBag.AuthorityId = new SelectList(db.AdminDetails, "Id", "Name", statusTrack.AuthorityId);
ViewBag.ApplicationId = new SelectList(db.LoanForms, "ApplicationId", "Name", statusTrack.ApplicationId);
ViewBag.UserId = new SelectList(db.UserRegisters, "UserId", "FullName", statusTrack.UserId);
return(View(statusTrack));
}
public ActionResult Create([Bind(Include = "StatusId,ApplicationId,UserId,AuthorityId,Date,Status")] StatusTrack statusTrack)
{
if (ModelState.IsValid)
{
// var q = db.UserRegisters.Where(a => a.UserId ==)
statusTrack.Date = DateTime.Today.Date;
db.StatusTracks.Add(statusTrack);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AuthorityId = new SelectList(db.AdminDetails, "Id", "Name", statusTrack.AuthorityId);
ViewBag.ApplicationId = new SelectList(db.LoanForms, "ApplicationId", "Name", statusTrack.ApplicationId);
ViewBag.UserId = new SelectList(db.UserRegisters, "UserId", "FullName", statusTrack.UserId);
return(View(statusTrack));
}
public ActionResult InsertStatus(int ApplicationId, int InspectorId, string EmailId)
{
using (MortgageDbEntities db = new MortgageDbEntities())
{
StatusTrack status = new StatusTrack();
status.ApplicationId = ApplicationId;
//var email = Session["Emailid"].ToString();
var user = db.UserRegisters.Where(x => x.EmailId == EmailId).FirstOrDefault();
status.UserId = user.UserId;
status.AuthorityId = InspectorId;
status.Date = DateTime.Now.Date;
status.Status = "Application in Inspection";
db.StatusTracks.Add(status);
db.SaveChanges();
//return RedirectToAction("InspectorView");
return(RedirectToAction("Index"));
}
}
