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