public ActionResult Arama(SatisArama Aranan) { Debug.WriteLine("Arama Çalıştı"); List <Satis> satis = database.Arama(Aranan); ViewBag.satislar = satis; ViewBag.SatisDurums = new SelectList(satisDurum.GetAll(), "ID", "Adi"); return(View("Emirler")); }
public List <Satis> Arama(SatisArama arama) { string sorgu = "select * from Satis where ID in(select Satis.ID from Satis Join Kullanici on Satis.KullaniciID=Kullanici.ID where 1=1"; if (arama.MusteriAdi != null && arama.MusteriAdi.Length != 0) { sorgu += string.Format(" and Kullanici.Adi like '%{0}%'", arama.MusteriAdi); } if (arama.Email != null && arama.Email.Length != 0) { sorgu += string.Format(" and Kullanici.Email like '%{0}%'", arama.Email); } if (arama.SatisDurum != 0) { sorgu += string.Format(" and Satis.SatisDurumID ={0}", arama.SatisDurum); } if (arama.SatisNo != 0) { sorgu += string.Format(" Satis.ID={0}", arama.SatisNo); } sorgu += ")"; Debug.WriteLine(sorgu + "Sorgu "); SqlDataReader reader = getReader(sorgu); List <Satis> satislar = new List <Satis>(); while (reader.Read()) { satislar.Add(new Satis() { ID = (int)reader[_ID], KullaniciID = (int)reader[_KullaniciID], Zaman = (DateTime)reader[_Zaman], SatisDurumID = (int)reader[_SatisDurumID], KargoKod = reader[_KargoKod].ToString(), KargoDurum = (bool)reader[_KargoDurum], KargoUcret = float.Parse(reader[_KargoUcret].ToString()), AdresID = (int)reader[_AdresID] }); } reader.Close(); AdresDatabase adresDatabase = new AdresDatabase(); SatisDetayDatabase satisdatabase = new SatisDetayDatabase(); MusteriDatabase kdatabase = new MusteriDatabase(); UrunDatabase udatabase = new UrunDatabase(); foreach (Satis item in satislar) { item.Kullanici = kdatabase.GetForID(item.KullaniciID); item.satisDetay = satisdatabase.getForSatisID(item.ID); float toplam = 0; int adet = 0; foreach (SatisDetay satisDetay in item.satisDetay) { toplam += (satisDetay.Fiyat * satisDetay.Adet); adet += (satisDetay.Adet); } item.Adet = adet; item.Toplam = toplam; item.Adres = adresDatabase.GetForID(item.AdresID); } return(satislar); }