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