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