public List <ViewModels.ProductStokViewModel> GetProductsOrderByPriceDESCInSearch(string search) { var priceDesc = db.FN_OrderByPriceDESC1().Where(x => x.ad.Contains(search)).ToList(); var Products = new List <ViewModels.ProductStokViewModel>(); if (priceDesc.Count > 0) { foreach (var model in priceDesc) { var product = new ViewModels.ProductStokViewModel(); product.ad = model.ad; product.adet = model.adet; product.altKategoriID = model.altKategoriID; product.eklenmeTarihi = model.eklenmeTarihi; product.fiyat = model.fiyat; product.altkategori = model.altKategori; product.imagePath = model.imagePath; product.markaID = model.markaID; product.marka = model.marka; product.satinAlinmaDurumu = model.satinAlinmaDurumu; product.stokID = model.stokID; product.urunID = model.urunID; Products.Add(product); } return(Products); } else { return(null); } }
//ProductsByCategory public List <ViewModels.ProductStokViewModel> GetProductsByCategory(int id) { var AltKategori = db.AltKategori.FirstOrDefault(x => x.altKategoriID == id); var Products = new List <ViewModels.ProductStokViewModel>(); if (AltKategori.Urun.Count > 0) { foreach (var model in AltKategori.Urun.ToList()) { var product = new ViewModels.ProductStokViewModel(); product.ad = model.ad; product.adet = model.Stok.adet; product.altKategoriID = model.altKategoriID; product.eklenmeTarihi = model.eklenmeTarihi; product.fiyat = model.fiyat; product.altkategori = AltKategori.altKategori1; product.imagePath = model.imagePath; product.markaID = model.markaID; product.marka = model.Marka.marka1; product.satinAlinmaDurumu = model.satinAlinmaDurumu; product.stokID = model.stokID; product.urunID = model.urunID; Products.Add(product); } return(Products); } else { return(null); } }
public List <ViewModels.ProductStokViewModel> GetFilterByBrandInSearch(string search, string marka) { var searchResults = db.FN_SearchProduct1(search).ToList(); var filteredProducts = searchResults.Where(x => x.marka == marka).ToList(); var Products = new List <ViewModels.ProductStokViewModel>(); if (filteredProducts.Count > 0) { foreach (var model in filteredProducts) { var product = new ViewModels.ProductStokViewModel(); product.ad = model.ad; product.adet = model.adet; product.altKategoriID = model.altKategoriID; product.eklenmeTarihi = model.eklenmeTarihi; product.fiyat = model.fiyat; product.altkategori = model.altKategori; product.imagePath = model.imagePath; product.markaID = model.markaID; product.marka = model.marka; product.satinAlinmaDurumu = model.satinAlinmaDurumu; product.stokID = model.stokID; product.urunID = model.urunID; Products.Add(product); } return(Products); } else { return(null); } }//endOfSearch
public List <ViewModels.ProductStokViewModel> GetFilterByBrand(int id, string marka) { var filteredProducts = db.Urun.Where(x => x.Marka.marka1 == marka && x.altKategoriID == id).ToList(); var Products = new List <ViewModels.ProductStokViewModel>(); if (filteredProducts.Count > 0) { foreach (var model in filteredProducts) { var product = new ViewModels.ProductStokViewModel(); product.ad = model.ad; product.adet = model.Stok.adet; product.altKategoriID = model.altKategoriID; product.eklenmeTarihi = model.eklenmeTarihi; product.fiyat = model.fiyat; product.altkategori = model.AltKategori.altKategori1; product.imagePath = model.imagePath; product.markaID = model.markaID; product.marka = model.Marka.marka1; product.satinAlinmaDurumu = model.satinAlinmaDurumu; product.stokID = model.stokID; product.urunID = model.urunID; Products.Add(product); } return(Products); } else { return(null); } }//endOfProductsByCategory
public List <ViewModels.ProductStokViewModel> GetProductsOrderByNameASC(int id) { var nameAsc = db.FN_OrderByNameASC1().Where(x => x.altKategoriID == id).ToList(); var Products = new List <ViewModels.ProductStokViewModel>(); if (nameAsc.Count > 0) { foreach (var model in nameAsc) { var product = new ViewModels.ProductStokViewModel(); product.ad = model.ad; product.adet = model.adet; product.altKategoriID = model.altKategoriID; product.eklenmeTarihi = model.eklenmeTarihi; product.fiyat = model.fiyat; product.altkategori = model.altKategori; product.imagePath = model.imagePath; product.markaID = model.markaID; product.marka = model.marka; product.satinAlinmaDurumu = model.satinAlinmaDurumu; product.stokID = model.stokID; product.urunID = model.urunID; Products.Add(product); } return(Products); } else { return(null); } }
}//endOfSearch //Ürün Öner public ViewModels.ProductStokViewModel SuggestProductToUser(int id) { var model = db.EnCokEtkilesimAlanAltKategori1(id).FirstOrDefault(); var product = new ViewModels.ProductStokViewModel(); if (model != null) { var urunler = db.Urun.Where(x => x.altKategoriID == model.altKategoriID).ToList(); var onerilecekUrun = urunler.OrderBy(x => Guid.NewGuid()).Take(1).ToList(); foreach (var urun in onerilecekUrun) { product.ad = urun.ad; product.adet = urun.Stok.adet; product.altKategoriID = urun.altKategoriID; product.altkategori = urun.AltKategori.altKategori1; product.kategori = urun.AltKategori.Kategori.kategori1; product.eklenmeTarihi = urun.eklenmeTarihi; product.fiyat = urun.fiyat; product.imagePath = urun.imagePath; product.markaID = urun.markaID; product.marka = urun.Marka.marka1; product.satinAlinmaDurumu = urun.satinAlinmaDurumu; product.stokID = urun.stokID; product.urunID = urun.urunID; } return(product); } else { var altkategori = db.AltKategori.OrderBy(x => Guid.NewGuid()).Take(1).ToList(); foreach (var alt in altkategori) { var urunler = db.Urun.Where(x => x.altKategoriID == alt.altKategoriID).ToList(); var onerilecekUrun = urunler.OrderBy(x => Guid.NewGuid()).Take(1).ToList(); foreach (var urun in onerilecekUrun) { product.ad = urun.ad; product.adet = urun.Stok.adet; product.altKategoriID = urun.altKategoriID; product.altkategori = urun.AltKategori.altKategori1; product.kategori = urun.AltKategori.Kategori.kategori1; product.eklenmeTarihi = urun.eklenmeTarihi; product.fiyat = urun.fiyat; product.imagePath = urun.imagePath; product.markaID = urun.markaID; product.marka = urun.Marka.marka1; product.satinAlinmaDurumu = urun.satinAlinmaDurumu; product.stokID = urun.stokID; product.urunID = urun.urunID; } } return(product); } }
public bool PostProductAlreadyExist(ViewModels.ProductStokViewModel model) { var stok = db.Stok.FirstOrDefault(x => x.stokID == model.stokID); if (stok != null) { stok.adet += model.adet; db.SaveChanges(); return(true); } else { return(false); } }
public List <ViewModels.ProductStokViewModel> GetFiveBestSellerProduts() { var bestSellers = db.FN_OrderByBestSallersNew().ToList(); var BestSellerProducts = new List <ViewModels.ProductStokViewModel>(); int sayac = 0; if (bestSellers.Count > 0) { foreach (var model in bestSellers) { if (sayac < 5) { var product = new ViewModels.ProductStokViewModel(); product.ad = model.ad; product.adet = model.adet; product.altKategoriID = model.altKategoriID; product.eklenmeTarihi = model.eklenmeTarihi; product.fiyat = model.fiyat; product.altkategori = model.altKategori; product.imagePath = model.imagePath; product.markaID = model.markaID; product.marka = model.marka; product.satinAlinmaDurumu = model.satinAlinmaDurumu; product.stokID = model.stokID; product.urunID = model.urunID; product.kullaniciAdi = model.kullaniciAdi; BestSellerProducts.Add(product); sayac++; } else { break; } } return(BestSellerProducts); } else { return(null); } }
public bool PutProduct(ViewModels.ProductStokViewModel model) { var test = db.Urun.FirstOrDefault(m => m.urunID == model.urunID); if (test != null) { var marka = db.Marka.FirstOrDefault(x => x.marka1 == model.marka); if (marka != null) { test.markaID = marka.markaID; } else { var newmarka = new Models.Marka(); newmarka.marka1 = model.marka; db.Marka.Add(newmarka); db.SaveChanges(); test.markaID = newmarka.markaID; } test.ad = model.ad; test.altKategoriID = model.altKategoriID; test.fiyat = model.fiyat; test.imagePath = "-"; test.eklenmeTarihi = DateTime.Now; test.Stok.adet = model.adet; if (model.adet <= 0) { test.satinAlinmaDurumu = true; } db.SaveChanges(); return(true); } else { return(false); } }
public bool PostProduct(ViewModels.ProductStokViewModel model) { var stok = new Models.Stok(); stok.adet = model.adet; db.Stok.Add(stok); db.SaveChanges(); var Product = new Models.Urun(); var marka = db.Marka.FirstOrDefault(x => x.marka1 == model.marka); if (marka != null) { Product.markaID = marka.markaID; } else { var yenimarka = new Models.Marka(); yenimarka.marka1 = model.marka; db.Marka.Add(yenimarka); db.SaveChanges(); Product.markaID = yenimarka.markaID; } Product.imagePath = model.imagePath; Product.ad = model.ad; Product.altKategoriID = model.altKategoriID; Product.eklenmeTarihi = DateTime.Now; Product.fiyat = model.fiyat; Product.stokID = stok.stokID; Product.satinAlinmaDurumu = false; db.Urun.Add(Product); db.SaveChanges(); return(true); }
public ViewModels.ProductStokViewModel GetProductById(int id) { var model = db.Urun.FirstOrDefault(m => m.urunID == id); if (model != null) { var urun = new ViewModels.ProductStokViewModel(); urun.ad = model.ad; urun.adet = model.Stok.adet; urun.fiyat = model.fiyat; urun.altKategoriID = model.altKategoriID; urun.marka = model.Marka.marka1; urun.urunID = model.urunID; urun.stokID = model.stokID; urun.markaID = model.markaID; return(urun); } else { return(null); } }
public List <ViewModels.ProductStokViewModel> GetFilterByPrice(int id, int min, int max) { if (max < min) { max = min + 1; } var filteredProducts = db.Urun.Where(x => x.fiyat >= min && x.fiyat <= max && x.altKategoriID == id).ToList(); var Products = new List <ViewModels.ProductStokViewModel>(); if (filteredProducts.Count > 0) { foreach (var model in filteredProducts) { var product = new ViewModels.ProductStokViewModel(); product.ad = model.ad; product.adet = model.Stok.adet; product.altKategoriID = model.altKategoriID; product.eklenmeTarihi = model.eklenmeTarihi; product.fiyat = model.fiyat; product.altkategori = model.AltKategori.altKategori1; product.imagePath = model.imagePath; product.markaID = model.markaID; product.marka = model.Marka.marka1; product.satinAlinmaDurumu = model.satinAlinmaDurumu; product.stokID = model.stokID; product.urunID = model.urunID; Products.Add(product); } return(Products); } else { return(null); } }
public List <ViewModels.ProductStokViewModel> GetAllSellerProduts() { var SellerProducts = db.Siparis.ToList(); var SellerProductsNew = new List <ViewModels.ProductStokViewModel>(); if (SellerProducts.Count > 0) { foreach (var models in SellerProducts) { var kullanici = db.Kullanici.FirstOrDefault(x => x.kullaniciID == models.Sepet.kullaniciID); foreach (var model in models.Sepet.SepettekiUrunler) { var product = new ViewModels.ProductStokViewModel(); product.ad = model.Urun.ad; product.adet = model.adet; product.altKategoriID = model.Urun.altKategoriID; product.eklenmeTarihi = model.Urun.eklenmeTarihi; product.fiyat = model.Urun.fiyat; product.altkategori = model.Urun.AltKategori.altKategori1; product.imagePath = model.Urun.imagePath; product.markaID = model.Urun.markaID; product.marka = model.Urun.Marka.marka1; product.satinAlinmaDurumu = model.Urun.satinAlinmaDurumu; product.stokID = model.Urun.stokID; product.urunID = model.Urun.urunID; product.kullaniciAdi = kullanici.kullaniciAdi; SellerProductsNew.Add(product); } } return(SellerProductsNew); } else { return(null); } }
public List <ViewModels.ProductStokViewModel> GetAllProduct() { var model = db.Urun.ToList(); var Products = new List <ViewModels.ProductStokViewModel>(); if (model != null) { foreach (var urun in model) { if (urun.satinAlinmaDurumu != true) { var product = new ViewModels.ProductStokViewModel(); product.ad = urun.ad; product.adet = urun.Stok.adet; product.altKategoriID = urun.altKategoriID; product.altkategori = urun.AltKategori.altKategori1; product.kategori = urun.AltKategori.Kategori.kategori1; product.eklenmeTarihi = urun.eklenmeTarihi; product.fiyat = urun.fiyat; product.imagePath = urun.imagePath; product.markaID = urun.markaID; product.satinAlinmaDurumu = urun.satinAlinmaDurumu; product.stokID = urun.stokID; product.urunID = urun.urunID; Products.Add(product); } } return(Products); } else { return(null); } }