public static List <Siparis> SiparisleriYerlestir(short siparisDurum = -1)
{
baglanti();
List <Siparis> siparisler = new List <Siparis>();
OleDbCommand komut = new OleDbCommand();
komut.Connection = con;
if (siparisDurum == -1)
{
komut.CommandText = "SELECT * FROM Siparisler AS S INNER JOIN Urunler AS U ON S.Siparis_Urun = U.Urun_ID WHERE S.Siparis_Odenme=false AND S.Siparis_Durum<4 ORDER BY S.Siparis_Zaman DESC";
}
else
{
komut.CommandText = "SELECT * FROM Siparisler AS S INNER JOIN Urunler AS U ON S.Siparis_Urun = U.Urun_ID WHERE S.Siparis_Odenme=false AND S.Siparis_Durum=@durum ORDER BY S.Siparis_Zaman DESC";
komut.Parameters.AddWithValue("@durum", siparisDurum);
}
OleDbDataReader oku = komut.ExecuteReader();
while (oku.Read())
{
int id = Convert.ToInt32(oku["Siparis_Urun"]);
Urun urun = new Urun(0, "", "", 0);
urun.UrunID = id;
urun.UrunAdi = oku["Urun_Adi"].ToString();
urun.UrunAyrinti = oku["Urun_Ayrinti"].ToString();
urun.UrunUcret = Convert.ToDecimal(oku["Urun_Ucret"]);
Siparis siparis = new Siparis(Convert.ToInt32(oku["Siparis_ID"]), urun, Convert.ToInt32(oku["Siparis_Adet"]), Convert.ToDateTime(oku["Siparis_Zaman"]), Convert.ToByte(oku["Siparis_Durum"]), Convert.ToBoolean(oku["Siparis_Odenme"]), Convert.ToInt32(oku["Siparis_Masa"]));
siparisler.Add(siparis);
}
bitir();
return(siparisler);
}
public static List <Siparis> SiparisListele()
{
baglanti();
List <Siparis> siparisler = new List <Siparis>();
OleDbCommand komut = new OleDbCommand("SELECT * FROM Siparisler AS S INNER JOIN Urunler AS U ON S.Siparis_Urun=U.Urun_ID WHERE Siparis_Odenme=true", con);
OleDbDataReader oku = komut.ExecuteReader();
while (oku.Read())
{
Urun urun = new Urun(Convert.ToInt32(oku["Urun_ID"]), oku["Urun_Adi"].ToString(), oku["Urun_Ayrinti"].ToString(), Convert.ToDecimal(oku["Urun_Ucret"]));
Siparis siparis = new Siparis(Convert.ToInt32(oku["Siparis_ID"]), urun, Convert.ToInt32(oku["Siparis_Adet"]), Convert.ToDateTime(oku["Siparis_Zaman"]), Convert.ToByte(oku["Siparis_Durum"]), Convert.ToBoolean(oku["Siparis_Odenme"]), Convert.ToInt32(oku["Siparis_Masa"]));
siparisler.Add(siparis);
}
bitir();
return(siparisler);
}
public static List <Siparis> SiparisleriListele(int masaNo = -1, short masaDurum = -1)
{
bool where = false;
List <Siparis> siparisler = new List <Siparis>();
baglanti();
OleDbCommand komut = new OleDbCommand("SELECT * FROM Siparisler AS S INNER JOIN Urunler AS U ON S.Siparis_Urun=U.Urun_ID", con);
if (masaNo != -1)
{
where = true;
komut.CommandText += " WHERE S.Siparis_Masa=@masa AND S.Siparis_Odenme=false";
komut.Parameters.AddWithValue("@masa", masaNo);
}
if (masaDurum != -1)
{
if (where)
{
komut.CommandText += " AND S.Siparis_Durum=@durum AND S.Siparis_Odenme=false";
}
else
{
komut.CommandText += " WHERE S.Siparis_Durum=@durum AND S.Siparis_Odenme=false";
}
komut.Parameters.AddWithValue("@durum", masaDurum);
}
OleDbDataReader oku = komut.ExecuteReader();
while (oku.Read())
{
int siparisID = Convert.ToInt32(oku["Siparis_ID"]);
Urun urun = new Urun(0, "", "", 0);
urun.UrunID = Convert.ToInt32(oku["Siparis_Urun"]);
urun.UrunAdi = oku["Urun_Adi"].ToString();
urun.UrunAyrinti = oku["Urun_Ayrinti"].ToString();
urun.UrunUcret = Convert.ToDecimal(oku["Urun_Ucret"]);
Siparis siparis = new Siparis(siparisID, urun, Convert.ToInt32(oku["Siparis_Adet"]), Convert.ToDateTime(oku["Siparis_Zaman"]), Convert.ToByte(oku["Siparis_Durum"]), Convert.ToBoolean(oku["Siparis_Odenme"]), Convert.ToInt32(oku["Siparis_Masa"]));
siparisler.Add(siparis);
}
bitir();
return(siparisler);
}
public static List <Siparis> MasaOzetiCikar(int masaNo)
{
List <Siparis> siparisler = new List <Siparis>();
baglanti();
OleDbCommand komut = new OleDbCommand("SELECT * FROM Siparisler AS S INNER JOIN Urunler AS U ON S.Siparis_Urun = U.Urun_ID WHERE S.Siparis_Masa=@masa AND S.Siparis_Odenme=false ORDER BY S.Siparis_Zaman", con);
komut.Parameters.AddWithValue("@masa", masaNo);
OleDbDataReader oku = komut.ExecuteReader();
while (oku.Read())
{
Urun urun = new Urun(0, "", "", 0);
urun.UrunID = Convert.ToInt32(oku["Urun_ID"]);
urun.UrunAdi = oku["Urun_Adi"].ToString();
urun.UrunAyrinti = oku["Urun_Ayrinti"].ToString();
urun.UrunUcret = Convert.ToDecimal(oku["Urun_Ucret"]);
Siparis siparis = new Siparis(Convert.ToInt32(oku["Siparis_ID"]), urun, Convert.ToInt32(oku["Siparis_Adet"]), Convert.ToDateTime(oku["Siparis_Zaman"]), Convert.ToByte(oku["Siparis_Durum"]), Convert.ToBoolean(oku["Siparis_Odenme"]), Convert.ToInt32(oku["Siparis_Masa"]));
siparisler.Add(siparis);
}
bitir();
return(siparisler);
}
public static List <Siparis> SiparisListele(int sayi, byte tur)
{
baglanti();
List <Siparis> siparisler = new List <Siparis>();
OleDbCommand komut = new OleDbCommand("SELECT * FROM Siparisler AS S INNER JOIN Urunler AS U ON S.Siparis_Urun=U.Urun_ID WHERE Siparis_Odenme=true", con);
OleDbDataReader oku = komut.ExecuteReader();
while (oku.Read())
{
DateTime zaman = Convert.ToDateTime(oku["Siparis_Zaman"]);
DateTime suan = DateTime.Now;
switch (tur)
{
case 0:
suan = suan.AddDays(-sayi);
break;
case 1:
suan = suan.AddMonths(-sayi);
break;
case 2:
suan = suan.AddYears(-sayi);
break;
}
int karsilastirma = DateTime.Compare(suan, zaman);
if (karsilastirma > 0)
{
Urun urun = new Urun(Convert.ToInt32(oku["Urun_ID"]), oku["Urun_Adi"].ToString(), oku["Urun_Ayrinti"].ToString(), Convert.ToDecimal(oku["Urun_Ucret"]));
Siparis siparis = new Siparis(Convert.ToInt32(oku["Siparis_ID"]), urun, Convert.ToInt32(oku["Siparis_Adet"]), Convert.ToDateTime(oku["Siparis_Zaman"]), Convert.ToByte(oku["Siparis_Durum"]), Convert.ToBoolean(oku["Siparis_Odenme"]), Convert.ToInt32(oku["Siparis_Masa"]));
siparisler.Add(siparis);
}
}
bitir();
return(siparisler);
}
