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