public JsonResult UrunGetir(int id)
{
using (var context = new MvsDbstokEntities1())
{
var karalisteId = context.TBLKARALISTE.FirstOrDefault(x => x.KARALISTEID == id);
if (karalisteId != null)
{
var model = (from urun in context.TBLURUNLER
join
kategori in context.TBLKATEGORILER on
urun.URUNKATEGORI equals kategori.KATEGORIID join liste in context.TBLKARALISTE on
urun.URUNID equals liste.URUNID
where urun.URUNID == karalisteId.URUNID
select new UrunDto
{
Fiyat = urun.FIYAT,
KategoriAd = kategori.KATEGORIADI,
Marka = urun.MARKA,
MinStok = urun.MINSTOK,
Stok = urun.STOK,
UrunAd = urun.URUNAD,
UrunId = urun.URUNID,
Aciklama1 = liste.ACIKLAMA1,
Kaldirildimi = (bool)liste.KALDIRILDIMI
}).ToList();
var entity = model.Where(x => x.Kaldirildimi == false).FirstOrDefault();
return(Json(new { result = entity, success = true }));
}
else
{
return(Json(new { result = "Ürün bulunamadı", success = false }));
}
}
}
public ActionResult Login(LoginModel model, string returnurl)
{
using (MvsDbstokEntities1 db = new MvsDbstokEntities1())
{
if (ModelState.IsValid)
{
TBLKULLANICI kullanici = db.TBLKULLANICI.Where
(x => x.Email.ToLower().Trim() == model.Email.ToLower().Trim() && x.Sifre.ToLower().Trim() == model.Sifre.ToLower().Trim()).FirstOrDefault();
if (kullanici != null)
{
FormsAuthentication.SetAuthCookie(model.Email, true);
FormsAuthentication.RedirectFromLoginPage(model.Email, true);
return(RedirectToAction("Index", "Home"));
}
}
return(View(model));
}
}
public JsonResult UrunGetir(int id)
{
using (var context = new MvsDbstokEntities1())
{
var model = (from urun in context.TBLURUNLER
join
kategori in context.TBLKATEGORILER on
urun.URUNKATEGORI equals kategori.KATEGORIID
where urun.URUNID == id
select new UrunDto
{
Fiyat = urun.FIYAT,
KategoriAd = kategori.KATEGORIADI,
Marka = urun.MARKA,
MinStok = urun.MINSTOK,
Stok = urun.STOK,
UrunAd = urun.URUNAD,
UrunId = urun.URUNID
}).ToList();
return(Json(new { result = model, success = true }));
}
}
