public ActionResult SearchResult(String searchTerm, String type = "", int currentPageIndex = 1)
{
int maxRows = 8;
ViewBag.searchTerm = searchTerm;
string[] searchTerms = searchTerm.Split(' ');
List <Tbl_Perfume> perfumes = new List <Tbl_Perfume>();
foreach (var term in searchTerms)
{
perfumes = db.Tbl_Perfume.Where(a => a.Perfume_Name.Contains(term) || a.Perfume_Perfumer.Contains(term) ||
a.Perfume_Country.Contains(term) || a.Perfume_Description.Contains(term) ||
a.Perfume_Notes.Contains(term) || a.Tbl_Brand.Brand_Title.Contains(term)).ToList();
}
PerfumeModel perfumeModel = new PerfumeModel();
perfumeModel.Perfumes = perfumes
.OrderBy(a => a.Perfume_ID)
.Skip((currentPageIndex - 1) * maxRows)
.Take(maxRows).ToList();
double pageCount = (double)((decimal)perfumes.Count() / Convert.ToDecimal(maxRows));
perfumeModel.PageCount = (int)Math.Ceiling(pageCount);
perfumeModel.CurrentPageIndex = currentPageIndex;
perfumeModel.type = type;
return(PartialView(perfumeModel));
}
public ActionResult PerfumesBrand(int brandID = 0, string type = "", int currentPageIndex = 1)
{
int maxRows = 8;
List <Tbl_Perfume> perfumes = new List <Tbl_Perfume>();
perfumes = db.Tbl_Perfume.Where(a => a.Perfume_Brand_ID == brandID).ToList();
PerfumeModel perfumeModel = new PerfumeModel();
perfumeModel.Perfumes = perfumes
.OrderBy(a => a.Perfume_ID)
.Skip((currentPageIndex - 1) * maxRows)
.Take(maxRows).ToList();
double pageCount = (double)((decimal)perfumes.Count() / Convert.ToDecimal(maxRows));
perfumeModel.PageCount = (int)Math.Ceiling(pageCount);
perfumeModel.CurrentPageIndex = currentPageIndex;
perfumeModel.brandID = brandID;
perfumeModel.type = type;
return(View(perfumeModel));
}
private PerfumeModel GetPerfumes(int brandID = 0, String type = "", int currentPage = 0)
{
int maxRows = 8;
//var brands = db.Tbl_Brand.OrderByDescending(a => a.Brand_ID).ToList();
List <Tbl_Perfume> perfumes = new List <Tbl_Perfume>();
/////////////////////////////
if (type == "specialOffer")
{
//Rep_Perfume rep_perfume = new Rep_Perfume();
// var perfumes = rep_perfume.Get_IsSpecialOffer_Perfumes();
perfumes = db.Tbl_Perfume.Where(a => a.Perfume_SpecialOffer == true && a.Perfume_Brand_ID == brandID).OrderByDescending(a => a.Perfume_ID).ToList();
TempData["title"] = "پیشنهاد ویژه";
}
else if (type == "women")
{
//Rep_Perfume rep_perfume = new Rep_Perfume();
//var perfumes = rep_perfume.Get_NewPerfume("زنانه");
perfumes = db.Tbl_Perfume.Where(a => a.Perfume_Gender == "زنانه" && a.Perfume_Brand_ID == brandID).OrderByDescending(a => a.Perfume_ID).ToList();
TempData["title"] = "زنانه";
}
else if (type == "man")
{
//Rep_Perfume rep_perfume = new Rep_Perfume();
//var perfumes = rep_perfume.Get_NewPerfume("مردانه");
perfumes = db.Tbl_Perfume.Where(a => a.Perfume_Gender == "مردانه" && a.Perfume_Brand_ID == brandID).OrderByDescending(a => a.Perfume_ID).ToList();
TempData["title"] = "مردانه";
}
else if (type == "unisex")
{
// Rep_Perfume rep_perfume = new Rep_Perfume();
// var perfumes = rep_perfume.Get_NewPerfume("یونیسکس");
perfumes = db.Tbl_Perfume.Where(a => a.Perfume_Gender == "یونیسکس" && a.Perfume_Brand_ID == brandID).OrderByDescending(a => a.Perfume_ID).ToList();
TempData["title"] = "یونیسکس";
}
else if (type == "seasonOffers")
{
Rep_Season rep_season = new Rep_Season();
perfumes = rep_season.Get_SeasonPerfumes(brandID).ToList();
TempData["title"] = "عطر مناسب فصل";
}
else if (type == "companySample")
{
Rep_CompanySample rep_companySample = new Rep_CompanySample();
//List<Tbl_Perfume> perfumes1 = new List<Tbl_Perfume>();
var companySamples = rep_companySample.Get_All_CompanySamples();
foreach (var sample in companySamples)
{
perfumes.Add(sample.Tbl_Perfume);
}
TempData["title"] = "سمپل شرکتی";
}
else if (type == "handySample")
{
Rep_HandySample rep_handySample = new Rep_HandySample();
//List<Tbl_Perfume> perfumes = new List<Tbl_Perfume>();
var handySamples = rep_handySample.Get_All_HandySamples();
foreach (var sample in handySamples)
{
perfumes.Add(sample.Tbl_Perfume);
}
TempData["title"] = "دکانت و سمپل دست ریز";
}
else
{
// Rep_Perfume rep_perfume = new Rep_Perfume();
// var perfumes = rep_perfume.Get_All_Perfumes();
perfumes = db.Tbl_Perfume.Where(a => a.Perfume_Brand_ID == brandID).OrderByDescending(a => a.Perfume_ID).ToList();
TempData["title"] = "همه محصولات";
}
////////////////////////
PerfumeModel perfumeModel = new PerfumeModel();
perfumeModel.Perfumes = perfumes
.OrderBy(a => a.Perfume_ID)
.Skip((currentPage - 1) * maxRows)
.Take(maxRows).ToList();
double pageCount = (double)((decimal)perfumes.Count() / Convert.ToDecimal(maxRows));
perfumeModel.PageCount = (int)Math.Ceiling(pageCount);
perfumeModel.CurrentPageIndex = currentPage;
perfumeModel.brandID = brandID;
perfumeModel.type = type;
return(perfumeModel);
}
