public ActionResult DeleteConfirmed(int id)
{
AlbumCopy albumCopy = db.AlbumCopies.Find(id);
db.AlbumCopies.Remove(albumCopy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "AlbumCopyId,IssueDate,DvdCopyNumber,AlbumId,CopyStatus")] AlbumCopy albumCopy)
{
if (ModelState.IsValid)
{
db.Entry(albumCopy).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AlbumId = new SelectList(db.Albums, "AlbumId", "Name", albumCopy.AlbumId);
return(View(albumCopy));
}
public ActionResult Create([Bind(Include = "LoanId,MemberId,AlbumCopyId,IssuedDate,DueDate,ReturnedDate,TotalCharge,LoanTypes")] Loan loan)
{
if (ModelState.IsValid)
{
AlbumCopy albumCopy = db.AlbumCopies.Find(loan.AlbumCopyId);
DateTime startTime = DateTime.Now;
Member member = db.Members.Single(m => m.MemberID == loan.MemberId);
var age = startTime.Year - member.Dob.Year;
int copyLoancount = (from l in db.Loans.ToList()
where l.AlbumCopyId == albumCopy.AlbumCopyId
select albumCopy
).ToList().Count();
int loanCount = (from l in db.Loans.ToList()
where l.MemberId == member.MemberID
where l.ReturnedDate == null
select l).ToList().Count();
//MemberCategory silver = db.MemberCategories.Single(m => m.CategoryName == "Silver");
//MemberCategory gold = db.MemberCategories.Single(m => m.CategoryName == "Gold");
//MemberCategory diamond = db.MemberCategories.Single(m => m.CategoryName == "Diamond");
MemberCategory cata = db.MemberCategories.Single(m => m.MemberCategoryId == member.MemberCategoryId);
var albumres = (
from l in db.Loans
join c in db.AlbumCopies
on l.AlbumCopyId equals c.AlbumCopyId
join a in db.Albums on c.AlbumId equals a.AlbumId
select a
);
Album album = db.Albums.Find(albumCopy.AlbumId);
if (member.MemberCategoryId == cata.MemberCategoryId && loanCount == cata.LoanAvailable && copyLoancount > 1)
{
TempData["Error"] = "loan not available";
}
else if (album.AgeRestricted == true && age < 18)
{
TempData["Error"] = "User is small";
}
else
{
db.Loans.Add(loan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.AlbumCopyId = new SelectList(db.AlbumCopies, "AlbumCopyId", "DvdCopyNumber", loan.AlbumCopyId);
ViewBag.MemberId = new SelectList(db.Members, "MemberID", "FirstName", loan.MemberId);
return(View(loan));
}
// GET: AlbumCopies/Details/5
public ActionResult Details(int?id)
{
if (Session["assis"] != null || Session["manag"] != null || Session["memb"] != null)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AlbumCopy albumCopy = db.AlbumCopies.Find(id);
if (albumCopy == null)
{
return(HttpNotFound());
}
return(View(albumCopy));
}
return(null);
}
// GET: AlbumCopies/Edit/5
public ActionResult Edit(int?id)
{
if (Session["assis"] != null || Session["manag"] != null)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AlbumCopy albumCopy = db.AlbumCopies.Find(id);
if (albumCopy == null)
{
return(HttpNotFound());
}
ViewBag.AlbumId = new SelectList(db.Albums, "AlbumId", "Name", albumCopy.AlbumId);
return(View(albumCopy));
}
return(null);
}
