public List <BuyerProductModel> DeleteBuyerProduct(long Id, long buyerID)
{
List <BuyerProductModel> lstbulkproducts = new List <BuyerProductModel>();
using (ShopDevEntities db = new ShopDevEntities())
{
try
{
BuyerProduct product = GetProduct(db, Id);
db.BuyerProducts.Remove(product);
db.SaveChanges();
var lstproducts = db.BuyerProducts.Where(m => m.BuyerID == buyerID).ToList();
foreach (var cusprod in lstproducts)
{
BuyerProductModel objcsproducts = new BuyerProductModel();
cusprod.CopyProperties(objcsproducts);
lstbulkproducts.Add(objcsproducts);
}
}
catch (Exception)
{
}
return(lstbulkproducts);
}
}
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 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);
}
