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