public List <Siparis> GetSiparisler()
{
List <Siparis> siparisler = new List <Siparis>();
DataTable dt = SQL.get(
"SELECT " +
" * " +
"FROM " +
" siparisler " +
"WHERE " +
" silindi = 0 " +
(iptalGoster ? " " : " AND siparisDurum != " + (int)Helper.siparisDurum.iptalEdildi) +
(teslimGoster ? " " : " AND siparisDurum != " + (int)Helper.siparisDurum.teslimEdildi) +
(siparisIDs.Count > 0 ? " AND siparisID IN (" + string.Join(",", siparisIDs) + ") " : "") +
(kullaniciIDs.Count > 0 ? " AND kullaniciID IN (" + string.Join(",", kullaniciIDs) + ") " : "") +
(siparisDurums.Count > 0 ? " AND siparisDurum IN (" + string.Join(",", siparisDurums) + ") " : "") +
(odemeTipis.Count > 0 ? " AND odemeTipi IN (" + string.Join(",", odemeTipis) + ") " : "") +
" ORDER by siparisID DESC OFFSET " + ((page - 1) * count) + " ROWS FETCH NEXT " + count + " ROWS ONLY");
foreach (DataRow dr in dt.Rows)
{
Siparis siparis = new Siparis();
Int32.TryParse(dr["siparisID"].ToString(), out siparis.siparisID);
DateTime.TryParse(dr["kayitTarihi"].ToString(), out siparis.kayitTarihi);
Int32.TryParse(dr["kaydedenKullaniciID"].ToString(), out siparis.kaydedenKullaniciID);
DateTime.TryParse(dr["guncellemeTarihi"].ToString(), out siparis.guncellemeTarihi);
Int32.TryParse(dr["guncelleyenKullaniciID"].ToString(), out siparis.guncelleyenKullaniciID);
Int32.TryParse(dr["silindi"].ToString(), out siparis.silindi);
siparis.ad = dr["ad"].ToString();
siparis.soyad = dr["soyad"].ToString();
siparis.telefon = dr["telefon"].ToString();
siparis.sehir = dr["sehir"].ToString();
siparis.semt = dr["semt"].ToString();
siparis.mahalle = dr["mahalle"].ToString();
siparis.postaKodu = dr["postaKodu"].ToString();
siparis.adresSatir1 = dr["adresSatir1"].ToString();
siparis.adresSatir2 = dr["adresSatir2"].ToString();
Int32.TryParse(dr["kullaniciID"].ToString(), out siparis.kullaniciID);
Int32.TryParse(dr["siparisDurum"].ToString(), out siparis.siparisDurum);
Int32.TryParse(dr["odemeTipi"].ToString(), out siparis.odemeTipi);
siparis.siparisNotu = dr["siparisNotu"].ToString();
siparis.kargoNo = dr["kargoNo"].ToString();
Decimal.TryParse(dr["kargoUcreti"].ToString(), out siparis.kargoUcreti);
siparis.siparisKalemleri = new SiparisKalem().GetSiparisKalem(siparis.siparisID);
siparisler.Add(siparis);
}
return(siparisler);
}
public bool LoadSiparisler()
{
this.siparisler = new List <Siparis>();
DataTable dt = SQL.get("SELECT TOP 20 * FROM siparisler WHERE silindi = 0 AND kullaniciID = " + this.kullaniciID + " ORDER by kayitTarihi DESC");
foreach (DataRow dr in dt.Rows)
{
Siparis s = new Siparis();
Int32.TryParse(dr["siparisID"].ToString(), out s.siparisID);
DateTime.TryParse(dr["kayitTarihi"].ToString(), out s.kayitTarihi);
Int32.TryParse(dr["kaydedenKullaniciID"].ToString(), out s.kaydedenKullaniciID);
DateTime.TryParse(dr["guncellemeTarihi"].ToString(), out s.guncellemeTarihi);
Int32.TryParse(dr["guncelleyenKullaniciID"].ToString(), out s.guncelleyenKullaniciID);
Int32.TryParse(dr["silindi"].ToString(), out s.silindi);
s.ad = dr["ad"].ToString();
s.soyad = dr["soyad"].ToString();
s.telefon = dr["telefon"].ToString();
s.sehir = dr["sehir"].ToString();
s.semt = dr["semt"].ToString();
s.mahalle = dr["mahalle"].ToString();
s.postaKodu = dr["postaKodu"].ToString();
s.adresSatir1 = dr["adresSatir1"].ToString();
s.adresSatir2 = dr["adresSatir2"].ToString();
Int32.TryParse(dr["kullaniciID"].ToString(), out s.kullaniciID);
Int32.TryParse(dr["siparisDurum"].ToString(), out s.siparisDurum);
Int32.TryParse(dr["odemeTipi"].ToString(), out s.odemeTipi);
s.siparisNotu = dr["siparisNotu"].ToString();
s.kargoNo = dr["kargoNo"].ToString();
Decimal.TryParse(dr["kargoUcreti"].ToString(), out s.kargoUcreti);
s.siparisKalemleri = new SiparisKalem().GetSiparisKalem(s.siparisID);
this.siparisler.Add(s);
}
return(true);
}
