public List<Installments> DeleteDeleteInstallment(long Id, long bulkBuyID) { List<Installments> lstinstallments = new List<Installments>(); using (ShopDevEntities db = new ShopDevEntities()) { try { BulkBuyInstallment installment = GetInstallment(db, Id); var bulkbuy = db.BulkBuys.Where(m => m.BulkBuyID == bulkBuyID).FirstOrDefault(); var outstandingAmount = bulkbuy.OustandingAmont; bulkbuy.OustandingAmont = outstandingAmount == null ? installment.Amount : outstandingAmount + installment.Amount; var interstableAmount = bulkbuy.InterstableAmount; bulkbuy.InterstableAmount = interstableAmount == null ? installment.Amount : interstableAmount + installment.Amount; db.BulkBuyInstallments.Remove(installment); db.SaveChanges(); var lstproducts = db.BulkBuyInstallments.Where(m => m.BulkBuyID == bulkBuyID).ToList(); foreach (var cusprod in lstproducts) { Installments objInstallments = new Installments(); cusprod.CopyProperties(objInstallments); lstinstallments.Add(objInstallments); } } catch (Exception) { } return lstinstallments; } }
public List <BorrowerModel> AllBorrowers(BorrowerModel objborrower) { List <BorrowerModel> Allcust = new List <BorrowerModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { var res = from buyer in db.Borrowers where (buyer.Name.Contains(objborrower.Name) || buyer.CustCode == objborrower.CustCode) || (string.IsNullOrEmpty(objborrower.Name) && objborrower.CustCode == null) select buyer; foreach (var seller in res) { BorrowerModel sellerModel = new BorrowerModel(); seller.CopyProperties(sellerModel); Allcust.Add(sellerModel); } } catch (Exception ex) { } return(Allcust); } }
public List<VendorDetailsModel> DeleteVendor(long Id, long bulkBuyID) { List<VendorDetailsModel> lstvendors = new List<VendorDetailsModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { VendorDetail vendor = GetVendor(db, Id); db.VendorDetails.Remove(vendor); db.SaveChanges(); var lstproducts = db.VendorDetails.Where(m => m.BulkByID == bulkBuyID).ToList(); foreach (var cusprod in lstproducts) { VendorDetailsModel objvendor = new VendorDetailsModel(); cusprod.CopyProperties(objvendor); lstvendors.Add(objvendor); } } catch (Exception) { } return lstvendors; } }
public List <BorrowerInstallmentModel> DeleteBorrowerInstallment(long Id, long buyerID) { List <BorrowerInstallmentModel> lstinstallments = new List <BorrowerInstallmentModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { BorrowerInstallment installment = GetBorrowerInstallment(db, Id); var borrower = db.Borrowers.Where(m => m.BorrowID == installment.BorrowerID).FirstOrDefault(); var outstandingAmount = borrower.Outstanding; borrower.Outstanding = outstandingAmount == null ? installment.Amount : outstandingAmount + installment.Amount; var interstableAmount = borrower.InterstableAmount; borrower.InterstableAmount = interstableAmount == null ? installment.Amount : interstableAmount + installment.Amount; db.BorrowerInstallments.Remove(installment); db.SaveChanges(); var lstproducts = db.BorrowerInstallments.Where(m => m.BorrowerID == buyerID).ToList(); foreach (var cusprod in lstproducts) { BorrowerInstallmentModel objInstallments = new BorrowerInstallmentModel(); cusprod.CopyProperties(objInstallments); lstinstallments.Add(objInstallments); } } catch (Exception) { } return(lstinstallments); } }
public List <CustomerProductModel> DeleteCustomerProduct(long Id, long orderId) { List <CustomerProductModel> lstcsproducts = new List <CustomerProductModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { CustomerProduct customerProduct = GetCustomerProduct(db, Id); customerProduct.IsActive = false; db.CustomerProducts.Remove(customerProduct); db.SaveChanges(); var lstproducts = db.CustomerProducts.Where(m => m.OrderID == orderId && m.IsActive).ToList(); foreach (var cusprod in lstproducts) { CustomerProductModel objcsproducts = new CustomerProductModel(); cusprod.CopyProperties(objcsproducts); lstcsproducts.Add(objcsproducts); } } catch (Exception) { } return(lstcsproducts); } }
public List<BulkBuyProductsModel> DeleteProduct(long Id, long bulkBuyID) { List<BulkBuyProductsModel> lstbulkproducts = new List<BulkBuyProductsModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { BulkBuyProduct product = GetProduct(db, Id); db.BulkBuyProducts.Remove(product); db.SaveChanges(); var lstproducts = db.BulkBuyProducts.Where(m => m.BulkBuyID == bulkBuyID).ToList(); foreach (var cusprod in lstproducts) { BulkBuyProductsModel objcsproducts = new BulkBuyProductsModel(); cusprod.CopyProperties(objcsproducts); lstbulkproducts.Add(objcsproducts); } } catch (Exception) { } return lstbulkproducts; } }
public List<BulkBuyModel> AllBulk(BulkBuyModel bulkmodel) { List<BulkBuyModel> Allcust = new List<BulkBuyModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { var res = from buyer in db.BulkBuys where (buyer.CustomerName.Contains(bulkmodel.CustomerName) || buyer.CustomerCode == bulkmodel.CustomerCode) || (string.IsNullOrEmpty(bulkmodel.CustomerName) && bulkmodel.CustomerCode == null) select buyer; foreach (var seller in res) { BulkBuyModel sellerModel = new BulkBuyModel(); seller.CopyProperties(sellerModel); Allcust.Add(sellerModel); } } catch (Exception ex) { } return Allcust; } }
public SellerSearchViewModel SearchSeller(string name) { SellerSearchViewModel searchRes = new SellerSearchViewModel(); List <SellerModel> lstsellers = new List <SellerModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { var res = from seller in db.Sellers where seller.SellerName.Contains(name) || string.IsNullOrEmpty(name) orderby seller.BuyDate descending select seller; foreach (var seller in res) { SellerModel sellerModel = new SellerModel(); seller.CopyProperties(sellerModel); lstsellers.Add(sellerModel); } } catch (Exception ex) { } searchRes.lstseller = lstsellers; searchRes.seller = new SellerModel(); return(searchRes); } }
public List <SellerInstallmentModel> DeleteSellerInstallment(long Id, long sellerID) { List <SellerInstallmentModel> lstinstallments = new List <SellerInstallmentModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { SellerInstallment installment = GetSellerInstallment(db, Id); db.SellerInstallments.Remove(installment); db.SaveChanges(); var lstproducts = db.SellerInstallments.Where(m => m.SellerID == sellerID).ToList(); foreach (var cusprod in lstproducts) { SellerInstallmentModel objInstallments = new SellerInstallmentModel(); cusprod.CopyProperties(objInstallments); lstinstallments.Add(objInstallments); } } catch (Exception) { } return(lstinstallments); } }
public BorrowerViewModel GetBorrowerInfo(long?borrowerID) { BorrowerViewModel borrowermodel = new BorrowerViewModel(); using (ShopDevEntities db = new ShopDevEntities()) { try { var sellerInfo = db.Borrowers.Where(m => m.BorrowID == borrowerID).FirstOrDefault(); var AllInstallments = db.BorrowerInstallments.Where(m => m.BorrowerID == borrowerID).ToList(); BorrowerModel bbModel = new BorrowerModel(); sellerInfo.CopyProperties(bbModel); List <BorrowerInstallmentModel> lstInstallments = new List <BorrowerInstallmentModel>(); foreach (var cusprod in AllInstallments) { BorrowerInstallmentModel objcsproduct = new BorrowerInstallmentModel(); cusprod.CopyProperties(objcsproduct); lstInstallments.Add(objcsproduct); } borrowermodel.Borrower = bbModel; borrowermodel.Installments = new BorrowerInstallmentModel(); borrowermodel.Lstinstallments = new List <BorrowerInstallmentModel>(); borrowermodel.Lstinstallments.AddRange(lstInstallments); } catch (Exception) { } } return(borrowermodel); }
public List <CustomerModel> AllCustomers(CustomerModel objModel) { List <CustomerModel> lstcustomers = new List <CustomerModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { var res = from customer in db.Customers where (customer.CustmerName.Contains(objModel.CustmerName) || customer.CustCode == objModel.CustCode) || (string.IsNullOrEmpty(objModel.CustmerName) && objModel.CustCode == 0) select customer; foreach (var seller in res) { CustomerModel sellerModel = new CustomerModel(); seller.CopyProperties(sellerModel); lstcustomers.Add(sellerModel); } } catch { } return(lstcustomers); } }
public List <BuyerProductModel> AddBuyerProduct(BuyerProductModel productModel) { List <BuyerProductModel> lstcsproducts = new List <BuyerProductModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { productModel.BuyerID = productModel.BuyerID == null ? 0 : productModel.BuyerID; BuyerProduct buyerproduct = null; int? oldUnits = 0; if (productModel.BuyerProductlD > 0) { buyerproduct = db.BuyerProducts.Where(m => m.BuyerProductlD == productModel.BuyerProductlD).FirstOrDefault(); oldUnits = buyerproduct.Units == null ? 0 : buyerproduct.Units; var diffUnit = oldUnits - productModel.Units; var product = db.Products.Where(m => m.ProductName == productModel.ProductName).FirstOrDefault(); if (product != null) { product.Unit += diffUnit; } } else { buyerproduct = new BuyerProduct(); } productModel.CopyProperties(buyerproduct); if (productModel.BuyerProductlD == 0) { db.BuyerProducts.Add(buyerproduct); if (productModel.BuyerID > 0) { var oldproduct = db.Products.Where(m => m.ProductName == productModel.ProductName && m.Type == productModel.Type).FirstOrDefault(); if (oldproduct != null) { oldproduct.Unit -= productModel.Units; } } } db.SaveChanges(); var lstproducts = db.BuyerProducts.Where(m => m.BuyerID == productModel.BuyerID).ToList(); foreach (var cusprod in lstproducts) { BuyerProductModel objcsproduct = new BuyerProductModel(); cusprod.CopyProperties(objcsproduct); lstcsproducts.Add(objcsproduct); } return(lstcsproducts); } catch (Exception) { return(lstcsproducts); } } }
public BulkBuyViewModel GetBulk(long? bulkID) { BulkBuyViewModel bulkmodel = new BulkBuyViewModel(); using (ShopDevEntities db = new ShopDevEntities()) { try { var bulkBuycustomerInfo = db.BulkBuys.Where(m => m.BulkBuyID == bulkID).FirstOrDefault(); var lstproducts = db.BulkBuyProducts.Where(m => m.BulkBuyID == bulkID).ToList(); var AllInstallments = db.BulkBuyInstallments.Where(m => m.BulkBuyID == bulkID).ToList(); var Allvendors = db.VendorDetails.Where(m => m.BulkByID == bulkID).ToList(); BulkBuyModel bbModel = new BulkBuyModel(); bulkBuycustomerInfo.CopyProperties(bbModel); List<BulkBuyProductsModel> lstcsproducts = new List<BulkBuyProductsModel>(); foreach (var cusprod in lstproducts) { BulkBuyProductsModel objcsproduct = new BulkBuyProductsModel(); cusprod.CopyProperties(objcsproduct); lstcsproducts.Add(objcsproduct); } List<VendorDetailsModel> lstvendors = new List<VendorDetailsModel>(); foreach (var cusprod in Allvendors) { VendorDetailsModel objcsproduct = new VendorDetailsModel(); cusprod.CopyProperties(objcsproduct); lstvendors.Add(objcsproduct); } List<Installments> lstInstallments = new List<Installments>(); foreach (var cusprod in AllInstallments) { Installments objcsproduct = new Installments(); cusprod.CopyProperties(objcsproduct); lstInstallments.Add(objcsproduct); } bulkmodel.bulkBuyModel = bbModel; bulkmodel.Products = new BulkBuyProductsModel(); bulkmodel.lstbulkBuyProducts = new List<BulkBuyProductsModel>(); bulkmodel.lstbulkBuyProducts.AddRange(lstcsproducts); bulkmodel.Vendors = new VendorDetailsModel(); bulkmodel.lstVendors = new List<VendorDetailsModel>(); bulkmodel.lstVendors.AddRange(lstvendors); bulkmodel.installments = new Installments(); bulkmodel.lstinstallments = new List<Installments>(); bulkmodel.lstinstallments.AddRange(lstInstallments); } catch (Exception) { } } return bulkmodel; }
// vendor public List<VendorDetailsModel> AddVendor(VendorDetailsModel vendorModel) { List<VendorDetailsModel> lstvendors = new List<VendorDetailsModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { vendorModel.BulkByID = vendorModel.BulkByID == null ? 0 : vendorModel.BulkByID; VendorDetail vendordetails = null; if (vendorModel.VendorCode == null) { Vendor vendor = new Vendor { VendorName = vendorModel.VendorName, Address = vendorModel.Address, MobileNo= vendorModel.MobileNo, TotalBulks=1 }; db.Vendors.Add(vendor); db.SaveChanges(); vendorModel.VendorCode = vendor.VendorCode; } if (vendorModel.BuyVendorID > 0) { vendordetails = db.VendorDetails.Where(m => m.BuyVendorID == vendorModel.BuyVendorID).FirstOrDefault(); } else { vendordetails = new VendorDetail(); } vendorModel.CopyProperties(vendordetails); if (vendorModel.BuyVendorID == 0) { db.VendorDetails.Add(vendordetails); } db.SaveChanges(); var lstAllvendors = db.VendorDetails.Where(m => m.BulkByID == vendorModel.BulkByID).ToList(); foreach (var cusprod in lstAllvendors) { VendorDetailsModel objcsproduct = new VendorDetailsModel(); cusprod.CopyProperties(objcsproduct); lstvendors.Add(objcsproduct); } return lstvendors; } catch (Exception) { return lstvendors; } } }
public void DeleteInitilProducts() { using (ShopDevEntities db = new ShopDevEntities()) { try { var AllInitialInstallments = db.BorrowerInstallments.Where(m => m.BorrowerID == 0).ToList(); db.BorrowerInstallments.RemoveRange(AllInitialInstallments); db.SaveChanges(); } catch { } } }
public CustomerProduct GetCustomerProduct(ShopDevEntities db, long Id) { CustomerProduct objCustomerProduct = null; try { objCustomerProduct = db.CustomerProducts.Where(m => m.ProductID == Id).FirstOrDefault(); } catch (Exception) { } return(objCustomerProduct); }
public SellerProduct GetProduct(ShopDevEntities db, long Id) { SellerProduct objProduct = null; try { objProduct = db.SellerProducts.Where(m => m.SellerProductID == Id).FirstOrDefault(); } catch (Exception) { } return(objProduct); }
public VendorDetail GetVendor(ShopDevEntities db, long Id) { VendorDetail objvendor = null; try { objvendor = db.VendorDetails.Where(m => m.BuyVendorID == Id).FirstOrDefault(); } catch (Exception) { } return objvendor; }
public BorrowerInstallment GetBorrowerInstallment(ShopDevEntities db, long Id) { BorrowerInstallment objinstllment = null; try { objinstllment = db.BorrowerInstallments.Where(m => m.InstallmentID == Id).FirstOrDefault(); } catch (Exception) { } return(objinstllment); }
public BulkBuyProduct GetProduct(ShopDevEntities db, long Id) { BulkBuyProduct objProduct = null; try { objProduct = db.BulkBuyProducts.Where(m => m.BulkBuyProductID == Id).FirstOrDefault(); } catch (Exception) { } return objProduct; }
public BulkBuyInstallment GetInstallment(ShopDevEntities db, long Id) { BulkBuyInstallment objinstllment = null; try { objinstllment = db.BulkBuyInstallments.Where(m => m.InstallmentID == Id).FirstOrDefault(); } catch (Exception) { } return objinstllment; }
public void AddSeller(SellerModel seller) { using (ShopDevEntities db = new ShopDevEntities()) { try { Seller sellerdb = null; if (seller.SellerID == 0) { sellerdb = new Seller(); seller.CopyProperties(sellerdb); db.Sellers.Add(sellerdb); } else { sellerdb = db.Sellers.Where(m => m.SellerID == seller.SellerID).FirstOrDefault(); seller.CopyProperties(sellerdb); } db.SaveChanges(); List <SellerProduct> lstNewproducts = db.SellerProducts.Where(m => m.SellerID == 0).ToList(); lstNewproducts.ForEach(m => m.SellerID = sellerdb.SellerID); foreach (var product in lstNewproducts) { var oldproduct = db.Products.Where(m => m.ProductName == product.ProductName && m.Type == product.Type && m.CategoryID == product.CategoryID).FirstOrDefault(); if (oldproduct != null) { oldproduct.Unit += product.Unit; } else { Product prod = new Product(); prod.ProductName = product.ProductName; prod.ProdDesc = product.Description; prod.Type = product.Type; prod.CategoryID = product.CategoryID; prod.Unit = product.Unit; prod.IsActive = true; db.Products.Add(prod); } } List <SellerInstallment> lstinstallments = db.SellerInstallments.Where(m => m.SellerID == 0).ToList(); lstinstallments.ForEach(m => m.SellerID = sellerdb.SellerID); db.SaveChanges(); } catch { } } }
public Installments GetInstallmentDetails(long Id) { Installments objModel = new Installments(); using (ShopDevEntities db = new ShopDevEntities()) { try { BulkBuyInstallment installment = GetInstallment(db, Id); installment.CopyProperties(objModel); } catch (Exception) { } } return objModel; }
public BulkBuyProductsModel GetProductDetails(long Id) { BulkBuyProductsModel objModel = new BulkBuyProductsModel(); using (ShopDevEntities db = new ShopDevEntities()) { try { BulkBuyProduct product = GetProduct(db, Id); product.CopyProperties(objModel); } catch (Exception) { } } return objModel; }
public VendorDetailsModel GetVendorDetails(long Id) { VendorDetailsModel objModel = new VendorDetailsModel(); using (ShopDevEntities db = new ShopDevEntities()) { try { VendorDetail vendor = GetVendor(db, Id); vendor.CopyProperties(objModel); } catch (Exception) { } } return objModel; }
public void DeleteInitilProducts() { using (ShopDevEntities db = new ShopDevEntities()) { try { var AllInitialVendors = db.VendorDetails.Where(m => m.BulkByID == 0).ToList(); db.VendorDetails.RemoveRange(AllInitialVendors); var AllInitialproducts = db.BulkBuyProducts.Where(m => m.BulkBuyID == 0).ToList(); db.BulkBuyProducts.RemoveRange(AllInitialproducts); var AllInitialInstallments = db.BulkBuyInstallments.Where(m => m.BulkBuyID == 0).ToList(); db.BulkBuyInstallments.RemoveRange(AllInitialInstallments); db.SaveChanges(); } catch { } } }
public SellerViewModel GetSellerInfo(long?sellerID) { SellerViewModel sellermodel = new SellerViewModel(); using (ShopDevEntities db = new ShopDevEntities()) { try { var sellerInfo = db.Sellers.Where(m => m.SellerID == sellerID).FirstOrDefault(); var lstproducts = db.SellerProducts.Where(m => m.SellerID == sellerID).ToList(); var AllInstallments = db.SellerInstallments.Where(m => m.SellerID == sellerID).ToList(); SellerModel bbModel = new SellerModel(); sellerInfo.CopyProperties(bbModel); List <SellerProductModel> lstcsproducts = new List <SellerProductModel>(); foreach (var cusprod in lstproducts) { SellerProductModel objcsproduct = new SellerProductModel(); cusprod.CopyProperties(objcsproduct); lstcsproducts.Add(objcsproduct); } List <SellerInstallmentModel> lstInstallments = new List <SellerInstallmentModel>(); foreach (var cusprod in AllInstallments) { SellerInstallmentModel objcsproduct = new SellerInstallmentModel(); cusprod.CopyProperties(objcsproduct); lstInstallments.Add(objcsproduct); } sellermodel.sellerInfor = bbModel; sellermodel.productInfo = new SellerProductModel(); sellermodel.Lstproducts = new List <SellerProductModel>(); sellermodel.Lstproducts.AddRange(lstcsproducts); sellermodel.Installments = new SellerInstallmentModel(); sellermodel.LstInstallments = new List <SellerInstallmentModel>(); sellermodel.LstInstallments.AddRange(lstInstallments); } catch (Exception) { } } return(sellermodel); }
public BuyerViewModel GetBuyerInfo(long?buyerId) { BuyerViewModel buyermodel = new BuyerViewModel(); using (ShopDevEntities db = new ShopDevEntities()) { try { var buyercustomerInfo = db.Buyers.Where(m => m.BuyerID == buyerId).FirstOrDefault(); var lstproducts = db.BuyerProducts.Where(m => m.BuyerID == buyerId).ToList(); var AllInstallments = db.BuyerInstallments.Where(m => m.BuyerID == buyerId).ToList(); BuyerModel bbModel = new BuyerModel(); buyercustomerInfo.CopyProperties(bbModel); List <BuyerProductModel> lstcsproducts = new List <BuyerProductModel>(); foreach (var cusprod in lstproducts) { BuyerProductModel objcsproduct = new BuyerProductModel(); cusprod.CopyProperties(objcsproduct); lstcsproducts.Add(objcsproduct); } List <BuyerInstallmentModel> lstInstallments = new List <BuyerInstallmentModel>(); foreach (var cusprod in AllInstallments) { BuyerInstallmentModel objcsproduct = new BuyerInstallmentModel(); cusprod.CopyProperties(objcsproduct); lstInstallments.Add(objcsproduct); } buyermodel.buyer = bbModel; buyermodel.productInfo = new BuyerProductModel(); buyermodel.LstProducts = new List <BuyerProductModel>(); buyermodel.LstProducts.AddRange(lstcsproducts); buyermodel.Installments = new BuyerInstallmentModel(); buyermodel.LstInstallments = new List <BuyerInstallmentModel>(); buyermodel.LstInstallments.AddRange(lstInstallments); } catch (Exception) { } } return(buyermodel); }
public void AddOrder(OrderModel orderModel) { using (ShopDevEntities db = new ShopDevEntities()) { try { Order order = null; //if (orderModel.OrderId > 0) //{ // order = GetCustomerProduct(db, customerProductModel.ProductID); //} if (orderModel.OrderId == 0) { order = new Order(); orderModel.CopyProperties(order); db.Orders.Add(order); } else { order = db.Orders.Where(m => m.OrderId == orderModel.OrderId).FirstOrDefault(); orderModel.CopyProperties(order); } db.SaveChanges(); List <CustomerProduct> lstNewproducts = db.CustomerProducts.Where(m => m.OrderID == 0).ToList(); lstNewproducts.ForEach(m => m.OrderID = order.OrderId); //foreach (var product in lstNewproducts) //{ // var oldproduct = db.Products.Where(m => m.ProductName == product.ProductName && m.Type == product.Type && m.CategoryID == product.CategoryID).FirstOrDefault(); // if (oldproduct != null) // { // oldproduct.Unit -= 1; // } //} db.SaveChanges(); } catch { } } }
public List<BulkBuyProductsModel> AddProduct(BulkBuyProductsModel productModel) { List<BulkBuyProductsModel> lstcsproducts = new List<BulkBuyProductsModel>(); using (ShopDevEntities db = new ShopDevEntities()) { try { productModel.BulkBuyID = productModel.BulkBuyID == null ? 0 : productModel.BulkBuyID; BulkBuyProduct bulkproduct = null; if (productModel.BulkBuyProductID > 0) { bulkproduct = db.BulkBuyProducts.Where(m => m.BulkBuyProductID == productModel.BulkBuyProductID).FirstOrDefault(); } else { bulkproduct = new BulkBuyProduct(); } productModel.CopyProperties(bulkproduct); if (productModel.BulkBuyProductID == 0) { db.BulkBuyProducts.Add(bulkproduct); } db.SaveChanges(); var lstproducts = db.BulkBuyProducts.Where(m => m.BulkBuyID == productModel.BulkBuyID).ToList(); foreach (var cusprod in lstproducts) { BulkBuyProductsModel objcsproduct = new BulkBuyProductsModel(); cusprod.CopyProperties(objcsproduct); lstcsproducts.Add(objcsproduct); } return lstcsproducts; } catch (Exception) { return lstcsproducts; } } }