public async Task <List <IncomeProdFieldSetModel> > GetProductAttributes(int pid)
{
try
{
var prod = _context.Product.FirstOrDefault(x => x.P_Id == pid);
if (prod == null)
{
return(null);
}
List <AttributeModel> attributes = _context.Attribute.AsNoTracking().Where(x => x.A_IsDeleted == false).ToList();
List <CatAttrRelationModel> CategoryRelations = _context.CategoryAttribute.AsNoTracking().Where(x => (x.X_CatId == prod.P_MainCatId || x.X_CatId == prod.P_EndLevelCatId) && !x.X_IsDeleted && x.X_Status).ToList();
List <ProductAttributeModel> AllAnswers = _context.ProductAttributeAnswer.AsNoTracking().ToList();
List <AttrAnswerModel> DefAnswers = _context.AttributeAnswer.AsNoTracking().ToList();
List <IncomeProdFieldSetModel> result = new List <IncomeProdFieldSetModel>();
foreach (var catattr in CategoryRelations)
{
IncomeProdFieldSetModel ipfs = new IncomeProdFieldSetModel();
var attr = attributes.FirstOrDefault(x => x.A_Id == catattr.X_AttrId);
if (attr != null)
{
ipfs.type = attr.A_Type;
ipfs.title = attr.A_Title;
var ans = AllAnswers.FirstOrDefault(x => x.X_AId == attr.A_Id && x.X_PId == pid);
ipfs.id = attr.A_Id;
ipfs.productid = pid;
if (ans != null)
{
if (ipfs.type == 2)
{
ipfs.value = ans.X_AnswerTitle;
}
else
{
ipfs.value = ans.X_AnswerId;
}
}
else
{
ipfs.value = null;
}
if (ipfs.type == 1)
{
var defans = DefAnswers.Where(x => x.X_CatAttrId == catattr.X_Id && x.X_IsDeleted == false && x.X_Status == true).ToList();
ipfs.Answers = defans.Select(x => new { value = x.X_Id, text = x.X_Answer });
}
result.Add(ipfs);
}
}
return(result);
}
catch (Exception ex)
{
return(new List <IncomeProdFieldSetModel>());
}
}
public async Task <ResponseStructure> GetAll()
{
try
{
List <ProductModel> AllProducts = this._context.Product.Where(x => x.P_IsDeleted == false).ToList();
List <ProductCategoryModel> AllCategories = this._context.ProductCategory.ToList();
List <BrandModel> AllBrands = this._context.Brands.ToList();
List <ProductLabelRelationModel> AllLabels = this._context.ProductLabelRelation.ToList();
List <ProductLabelModel> AllLabelTable = this._context.ProductLabel.ToList();
List <ProductCombineModel> AllCombines = this._context.ProductCombine.Where(x => !x.X_IsDeleted).ToList();
List <ColorModel> AllColors = this._context.Color.Where(x => !x.C_IsDeleted).ToList();
List <WarrantyModel> AllWarranties = this._context.Warranty.Where(x => !x.W_IsDeleted).ToList();
foreach (var item in AllProducts)
{
string cattitle = "";
string brandtitle = "";
var cat = AllCategories.FirstOrDefault(x => x.PC_Id == item.P_EndLevelCatId);
var brand = AllBrands.FirstOrDefault(x => x.B_Id == item.P_BrandId);
if (cat != null)
{
cattitle = cat.PC_Title;
}
if (brand != null)
{
brandtitle = brand.B_Title;
}
AllProducts.FirstOrDefault(x => x.P_Id == item.P_Id).P_CatTitle = cattitle;
AllProducts.FirstOrDefault(x => x.P_Id == item.P_Id).P_BrandTitle = brandtitle;
var prdslabel = AllLabels.Where(x => x.X_Pid == item.P_Id).ToList();
if (prdslabel != null)
{
AllProducts.FirstOrDefault(x => x.P_Id == item.P_Id).P_LabelIds = prdslabel.Select(x => x.X_LabelId).ToArray();
List <ProductLabelModel> Labels = new List <ProductLabelModel>();
foreach (var lid in prdslabel)
{
Labels.Add(AllLabelTable.FirstOrDefault(x => x.L_Id == lid.X_LabelId));
}
AllProducts.FirstOrDefault(x => x.P_Id == item.P_Id).P_Labels = Labels;
}
var prdDedicatedFields = _context.ProductAttributeAnswer.Where(x => x.X_PId == item.P_Id).ToList();
List <IncomeProdFieldSetModel> dedicated = new List <IncomeProdFieldSetModel>();
foreach (var d in prdDedicatedFields)
{
IncomeProdFieldSetModel ipfs = new IncomeProdFieldSetModel();
ipfs.id = d.X_AId;
if (d.X_AnswerId == 0)
{
ipfs.value = d.X_AnswerTitle;
}
else
{
ipfs.value = d.X_AnswerId;
}
dedicated.Add(ipfs);
}
item.P_DedicatedField = JsonConvert.SerializeObject(dedicated);
AllProducts.FirstOrDefault(x => x.P_Id == item.P_Id).P_ParentCategories = await this._pCRepository.GetCategoryParents(item.P_EndLevelCatId);
var ProductCombines = AllCombines.Where(x => x.X_ProductId == item.P_Id && x.X_Status && !x.X_IsDeleted).ToList();
if (ProductCombines != null && ProductCombines.Count > 0)
{
List <Models.KeyValueModel.Warranty> warranties = new List <Models.KeyValueModel.Warranty>();
List <Models.KeyValueModel.Color> colors = new List <Models.KeyValueModel.Color>();
int AvlCount = 0;
foreach (var combine in ProductCombines)
{
if (combine.X_AvailableCount > 1)
{
AvlCount += combine.X_AvailableCount;
}
var w = AllWarranties.FirstOrDefault(x => x.W_Id == combine.X_WarrantyId);
if (w != null && warranties.Count(x => x.Id == w.W_Id) < 1)
{
warranties.Add(new Models.KeyValueModel.Warranty()
{
Id = w.W_Id, Title = w.W_Title
});
}
var c = AllColors.FirstOrDefault(x => x.C_Id == combine.X_ColorId);
if (c != null && colors.Count(x => x.Id == c.C_Id) < 1)
{
colors.Add(new Models.KeyValueModel.Color()
{
Id = c.C_Id, ColorCode = c.C_HexColor, Title = c.C_Title
});
}
}
item.DefaultProductCombine = await _priceCalculator.CalculateProductPrice(item.P_Id, item.P_EndLevelCatId);
if (AvlCount > 0)
{
item.IsAvailable = true;
}
item.Warranties = warranties;
item.Colors = colors;
}
}
return(ResponseModel.Success(data: AllProducts));
}
catch (Exception ex)
{
return(ResponseModel.Error(msg: ex.Message, data: ex));
}
}
public async Task <ProductModel> GetById(object id)
{
try
{
ProductModel AllProducts = this._context.Product.FirstOrDefault(x => x.P_IsDeleted == false && x.P_Id == int.Parse(id.ToString()));
if (AllProducts == null)
{
return(null);
}
var hasgift = _context.GiftProduct.FirstOrDefault(x => x.X_MainProdId == AllProducts.P_Id);
if (hasgift != null)
{
var defcombine = _context.ProductCombine.FirstOrDefault(x => x.X_WarrantyId == hasgift.X_WarrantyId && x.X_ColorId == hasgift.X_ColorId && x.X_ProductId == hasgift.X_ProdId);
if (defcombine != null)
{
ProductModel Gift = new ProductModel();
var prod = _context.Product.FirstOrDefault(x => x.P_Id == hasgift.X_ProdId);
if (prod != null)
{
Gift = prod;
Gift.DefaultProductCombine = defcombine;
AllProducts.Gift = Gift;
}
}
}
List <ProductCategoryModel> AllCategories = this._context.ProductCategory.ToList();
List <BrandModel> AllBrands = this._context.Brands.ToList();
List <ProductLabelRelationModel> AllLabels = this._context.ProductLabelRelation.ToList();
List <ProductLabelModel> AllLabelTable = this._context.ProductLabel.ToList();
List <ProductCombineModel> AllCombines = this._context.ProductCombine.Where(x => !x.X_IsDeleted).ToList();
List <ColorModel> AllColors = this._context.Color.Where(x => !x.C_IsDeleted).ToList();
List <WarrantyModel> AllWarranties = this._context.Warranty.Where(x => !x.W_IsDeleted).ToList();
string cattitle = "";
string brandtitle = "";
var cat = AllCategories.FirstOrDefault(x => x.PC_Id == AllProducts.P_EndLevelCatId);
var brand = AllBrands.FirstOrDefault(x => x.B_Id == AllProducts.P_BrandId);
if (cat != null)
{
cattitle = cat.PC_Title;
}
if (brand != null)
{
brandtitle = brand.B_Title;
}
AllProducts.P_CatTitle = cattitle;
AllProducts.P_BrandTitle = brandtitle;
var prdslabel = AllLabels.Where(x => x.X_Pid == AllProducts.P_Id).ToList();
if (prdslabel != null)
{
AllProducts.P_LabelIds = prdslabel.Select(x => x.X_LabelId).ToArray();
List <ProductLabelModel> Labels = new List <ProductLabelModel>();
foreach (var lid in prdslabel)
{
Labels.Add(AllLabelTable.FirstOrDefault(x => x.L_Id == lid.X_LabelId));
}
AllProducts.P_Labels = Labels;
}
var prdDedicatedFields = _context.ProductAttributeAnswer.Where(x => x.X_PId == AllProducts.P_Id).ToList();
List <IncomeProdFieldSetModel> dedicated = new List <IncomeProdFieldSetModel>();
foreach (var d in prdDedicatedFields)
{
if (_context.Attribute.FirstOrDefault(x => x.A_Id == d.X_AId && !x.A_IsDeleted && x.A_Status) != null)
{
if (_context.CategoryAttribute.FirstOrDefault(x => (x.X_CatId == AllProducts.P_MainCatId || x.X_CatId == AllProducts.P_EndLevelCatId) && x.X_AttrId == d.X_AId && x.X_Status && !x.X_IsDeleted) != null)
{
IncomeProdFieldSetModel ipfs = new IncomeProdFieldSetModel();
ipfs.id = d.X_AId;
if (d.X_AnswerId == 0)
{
ipfs.value = d.X_AnswerTitle;
}
else
{
ipfs.value = d.X_AnswerId;
}
dedicated.Add(ipfs);
}
}
}
AllProducts.P_DedicatedField = JsonConvert.SerializeObject(dedicated);
AllProducts.P_ParentCategories = await this._pCRepository.GetCategoryParents(AllProducts.P_EndLevelCatId);
var ProductCombines = AllCombines.Where(x => x.X_ProductId == AllProducts.P_Id).ToList();
if (ProductCombines != null && ProductCombines.Count > 0)
{
List <Models.KeyValueModel.Warranty> warranties = new List <Models.KeyValueModel.Warranty>();
List <Models.KeyValueModel.Color> colors = new List <Models.KeyValueModel.Color>();
int AvlCount = 0;
foreach (var combine in ProductCombines)
{
if (combine.X_AvailableCount > 0)
{
var w = AllWarranties.FirstOrDefault(x => x.W_Id == combine.X_WarrantyId);
if (w != null && warranties.Count(x => x.Id == w.W_Id) < 1)
{
warranties.Add(new Models.KeyValueModel.Warranty()
{
Id = w.W_Id, Title = w.W_Title
});
}
var c = AllColors.FirstOrDefault(x => x.C_Id == combine.X_ColorId);
if (c != null && colors.Count(x => x.Id == c.C_Id) < 1)
{
colors.Add(new Models.KeyValueModel.Color()
{
Id = c.C_Id, ColorCode = c.C_HexColor, Title = c.C_Title
});
}
}
AvlCount += combine.X_AvailableCount;
}
AllProducts.DefaultProductCombine = await _priceCalculator.CalculateProductPrice(int.Parse(id.ToString()), AllProducts.P_EndLevelCatId);
if (AvlCount > 0)
{
AllProducts.IsAvailable = true;
}
AllProducts.Warranties = warranties;
AllProducts.Colors = colors;
}
AllProducts.Cuntry = _context.ManufacturingCuntry.FirstOrDefault(x => x.M_Id == AllProducts.P_MCuntryId);
var getRelatedProducts = _context.RelatedProduct.Where(x => x.X_MainProdId == AllProducts.P_Id).ToList();
var getCompletelyProducts = _context.PerfectProduct.Where(x => x.X_MainProdId == AllProducts.P_Id).ToList();
var getSetProducts = _context.SetProduct.Where(x => x.X_MainProdId == AllProducts.P_Id).ToList();
foreach (var rp in getRelatedProducts)
{
if (AllProducts.RelatedProducts.Count(x => x.P_Id == rp.X_ProdId) < 1)
{
var prod = _context.Product.FirstOrDefault(x => x.P_Id == rp.X_ProdId);
AllProducts.RelatedProducts.Add(prod);
}
}
foreach (var hl in getCompletelyProducts)
{
if (AllProducts.CompletelyProducts.Count(x => x.P_Id == hl.X_ProdId) < 1)
{
var hp = _context.Product.FirstOrDefault(x => x.P_Id == hl.X_ProdId);
AllProducts.CompletelyProducts.Add(hp);
}
}
foreach (var rp in getSetProducts)
{
if (AllProducts.SetProducts.Count(x => x.P_Id == rp.X_ProdId) < 1)
{
var prod = _context.Product.FirstOrDefault(x => x.P_Id == rp.X_ProdId);
AllProducts.SetProducts.Add(prod);
}
}
var attrs = _context.ProductAttributeAnswer.Where(x => x.X_PId == AllProducts.P_Id).ToList();
List <AttributeStructure> attributeStructures = new List <AttributeStructure>();
foreach (var attr in attrs)
{
var attribute = _context.Attribute.FirstOrDefault(x => x.A_Id == attr.X_AId && x.A_IsDeleted == false && x.A_Status);
var answer = "";
if (attr.X_AnswerId == 0)
{
answer = attr.X_AnswerTitle;
}
else
{
var Ans = _context.AttributeAnswer.FirstOrDefault(x => x.X_Id == attr.X_AnswerId && x.X_IsDeleted == false && x.X_Status == true);
if (Ans != null)
{
answer = Ans.X_Answer;
}
}
if (attribute != null)
{
attributeStructures.Add(new AttributeStructure()
{
AnswerTitle = answer,
AttributeTitle = attribute.A_Title,
AttributeId = attribute.A_Id,
ShowInDetail = attribute.A_ShowInDetail
});
}
}
AllProducts.P_AttributeStructures = attributeStructures;
AllProducts.Comments = _context.Comment.Where(x => x.C_EntityId == AllProducts.P_Id && x.C_Type == 1 && x.C_Status == 2).ToList();
return(AllProducts);
}
catch (Exception ex)
{
return(null);
}
}