public List <SupplierProductsViewModel> GetProductLink([FromBody] CodesViewModel model)
{
List <SchoolProductsLink> ls = _context.SchoolProductsLink.Where(m => m.ProductId.ToString() == model.Code).ToList();
List <SupplierProductsViewModel> returnList = new List <SupplierProductsViewModel>();
ls.ForEach(pl => {
SupplierProducts sp = _context.SupplierProducts.Where(p => p.ProductId.ToString() == pl.ProductCode).FirstOrDefault();
returnList.Add(new SupplierProductsViewModel {
BrandCode = sp.BrandCode,
ProductCode = sp.ProductCode,
CatalogueCode = sp.CatalogueCode,
CategoryCode = sp.CategoryCode,
Description = sp.Description,
Image = sp.Image,
ProductId = sp.ProductId,
RetailPrice = sp.RetailPrice,
SupplierPrice = sp.SupplierPrice,
SuppliersId = sp.SuppliersId,
UOMCode = sp.UOMCode,
UserID = sp.UserID,
Colour = sp.Color
});
});
return(returnList);
}
public bool AddSuppliersProducts([FromBody] SupplierProductsViewModel model)
{
SupplierProducts db = new SupplierProducts();
try
{
Mapper.Map(model, db);
db.SuppliersId = "1";
db.Type008 = "008";
db.Type009 = "009";
db.Type010 = "010";
db.Type011 = "011";
db.Color = model.Colour;
_context.SupplierProducts.Add(db);
var result = _context.SaveChanges();
return(true);
}
catch (Exception ex)
{
var error = ex.InnerException;
return(false);
}
}
public bool UpdateSuppliersProducts([FromBody] SupplierProductsViewModel model)
{
SupplierProducts db = _context.SupplierProducts.Where(c => c.ProductCode == model.ProductCode.ToString() && c.Color == model.Colour && c.UOMCode == model.UOMCode).FirstOrDefault();
try
{
if (db != null)
{
Mapper.Map(model, db);
if (model.Image == null)
{
db.Image = null;
}
_context.SupplierProducts.Update(db);
var result = _context.SaveChanges();
return(true);
}
else
{
db = new SupplierProducts();
Mapper.Map(model, db);
db.ProductId = 0;
db.Type008 = "008";
db.Type009 = "009";
db.Type010 = "010";
db.Type011 = "011";
db.Color = model.Colour;
db.SuppliersId = "1";
if (model.Image == null)
{
db.Image = null;
}
_context.SupplierProducts.Add(db);
var result = _context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
var error = ex.InnerException;
return(false);
}
}
public ActionResult SupplierDetails(int ID)
{
SupplierProducts supplierProductInfo = new SupplierProducts();
try
{
SuppliersPO detailedSupplier = Mapper.SupplierDOtoSupplierPO(dao.ObtainSupplierSingle(ID));
List <ProductDO> products = prodDAO.ViewBySupplierID(detailedSupplier.SupplierID);
List <ProductPO> displayProducts = ProductMapper.MapDoListToPo(products);
supplierProductInfo.supplier = detailedSupplier;
supplierProductInfo.products = displayProducts;
}
catch (SqlException sqlEx)
{
Logger.SqlExceptionLog(sqlEx);
}
return(View(supplierProductInfo));
}
public ActionResult LoadData(string CompanyId, int draw, int start, int length)
{
List <SupplierProducts> products = new List <SupplierProducts>();
#region Get Company info
AgentGetReq request = new AgentGetReq()
{
CompanyId = CompanyId, Start = start, Length = (length == 0) ? 10 : length
};
AgentGetRes response = agentProviders.GetAgentDetailedInfo(request, token).Result;
#endregion
if (response.AgentDetails.Products != null && response.AgentDetails.Products.Count > 0)
{
#region Get Booking info
List <BookingCount> list = new List <BookingCount>();
foreach (var a in response.AgentDetails.Products)
{
BookingCount b = new BookingCount();
b.ProductId = a.Product_Id;
b.SupplierId = a.Supplier_Id;
list.Add(b);
}
SupplierGetReq request1 = new SupplierGetReq()
{
CompanyId = CompanyId, bookingCount = list
};
SupplierGetRes response1 = supplierProviders.GetNoOfBookingsForSupplier(request1, token).Result;
#endregion
#region Data binding
foreach (var p in response.AgentDetails.Products)
{
SupplierProducts prod = new SupplierProducts();
prod.ProductId = p.Product_Id;
prod.ProductType = p.ProductType;
prod.ProductSupplierId = p.ProductSupplier_Id;
prod.Code = p.ProductCode;
prod.Name = p.ProductName;
prod.Status = string.IsNullOrWhiteSpace(p.SupplierStatus) ? "Active" : "Inactive";
prod.Type = p.ProductType;
prod.Country = p.Country;
prod.City = p.City;
prod.Default = (p.IsDefault == null || p.IsDefault == false) ? "N" : "Y";
prod.Preferred = (p.IsPreferred == null || p.IsPreferred == false) ? "N" : "Y";
prod.Usage = response1.BookingCount.Where(x => x.ProductId == p.Product_Id).Select(x => x.TotalCount).FirstOrDefault(); //bookinglist.Where(x => x.Positions.Any(y => y.Product_Id == p.Product_Id && y.SupplierInfo.Id == p.Supplier_Id)).Count();
products.Add(prod);
}
//products = products.OrderBy(x => x.Name).ToList();
#endregion
}
return(Json(new
{
draw = draw,
recordsTotal = response.ProductsTotalCount,
recordsFiltered = response.ProductsTotalCount,
data = products
}));
}
public IActionResult Getproducts()
{
return(Ok(SupplierProducts.GetProducts()));
}
public IActionResult Getproduct(long?id)
{
return(Ok(SupplierProducts.GetProduct(id)));
}
