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); }