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