public ActionResult Create([Bind(Include = "Id,IssueDate,MortgageItemD,ItemQuantity,Price,Loan,InterestRate,InterestRatePerMonth,MaturityOfThisLoan,CustomerId")] MortgageItem mortgageItem, HttpPostedFileBase file) { mortgageItem.Status = true; try { if (file.ContentLength > 0) { mortgageItem.File = DateTime.Now.Date.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Date.Millisecond.ToString() + Path.GetFileName(file.FileName); mortgageItem.FilePath = Path.Combine(Server.MapPath("~/Image"), mortgageItem.File); file.SaveAs(mortgageItem.FilePath); } } catch { ViewBag.Message = " File Upload Failed!"; return(View(mortgageItem)); } if (ModelState.IsValid) { db.MortgageItems.Add(mortgageItem); db.SaveChanges(); return(RedirectToAction("Details", "Customers", new { Id = mortgageItem.CustomerId })); } return(RedirectToAction("Details", "Customers", new { Id = mortgageItem.CustomerId })); }
public ActionResult Edit([Bind(Include = "Id,IssueDate,MortgageItemD,MortgageItemFile,MortgageItemPath,ItemQuantity,Price,Loan,InterestRate,InterestRatePerMonth,MaturityOfThisLoan,File,FilePath,CustomerId")] MortgageItem mortgageItem, HttpPostedFileBase file) { mortgageItem.Status = true; if (file != null) { try { if (file.ContentLength > 0) { mortgageItem.File = DateTime.Now.Date.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Date.Millisecond.ToString() + Path.GetFileName(file.FileName); mortgageItem.FilePath = Path.Combine(Server.MapPath("~/Image"), mortgageItem.File); file.SaveAs(mortgageItem.FilePath); } } catch { ViewBag.Message = " File Upload Failed!"; return(View(mortgageItem)); } } if (ModelState.IsValid) { db.Entry(mortgageItem).State = EntityState.Modified; db.SaveChanges(); ViewBag.Message = "Successfully Updated!"; return(View(mortgageItem)); } return(View(mortgageItem)); }
// GET: MortgageItems/Create public ActionResult Create(int Id) { Customer C = db.Customers.Find(Id); ViewBag.Customer = C.FullName; MortgageItem MR = new MortgageItem(); MR.CustomerId = Id; return(View(MR)); }
public ActionResult DeleteConfirmed(int id) { MortgageItem mortgageItem = db.MortgageItems.Find(id); mortgageItem.Status = false; mortgageItem.MaturityOfThisLoan = DateTime.Now; db.Entry(mortgageItem).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", "Customers", new { Id = mortgageItem.CustomerId })); }
// GET: MortgageItems/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MortgageItem mortgageItem = db.MortgageItems.Find(id); if (mortgageItem == null) { return(HttpNotFound()); } return(View(mortgageItem)); }
public ActionResult Index(DateTime From, DateTime To) { List <MortgageItem> deposites = db.MortgageItems.Where(a => a.IssueDate >= From && a.IssueDate <= To).Where(a => a.Status == true).Include(d => d.Customer).ToList(); List <MortgageItem> deposites2 = db.MortgageItems.Where(a => a.IssueDate.Day == To.Day && a.IssueDate.Month == To.Month && a.IssueDate.Year == To.Year).Where(a => a.Status == true).Include(d => d.Customer).ToList(); foreach (MortgageItem M in deposites2) { MortgageItem Moo = deposites.FirstOrDefault(a => a.Id == M.Id); if (Moo == null ) { deposites.Add(M); } } double Amount = 0; if (deposites.Count > 0) { foreach (MortgageItem D in deposites) { Amount = Amount + D.Loan; } } MortgageItem deposite = new MortgageItem(); deposite.ItemQuantity = "Total"; deposite.Loan = Amount; deposites.Add(deposite); return(View(deposites.ToList())); }