public List <SAPO.CalculatorCategory> GetCalculatorCategory()
{
SAContext objSAContext = new SAContext();
var lstCalculator = new List <SAPO.CalculatorCategory>();
var calculatorCat = objSAContext.CalulatorCategory.Where(x => x.IsActive == true).ToList();
foreach (var calc in calculatorCat)
{
var _category = new SAPO.CalculatorCategory();
_category.Id = calc.Id;
_category.Name = calc.Name;
_category.MustAddInList = calc.MustAddInList;
lstCalculator.Add(_category);
}
return(lstCalculator);
}
public List <SAPO.Brands> SelectBrandList(SAPO.BrandInput getBrand)
{
SAContext objSAContext = new SAContext();
List <SAPO.Brands> lstbrand = new List <Brands>();
var brands = objSAContext.Brands.Where(b => b.IsActive == true && b.IsDeleted == false).ToList();
foreach (var brand in brands)
{
SAPO.Brands _brand = new Brands();
_brand.Id = brand.Id;
_brand.Name = brand.Name;
_brand.IsActive = brand.IsActive;
_brand.Desc = brand.Desc;
_brand.LargeImg = brand.LargeImg;
_brand.SmallImg = brand.SmallImg;
_brand.CreatedDate = brand.CreatedDate;
lstbrand.Add(_brand);
}
return(lstbrand);
}
public SAPO.ProductsPro SelectProductDetail(string productName)
{
SAContext objSAContext = new SAContext();
SAPO.ProductsPro _product = new ProductsPro();
var product = objSAContext.Products.Include("ProductGalleries").Where(x => x.ProductName.ToLower() == productName).SingleOrDefault();
if (product != null)
{
_product.Id = product.Id;
_product.Discount = product.Discount;
_product.IsActive = product.IsActive;
_product.MRP = product.MRP;
_product.ProductCode = product.ProductCode;
_product.ProductDesc = product.ProductDesc;
_product.ProductName = product.ProductName;
_product.ProductShortDesc = product.ProductShortDesc;
_product.Quantity = product.Quantity;
_product.ReturnDuration = product.ReturnDuration;
_product.SellingPrice = product.SellingPrice;
_product.Tax = product.Tax;
foreach (var pic in product.ProductGalleries)
{
if (pic.IsActive)
{
SAPO.ProductGallery productGallery = new SAPO.ProductGallery();
productGallery.GalleryDesc = pic.GalleryDesc;
productGallery.GalleryImg = pic.GalleryImg;
productGallery.GalleryName = pic.GalleryName;
productGallery.ShowOnListing = pic.ShowOnListing;
productGallery.IsActive = pic.IsActive;
_product.ProductGalleries.Add(productGallery);
}
}
}
return(_product);
}
public List <SAPO.Category> SelectMenu(SAPO.MenuRequest menuRequest)
{
SAContext objSAContext = new SAContext();
List <SAPO.Category> lstCategory = new List <SAPO.Category>();
var categories = objSAContext.Categories.Where(c => c.CategoryId == menuRequest.Id && c.IsActive == true && c.IsDeleted == false && c.IsShowOnCalculator == menuRequest.IsShowOnCalculator).ToList();
foreach (var category in categories)
{
SAPO.Category _category = new SAPO.Category();
_category.Id = category.Id;
_category.CategoryId = category.CategoryId;
_category.Desc = category.Desc;
_category.LargeImg = category.LargeImg;
_category.MetaDesc = category.MetaDesc;
_category.MetaKeywords = category.MetaKeywords;
_category.MetaTitle = category.MetaTitle;
_category.Name = category.Name;
_category.SequenceNumber = category.SequenceNumber;
_category.ShortDesc = category.ShortDesc;
_category.SmallImg = category.SmallImg;
lstCategory.Add(_category);
}
return(lstCategory);
}
public void AddProduct(ProductsPro detail)
{
SAContext objSAContext = new SAContext();
List <Product> lstProduct = new List <Product>();
//var products = objSAContext.;
}
public List <SAPO.ProductsPro> SelectProductList(SAPO.GetProduct getProduct)
{
SAContext objSAContext = new SAContext();
List <SAPO.ProductsPro> lstProductsPro = new List <ProductsPro>();
var lstProduct = new List <Product>();
var products = objSAContext.Products.Include("ProductGalleries");
if (!string.IsNullOrWhiteSpace(getProduct.CategoryName) && !string.IsNullOrWhiteSpace(getProduct.BrandName))
{
lstProduct = products.Where(c => c.Brand.Name.ToLower().Contains(getProduct.BrandName.ToLower()) && c.Categories.Any(xcat => xcat.Name.ToLower().Contains(getProduct.CategoryName.ToLower())) && c.IsActive == true && c.IsDeleted == false).ToList();
}
else if (!string.IsNullOrWhiteSpace(getProduct.CategoryName))
{
lstProduct = products.Where(c => c.Categories.Any(xcat => xcat.Name.ToLower().Contains(getProduct.CategoryName.ToLower())) && c.IsActive == true && c.IsDeleted == false).ToList();
}
else if (!string.IsNullOrWhiteSpace(getProduct.BrandName))
{
lstProduct = products.Where(c => c.Brand.Name.ToLower().Contains(getProduct.BrandName.ToLower()) && c.IsActive == true && c.IsDeleted == false).ToList();
}
else if (getProduct.BrandIds.Count > 0)
{
lstProduct = products.Where(c => getProduct.BrandIds.Select(br => br.Id).Contains(c.Brand.Id) && c.IsActive == true && c.IsDeleted == false).ToList();
}
else
{
lstProduct = products.Where(c => c.IsActive == true && c.IsDeleted == false).ToList();
}
foreach (var product in lstProduct)
{
SAPO.ProductsPro _product = new ProductsPro();
_product.Id = product.Id;
_product.Discount = product.Discount;
_product.IsActive = product.IsActive;
_product.MRP = product.MRP;
_product.ProductCode = product.ProductCode;
_product.ProductDesc = product.ProductDesc;
_product.ProductName = product.ProductName;
_product.NameForCalculator = product.NameForCalculator;
_product.ProductShortDesc = product.ProductShortDesc;
_product.Quantity = product.Quantity;
_product.ReturnDuration = product.ReturnDuration;
_product.SellingPrice = product.SellingPrice;
_product.Tax = product.Tax;
foreach (var pic in product.ProductGalleries)
{
if (pic.IsActive)
{
SAPO.ProductGallery productGallery = new SAPO.ProductGallery();
productGallery.GalleryDesc = pic.GalleryDesc;
productGallery.GalleryImg = pic.GalleryImg;
productGallery.GalleryName = pic.GalleryName;
productGallery.ShowOnListing = pic.ShowOnListing;
productGallery.IsActive = pic.IsActive;
_product.ProductGalleries.Add(productGallery);
}
}
lstProductsPro.Add(_product);
}
return(lstProductsPro);
}
