public ActionResult BorrowBack(TBLPROCESS p) { var book = db.TBLBOOK.Where(b => b.ID == p.TBLBOOK.ID).FirstOrDefault(); var process = db.TBLPROCESS.Where(z => z.ID == p.ID).FirstOrDefault(); book.State = true; process.ProcessState = true; process.BorrowBack = p.BorrowBack; DateTime d1 = Convert.ToDateTime(process.RETURNDATE); DateTime d2 = Convert.ToDateTime(process.BorrowBack); TimeSpan d3 = d2 - d1; double numberofdays = d3.TotalDays; if (!(numberofdays < 0 || numberofdays == 0)) { TBLPENALTIES tbl = new TBLPENALTIES(); tbl.Member = process.Member; tbl.Process = process.ID; tbl.Starttime = process.DATEOFPURCHASE; tbl.Endtime = process.BorrowBack; tbl.Charge = Convert.ToDecimal(numberofdays * 0.25); db.TBLPENALTIES.Add(tbl); } db.SaveChanges(); return(RedirectToAction("Index", "Lending")); }
public ActionResult toLend(TBLPROCESS p) { var member = db.TBLMEMBERS.Where(c => c.ID == p.TBLMEMBERS.ID).FirstOrDefault(); var book = db.TBLBOOK.Where(a => a.ID == p.TBLBOOK.ID).FirstOrDefault(); var employee = db.TBLEMPLOYEE.Where(e => e.ID == p.TBLEMPLOYEE.ID).FirstOrDefault(); if (book.State == true) { p.TBLBOOK = book; book.State = false; p.TBLMEMBERS = member; p.TBLEMPLOYEE = employee; db.TBLPROCESS.Add(p); p.ProcessState = false; db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("toLend")); }