public void PlaceOnHold(Item item)
{
List <Reservation> lstRe = db.Reservations.Where(x => x.Id_Title == item.Id_Title && x.Status == "Chưa Có Đĩa").ToList();
if (lstRe != null)
{
Reservation re = new Reservation();
re.Id_Reservation = int.MaxValue;
foreach (Reservation reitem in lstRe)
{
if (reitem.Id_Reservation < re.Id_Reservation)
{
re = reitem;
}
}
if (re.Id_Reservation == int.MaxValue)
{
return;
}
item.Status = "On-Hold";
re.Status = "Đã Có Đĩa";
//thêm reDetail
ReserDetails reDetail = new ReserDetails();
reDetail.Id_Reservation = re.Id_Reservation;
reDetail.Id_Item = item.Id_Item;
db.ReserDetails.Add(reDetail);
db.SaveChanges();
}
}
public JsonResult DeleteReservationsRecord(int Id)
{
bool result = false;
Reservation Res = db.Reservations.SingleOrDefault(x => x.Id_Reservation == Id);
//Xoa chi tiet cua dat cho
ReserDetails ResD = db.ReserDetails.Where(x => x.Id_Reservation == Id).FirstOrDefault();
if (Res.Status == "Đã Có Đĩa")
{
Item item = db.Items.Where(x => x.Id_Item == ResD.Id_Item).FirstOrDefault();
item.Status = "On-Shelf";
}
db.ReserDetails.Remove(ResD);
//Xoa dat cho
db.Reservations.Remove(Res);
db.SaveChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
