public static ReservationVIewModel GetByTable(int tableid)
{
ReservationVIewModel result = new ReservationVIewModel();
using (var db = new KitchenContext())
{
result = (from r in db.Reservations
join t in db.Tables on
r.tableid equals t.id
where r.tableid == tableid
select new ReservationVIewModel
{
id = r.id,
tableid = r.tableid,
tableinit = t.initial,
tabledesc = t.Desc,
reference = r.reference,
Paid = r.Paid,
guest = r.guest,
Active = r.Active
}).FirstOrDefault();
return(result == null ? result = new ReservationVIewModel() : result);
}
}
public ActionResult Create(int id)
{
//id = table id
ReservationVIewModel model = new ReservationVIewModel()
{
tableid = id
};
return(PartialView("_Create", model));
}
public ActionResult GetSelectedTable(int id)
{
ReservationVIewModel model = ReservationRepo.GetByTable(id);
return(Json(new
{
success = model.id == 0 ? false : true,
entity = model
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(ReservationVIewModel model)
{
ResponResultViewModel respon = ReservationRepo.Update(model);
return(Json(new
{
success = respon.Success,
message = respon.Message,
entity = respon.Entity
}, JsonRequestBehavior.AllowGet));
}
public static ResponResultViewModel Update(ReservationVIewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
entity.reference = GerReff();
try
{
using (var db = new KitchenContext())
{
if (entity.id == 0)
{
Reservation reserv = new Reservation();
reserv.guest = entity.guest;
reserv.reference = entity.reference;
reserv.tableid = entity.tableid;
reserv.Paid = false;
reserv.CreateBy = "Floofloo";
reserv.CreateDate = DateTime.Now;
reserv.Active = true;
db.Reservations.Add(reserv);
db.SaveChanges();
result.Entity = entity;
}
else
{
Reservation reserv = db.Reservations.Where(r => r.id == entity.id).FirstOrDefault();
reserv.guest = entity.guest;
reserv.ModifyBy = "BlubluRese";
reserv.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ee)
{
result.Success = false;
result.Message = ee.Message;
}
return(result);
}
