public List <Models.Siparis> Siparislerim(string kullanici_id)
{
List <Models.Siparis> siparislist = new List <Models.Siparis>();
sql.con.Open();
if (kullanici_id == "user")
{
sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("select * from siparis", sql.con);
}
else
{
sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("select * from siparis where kullanici_id='" + kullanici_id + "'", sql.con);
}
var rd = sql.cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Models.Siparis siparis = new Models.Siparis();
siparis.siparis_id = rd.GetInt16("siparis_id");
siparis.kullanici_id = rd.GetString("kullanici_id");
siparis.kullanici_siparisdurumu = rd.GetString("kullanici_siparisdurumu");
siparislist.Add(siparis);
}
sql.con.Close();
return(siparislist);
}
public ActionResult Duzenle(Models.Siparis siparis)
{
var stk = Veritabani.SiparisListesi.Where(x => x.SiparisId == siparis.SiparisId).SingleOrDefault();
var index = Veritabani.SiparisListesi.IndexOf(stk);
Veritabani.SiparisListesi[index] = siparis;
return(RedirectToAction("Index"));
}
public ActionResult Kaydet(Models.Siparis siparis)
{
Veritabani.SiparisListesi.Add(siparis);
return(RedirectToAction("Index"));
}
