public ActionResult SiparisBitir()
{
if (Session["kull"] != null)
{
List <tblUrunler> sepetListesi = (List <tblUrunler>)Session["cart"];
using (var db = new db_EOAEntities1())
{
foreach (tblUrunler item in sepetListesi)
{
tblSiparis gelenSiparis = new tblSiparis()
{
musteriId = ((tblMusteri)Session["kull"]).musteriID,
siparisAdet = 1,
urunId = item.urunID,
siparisTarih = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))
};
db.tblSiparis.Add(gelenSiparis);
}
foreach (tblUrunler item in sepetListesi)
{
tblUrunler tmpUrun = db.tblUrunler.Where(urun => urun.urunID == item.urunID).First();
tmpUrun.urunDetayStok--;
}
db.SaveChanges();
}
Session["cart"] = null;
return(RedirectToAction("Siparisler", "Profil"));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Kontrol(tblMusteri m)
{
db_EOAEntities1 db = new db_EOAEntities1();
var _kull = db.tblMusteri.Where(s => s.kullaniciAdi == m.kullaniciAdi);
if (_kull.Any())
{
if (_kull.Where(s => s.kullaniciSifre == m.kullaniciSifre).Any())
{
//Session["kull"] = ((tblMusteri)_kull);
Session["kull"] = _kull.SingleOrDefault();
return(RedirectToAction("Index", "Home"));
}
else
{
//ViewBag.Mesaj = Json("Hata");
//return Json(new { status = true, message = "Invalid Password!" });
return(RedirectToAction("Index", "Login"));
}
}
else
{
// return Json(new { status = false, message = "Invalid Email!" });
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult Guncelle(FormCollection fc, HttpPostedFileBase uploadFile)
{
//bool isModified = false;
if (Session["kull"] != null)
{
tblMusteri tempMus = new tblMusteri();
using (var db = new db_EOAEntities1())
{
string gelenKullAdi = fc["kullaniciAdi"];
tempMus = db.tblMusteri.Single(mus => mus.kullaniciAdi == gelenKullAdi);
tempMus.musteriAdi = fc["musteriAdi"];
tempMus.musteriSoyadi = fc["musteriSoyadi"];
tempMus.musteriTel = fc["musteriTel"];
tempMus.musteriAdres = fc["musteriAdres"];
tempMus.kullaniciAdi = fc["kullaniciAdi"];
tempMus.kullaniciSifre = fc["kullaniciSifre"];
db.tblMusteri.Attach(tempMus);
db.Entry(tempMus).State = EntityState.Modified;
db.SaveChanges();
Session["kull"] = tempMus;
//isModified = true;
}
}
return(RedirectToAction("Hesabim"));
}
public ActionResult KategoriDuzenle(FormCollection fc, HttpPostedFileBase uploadFile)
{
if (Session["kull"] != null && ((tblMusteri)Session["kull"]).rolId == 2)
{
tblKategori tempKat = new tblKategori();
using (var db = new db_EOAEntities1())
{
string gelenKatAdi = fc["kategoriAd"];
long gelentId = Convert.ToInt64(fc["kategoriId"]);
tempKat = db.tblKategori.Single(cat => cat.kategoriID == gelentId);
tempKat.kategoriAdi = fc["kategoriAd"]; // TODO
if (uploadFile != null)
{
string path = Path.Combine(Server.MapPath("~/Content/kategori"), Path.GetFileName(uploadFile.FileName));
string dbKaydet = "Content/kategori/" + uploadFile.FileName;
tempKat.kategoriResimLink = dbKaydet;
uploadFile.SaveAs(path);
}
db.tblKategori.Attach(tempKat);
db.Entry(tempKat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Kategori", "Admin"));
}
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult UrunDuzenle(FormCollection fc, HttpPostedFileBase uploadFile)
{
if (Session["kull"] != null && ((tblMusteri)Session["kull"]).rolId == 2)
{
using (var db = new db_EOAEntities1())
{
tblUrunler editUrun = new tblUrunler();
long gelentId = Convert.ToInt64(fc["urunID"]);
editUrun = db.tblUrunler.Single(urun => urun.urunID == gelentId);
editUrun.urunAdi = fc["urunAd"];
editUrun.urunDetayStok = Convert.ToInt32(fc["urunDetayStok"]);
editUrun.urunDetayFiyat = Convert.ToDecimal(fc["urunDetayFiyat"]);
if (uploadFile != null)
{
string path = Path.Combine(Server.MapPath("~/Content/resim"), Path.GetFileName(uploadFile.FileName));
string dbKaydet = "Content/resim/" + uploadFile.FileName;
editUrun.urunDetayResim = dbKaydet;
uploadFile.SaveAs(path);
}
db.tblUrunler.Attach(editUrun);
db.Entry(editUrun).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Urun", "Admin"));
}
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult AddToFav(int id)
{
if (Session["kull"] != null)
{
using (var db = new db_EOAEntities1())
{
tblFavori fav = new tblFavori();
fav.urunID = id;
fav.musteriID = Convert.ToInt32(((tblMusteri)Session["kull"]).musteriID);
db.tblFavori.Add(fav);
db.SaveChanges();
}
return(View("Favorilerim"));
}
return(RedirectToAction("Index", "Login"));
}
public ActionResult DeleteToFav(int id)
{
if (Session["kull"] != null)
{
using (var db = new db_EOAEntities1())
{
var sorguFav = (from fav in db.tblFavori
where fav.favoriID == id
select fav).First();
db.tblFavori.Remove(sorguFav);
db.SaveChanges();
}
return(View("Favorilerim"));
}
return(RedirectToAction("Index", "Login"));
}
public ActionResult Add(FormCollection mus)
{
tblMusteri Musteri = new tblMusteri();
Musteri.musteriAdi = mus["musteriAdi"];
Musteri.musteriSoyadi = mus["musteriSoyadi"];
Musteri.kullaniciAdi = mus["kullaniciAdi"];
Musteri.kullaniciSifre = mus["kullaniciSifre"];
Musteri.rolId = 1;
using (var db = new db_EOAEntities1())
{
db.tblMusteri.Add(Musteri);
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult KategoriSil(int id)
{
if (Session["kull"] != null && ((tblMusteri)Session["kull"]).rolId == 2)
{
using (var db = new db_EOAEntities1())
{
var sorguCat = (from cat in db.tblKategori
where cat.kategoriID == id
select cat).First();
db.tblKategori.Remove(sorguCat);
db.SaveChanges();
}
return(RedirectToAction("Kategori", "Admin"));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult UrunSil(int id)
{
if (Session["kull"] != null && ((tblMusteri)Session["kull"]).rolId == 2)
{
using (var db = new db_EOAEntities1())
{
var sorguUrun = (from urun in db.tblUrunler
where urun.urunID == id
select urun).First();
db.tblUrunler.Remove(sorguUrun);
db.SaveChanges();
}
return(RedirectToAction("Urun", "Admin"));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Index()
{
/* //List<UrunlerViewModel> um = new List<UrunlerViewModel>();
* string aranan = Request.QueryString["aranan"];
*
* db_EOAEntities1 db = new db_EOAEntities1();
* tblUrunler araSonuc = db.tblUrunler.ToList<tblUrunler>();
* var bizimSonuc = araSonuc.Contains(aranan);
* tblUrunler tblUrunler = (tblUrunler)araSonuc;
*
*
* List<tblUrunler> urunListesi = new List<tblUrunler>();
*
* foreach (tblUrunler urun in araSonuc)
* {
* if (urun.urunAdi.Contains(aranan))
* {
* urunListesi.Add(urun);
* }
*
* }
* // var araSonuc = db.tblUrunler;
*
* return Json(urunListesi , JsonRequestBehavior.AllowGet);
*
*/
string aranan = Request.QueryString["aranan"];
if (aranan != null)
{
db_EOAEntities1 db = new db_EOAEntities1();
List <tblUrunler> tblUrunlers = new List <tblUrunler>();
// List<UrunlerViewModel> model = new List<UrunlerViewModel>();
tblUrunlers = db.tblUrunler.Where(s => s.urunAdi.Contains(aranan)).ToList();
ViewBag.Title = "Arama | " + aranan;
return(View(tblUrunlers));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Add(FormCollection fc, HttpPostedFileBase uploadFile)
{
tblUrunler yeniUrun = new tblUrunler();
yeniUrun.urunAdi = fc["urunAd"];
yeniUrun.urunDetayStok = Convert.ToInt32(fc["urunDetayStok"]);
yeniUrun.urunDetayFiyat = Convert.ToDecimal(fc["urunDetayFiyat"]);
yeniUrun.kategoriId = Convert.ToInt32(fc["kategoriId"]);
string path = Path.Combine(Server.MapPath("~/Content/resim"), Path.GetFileName(uploadFile.FileName));
string dbKaydet = "Content/resim/" + uploadFile.FileName;
yeniUrun.urunDetayResim = dbKaydet;
uploadFile.SaveAs(path);
using (var db = new db_EOAEntities1())
{
db.tblUrunler.Add(yeniUrun);
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
// GET: Category
public ActionResult Index()
{
db_EOAEntities1 db = new db_EOAEntities1();
List <tblUrunler> tblUrunlers = new List <tblUrunler>();
tblKategori kategori = new tblKategori();
if (Request.QueryString["kategoriID"] != null)
{
int kategoriID = Convert.ToInt32(Request.QueryString["kategoriID"]);
kategori = db.tblKategori.Where(p => p.kategoriID == kategoriID).First();
tblUrunlers = db.tblUrunler.Where(urun => urun.tblKategori.kategoriID == kategoriID).ToList();
ViewBag.Kategori = kategori.kategoriAdi;
}
else
{
ViewBag.Kategori = "TÜMÜ";
tblUrunlers = db.tblUrunler.ToList();
}
return(View(tblUrunlers));
}
