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