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