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