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