public string SaveUrun(ent_URUNLER ent)
{
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
l_urunler urun = new l_urunler();
if (ent.urun_id != 0)
{
urun = db.l_urunler.Where(p => p.urun_id == ent.urun_id).First();
}
urun.urun_adi = ent.urun_adi;
urun.urun_kategori_id = ent.urun_kategori_id;
urun.urun_fiyat = ent.urun_fiyat;
urun.urun_detay = ent.urun_detay.ToString();
urun.urun_foto_url = ent.urun_foto_url;
urun.urun_uye_id = ent.urun_uye_id;
urun.urun_tarih = ent.urun_tarih;
urun.urun_ispassive = ent.urun_ispassive;
if (ent.urun_id == 0)
{
db.l_urunler.Add(urun);
}
db.SaveChanges();
}
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ActionResult UrunGoruntule(int urun_id)
{
BLL_URUNLER urun = new BLL_URUNLER();
ent_URUNLER urungoster = urun.UrunGoruntule(urun_id);
return(View("UrunGoruntule", urungoster));
}
public ActionResult CreateUrun(ent_URUNLER urun)
{
BLL_URUNLER kaydet = new BLL_URUNLER();
kaydet.SaveUrun(urun);
return(RedirectToAction("UrunlerList", "Urunler"));
}
public ent_URUNLER SelectUrun(int urun_id)
{
ent_URUNLER result = new ent_URUNLER();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_URUNLER>("select * from l_urunler as urun where urun.urun_id={0}", urun_id).First();
}
return(result);
}
catch
{
return(result);
}
}
public ent_URUNLER UrunGoruntule(int urun_id)
{
ent_URUNLER result = new ent_URUNLER();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_URUNLER>("select urun.urun_adi,kat.kategori_ad as urun_kategori_adi, uye.uye_ad_soyad as urun_uye_adi,urun.urun_detay,urun.urun_foto_url,urun.urun_tarih,urun.urun_fiyat,urun.* FROM l_urunler as urun LEFT JOIN l_kategori as kat ON urun.urun_kategori_id = kat.kategori_id LEFT JOIN l_uyeler as uye ON uye.uye_id = urun.urun_uye_id where urun.urun_id={0}", urun_id).First();
}
return(result);
}
catch (Exception)
{
return(result);
}
}
public ent_URUNLER SonSporUrun()
{
ent_URUNLER result = new ent_URUNLER();
try
{
using (DataAccessEntities db = new DataAccessEntities())
{
result = db.Database.SqlQuery <ent_URUNLER>("select TOP 1 * from l_urunler where l_urunler.urun_kategori_id = 3 order by l_urunler.urun_tarih desc ").First();
}
return(result);
}
catch
{
return(result);
}
}