/// <summary>
///دریافت منو فوتر
/// </summary>
/// <returns></returns>
public bool SubscribeByEmail(string email)
{
using (Store.Models.DataBase.Context.StoreContext _Storedb = new DataBase.Context.StoreContext(null))
{
try
{
var result = _Storedb.NewsLetters.Where(x => x.Email == email);
if (result.Count() > 0)
{
result.First().IsDeleted = false;
result.First().Token = string.Empty.GetNewToken();
}
else
{
_Storedb.NewsLetters.Add(new DataBase.Entities.NewsLetter()
{
Email = email,
IsDeleted = false,
Token = string.Empty.GetNewToken()
});
}
_Storedb.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
/// <summary>
/// عضویت در خبرنامه
/// </summary>
/// <param name="email">ایمیل</param>
/// <returns></returns>
public FoterBarMenu GetFooterMenu()
{
using (Store.Models.DataBase.Context.StoreContext _Storedb = new DataBase.Context.StoreContext(null))
{
return(JsonConvert.DeserializeObject <FoterBarMenu>(_Storedb.Settings.First().ContactUs_Json));
}
}
public Banner GetBanner()
{
using (Store.Models.DataBase.Context.StoreContext _Storedb = new DataBase.Context.StoreContext(null))
{
return(_Storedb.Settings.Select(x => new Banner
{
ImageName = x.BanerImageName,
ImageNameMob = x.BanerImageNameMob
}).First());
}
}
public List <Slider> GetSlider()
{
using (Store.Models.DataBase.Context.StoreContext _Storedb = new DataBase.Context.StoreContext(null))
{
return(_Storedb.Sliders.Where(x => x.IsActive).Select(x => new Slider {
Description = x.Description,
ImageName = x.ImageName,
ImageNameMob = x.ImageNameMob,
IsShowInMainPage = x.IsShowInMainPage,
SliderId = x.SliderId,
Title = x.Title,
UrlLink = x.UrlLink,
UrlText = x.UrlText
}).ToList());
}
}
public List <Product> GetProductsBySearch(string search_text)
{
using (Store.Models.DataBase.Context.StoreContext _Storedb = new DataBase.Context.StoreContext(null))
{
return(_Storedb.Products.Where(x => x.Name.Contains(search_text) || x.EName.Contains(search_text)).Select(x => new Product
{
ProductId = x.ProductId,
Ename = x.EName,
ImageName = JsonConvert.DeserializeObject <List <ImageProduct> >(x.Images_Json).Where(p => p.IsDefaultImage == true).First().EName,
IsExist = x.ExistCount > 0 ? true : false,
IsSpecial = x.IsSpecial,
Name = x.Name,
Price_New = x.SalesPrice.ToPriceStringFormat(),
Price_Old = x.WrittenPrice.ToPriceStringFormat(),
UnitType = x.UnitType
}).ToList());
}
}
public Category GetCategory()
{
using (Store.Models.DataBase.Context.StoreContext _Storedb = new DataBase.Context.StoreContext(null))
{
_Storedb.ChangeTracker.QueryTrackingBehavior = Microsoft.EntityFrameworkCore.QueryTrackingBehavior.NoTracking;
var categories = _Storedb.Categories.Where(x => x.IsActive == true).OrderBy(x => x.OrderNumber).ToList();
List <Category> categories_list = new List <Category>();
foreach (var cat in categories)
{
Category category = new Category()
{
CategoryId = cat.CategoryId,
Description = cat.Description,
EName = cat.EName,
//Icon=cat.Icon,
MainCategoryId = cat.MainCategoryId,
Name = cat.Name
};
}
return(null);
}
}