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