public static List <Musteri> GetByNameAndSurname(string a, string b)
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
return(m.Musteri.Where(x => x.Ad.Contains(a) && x.Soyad.Contains(b)).ToList());
}
}
public static Musteri GetById(int MusteriId)
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
return(m.Musteri.Find(MusteriId));
}
}
public static List <Musteri> GetList()
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
return(m.Musteri.ToList());
}
}
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 static Siparis GetById(int SiparisId)
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
return(m.Siparis.Find(SiparisId));
}
}
public static List <Siparis> GetJustSiparisList()
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
return(m.Siparis.ToList());
}
}
public static (Musteri, bool) Update(Musteri p)
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
m.Entry(p).State = System.Data.Entity.EntityState.Modified;
if (m.SaveChanges() > 0)
{
return(p, true);
}
else
{
return(p, false);
}
}
}
public static (Musteri, bool) Add(Musteri p)
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
m.Musteri.Add(p);
if (m.SaveChanges() > 0)
{
return(p, true);
}
else
{
return(p, false);
}
}
}
public static (Siparis, bool) Add(Siparis p)
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
m.Siparis.Add(p);
if (m.SaveChanges() > 0)
{
return(p, true);
}
else
{
return(p, false);
}
}
}
public static bool Delete(int MusteriId)
{
using (SuSatisDbEntities m = new SuSatisDbEntities())
{
var a = m.Musteri.Where(x => x.MusteriId == MusteriId).FirstOrDefault();
m.Musteri.Remove(a);
if (m.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
