public ActionResult Track(int?Id) { if (Session["username"] == null || Session["userlevel"].ToString() != "clientele") { return(this.RedirectToAction("MobileLogout", "Account")); } if (Id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <loan_table> loan = ags.loan_table.Where(x => x.id == Id).ToList(); List <loan_track_table> employeeLoantrack = ags.loan_track_table.Where(x => x.loanid == Id.ToString()).ToList(); var employee = ags.admin_table.ToList(); loan_track loan_track = new loan_track(); loan_track.loan_details = loan.ToList(); loan_track.employee_track = employeeLoantrack.ToList().OrderBy(t => t.tracktime); var user = ags.loan_table.Where(x => x.id == Id).FirstOrDefault(); var employees = ags.admin_table.ToList(); var employeeid = ""; foreach (var item in employeeLoantrack) { foreach (var items in employees) { if (item.employeeid != null) { if (item.employeeid.ToString() == items.id.ToString()) { var employeeType = ags.emp_category_table.Where(x => x.emp_category_id == items.userrole).FirstOrDefault(); //string concatenated = items.name + " ( " + items.userrole + " ) "; employeeid = employeeType.emp_category; break; } else if (items.id.ToString() != item.employeeid) { employeeid = "Not Updated"; continue; } } } item.employeeid = employeeid; } return(PartialView(loan_track)); }
public ActionResult Track(int?Id) { if (Session["username"] == null || Session["userlevel"].ToString() != "clientele") { return(this.RedirectToAction("ClientLogout", "Account")); } if (Id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <loan_table> loan = ags.loan_table.Where(x => x.id == Id).ToList(); List <loan_track_table> employeeLoantrack = ags.loan_track_table.Where(x => x.loanid == Id.ToString()).ToList(); List <vendor_track_table> vendorLoantrack = ags.vendor_track_table.Where(x => x.loanid == Id.ToString()).ToList(); List <external_comment_table> externalComment = ags.external_comment_table.ToList(); var employee = ags.admin_table.ToList(); loan_track loan_track = new loan_track(); loan_track.loan_details = loan.ToList(); loan_track.employee_track = employeeLoantrack.ToList().OrderBy(t => t.tracktime); loan_track.vendor_track = vendorLoantrack.ToList().OrderBy(t => t.tracktime); var user = ags.loan_table.Where(x => x.id == Id).FirstOrDefault(); var getCustomer = ags.customer_profile_table.ToList(); var customerid = ""; var phonenumber = ""; var name = ""; var email = ""; foreach (var customer in getCustomer) { if (user.customerid == customer.id.ToString()) { name = customer.name; customerid = customer.customerid; phonenumber = customer.phoneno; email = customer.email; break; } else if (user.customerid != customer.id.ToString()) { customerid = "Not Updated"; continue; } } user.customerid = customerid; ViewBag.name = name; ViewBag.phoneno = phonenumber; ViewBag.email = email; var employees = ags.admin_table.ToList(); var employeeid = ""; foreach (var item in employeeLoantrack) { foreach (var items in employees) { if (item.employeeid != null) { if (item.employeeid.ToString() == items.id.ToString()) { var employeeType = ags.emp_category_table.Where(x => x.emp_category_id == items.userrole).FirstOrDefault(); //string concatenated = items.name + " ( " + items.userrole + " ) "; employeeid = employeeType.emp_category; break; } else if (items.id.ToString() != item.employeeid) { employeeid = "Not Updated"; continue; } } } item.employeeid = employeeid; } var extComment = ""; foreach (var item in employeeLoantrack) { foreach (var items in externalComment) { if (item.externalcomment != null) { if (item.externalcomment.ToString() == items.id.ToString()) { extComment = items.externalcomment; break; } else if (items.id.ToString() != item.externalcomment) { extComment = "Not Updated"; continue; } } } item.externalcomment = extComment; } var vendors = ags.vendor_table.ToList(); var vendorid = ""; foreach (var item in vendorLoantrack) { foreach (var items in vendors) { if (item.vendorid != null) { if (item.vendorid.ToString() == items.id.ToString()) { string concatenated = items.companyname + " ( " + items.name + " ) "; vendorid = concatenated; break; } else if (items.id.ToString() != item.vendorid) { vendorid = "Not Updated"; continue; } } } item.vendorid = vendorid; } return(PartialView("~/Views/Clientele/Track.cshtml", loan_track)); }