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