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