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