public ActionResult Save(Kvar emp) { bool status = false; if (ModelState.IsValid) { using (BazaParkGateEntities dc = new BazaParkGateEntities()) { if (emp.KvarID > 0) { //Edit var v = dc.Kvar.Where(a => a.KvarID == emp.KvarID).FirstOrDefault(); if (v != null) { v.DatumKvara = emp.DatumKvara; v.OpisKvara = emp.OpisKvara; v.IDZaposlenog = emp.IDZaposlenog; v.GostID = emp.GostID; v.BrojSobe = emp.BrojSobe; } } else { //Save dc.Kvar.Add(emp); } dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
internal Zaposleni VratiZaposlenog() { using (BazaParkGateEntities db = new BazaParkGateEntities()) { return(db.Zaposleni.FirstOrDefault()); } }
internal List <Soba> VratiSobe() { using (BazaParkGateEntities db = new BazaParkGateEntities()) { return(db.Soba.ToList()); } }
public ActionResult Save(int id) { using (BazaParkGateEntities dc = new BazaParkGateEntities()) { var v = dc.Kvar.Where(a => a.KvarID == id).FirstOrDefault(); return(View(v)); } }
internal int VratiSifruKvara() { using (BazaParkGateEntities db = new BazaParkGateEntities()) { List <Kvar> lista = db.Kvar.ToList(); return(lista.Count == 0 ? 1 : lista.Max(x => x.KvarID) + 1); } }
public Gost PronadjiGosta(int sifraGosta) { using (BazaParkGateEntities db = new BazaParkGateEntities()) { return(db.Gost.AsNoTracking() .ToList() .Where(g => g.SifraGosta == sifraGosta) .SingleOrDefault()); } }
public List <Kvar> PronadjiKvarove(DateTime datumKvara) { using (BazaParkGateEntities db = new BazaParkGateEntities()) { return(db.Kvar.AsNoTracking() .Include(k => k.Gost) .Include(k => k.Soba) .Include(k => k.Zaposleni) .Where(k => k.DatumKvara == datumKvara) .ToList()); } }
public ActionResult GetEmployees() { using (BazaParkGateEntities db = new BazaParkGateEntities()) { var kvarovi = db.Kvar.OrderBy(a => a.DatumKvara).ToList(); foreach (var item in kvarovi) { string formatted = item.DatumKvara.ToString("yyyy-MM-dd"); item.Datum = formatted; } return(Json(new { data = kvarovi }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (BazaParkGateEntities dc = new BazaParkGateEntities()) { var v = dc.Kvar.Where(a => a.KvarID == id).FirstOrDefault(); if (v != null) { return(View(v)); } else { return(HttpNotFound()); } } }
public ActionResult DeleteEmployee(int id) { bool status = false; using (BazaParkGateEntities dc = new BazaParkGateEntities()) { var v = dc.Kvar.Where(a => a.KvarID == id).FirstOrDefault(); if (v != null) { dc.Kvar.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }