public ActionResult Guncelle(int orderID, string?error)
{
if (error != null && error != "")
{
ModelState.AddModelError("error", error);
}
OrderModel order = _context.OrderModel.Include(b => b.orderdetailsmodels)
.FirstOrDefault <OrderModel>(t => t.orderID == orderID && t.validTo == DateTime.Parse("2099-01-01"));
SiparisModel siparis = new SiparisModel();
siparis.orderID = order.orderID;
siparis.orderDate = order.orderDate;
siparis.orderLocationID = order.orderLocationID;
siparis.orderOwner_personelID = order.personelID;
siparis.recStatus = order.recStatus;
ViewData["personelID"] = new SelectList(_context.employeesmodels, nameof(SiparisModel.orderOwnerEmployeeModel.personelID), nameof(SiparisModel.orderOwnerEmployeeModel.persName));
EmployeesModels employees = _context.employeesmodels.FirstOrDefault(t => t.personelID == siparis.orderOwner_personelID);
siparis.orderLocation = _context.stocklocationmodel.FirstOrDefault(e => e.locationID == siparis.orderLocationID);
foreach (OrderDetailsModel orderDetails in order.orderdetailsmodels)
{
orderDetails.Product = _context.Products.FirstOrDefault(e => e.productBarcodeID == orderDetails.productBarcodeID);
}
siparis.orderdetailsmodels = order.orderdetailsmodels;
siparis.operation = "Update";
return(View("Giris", siparis));
}
public static List <SiparisModel> GetList()
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
List <SiparisModel> siparisModeller = new List <SiparisModel>();
List <Siparis> siparisler = m.Siparis.ToList();
foreach (var item in siparisler)
{
SiparisModel siparisModel = new SiparisModel();
siparisModel.SiparisId = item.SiparisId;
siparisModel.Tutar = item.Tutar;
siparisModel.Musteri = m.Musteri.Find(item.MusteriId);
siparisModel.Tarih = item.Tarih;
if (item.Durum == 0)
{
siparisModel.Durum = "Hazırlanıyor";
}
else if (item.Durum == 1)
{
siparisModel.Durum = "Yola Çıktı";
}
else if (item.Durum == 2)
{
siparisModel.Durum = "Teslim Edildi";
}
siparisModel.AktifMi = item.AktifMi;
siparisModeller.Add(siparisModel);
}
return(siparisModeller);
}
}
public ActionResult Giris(string productName)
{
SiparisModel siparis = new SiparisModel();
if (User.Identity.IsAuthenticated)
{
siparis.orderDate = DateTime.Now;
ViewData["personelID"] = new SelectList(_context.employeesmodels, nameof(SiparisModel.orderOwnerEmployeeModel.personelID), nameof(SiparisModel.orderOwnerEmployeeModel.persName));
EmployeesModels employees = _context.employeesmodels.First();
siparis.orderLocation = _context.stocklocationmodel.FirstOrDefault(e => e.locationID == employees.locationID);
if (!String.IsNullOrEmpty(productName))
{
siparis.Products = _context.Products.Where(x => x.productName.Contains(productName)).ToList();
}
else
{
siparis.Products = new List <products>();
}
siparis.operation = "Add";
}
else
{
ModelState.AddModelError("User", "İşlem yapabilmeniz için sisteme giriş yapınız.");
}
return(View(siparis));
}
public ViewResult MasaKapat(int Id)
{
ViewBag.MasaNo = efMasa.GetMasa(Id).MasaNo;
ViewBag.MasaKat = efMasa.GetMasa(Id).Kat;
if (efMasa.GetGarson(Id) != null)
{
ViewBag.GarsonAd = efGarson.GetGarsonIsim(efMasa.GetGarson(Id).Id);
}
List <SiparisModel> ls = new List <SiparisModel>();
var siparisList = efMasa.MasaTeslimEdilenSiparisler(Id);
foreach (var item in siparisList)
{
Urunler u = efUrun.GetUrun(item.UrunID);
SiparisModel sm = new SiparisModel();
sm.Adet = item.Adet;
sm.SiparisZamani = item.SiparisZamani;
sm.Tutar = item.Tutar;
sm.UrunAD = u.Ad;
sm.UrunFiyat = u.Fiyat;
ls.Add(sm);
}
ViewBag.ToplamTutar = efMasa.MasaToplamTutar(Id);
return(View(ls));
}
public SiparisModel getProducts(string productName)
{
SiparisModel siparis = new SiparisModel();
if (!String.IsNullOrEmpty(productName))
{
siparis.Products = _context.Products.Where(x => x.productName.Contains(productName)).ToList();
}
else
{
siparis.Products = new List <products>();
}
return(siparis);
}
public SiparisModel SiparsiById(int siparsiId)
{
SiparisModel kayit = db.Siparis.Where(s => s.siparisId == siparsiId).Select(x => new SiparisModel()
{
siparisId = x.siparisId,
genelToplam = x.genelToplam,
siparisTarih = x.siparisTarih,
siparisAdres = x.siparisAdres,
siparisIl = x.siparisIl,
siparisIlce = x.siparisIlce,
siparisMusteriId = x.siparisMusteriId
}).FirstOrDefault();
return(kayit);
}
public ActionResult MasaDetay(int Id)
{
int control = SessionControl();
if (control == 1)
{
Session["MasaID"] = Id;
ViewData["MasaID"] = Id;
ViewData["GarsonID"] = efMasa.GetGarson(Id);
Masalar m = efMasa.GetMasa(Id);
List <SiparisModel> ls = new List <SiparisModel>();
var siparisList = efMasa.MasaAktifSiparisleri(Id).ToList();
foreach (var item in siparisList)
{
Urunler u = efUrun.GetUrun(item.UrunID);
SiparisModel s = new SiparisModel();
s.Id = item.Id;
if (m.GarsonID != null && m.GarsonID != 0)
{
s.GarsonIsmi = efGarson.GetGarsonIsim(Convert.ToInt32(m.GarsonID));
}
s.Adet = item.Adet;
s.UrunFiyat = u.Fiyat;
s.MasaID = m.Id;
s.MasaNo = m.MasaNo;
s.Durum = item.Statu;
s.UrunAD = u.Ad;
s.Tutar = s.TutarHesapla(s.Adet, u.Fiyat);
s.SiparisZamani = item.SiparisZamani;
s.UrunResmi = u.ResimYolu.Trim();
ls.Add(s);
}
return(View(ls));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
public SonucModel SiparisDuzenle(SiparisModel model)
{
Siparis kayit = db.Siparis.Where(s => s.siparisId == model.siparisId).FirstOrDefault();
if (kayit == null)
{
sonuc.islem = false;
sonuc.mesaj = "Girdiğiniz bilgilere ait sipariş bilgisi bulunamadı.";
return(sonuc);
}
kayit.siparisId = model.siparisId;
kayit.genelToplam = model.genelToplam;
kayit.siparisTarih = model.siparisTarih;
kayit.siparisAdres = model.siparisAdres;
kayit.siparisIl = model.siparisIl;
kayit.siparisIlce = model.siparisIlce;
kayit.siparisMusteriId = model.siparisMusteriId;
db.SaveChanges();
sonuc.islem = true;
sonuc.mesaj = "Sipariş bilgileri başarılı bir şekilde güncellenmiştir.";
return(sonuc);
}
public ActionResult SiparisDuzenle(SiparisModel model)
{
if (!ModelState.IsValid)
{
ModelState.AddModelError("", @"Sipariş düzenlenirken bir hata oluştu");
return(RedirectToAction("Index"));
}
try
{
var siparis = _siparisRepository.GetById(model.SiparisId);
siparis.KargoDurumId = model.KargoDurumId;
siparis.SiparisDurumId = model.SiparisDurumId;
siparis.OdemeDurumId = model.OdemeDurumId;
_siparisRepository.Update(siparis);
return(RedirectToAction("Index"));
}
catch (Exception e)
{
Logger.Error(e.Message);
return(RedirectToAction("Index"));
}
}
public ActionResult Siparisler()
{
List <Siparisler> ls = efSiparis.TumSiparisler();
List <SiparisModel> lm = new List <SiparisModel>();
foreach (var item in ls)
{
Urunler u = efUrun.GetUrun(item.UrunID);
SiparisModel sm = new SiparisModel();
sm.Id = item.Id;
sm.Durum = item.Statu;
sm.Adet = item.Adet;
sm.GarsonIsmi = efGarson.GetGarsonIsim(item.GarsonID);
sm.MasaID = item.MasaID;
sm.SiparisZamani = item.SiparisZamani;
sm.Tutar = item.Tutar;
sm.UrunAD = u.Ad;
sm.UrunFiyat = u.Fiyat;
sm.UrunResmi = u.ResimYolu;
lm.Add(sm);
}
return(View(lm));
}
public SonucModel SiparisEkle(SiparisModel model)
{
if (db.Siparis.Count(s => s.siparisId == model.siparisId) > 0)
{
sonuc.islem = false;
sonuc.mesaj = "Sipariş bilgileri zaten mevcut.";
return(sonuc);
}
Siparis yeni = new Siparis();
yeni.siparisId = model.siparisId;
yeni.genelToplam = model.genelToplam;
yeni.siparisTarih = model.siparisTarih;
yeni.siparisAdres = model.siparisAdres;
yeni.siparisIl = model.siparisIl;
yeni.siparisIlce = model.siparisIlce;
yeni.siparisMusteriId = model.siparisMusteriId;
db.Siparis.Add(yeni);
db.SaveChanges();
sonuc.islem = true;
sonuc.mesaj = "Sipariş başarı ile oluşturulmuştur.";
return(sonuc);
}
