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 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; }
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 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; } } }