public void MasaKapat(int masaID) { using (var db = new NusrETEntities()) { Masalar m = db.Masalar.Find(masaID); if (m.Statu == 1) { List <Siparisler> siparisList = MasaAktifSiparisleri(masaID); foreach (var item in siparisList) { Siparisler s = db.Siparisler.Find(item.Id); db.Siparisler.Remove(s); } List <Sepet> sepetList = MasaAktifSepetleri(masaID); foreach (var item in sepetList) { Sepet s = db.Sepet.Find(item.Id); db.Sepet.Remove(s); } m.Statu = 0; Garsonlar g = db.Garsonlar.Find(m.GarsonID); g.Statu = 0; m.GarsonID = 0; db.Entry(m).State = EntityState.Modified; db.SaveChanges(); } } }
public ActionResult GarsonEkle(Garsonlar g) { if (g != null) { efGarson.AddGarson(g); } return(RedirectToAction("Garsonlar", "Home")); }
public string GetGarsonIsim(int garsonID) { using (var db = new NusrETEntities()) { Garsonlar g = db.Garsonlar.Find(garsonID); return(g.Ad + " " + g.Soyad); } }
public void UpdateGarson(Garsonlar g) { using (var db = new NusrETEntities()) { db.Entry(g).State = EntityState.Modified; db.SaveChanges(); } }
public Garsonlar GetGarson(int garsonID) { using (var db = new NusrETEntities()) { Garsonlar g = db.Garsonlar.Find(garsonID); return(g); } }
public void AddGarson(Garsonlar g) { using (var db = new NusrETEntities()) { db.Garsonlar.Add(g); db.SaveChanges(); } }
public int Login(string username, string pass) { using (var db = new NusrETEntities()) { Garsonlar g = db.Garsonlar.FirstOrDefault(x => x.Kadi == username && x.Sifre == pass); if (g != null) { return(1); } else { return(0); } } }
public void DeleteGarson(int garsonID) { using (var db = new NusrETEntities()) { Garsonlar g = db.Garsonlar.Find(garsonID); List <Masalar> ls = db.Masalar.Where(x => x.GarsonID == g.Id).ToList(); foreach (var item in ls) { item.GarsonID = 0; db.Entry(item).State = EntityState.Modified; } db.Garsonlar.Remove(g); db.SaveChanges(); } }
public Garsonlar GetGarson(int masaID) { using (var db = new NusrETEntities()) { Masalar m = db.Masalar.Find(masaID); Garsonlar g = new Garsonlar(); if (m != null) { if (m.GarsonID != null || m.GarsonID != 0) { g = db.Garsonlar.Find(m.GarsonID); } } return(g); } }
public void GarsonEkle(int masaID, int garsonID) { using (var db = new NusrETEntities()) { Masalar m = db.Masalar.Find(masaID); if (m.GarsonID != 0 || m.GarsonID != null) { m.GarsonID = garsonID; db.Entry(m).State = EntityState.Modified; Garsonlar g = db.Garsonlar.Find(garsonID); g.Statu = 1; db.Entry(g).State = EntityState.Modified; db.SaveChanges(); } } }
public ActionResult EditGarson(Garsonlar g) { try { ViewBag.GarsonAd = efGarson.GetGarsonIsim(Convert.ToInt32(Session["GarsonId"])); efGarson.UpdateGarson(g); ViewBag.Msg = "1"; Garsonlar gc = efGarson.GetGarson(Convert.ToInt32(Session["GarsonId"])); return(View(gc)); } catch { ViewBag.GarsonAd = efGarson.GetGarsonIsim(Convert.ToInt32(Session["GarsonId"])); Garsonlar gc = efGarson.GetGarson(Convert.ToInt32(Session["GarsonId"])); ViewBag.Msg = "0"; return(View(gc)); } }
public ViewResult GarsonDetay() { int masaID = Convert.ToInt32(Session["MasaID"]); Garsonlar g = efMasa.GetGarson(masaID); List <Garsonlar> lg = efGarson.GetGarsonList(); List <SelectListItem> dropwItems = new List <SelectListItem>(); foreach (var garson in lg) { dropwItems.Add(new SelectListItem { Text = "(" + garson.Id + ")" + garson.Ad + garson.Soyad, Value = garson.Id.ToString() }); } ViewData["DataListGarson"] = dropwItems; return(View(g)); }
public ActionResult EditGarson(int Id) { int control = SessionControl(); if (control == 1) { Garsonlar g = efGarson.GetGarson(Id); if (g != null) { ViewBag.GarsonAd = efGarson.GetGarsonIsim(g.Id); Session["GarsonId"] = g.Id; } else { return(RedirectToAction("Login", "Login")); } return(View(g)); } else { return(RedirectToAction("Login", "Login")); } }