//public static List<Models.UrunDetayViewModel> modell = new List<Models.UrunDetayViewModel>(); // GET: Home public ActionResult Index() { Models.UrunDetayViewModel model = new Models.UrunDetayViewModel(); Models.Urun urun = new Models.Urun(); urun.UrunId = 1; urun.UrunAdi = "Apple Watch"; urun.UrunFiyati = 3500; Models.UrunResim urunresim = new Models.UrunResim(); urunresim.UrunId = 1; urunresim.UrunResimId = 1; urunresim.UrunResimAciklamasi = "Saat"; urunresim.UrunResimUrl = "resim1_url"; //List urunresimlistesi = new List(); //urunresimlistesi.Add(urunresim); List <Models.UrunResim> urunresimlistesi = new List <Models.UrunResim>(); urunresimlistesi.Add(urunresim); //modell.a model.Urun = urun; //model.UrunResimleri = urunresimlistesi; return(View(model)); }
public ActionResult Update(Models.Urun urun) { var _urun = db.Urun.Single(x => x.Id == urun.Id); _urun.Ad = urun.Ad; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Duzenle(Models.Urun urun) { var stk = Veritabani.UrunListesi.Where(x => x.UrunId == urun.UrunId).SingleOrDefault(); var index = Veritabani.UrunListesi.IndexOf(stk); Veritabani.UrunListesi[index] = urun; return(RedirectToAction("Index")); }
public ActionResult Creat(Models.Urun urun) { Models.Urun _urun = new Models.Urun(); _urun.Ad = urun.Ad; db.Urun.Add(_urun); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult UrunEkle(Models.Urun urun, HttpPostedFileBase urun_resim) { var FileName = Path.GetFileName(urun_resim.FileName); var path = Path.Combine(Server.MapPath("~/img/urunimg"), FileName); urun_resim.SaveAs(path); urun.urun_resim = "~/img/urunimg/" + FileName; urun.urun_indirimfiyati = "null"; servis.UrunEkle(urun); ViewBag.Message = "Ürün Eklendi"; return(View()); }
public ActionResult Detaylar(Models.Urun detay) { var bilgi = new Models.Urun(); bilgi.adi = "Bilgisayar"; bilgi.aciklamasi = "5 inc"; bilgi.fiyat = 7500; bilgi.turu = "Asus"; bilgi.durum = true; return(View(bilgi)); }
public void UrunEkle(Models.Urun urun) { sql.con.Open(); sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("insert into `urun`(`urun_adi`,`urun_markaid`,`urun_modeladi`,`urun_fiyati`,`urun_indirimfiyati`,`urun_resim`)values('" + urun.urun_adi + "', '" + urun.urun_markaadi + "', '" + urun.urun_modeladi + "', '" + urun.urun_fiyati + "','" + urun.urun_indirimfiyati + "' ,'" + urun.urun_resim + "') ", sql.con); sql.cmd.ExecuteNonQuery(); sql.con.Close(); sql.con.Open(); sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("insert into urun_star(urun_id, star1, star2, star3, star4, star5) values((select max(urun_id) from urun), 0, 0, 0, 0, 0);", sql.con); sql.cmd.ExecuteNonQuery(); sql.con.Close(); sql.con.Open(); sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("insert into `satilan_urunler`(`urun_id`,`satilan_miktar`)values((select max(urun_id) from urun), '0'); ", sql.con); sql.cmd.ExecuteNonQuery(); sql.con.Close(); }
public Models.Urun UrunAra2(int urun_id) { Models.Urun urun = new Models.Urun(); sql.con.Open(); sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT urun.urun_id,urun.urun_adi,urun_marka.urun_markaadi,urun.urun_modeladi,urun.urun_fiyati,urun.urun_indirimfiyati,urun.urun_resim,urun_star.star1,urun_star.star2,urun_star.star3,urun_star.star4,urun_star.star5 FROM urun inner join urun_marka on urun_marka.urun_markaid = urun.urun_markaid inner join urun_star on urun_star.urun_id = urun.urun_id and urun.urun_id = '" + urun_id + "' order by urun_id desc ;", sql.con); var rd = sql.cmd.ExecuteReader(CommandBehavior.CloseConnection); while (rd.Read()) { urun.urun_id = rd.GetInt32("urun_id"); urun.urun_adi = rd.GetString("urun_adi"); urun.urun_markaadi = rd.GetString("urun_markaadi"); urun.urun_indirimfiyati = rd.GetString("urun_indirimfiyati"); urun.urun_fiyati = rd.GetDouble("urun_fiyati"); urun.urun_modeladi = rd.GetString("urun_modeladi"); urun.urun_resim = rd.GetString("urun_resim"); } sql.con.Close(); return(urun); }
public Dictionary <Models.Urun, Models.Urun_star> TumUrunler() { Dictionary <Models.Urun, Models.Urun_star> urunlistesi = new Dictionary <Models.Urun, Models.Urun_star>(); sql.con.Open(); sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("Tum_Urunler", sql.con); sql.cmd.CommandType = CommandType.StoredProcedure; var rd = sql.cmd.ExecuteReader(CommandBehavior.CloseConnection); while (rd.Read()) { Models.Urun_star star = new Models.Urun_star(); Models.Urun urun = new Models.Urun(); urun.urun_id = rd.GetInt32("urun_id"); urun.urun_adi = rd.GetString("urun_adi"); urun.urun_markaadi = rd.GetString("urun_markaadi"); urun.urun_indirimfiyati = rd.GetString("urun_indirimfiyati"); urun.urun_fiyati = rd.GetDouble("urun_fiyati"); urun.urun_modeladi = rd.GetString("urun_modeladi"); urun.urun_resim = rd.GetString("urun_resim"); star.urun_id = rd.GetInt32("urun_id"); star.star1 = rd.GetInt32("star1"); star.star2 = rd.GetInt32("star2"); star.star3 = rd.GetInt32("star3"); star.star4 = rd.GetInt32("star4"); star.star5 = rd.GetInt32("star5"); if (star.star1 == 0 && star.star2 == 0 && star.star3 == 0 && star.star4 == 0 && star.star5 == 0) { star.ortalama = 0; } else { double ortalama = (double)(star.star5 * 5 + star.star4 * 4 + star.star3 * 3 + star.star2 * 2 + star.star1 * 1) / (star.star1 + star.star2 + star.star3 + star.star4 + star.star5); star.ortalama = ortalama; } urunlistesi.Add(urun, star); } sql.con.Close(); return(urunlistesi); }
public Dictionary <Models.Urun, Models.Urun_star> UrunAra(int urun_id) { Dictionary <Models.Urun, Models.Urun_star> urunlistesi = new Dictionary <Models.Urun, Models.Urun_star>(); sql.con.Open(); sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT urun.urun_id,urun.urun_adi,urun_marka.urun_markaadi,urun.urun_modeladi,urun.urun_fiyati,urun.urun_indirimfiyati,urun.urun_resim,urun_star.star1,urun_star.star2,urun_star.star3,urun_star.star4,urun_star.star5 FROM urun inner join urun_marka on urun_marka.urun_markaid = urun.urun_markaid inner join urun_star on urun_star.urun_id = urun.urun_id and urun.urun_id = '" + urun_id + "' order by urun_id desc ;", sql.con); var rd = sql.cmd.ExecuteReader(CommandBehavior.CloseConnection); while (rd.Read()) { Models.Urun_star star = new Models.Urun_star(); Models.Urun urun = new Models.Urun(); urun.urun_id = rd.GetInt32("urun_id"); urun.urun_adi = rd.GetString("urun_adi"); urun.urun_markaadi = rd.GetString("urun_markaadi"); urun.urun_indirimfiyati = rd.GetString("urun_indirimfiyati"); urun.urun_fiyati = rd.GetDouble("urun_fiyati"); urun.urun_modeladi = rd.GetString("urun_modeladi"); urun.urun_resim = rd.GetString("urun_resim"); star.urun_id = rd.GetInt32("urun_id"); star.star1 = rd.GetInt32("star1"); star.star2 = rd.GetInt32("star2"); star.star3 = rd.GetInt32("star3"); star.star4 = rd.GetInt32("star4"); star.star5 = rd.GetInt32("star5"); if (star.star1 == 0 && star.star2 == 0 && star.star3 == 0 && star.star4 == 0 && star.star5 == 0) { star.ortalama = 0; } else { double ortalama = (double)(star.star5 * 5 + star.star4 * 4 + star.star3 * 3 + star.star2 * 2 + star.star1 * 1) / (star.star1 + star.star2 + star.star3 + star.star4 + star.star5); star.ortalama = ortalama; } urunlistesi.Add(urun, star); } sql.con.Close(); return(urunlistesi); }
public List <Models.Urun> SiparisUrunlerim(int siparis_id) { List <Models.Urun> urunlist = new List <Models.Urun>(); sql.con.Open(); sql.cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT urun.urun_id,urun.urun_adi,urun_marka.urun_markaadi,urun.urun_modeladi,urun.urun_fiyati,urun.urun_indirimfiyati,urun.urun_resim FROM urun inner join urun_marka on urun_marka.urun_markaid = urun.urun_markaid inner join siparis_urunleri on siparis_urunleri.kullanici_siparisurunid = urun.urun_id where siparis_id='" + siparis_id + "'", sql.con); var rd = sql.cmd.ExecuteReader(CommandBehavior.CloseConnection); while (rd.Read()) { Models.Urun urun = new Models.Urun(); urun.urun_id = rd.GetInt32("urun_id"); urun.urun_adi = rd.GetString("urun_adi"); urun.urun_markaadi = rd.GetString("urun_markaadi"); urun.urun_indirimfiyati = rd.GetString("urun_indirimfiyati"); urun.urun_fiyati = rd.GetDouble("urun_fiyati"); urun.urun_modeladi = rd.GetString("urun_modeladi"); urun.urun_resim = rd.GetString("urun_resim"); urunlist.Add(urun); } sql.con.Close(); return(urunlist); }
public void UrunEkle(Models.Urun urun) { urunentity.UrunEkle(urun); }
public ActionResult Kaydet(Models.Urun urun) { Veritabani.UrunListesi.Add(urun); return(RedirectToAction("Index")); }