public ActionResult Create(int?id) { //var details = db.Orders.Where(odt => odt.UserName == userName).ToList; Order orders = db.Orders.Find(id); DisbursedLoan views = new DisbursedLoan() { //UserName = User.Identity.Name, CompanyId = orders.CompanyId, CustomerId = orders.CustomerId, WarehouseId = orders.WarehouseId, OrderId = orders.OrderId, StateId = DBHelper.GetState("Disbursed", db), TypeLoanId = DBHelper.GetTypeLoan("Renewed", db), LoanStateId = DBHelper.GetLoanState("Common", db), StartDate = orders.StartDate, EndDate = orders.EndDate, Period = orders.Period, UserName = User.Identity.Name, Remarks = orders.Remarks, BorrowedCapital = orders.BorrowedCapital, Interest = orders.Interest, Total = orders.Total, Balance = orders.Balance, DailyPayment = orders.DailyPayment, OperatingExpenses = orders.OperatingExpenses, }; var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault(); ViewBag.CompanyId = new SelectList(CombosHelper.GetCompanies(), "CompanyId", "Name", orders.CompanyId); ViewBag.CustomerId = new SelectList(CombosHelper.GetCustomers(user.CompanyId), "CustomerId", "FullName", orders.CustomerId); return(View(views)); }
public async Task <ActionResult> DeleteConfirmed(int id) { DisbursedLoan disbursedLoan = await db.DisbursedLoans.FindAsync(id); db.DisbursedLoans.Remove(disbursedLoan); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
// GET: DisbursedLoans/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DisbursedLoan disbursedLoan = await db.DisbursedLoans.FindAsync(id); if (disbursedLoan == null) { return(HttpNotFound()); } return(View(disbursedLoan)); }
public ActionResult Create(DisbursedLoan view) { if (ModelState.IsValid) { var response = MovementsHelper.NewLoan(view, User.Identity.Name); if (response.Succeeded) { return(RedirectToAction("Index")); } ModelState.AddModelError(string.Empty, response.Message); } ViewBag.CompanyId = new SelectList(CombosHelper.GetCompanies(), "CompanyId", "Name", view.CompanyId); ViewBag.CustomerId = new SelectList(CombosHelper.GetCustomers(view.CompanyId), "CustomerId", "FullName", view.CustomerId); return(View(view)); }
public async Task <ActionResult> Edit(DisbursedLoan disbursedLoan) { if (ModelState.IsValid) { db.Entry(disbursedLoan).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "Name", disbursedLoan.CompanyId); ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "UserName", disbursedLoan.CustomerId); ViewBag.LoanStateId = new SelectList(db.LoanStates, "LoanStateId", "Description", disbursedLoan.LoanStateId); ViewBag.StateId = new SelectList(db.States, "StateId", "Description", disbursedLoan.StateId); ViewBag.TypeLoanId = new SelectList(db.TypeLoans, "TypeLoanId", "Description", disbursedLoan.TypeLoanId); ViewBag.WarehouseId = new SelectList(db.Warehouses, "WarehouseId", "Name", disbursedLoan.WarehouseId); return(View(disbursedLoan)); }
// GET: DisbursedLoans/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DisbursedLoan disbursedLoan = await db.DisbursedLoans.FindAsync(id); if (disbursedLoan == null) { return(HttpNotFound()); } ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "Name", disbursedLoan.CompanyId); ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "UserName", disbursedLoan.CustomerId); ViewBag.LoanStateId = new SelectList(db.LoanStates, "LoanStateId", "Description", disbursedLoan.LoanStateId); ViewBag.StateId = new SelectList(db.States, "StateId", "Description", disbursedLoan.StateId); ViewBag.TypeLoanId = new SelectList(db.TypeLoans, "TypeLoanId", "Description", disbursedLoan.TypeLoanId); ViewBag.WarehouseId = new SelectList(db.Warehouses, "WarehouseId", "Name", disbursedLoan.WarehouseId); return(View(disbursedLoan)); }
public static Response NewLoan(DisbursedLoan view, string userName) { using (var transacction = db.Database.BeginTransaction()) { try { var user = db.Users.Where(u => u.UserName == userName).FirstOrDefault(); var lastOrder = db.Orders.Where(l => l.OrderId == view.OrderId).FirstOrDefault(); lastOrder.CompanyId = view.CompanyId; lastOrder.CustomerId = view.CustomerId; lastOrder.WarehouseId = view.WarehouseId; lastOrder.OrderId = view.OrderId; lastOrder.StateId = DBHelper.GetState("Disbursed", db); lastOrder.StartDate = view.StartDate; lastOrder.EndDate = view.EndDate; lastOrder.Period = view.Period; lastOrder.UserName = view.UserName; lastOrder.Remarks = lastOrder.Remarks; lastOrder.BorrowedCapital = lastOrder.BorrowedCapital; lastOrder.Interest = lastOrder.Interest; lastOrder.Total = lastOrder.Total; lastOrder.Balance = lastOrder.Balance; lastOrder.DailyPayment = lastOrder.DailyPayment; lastOrder.OperatingExpenses = lastOrder.OperatingExpenses; db.Entry(lastOrder).State = EntityState.Modified; db.SaveChanges(); var disbursedLoan = new DisbursedLoan { CompanyId = view.CompanyId, CustomerId = view.CustomerId, WarehouseId = view.WarehouseId, OrderId = view.OrderId, StateId = DBHelper.GetState("Disbursed", db), TypeLoanId = DBHelper.GetTypeLoan("Renewed", db), LoanStateId = DBHelper.GetLoanState("Common", db), StartDate = view.StartDate, EndDate = view.EndDate, Period = view.Period, UserName = view.UserName, Remarks = view.Remarks, BorrowedCapital = view.BorrowedCapital, Interest = view.Interest, Total = view.Total, Balance = view.Balance, DailyPayment = view.DailyPayment, OperatingExpenses = view.OperatingExpenses, }; db.DisbursedLoans.Add(disbursedLoan); db.SaveChanges(); transacction.Commit(); return(new Response { Succeeded = true, }); } catch (Exception ex) { transacction.Rollback(); return(new Response { Message = ex.Message, Succeeded = false, }); } } }