/// <summary> /// Show pending request's to admin /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Index(string id) { try { Request obj = new Request(); int Id = Int32.Parse(id); string userid = User.Identity.GetUserName(); var person = db.Employees.Where(y => y.Email == userid).First(); obj.EmployeeId = person.Id; obj.LoanId = Id; string cmd = "SELECT * FROM Lookup"; SqlDataReader reader = Database_Connection.get_instance().Getdata(cmd); while (reader.Read()) { if (reader.GetString(1) == "Pending") { obj.Status = reader.GetInt32(0); } } db.Requests.Add(obj); db.SaveChanges(); return(RedirectToAction("Index", "Account")); } catch (Exception ex) { throw (ex); } }
public ActionResult AddDocuments(int id, DocumentViewModel model, IEnumerable <HttpPostedFileBase> ImageFile) { model.temp = temp2.Count(); string userid = User.Identity.GetUserName(); var person = db.Employees.Where(y => y.Email == userid).First(); int i = 0; foreach (var files in ImageFile) { Document obj = new Document(); obj.Title = temp2[i]; obj.EmployeeId = person.Id; obj.LoanId = id; string cmd = "SELECT * FROM Lookup"; SqlDataReader reader = Database_Connection.get_instance().Getdata(cmd); while (reader.Read()) { if (reader.GetString(1) == "NotVerified") { obj.Status = reader.GetInt32(0); } } string fileName = Path.GetFileName(files.FileName); string extension = Path.GetExtension(files.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; model.Document = "~/Image/" + fileName; fileName = Path.Combine(Server.MapPath("~/Image/"), fileName); model.ImageFile.SaveAs(fileName); obj.RequiredDocuments = model.Document; db.Documents.Add(obj); db.SaveChanges(); i++; } //foreach (EmployeeLoan e in db.EmployeeLoans) //{ // if (e.EmployeeId != person.Id && e.LoanId != id && e.InstallementId != tem) // { // } // else { DateTime date = DateTime.Now.Date; string cmd2 = string.Format("INSERT INTO EmployeeLoan(EmployeeId,LoanId,InstallementId,Status,AssignDate) VALUES('{0}','{1}','{2}','{3}','{4}')", person.Id, id, tem, 2, date); int rows = Database_Connection.get_instance().Executequery(cmd2); temp2 = null; return(RedirectToAction("Index", "Account")); }
/// <summary> /// Delete Loan /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult DeleteLoan(int id) { try { DB64Entities db = new DB64Entities(); var item = db.Loans.Where(x => x.Id == id).SingleOrDefault(); db.Loans.Remove(item); db.SaveChanges(); return(RedirectToAction("Loanlist", "Admin")); } catch (Exception ex) { throw(ex); } }
/// <summary> /// Delete installment from database /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult DeleteInstallment(int id) { try { DB64Entities db = new DB64Entities(); var item2 = db.Installements.Where(x => x.Id == id).SingleOrDefault(); int temp = item2.LoanId; var item = db.Installements.Where(x => x.Id == id).SingleOrDefault(); db.Installements.Remove(item); db.SaveChanges(); return(RedirectToAction("ViewInstallment", "Admin", new { id = temp })); } catch (Exception ex) { throw (ex); } }