public ActionResult Edit([Bind(Include = "LoanId,IssuedDate,ReturnedDate,TotalFine,DVDId,MemberId")] Loan loan)
{
if (ModelState.IsValid)
{
ViewBag.DVDId = new SelectList(db.DVDDetails, "DVDId", "Title", loan.DVDId);
ViewBag.MemberId = new SelectList(db.Members, "MemberId", "Name", loan.MemberId);
var data = loan.DVDId;
if (loan.ReturnedDate != null)
{
DVDDetail dvd = db.DVDDetails.Find(data);
string copyNumber = dvd.NoOfCopy;
int cn = int.Parse(copyNumber);
int cnn = cn + 1;
copyNumber = cnn.ToString();
dvd.NoOfCopy = copyNumber;
db.Entry(dvd).State = EntityState.Modified;
db.SaveChanges();
}
db.Entry(loan).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loan));
}
public ActionResult DeleteConfirmed(int id)
{
DVDDetail dVDDetail = db.DVDDetails.Find(id);
db.DVDDetails.Remove(dVDDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "DVDId,Title,Genre,NoOfCopy,AgeRestriction,StudioName,DVDCover,DateAdded")] DVDDetail dVDDetail)
{
if (ModelState.IsValid)
{
db.Entry(dVDDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dVDDetail));
}
public ActionResult Create([Bind(Include = "DVDId,Title,Genre,NoOfCopy,AgeRestriction,StudioName,DVDCover,DateAdded")] DVDDetail dVDDetail)
{
if (ModelState.IsValid)
{
db.DVDDetails.Add(dVDDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dVDDetail));
}
public ActionResult Edit([Bind(Include = "DVDId,Title,DVDCatId,StudioId,Description")] DVDDetail dVDDetail)
{
if (ModelState.IsValid)
{
db.Entry(dVDDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DVDCatId = new SelectList(db.DVDCategories, "DvdCatId", "Category", dVDDetail.DVDCatId);
ViewBag.StudioId = new SelectList(db.Studios, "StudioId", "Name", dVDDetail.StudioId);
return(View(dVDDetail));
}
// GET: DVDDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DVDDetail dVDDetail = db.DVDDetails.Find(id);
if (dVDDetail == null)
{
return(HttpNotFound());
}
return(View(dVDDetail));
}
public Boolean CheckDvdStock(int dvdId)
{
DVDDetail dvd = db.DVDDetails.Find(dvdId);
string cp = dvd.NoOfCopy;
int copyNumber = int.Parse(cp);
if (copyNumber > 0)
{
return(true);
}
else
{
return(false);
}
}
// GET: DVDDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DVDDetail dVDDetail = db.DVDDetails.Find(id);
if (dVDDetail == null)
{
return(HttpNotFound());
}
ViewBag.DVDCatId = new SelectList(db.DVDCategories, "DvdCatId", "Category", dVDDetail.DVDCatId);
ViewBag.StudioId = new SelectList(db.Studios, "StudioId", "Name", dVDDetail.StudioId);
return(View(dVDDetail));
}
public ActionResult Edit([Bind(Include = "Id,DVDName,StudioName,ReleasedDate,AgeRestriction,Length,CoverImagePath")] DVDDetail dVDDetail)
{
string fileName = Path.GetFileNameWithoutExtension(dVDDetail.CoverImage.FileName);
string extention = Path.GetExtension(dVDDetail.CoverImage.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extention;
dVDDetail.CoverImagePath = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
dVDDetail.CoverImage.SaveAs(fileName);
if (ModelState.IsValid)
{
db.Entry(dVDDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dVDDetail));
}
public ActionResult Create(DVDDetail dVDDetail)
{
string fileName = Path.GetFileNameWithoutExtension(dVDDetail.CoverImage.FileName);
string extention = Path.GetExtension(dVDDetail.CoverImage.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extention;
dVDDetail.CoverImagePath = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
dVDDetail.CoverImage.SaveAs(fileName);
if (ModelState.IsValid)
{
db.DVDDetails.Add(dVDDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dVDDetail));
}
public ActionResult DeleteConfirmed(int id)
{
DVDDetail path = db.DVDDetails.Where(x => x.DVDId == id).FirstOrDefault();
string imagePath = path.DVDCoverPath;
string filePath = Server.MapPath(imagePath);
Boolean exist = false;
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
exist = true;
}
if (exist == true)
{
DVDDetail dVDDetail = db.DVDDetails.Find(id);
db.DVDDetails.Remove(dVDDetail);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "LoanId,IssuedDate,ReturnedDate,TotalFine,DVDId,MemberId")] Loan loan)
{
if (ModelState.IsValid)
{
ViewBag.DVDId = new SelectList(db.DVDDetails, "DVDId", "Title", loan.DVDId);
ViewBag.MemberId = new SelectList(db.Members, "MemberId", "Name", loan.MemberId);
var data = loan.DVDId;
var member = loan.MemberId;
DVDDetail dvd = db.DVDDetails.Find(data);
int memberId = member;
int dvdId = data;
CheckDvdStock(dvdId);
string ageVerify = dvd.AgeRestriction;
if (CheckLoanNumbers(memberId) == true)
{
if (CheckDvdStock(dvdId) == true)
{
if (ageVerify == "18+")
{
if (CheckAge(memberId) == true)
{
if (data != null)
{
string copyNumber = dvd.NoOfCopy;
int cn = int.Parse(copyNumber);
int cnn = cn - 1;
copyNumber = cnn.ToString();
dvd.NoOfCopy = copyNumber;
db.Entry(dvd).State = EntityState.Modified;
db.SaveChanges();
}
db.Loans.Add(loan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.ErrorMessage = "This user is too small to watch the movie";
return(View());
}
}
else
{
if (data != null)
{
string copyNumber = dvd.NoOfCopy;
int cn = int.Parse(copyNumber);
int cnn = cn - 1;
copyNumber = cnn.ToString();
dvd.NoOfCopy = copyNumber;
db.Entry(dvd).State = EntityState.Modified;
db.SaveChanges();
}
db.Loans.Add(loan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.ErrorMessage = "The Dvd is out of stock";
return(View());
}
}
else
{
ViewBag.ErrorMessage = "According to the Member Category the Dvd loan has exceeded!";
return(View());
}
}
return(View(loan));
}
