public ActionResult login(registration data, issue_book book)
{
var login = db.registrations.Where(i => i.EMAIL == data.EMAIL && i.PASSWORD == data.PASSWORD).SingleOrDefault();
if (login == null)
{
TempData["msg"] = "Email id or Password is wrong";
return(RedirectToAction("login"));
}
else
{
var role = db.user_role.Where(i => i.USER_ID == login.ID && i.IS_DELETED == false).FirstOrDefault();
Session["roll"] = role.USER_ROLE1;
Session["login"] = login.NAME;
Session["ID"] = login.ID;
var returnbook = db.issue_book.Where(i => i.USER_ID == login.ID).ToList();
foreach (var item in returnbook)
{
if (returnbook != null)
{
var issuedate = Convert.ToDateTime(item.ISSUE_DATE);
var expirydate2 = Convert.ToDateTime(item.EXPIRY_DATE);
var today2 = expirydate2.AddDays(-1);
if (DateTime.Now.Date == today2.Date)
{
Session["noti"] = "You have to return a book by Tomorrow";
}
db.SaveChanges();
}
}
return(RedirectToAction("book"));
}
}
public ActionResult issuebook(issue_book data)
{
if (data.ID > 0)
{
var regist = db.issue_book.Where(i => i.ID == data.ID).SingleOrDefault();
if (regist != null)
{
regist.BOOK_ID = data.BOOK_ID;
regist.ISSUEBOOK = data.ISSUEBOOK;
if (data.ISSUE_DATE != null)
{
regist.ISSUE_DATE = data.ISSUE_DATE;
}
//if (data.EXPIRY_DATE != null)
//{
// regist.EXPIRY_DATE = data.EXPIRY_DATE;
//}
if (data.FEES != null)
{
regist.FEES = data.FEES;
}
if (data.USER_ID != null)
{
regist.USER_ID = data.USER_ID;
}
db.SaveChanges();
}
}
else
{
var regist = db.issue_book.Where(i => i.USER_ID == data.USER_ID && i.IS_RETURN == false).SingleOrDefault();
if (regist != null)
{
TempData["issuebook"] = "User Have Already issue book";
return(RedirectToAction("issuebook"));
}
data.IS_RETURN = false;
if (data.ISSUE_DATE == null)
{
data.ISSUE_DATE = DateTime.Now;
var issuedate = DateTime.Now;
data.EXPIRY_DATE = issuedate.AddDays(10);
}
else
{
var issuedate = Convert.ToDateTime(data.ISSUE_DATE);
data.EXPIRY_DATE = issuedate.AddDays(10);
}
var reg = db.issue_book.Add(data);
db.SaveChanges();
var book = db.books.Where(i => i.ID == data.BOOK_ID).SingleOrDefault();
book.AVAILABLE = "No";
db.SaveChanges();
}
return(RedirectToAction("issuebook"));
}
