public ActionResult Create(masaKategori masakategori)
{
int sess = Convert.ToInt32(Session["userID"]);
if (ModelState.IsValid)
{
masakategori.isactive = false;
db.masaKategoris.Add(masakategori);
db.SaveChanges();
return(RedirectToAction("Index", "AdminMasaKategori"));
}
return(View(masakategori));
}
public ActionResult Edit(masaKategori masa, int masaKatID)
{
if (ModelState.IsValid)
{
var masas = db.masaKategoris.Where(k => k.masaKatID == masaKatID).SingleOrDefault();
masas.masaKatAdi = masa.masaKatAdi;
db.SaveChanges();
return(RedirectToAction("Index", "AdminMasaKategori", new { masaKatID = masas.masaKatID }));
}
return(View());
}
public JsonResult DeleteMasaKategoriRecord(int masaKatID)
{
bool result = false;
masaKategori ktgr = db.masaKategoris.Find(masaKatID);
Masa alt = db.Masas.Where(x => x.masaKatID == masaKatID).FirstOrDefault();
if (ktgr != null)
{
if (alt == null)
{
ktgr.isactive = true;
db.masaKategoris.Remove(ktgr);
db.SaveChanges();
result = true;
}
else
{
result = false;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(int?masaKatID)
{
Session["masaKatAdi"] = "Bahce";
if (masaKatID != null)
{
if (!String.IsNullOrEmpty(Request.QueryString["masaKatID"]))
{
// Query string value is there so now use it
int masaKat = Convert.ToInt32(Request.QueryString["masaKatID"]);
Session["masaKatID"] = masaKat;
var masaKatAdi = db.masaKategoris.Where(x => x.masaKatID == masaKatID).Select(x => x.masaKatAdi).FirstOrDefault();
Session["masaKatAdi"] = masaKatAdi.ToString();
}
var result2 =
from p1 in db.Masas
join c1 in db.CartItems on p1.masaID equals c1.masaID into j1
from j2 in j1.DefaultIfEmpty()
where p1.masaKatID == masaKatID
group j2 by new { p1.masaID, p1.masaNo, p1.masaKategori.masaKatAdi, p1.masaKatID } into grouped
select new { masaID = grouped.Key.masaID, masaNo = grouped.Key.masaNo, Count = grouped.Where(r => r.siparisonay == false).Select(c => c.cartNo).Distinct().Count(), siparisOnay = grouped.Where(o => o.siparisonay == false || o.siparisonay == null).Select(t1 => t1.siparisonay).FirstOrDefault(), masaKatID = grouped.Key.masaKatID, masaKatAdi = grouped.Key.masaKatAdi };
string b = JsonConvert.SerializeObject(result2);
List <masaCount> listMasa = new List <masaCount>();
foreach (var item in result2)
{
listMasa.Add(new masaCount {
masaID = item.masaID, siparisCount = item.Count, siparisOnay = item.siparisOnay, masaNo = item.masaNo, masaKatID = item.masaKatID, masaKatAdi = item.masaKatAdi
});
}
ViewBag.result = listMasa;
}
/// sayfa açıldığında ilk masa katının id ve adini almak için ekledim
var ilkMasaKatId = db.masaKategoris.Where(x => x.isactive == false).Select(m => m.masaKatID).FirstOrDefault();
if (masaKatID == null)
{
Session["masaKatID"] = Convert.ToInt32(ilkMasaKatId);
var result2 =
from p1 in db.Masas
join c1 in db.CartItems on p1.masaID equals c1.masaID into j1
from j2 in j1.DefaultIfEmpty()
where p1.masaKatID == ilkMasaKatId
group j2 by new { p1.masaID, p1.masaNo, p1.masaKategori.masaKatAdi, p1.masaKatID } into grouped
select new { masaID = grouped.Key.masaID, masaNo = grouped.Key.masaNo, Count = grouped.Where(r => r.siparisonay == false).Select(c => c.cartNo).Distinct().Count(), siparisOnay = grouped.Where(o => o.siparisonay == false || o.siparisonay == null).Select(t1 => t1.siparisonay).FirstOrDefault(), masaKatID = grouped.Key.masaKatID, masaKatAdi = grouped.Key.masaKatAdi };
string b = JsonConvert.SerializeObject(result2);
List <masaCount> listMasa = new List <masaCount>();
foreach (var item in result2)
{
listMasa.Add(new masaCount {
masaID = item.masaID, siparisCount = item.Count, siparisOnay = item.siparisOnay, masaNo = item.masaNo, masaKatID = item.masaKatID, masaKatAdi = item.masaKatAdi
});
}
ViewBag.result = listMasa;
}
masaKategori modell = new masaKategori();
//var masalar = db.Masas.ToList();
modell.masaKatList = db.masaKategoris.ToList();
modell.masaList = db.Masas.ToList();
return(View(modell));
}
