public ActionResult Edit(loan_table loan_table, FormCollection form)
{
if (ModelState.IsValid)
{
var getCustomer = ags.customer_profile_table.ToList();
SelectList customers = new SelectList(getCustomer, "id", "customerid");
ViewBag.customerList = customers;
var getVendor = ags.vendor_table.ToList();
SelectList vendors = new SelectList(getVendor, "id", "companyname");
ViewBag.vendorList = vendors;
var getBank = ags.bank_table.ToList();
SelectList banks = new SelectList(getBank, "id", "bankname");
ViewBag.bankList = banks;
var getloantype = ags.loantype_table.ToList();
SelectList loantp = new SelectList(getloantype, "id", "loan_type");
ViewBag.loantypeList = loantp;
var empCategory = ags.emp_category_table.Where(x => x.emp_category_id == "process_team").ToList();
SelectList empCategories = new SelectList(empCategory, "emp_category_id", "emp_category");
ViewBag.empCategories = empCategories;
var employee = ags.admin_table.ToList();
SelectList employees = new SelectList(employee, "id", "name");
ViewBag.employees = employees;
var ExtComment = ags.external_comment_table.ToList();
SelectList commentlist = new SelectList(ExtComment, "id", "externalcomment");
ViewBag.commentList = commentlist;
//var allowedExtensions = new[] {
// ".png", ".jpg", ".jpeg",".doc",".docx",".pdf"
//};
loan_table existing = ags.loan_table.Find(loan_table.id);
string partner = existing.partnerid;
//if (existing.sactionedcopy == null)
//{
// string BigfileName = Path.GetFileNameWithoutExtension(loan_table.sactionedCopyFile.FileName);
// string fileName = BigfileName.Substring(0, 1);
// string extension2 = Path.GetExtension(loan_table.sactionedCopyFile.FileName);
// string sactionedExtension = extension2.ToLower();
// if (allowedExtensions.Contains(sactionedExtension))
// {
// fileName = fileName + DateTime.Now.ToString("yyssmmfff") + sactionedExtension;
// loan_table.sactionedcopy = "~/sactionedcopyfile/" + fileName;
// fileName = Path.Combine(Server.MapPath("~/sactionedcopyfile/"), fileName);
// loan_table.sactionedCopyFile.SaveAs(fileName);
// }
// else
// {
// TempData["Message"] = "Only 'Jpg', 'png','jpeg','docx','doc','pdf' formats are alllowed..!";
// return RedirectToAction("managerloan");
// }
//}
//else if (existing.sactionedcopy != null && loan_table.sactionedcopy != null)
//{
// if (loan_table.sactionedCopyFile != null)
// {
// string path = Server.MapPath(existing.sactionedcopy);
// FileInfo file = new FileInfo(path);
// if (file.Exists)
// {
// file.Delete();
// }
// string BigfileName = Path.GetFileNameWithoutExtension(loan_table.sactionedCopyFile.FileName);
// string fileName = BigfileName.Substring(0, 1);
// string extension2 = Path.GetExtension(loan_table.sactionedCopyFile.FileName);
// string sactionedExtension = extension2.ToLower();
// if (allowedExtensions.Contains(sactionedExtension))
// {
// fileName = fileName + DateTime.Now.ToString("yyssmmfff") + sactionedExtension;
// loan_table.sactionedcopy = "~/adminimage/" + fileName;
// fileName = Path.Combine(Server.MapPath("~/adminimage/"), fileName);
// loan_table.sactionedCopyFile.SaveAs(fileName);
// }
// else
// {
// TempData["Message"] = "Only 'Jpg', 'png','jpeg' images formats are alllowed..!";
// return RedirectToAction("managerloan");
// }
// }
// else
// {
// existing.sactionedcopy = existing.sactionedcopy;
// }
//}
//else
//{
// existing.sactionedcopy = existing.sactionedcopy;
//}
////ID copy file
//if (existing.idcopy == null)
//{
// string BigfileName = Path.GetFileNameWithoutExtension(loan_table.idCopyFile.FileName);
// string fileName = BigfileName.Substring(0, 1);
// string extension1 = Path.GetExtension(loan_table.idCopyFile.FileName);
// string idExtension = extension1.ToLower();
// if (allowedExtensions.Contains(idExtension))
// {
// fileName = fileName + DateTime.Now.ToString("yyssmmfff") + idExtension;
// loan_table.idcopy = "~/idcopyfile/" + fileName;
// fileName = Path.Combine(Server.MapPath("~/idcopyfile/"), fileName);
// loan_table.idCopyFile.SaveAs(fileName);
// }
// else
// {
// TempData["Message"] = "Only 'Jpg', 'png','jpeg','docx','doc','pdf' formats are alllowed..!";
// return RedirectToAction("managerloan");
// }
//}
//else if (existing.idcopy != null && loan_table.idcopy != null)
//{
// if (loan_table.idCopyFile != null)
// {
// string path = Server.MapPath(existing.idcopy);
// FileInfo file = new FileInfo(path);
// if (file.Exists)
// {
// file.Delete();
// }
// string BigfileName = Path.GetFileNameWithoutExtension(loan_table.idCopyFile.FileName);
// string fileName = BigfileName.Substring(0, 1);
// string extension1 = Path.GetExtension(loan_table.idCopyFile.FileName);
// string idExtension = extension1.ToLower();
// if (allowedExtensions.Contains(idExtension))
// {
// fileName = fileName + DateTime.Now.ToString("yyssmmfff") + idExtension;
// loan_table.idcopy = "~/adminimage/" + fileName;
// fileName = Path.Combine(Server.MapPath("~/adminimage/"), fileName);
// loan_table.idCopyFile.SaveAs(fileName);
// }
// else
// {
// TempData["Message"] = "Only 'Jpg', 'png','jpeg' images formats are alllowed..!";
// return RedirectToAction("managerloan");
// }
// }
// else
// {
// existing.idcopy = existing.idcopy;
// }
//}
//else
//{
// existing.idcopy = existing.idcopy;
//}
existing.customerid = loan_table.customerid;
existing.partnerid = loan_table.partnerid;
existing.bankid = loan_table.bankid;
existing.loantype = loan_table.loantype;
existing.requestloanamt = loan_table.requestloanamt;
existing.loanamt = loan_table.loanamt;
existing.disbursementamt = loan_table.disbursementamt;
existing.rateofinterest = loan_table.rateofinterest;
//existing.followupdate = loan_table.followupdate;
//existing.sactionedcopy = loan_table.sactionedcopy;
//existing.idcopy = loan_table.idcopy;
if (existing.addedby == null)
{
existing.addedby = Session["username"].ToString();
}
else
{
existing.addedby = existing.addedby;
}
if (existing.datex == null)
{
existing.datex = DateTime.Now.ToString();
}
else
{
existing.datex = existing.datex;
}
ags.SaveChanges();
int latestloanid = loan_table.id;
///Assigned Employee
loan_track_table loan_track_employee = new loan_track_table();
if (loan_table.employee != null)
{
loan_track_employee.loanid = latestloanid.ToString();
loan_track_employee.employeeid = loan_table.employee;
loan_track_employee.tracktime = DateTime.Now.ToString();
if (loan_table.internalcomment != null)
{
loan_track_employee.internalcomment = loan_table.internalcomment;
}
if (loan_table.externalcomment != null)
{
loan_track_employee.externalcomment = loan_table.externalcomment;
}
loan_track_employee.datex = DateTime.Now.ToString();
loan_track_employee.followupdate = loan_table.followupdate;
loan_track_employee.addedby = Session["username"].ToString();
ags.loan_track_table.Add(loan_track_employee);
ags.SaveChanges();
}
vendor_track_table vendor_track = new vendor_track_table();
if (loan_table.partnerid != null)
{
vendor_track.loanid = latestloanid.ToString();
if (loan_table.partnerid != partner)
{
vendor_track.vendorid = loan_table.partnerid;
vendor_track.tracktime = DateTime.Now.ToString();
vendor_track.comment = "Assigned";
vendor_track.datex = DateTime.Now.ToString();
vendor_track.addedby = Session["username"].ToString();
ags.vendor_track_table.Add(vendor_track);
ags.SaveChanges();
}
}
string loanid = latestloanid.ToString();
int loan_counts = ags.process_executive.Where(x => x.loanid == loanid).Count();
if (loan_counts > 1)
{
var process = ags.process_executive.Where(x => x.loanid == loanid);
ags.process_executive.RemoveRange(process);
ags.SaveChanges();
}
int loan_count = ags.process_executive.Where(x => x.loanid == loanid).Count();
if (loan_count == 1)
{
process_executive process_executive = ags.process_executive.Where(x => x.loanid == loanid).FirstOrDefault();
//process_executive process_executive = new process_executive();
if (latestloanid.ToString() != null)
{
process_executive.loanid = latestloanid.ToString();
process_executive.technical = form["technical"].ToString();
process_executive.legal = form["legal"].ToString();
process_executive.rcu = form["rcu"].ToString();
process_executive.comment = form["technicalValue"].ToString();
process_executive.datex = DateTime.Now.ToString();
process_executive.addedby = Session["username"].ToString();
//ags.process_executive.Add(process_executive);
ags.SaveChanges();
}
}
else if (loan_count == 0)
{
process_executive process_executive = new process_executive();
process_executive.loanid = latestloanid.ToString();
process_executive.technical = form["technical"].ToString();
process_executive.legal = form["legal"].ToString();
process_executive.rcu = form["rcu"].ToString();
process_executive.comment = form["technicalValue"].ToString();;
process_executive.datex = DateTime.Now.ToString();
process_executive.addedby = Session["username"].ToString();
ags.process_executive.Add(process_executive);
ags.SaveChanges();
}
//assigned table
assigned_table existing_data = ags.assigned_table.Where(x => x.loanid == loan_table.id.ToString()).FirstOrDefault();
//existing_data.loanid = latestloanid.ToString();
if (loan_table.employee != null)
{
existing_data.assign_emp_id = loan_table.employee;
}
else
{
existing_data.assign_emp_id = Session["userid"].ToString();
}
if (loan_table.partnerid != null)
{
existing_data.assign_vendor_id = loan_table.partnerid;
}
else
{
existing_data.assign_vendor_id = Session["userid"].ToString();
}
if (existing_data.addedby == null)
{
existing_data.addedby = Session["username"].ToString();
}
else
{
existing_data.addedby = existing_data.addedby;
}
if (existing_data.datex == null)
{
existing_data.datex = DateTime.Now.ToString();
}
else
{
existing_data.datex = existing_data.datex;
}
//loan assingned to notification table
var employeename = ags.admin_table.Where(x => x.id.ToString() == loan_table.employee).FirstOrDefault();
if (employeename != null)
{
ags.notification_table.Add(new notification_table
{
notification = "Loan " + loan_table.customerid + " Assigned" + " to " + employeename.name,
seenstatus = 1,
userid = "super_admin",
addedby = Session["username"].ToString(),
datex = DateTime.Now.ToString(),
});
}
ags.notification_table.Add(new notification_table
{
notification = "Loan (" + loan_table.customerid + ") Assigned" + " to you",
seenstatus = 1,
userid = loan_table.employee,
addedby = Session["username"].ToString(),
datex = DateTime.Now.ToString(),
});
ags.SaveChanges();
return(RedirectToAction("ProcessExecutiveLoan"));
}
return(PartialView("~/Views/ProcessExecutive/ProcessExecutiveLoan/Edit.cshtml", loan_table));
}
public ActionResult Details(int?Id)
{
if (Session["username"] == null || Session["userlevel"].ToString() != "manager")
{
return(this.RedirectToAction("Logout", "Account"));
}
if (Id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var user = ags.loan_table.Where(x => x.id == Id).FirstOrDefault();
//var getCustomerProfile = ags.customer_profile_table.Where(x=>x.id.ToString() == user.customerid.ToString()).ToList();
//SelectList customers = new SelectList(getCustomerProfile, "id", "customerid", "name", "phoneno", "profileimg");
//ViewBag.customerList = customers;
var getCustomer = ags.customer_profile_table.ToList();
string id = "";
string name = "";
string phone = "";
string email = "";
string profilimg = "";
foreach (var customer in getCustomer)
{
if (user.customerid == customer.id.ToString())
{
id = customer.customerid.ToString();
name = customer.name;
phone = customer.phoneno;
email = customer.email;
profilimg = customer.profileimg;
break;
}
else if (user.customerid != customer.id.ToString())
{
id = "Not Updated";
name = "Not Updated";
phone = "Not Updated";
email = "Not Updated";
profilimg = "Not Updated";
}
}
user.customerid = id;
ViewBag.name = name;
ViewBag.phoneno = phone;
ViewBag.email = email;
ViewBag.profileimg = profilimg;
var getVendor = ags.vendor_table.ToList();
string partner = "";
foreach (var items in getVendor)
{
if (user.partnerid == items.id.ToString())
{
string concatenated = items.companyname + " ( Company Name ) ";
partner = concatenated;
break;
}
else if (user.partnerid != items.id.ToString())
{
partner = "Not Updated" + " ( Company Name ) ";
}
}
user.partnerid = partner;
var getBank = ags.bank_table.ToList();
string banknm = "";
foreach (var bank in getBank)
{
if (user.bankid == bank.id.ToString())
{
banknm = bank.bankname;
break;
}
else if (user.bankid != bank.id.ToString())
{
banknm = "Not Updated";
}
}
user.bankid = banknm;
var getloantype = ags.loantype_table.ToList();
string loan = "";
foreach (var loantp in getloantype)
{
if (user.loantype == loantp.id.ToString())
{
loan = loantp.loan_type;
break;
}
else if (user.loantype != loantp.id.ToString())
{
loan = "Not Updated";
}
}
user.loantype = loan;
string loanid = Id.ToString();
int loan_count = ags.process_executive.Where(x => x.loanid == loanid).Count();
if (loan_count == 1)
{
process_executive process_executive = ags.process_executive.Where(x => x.loanid == loanid).FirstOrDefault();
ViewBag.loan_count = loan_count;
ViewBag.technical = process_executive.technical;
ViewBag.legal = process_executive.legal;
ViewBag.rcu = process_executive.rcu;
if (process_executive.comment == null)
{
process_executive.comment = "0";
ViewBag.comment = process_executive.comment;
}
else
{
ViewBag.comment = process_executive.comment;
}
}
return(PartialView("~/Views/Manager/ManagerLoan/Details.cshtml", user));
}
public ActionResult Edit(int?Id)
{
if (Session["username"] == null || Session["userlevel"].ToString() != "process_executive")
{
return(this.RedirectToAction("Logout", "Account"));
}
if (Id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
string username = Session["username"].ToString();
var getCustomer = ags.customer_profile_table.ToList();
SelectList customers = new SelectList(getCustomer, "id", "customerid");
ViewBag.customerList = customers;
var getVendor = ags.vendor_table.ToList();
SelectList vendors = new SelectList(getVendor, "id", "companyname");
ViewBag.vendorList = vendors;
var getBank = ags.bank_table.ToList();
SelectList banks = new SelectList(getBank, "id", "bankname");
ViewBag.bankList = banks;
var getloantype = ags.loantype_table.ToList();
SelectList loantp = new SelectList(getloantype, "id", "loan_type");
ViewBag.loantypeList = loantp;
var empCategory = ags.emp_category_table.Where(x => x.emp_category_id == "process_team").ToList();
SelectList empCategories = new SelectList(empCategory, "emp_category_id", "emp_category");
ViewBag.empCategories = empCategories;
var employee = ags.admin_table.ToList();
SelectList employees = new SelectList(employee, "id", "name");
ViewBag.employees = employees;
var ExtComment = ags.external_comment_table.ToList();
SelectList commentlist = new SelectList(ExtComment, "id", "externalcomment");
ViewBag.commentList = commentlist;
//List<emp_category_table> categoryList = ags.emp_category_table.ToList();
//ViewBag.empCategories = new SelectList(categoryList, "emp_category_id", "emp_category");
string loanid = Id.ToString();
int loan_count = ags.process_executive.Where(x => x.loanid == loanid).Count();
if (loan_count == 1)
{
process_executive process_executive = ags.process_executive.Where(x => x.loanid == loanid).FirstOrDefault();
ViewBag.technical = process_executive.technical;
ViewBag.legal = process_executive.legal;
ViewBag.rcu = process_executive.rcu;
ViewBag.comment = process_executive.comment;
}
loan_table loan_table = ags.loan_table.Find(Id);
if (loan_table == null)
{
return(HttpNotFound());
}
return(PartialView("~/Views/ProcessExecutive/ProcessExecutiveLoan/Edit.cshtml", loan_table));
}
