public ActionResult Save(SupplierProduct entity)
{
ViewBag.GetSupplierList = GetSupplierList();
var ValidRecruitJob = SupplierProductManageBz.IsExist(o => o.SupplierId == entity.SupplierId && o.ProductName == entity.ProductName && o.ProductId != entity.ProductId);
if (ValidRecruitJob)
{
ViewBag.Msg = $"该供应商的产品已存在：{entity.ProductName}！";
return(View("SupplierProductEidt", entity));
}
if (string.IsNullOrWhiteSpace(entity.ProductName))
{
ViewBag.Msg = $"产品名称不能为空";
return(View("SupplierProductEidt", entity));
}
if (string.IsNullOrWhiteSpace(entity.Price))
{
ViewBag.Msg = $"产品单价不能为空";
return(View("SupplierProductEidt", entity));
}
var isSuccess = SupplierProductManageBz.SaveOrUpdate(entity, entity.ProductId > 0);
if (isSuccess)
{
ViewBag.Msg = "保存成功！";
}
else
{
ViewBag.Msg = "保存失败！";
}
var model = SupplierProductManageBz.Get(o => o.ProductId == entity.ProductId);
return(View("SupplierProductEidt", model));
}
protected void AddProductButton_Click(object sender, EventArgs e)
{
if (IsValid)
{
string barcode = BarcodeTextBox.Text;
double quantity = Convert.ToDouble(QuantityTextBox.Text);
var foundProduct = SupplierProduct.findProductByBarcode(currentOrder.supplier_id, barcode);
if (foundProduct != null)
{
if (currentOrder.PurchaseOrderItemsBypurchaseorder_.Where(i => i.barcode == barcode).Count() > 0)
{
AddProductsErrorLabel.Text = "This item is already in the order. Please delete and add again.";
}
else
{
PurchaseOrderItem newOrderItem = currentOrder.CreatePurchaseOrderItem();
newOrderItem.barcode = foundProduct.barcode;
newOrderItem.cost_price = foundProduct.CalculateApplicableCost(quantity, permission.is_member);
newOrderItem.description = foundProduct.description;
newOrderItem.product_code = foundProduct.product_code;
newOrderItem.quantity = quantity;
newOrderItem.Save();
}
currentOrder.Refresh();
PopulateOrderItems();
}
else
{
AddProductsErrorLabel.Text = "Product not found";
}
}
}
public void ImportProduct(string supplierProductJson, int updatedBy)
{
var productPriceList = JsonConvert.DeserializeObject <List <SupplierProduct> >(supplierProductJson);
List <SupplierProduct> insertList = new List <SupplierProduct>();
List <SupplierProduct> updateList = new List <SupplierProduct>();
foreach (var product in productPriceList)
{
SupplierProduct model = _db.Table.Find <SupplierProduct>(n => n.ProductId == product.Id && n.SupplierId == product.SupplierId);
if (model == null)
{
product.UpdatedBy = updatedBy;
product.UpdatedOn = DateTime.Now;
insertList.Add(product);
}
else
{
model.Price = product.Price;
model.UpdatedBy = updatedBy;
model.UpdatedOn = DateTime.Now;
updateList.Add(model);
}
}
if (insertList.Count > 0)
{
_db.Insert <SupplierProduct>(insertList.ToArray());
}
if (updateList.Count > 0)
{
_db.Update <SupplierProduct>(updateList.ToArray());
}
_db.SaveChange();
}
public void GetEstimatedDeliveryTime(int productId, out int unitsAvailable, out int estimatedDeliveryTimeInDays)
{
OrderBusinessComponent orderBC = DependencyInjectionHelper.GetOrderBusinessComponent();
SupplierBusinessComponent supplierBC = DependencyInjectionHelper.GetSupplierBusinessComponent();
Product product = rep.GetById(productId);
int unitsOrdered = orderBC.GetAllOrderDetails()
.Where(od => od.Product.ProductId == product.ProductId)
.Sum(od => od.QuantityInUnits);
unitsAvailable = product.UnitsOnStock - unitsOrdered;
if ((unitsAvailable) < 0)
{
unitsAvailable = 0;
}
estimatedDeliveryTimeInDays = -1;
IQueryable <Supplier> defaultSuppliers = supplierBC.GetSuppliersByCriteria(SupplierSearchType.None, null, 0);
foreach (Supplier supplier in defaultSuppliers)
{
if (supplier.ActiveFlag && supplier.PreferredSupplierFlag)
{
Supplier supplierWithCondition = supplierBC.GetSupplierById(supplier.SupplierId);
SupplierProduct supProd = supplierWithCondition.SupplierProduct.FirstOrDefault(c => c.Product.ProductId == productId);
if (supProd != null)
{
estimatedDeliveryTimeInDays = supProd.AverageLeadTimeInDays;
return;
}
}
}
}
public ActionResult EditPrice(string supID, string pID)
{
SupplierProduct Product = db.SupplierProduct.Where(x => x.ProductId == pID && x.SupplierId == supID).SingleOrDefault();
ViewData["product"] = Product;
return(View(Product));
}
public bool SaveSupplierProductsFromCSV(List <CSVSupplierProduct> csvList)
{
using (IDbContextTransaction transcat = db.Database.BeginTransaction())
{
try
{
foreach (CSVSupplierProduct sp in csvList)
{
SupplierProduct spSave = new SupplierProduct();
spSave.ProductPrice = sp.ProductPrice;
spSave.PriorityLevel = sp.PriorityLevel;
spSave.SPAvailStatus = (SPAvailStatus)Enum.Parse(typeof(SPAvailStatus), sp.SPAvailStatus);
spSave.Product = db.Products.Where(x => x.ProductCode == sp.ProductCode).First();
spSave.Supplier = db.Suppliers.Where(x => x.SupplierName == sp.SupplierName).First();
db.SupplierProducts.Add(spSave);
}
db.SaveChanges();
transcat.Commit();
return(true);
}
catch
{
transcat.Rollback();
return(false);
}
}
}
private void check_price_deviation(SupplierProduct sp)
{
decimal priceThrshold, deviationPercentage;
decimal.TryParse(Settings.GetSetting(Settings.Keys.DEVIATION_LOWEST_THRESHOLD), out priceThrshold);
decimal.TryParse(Settings.GetSetting(Settings.Keys.DEVIATION_PERCENTAGE), out deviationPercentage);
var product = Product.FetchByID(sp.ProductId);
var deviation = PriceDeviation.FetchByID(sp.SupplierId, sp.ProductId);
bool isDeviated = product.RecomendedPrice > priceThrshold && sp.Price < product.RecomendedPrice * (100 - deviationPercentage) / 100;
if (isDeviated)
{
var supplier = AppSupplier.FetchByID(sp.SupplierId);
deviation = deviation ?? new PriceDeviation();
deviation.ProductId = sp.ProductId;
deviation.ProductName = product.ProductName;
deviation.RecommendedPrice = product.RecomendedPrice;
deviation.SupplierId = supplier.SupplierId;
deviation.SupplierName = supplier.BusinessName;
deviation.ActualPrice = sp.Price;
deviation.DeviationPercentage = 100 - 100 * sp.Price / product.RecomendedPrice;
deviation.IsApproved = false;
deviation.TimeOfApproval = DateTime.MinValue;
deviation.Save();
}
else if (deviation != null)
{
PriceDeviation.Delete(sp.SupplierId, sp.ProductId);
}
}
public static int Update(SupplierProduct supplierproduct)
{
var r = DataFacade.GetDataRow("SupplierProductUpdate",
new ParameterValue("SupplierProductID", supplierproduct.SupplierProductID),
new ParameterValue("SupplierID", supplierproduct.SupplierID),
new ParameterValue("RetailBarcode", supplierproduct.RetailBarcode),
new ParameterValue("RetailPackSize", supplierproduct.RetailPackSize),
new ParameterValue("Ranging", supplierproduct.Ranging),
new ParameterValue("OuterCaseCode", supplierproduct.OuterCaseCode),
new ParameterValue("PackBarcode", supplierproduct.PackBarcode),
new ParameterValue("ProductCode", supplierproduct.ProductCode),
new ParameterValue("ProductDescription", supplierproduct.ProductDescription),
new ParameterValue("ISISRetailItemNaming", supplierproduct.ISISRetailItemNaming),
new ParameterValue("Category", supplierproduct.Category),
new ParameterValue("Brand", supplierproduct.Brand),
new ParameterValue("PackSizeCase", supplierproduct.PackSizeCase),
new ParameterValue("UOMType", supplierproduct.UOMType),
new ParameterValue("Cost", supplierproduct.Cost),
new ParameterValue("CaseCost", supplierproduct.CaseCost),
new ParameterValue("CategoryManagerStatus", supplierproduct.CategoryManagerStatus),
new ParameterValue("CategoryManagerStatusDate", supplierproduct.CategoryManagerStatusDate),
new ParameterValue("MasterDataComment", supplierproduct.MasterDataComment),
new ParameterValue("CategoryManagerComment", supplierproduct.CategoryManagerComment),
new ParameterValue("MasterDataStatus", supplierproduct.MasterDataStatus),
new ParameterValue("MasterDataStatusDate", supplierproduct.MasterDataStatusDate)
);
int SupplierProductID = Convert.ToInt32(r["SupplierProductID"]);
return(SupplierProductID);
}
public ActionResult ItemSupplied(string supplierid)
{
//SELECT s.ProductId,p.Category,p.[Description],s.Price
//FROM SupplierProducts s, Suppliers sp,Products p
//WHERE s.SupplierId = 'ALPA' AND p.ProductId = s.ProductId AND s.SupplierId = sp.SupplierId;
SupplierProduct suppro = db.SupplierProduct.Where(pro => pro.SupplierId == supplierid).First();
List <Product> products = db.Product.ToList();
List <Supplier> suppliers = db.Supplier.ToList();
List <SupplierProduct> supplierproducts = db.SupplierProduct.Where(sup => sup.SupplierId == supplierid).ToList();
if (suppro == null)
{
return(HttpNotFound());
}
else
{
ViewData["supplierproducts"] = suppro;
}
List <ItemSuppliedViewModel> data = (from sp in supplierproducts
join s in suppliers on sp.SupplierId equals s.SupplierId
join p in products on sp.ProductId equals p.ProductId
select new ItemSuppliedViewModel {
product = p, supplier = s, supplierproduct = sp
}).ToList();
return(View(data));
}
private void ApplyChangesBy(TradePointRequest tradePointRequest)
{
SupplierProduct supplierProduct = tradePointRequest.Product ?? new SupplierProduct();
supplierProduct.Supplier = comboBoxes[0].SelectedItem as Supplier;
supplierProduct.Product = comboBoxes[1].SelectedItem as Product;
try
{
supplierProduct.Count = Int32.Parse(textBoxes[0].Text);
}
catch (Exception ex)
{
supplierProduct.Count = 0;
}
tradePointRequest.Product = supplierProduct;
tradePointRequest.TradePoint = comboBoxes[2].SelectedItem as TradePoint;
if (tradePointRequest.Id < 0)
{
TradePointsController.GetInstance().AddTradePointRequest(tradePointRequest);
}
else
{
TradePointsController.GetInstance().EditTradePointRequest(tradePointRequest);
}
}
public virtual void ThisProductIsAvailable(SupplierProduct product)
{
StoreProducts.Add(new StoreProduct(product)
{
Reseller = this
});
}
public virtual void ThisProductIsNoLongerAvailable(SupplierProduct product)
{
foreach (var storeProduct in StoreProducts.RemoveWhere(s => s.SupplierProduct == product))
{
storeProduct.PrepareToDie();
}
}
/// <summary>
/// 添加产品
/// </summary>
/// <param name="request"></param>
public void AddProduct(AddSupplierProductRequest request)
{
Supplier model = this._supplierRepository.FindBy(request.SupplierId);
if (model == null)
{
throw new EntityIsInvalidException <string>(request.SupplierId.ToString());
}
Users createUser = this._usersRepository.FindBy(request.CreateUserId);
if (createUser == null)
{
throw new EntityIsInvalidException <string>(request.CreateUserId.ToString());
}
Product product = this._productRepository.FindBy(request.ProductId);
if (model == null)
{
throw new EntityIsInvalidException <string>(request.ProductId.ToString());
}
SupplierProduct p = new SupplierProduct(model, product, request.Price, createUser);
this._supplierRepository.Add(model);
this._uow.Commit();
}
public async Task <ApiResponse> CreateProduct(ProductBusinessModel product)
{
//Check if model is not null
if (product == null)
{
return(new ApiResponse()
{
StatusCode = StatusCodes.Status400BadRequest,
Result = false,
IsSuccess = false,
Message = "Empty Object"
});
}
//Construct Data Model
SupplierProduct supplierProduct = await ConstructProduct(product);
//Create Product
var result = await _supplierProductService.CreateAsync(supplierProduct);
//Get Product
var response = await _vwAllProductService.GetAsync(pr => pr.ID == supplierProduct.ProductID);
//Construct Product Supplier
return(new ApiResponse()
{
StatusCode = result?StatusCodes.Status200OK : StatusCodes.Status400BadRequest,
Result = response,
IsSuccess = result,
Message = result? "Successfully Created Product!": "Unable to create product, Check your model and try again!"
});
}
public ActionResult AddProduct([Bind(Include = "ProductId,Price, SupplierId")] SupplierProduct supplierP)
{
//check whether the warehouse item already exists
var supplierId = Int64.Parse(Request.Form["SupplierId"]);
var productId = Int64.Parse(Request.Form["ProductId"]);
if (
db.SupplierProducts.Any(
x =>
x.SupplierId == supplierId &&
x.ProductId == productId))
{
Session["warning"] = "Item is already attached to supplier";
}
else
{
supplierP.CreatedAt = DateTime.Now;
supplierP.UpdatedAt = DateTime.Now;
db.SupplierProducts.Add(supplierP);
db.SaveChanges();
Session["success"] = "Item has been added";
}
return(Redirect(Request.UrlReferrer.ToString()));
}
public async Task <IActionResult> Edit(int id, [Bind("ID,ProductID,SupplierID")] SupplierProduct supplierProduct)
{
if (id != supplierProduct.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(supplierProduct);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SupplierProductExists(supplierProduct.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ProductID"] = new SelectList(_context.Products, "ID", "Name", supplierProduct.ProductID);
ViewData["SupplierID"] = new SelectList(_context.Supplier, "ID", "FullName", supplierProduct.SupplierID);
return(View(supplierProduct));
}
public async Task <CommonResponse> AddProduct(AddProductRequest productValues, int userId)
{
using (var uow = this.unitOfWorkFactory.GetUnitOfWork())
{
var product = new Product
{
ProductName = productValues.ProductName
};
uow.Repository <Product>().Add(product);
var responseProduct = uow.SaveChanges();
if (responseProduct.Response.status == false)
{
return(CommonResponse.CreateError("Error occured while adding supplier products.", "ERR001", ""));
}
var supplierProduct = new SupplierProduct
{
ProductId = product.ProductId,
Quantity = productValues.Quantity,
Composition = productValues.Composition,
SupplierId = userId,
AvailableStatus = "a"
};
uow.Repository <SupplierProduct>().Add(supplierProduct);
var response = uow.SaveChanges();
if (response.Response.status == false)
{
return(CommonResponse.CreateError("Error occured while adding supplier products.", "ERR001", ""));
}
return(CommonResponse.CreateSuccess("Success", "SUC001", ""));
}
}
public ActionResult DeleteItemSuppliedConfirmed(int supplierproductid)
{
SupplierProduct supplierProduct = db.SupplierProduct.Find(supplierproductid);
db.SupplierProduct.Remove(supplierProduct);
db.SaveChanges();
return(RedirectToAction("SupplierList"));
}
public ActionResult DeleteConfirmed(int id)
{
SupplierProduct supplierproduct = db.SupplierProducts.Find(id);
db.SupplierProducts.Remove(supplierproduct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public virtual void Remove(SupplierProduct product)
{
Products.Remove(product);
product.Supplier = null;
foreach (var reseller in Resellers)
{
reseller.ThisProductIsNoLongerAvailable(product);
}
}
public virtual void Add(SupplierProduct product)
{
Products.Add(product);
product.Supplier = this;
foreach (var reseller in Resellers)
{
reseller.ThisProductIsAvailable(product);
}
}
public int Create(SupplierProduct obj)
{
using (IDbConnection connection = new MySqlConnection(ConnectionString))
{
var query = $"INSERT INTO {TableName} VALUE(NULL, @supplier_id, @product_id, @deliverydays);";
var affectedRows = connection.Execute(query, obj);
return(affectedRows);
}
}
public bool CreateTransactionsManual2(List <Product> pList, List <int> itQuantity, Employee emp, string comments)
{
using (IDbContextTransaction transcat = db.Database.BeginTransaction())
{
try
{
List <Product> _productList = new List <Product>();
foreach (Product p in pList)
{
Product _p = db.Products.Find(p.Id);
_productList.Add(_p);
}
SupplierProduct sp = db.SupplierProducts
.Where(x => x.PriorityLevel == 1)
.First();
List <int> _itQuantity = itQuantity;
Employee _emp = empService.GetEmployeeById(emp.Id);
for (int i = 0; i < _productList.Count; i++)
{
int InvTransCheckList = FindInvTransByTodayCount();
int count = InvTransCheckList + 1;
//Define invtrans Code
string invtransCode = "IT" + "/" + DateTime.Now.ToString("ddMMyy") + "/" + count.ToString();
InventoryTransaction itSave = new InventoryTransaction()
{
EmployeeId = _emp.Id,
ProductId = _productList[i].Id,
Employee = _emp,
InventoryChangeQuantity = _itQuantity[i],
InventoryTransComments = comments,
InventoryTransDate = DateTime.Now,
ITStatus = Enums.ITStatus.PendingApproval,
ITCode = invtransCode,
Product = _productList[i],
ProductPrice = sp.ProductPrice
};
db.InventoryTransactions.Add(itSave);
db.SaveChanges();
}
;
transcat.Commit();
return(true);
}
catch
{
transcat.Rollback();
return(false);
}
}
}
public ActionResult EditPriceConfirmed([Bind(Include = "SupplierProductId,ProductId,SupplierId,Price")] SupplierProduct supplierProduct)
{
if (ModelState.IsValid)
{
db.Entry(supplierProduct).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ItemSupplied", new { supplierid = supplierProduct.SupplierId }));
}
return(View(supplierProduct));
}
public ActionResult RemoveSupplierProduct(long?id)
{
SupplierProduct p = db.SupplierProducts.Find(id);
db.SupplierProducts.Remove(p);
db.SaveChanges();
Session["success"] = "The product has been detached from the supplier";
return(Redirect(Request.UrlReferrer.ToString()));
}
public ActionResult CreateItemSupplied([Bind(Include = "SupplierProductId,ProductId,SupplierId,Price")] SupplierProduct supplierProduct)
{
if (ModelState.IsValid)
{
db.SupplierProduct.Add(supplierProduct);
db.SaveChanges();
return(RedirectToAction("ItemSupplied", new { supplierid = supplierProduct.SupplierId }));
}
return(View(supplierProduct));
}
protected void btnExport_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"ProductName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"ProductCode"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"Amount"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"RecomendedPrice"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"Description"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"AnimalType"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"ProductPrice"), typeof(string)));
//dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"Category"), typeof(string)));
// dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"SubCategory"), typeof(string)));
// dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"ProductRate"), typeof(string)));
string searchCode = "%" + txtSearch.Text.Trim() + "%";
List <ProductUI> products = ProductController.GetAllProductUI(searchCode, Int64.Parse(ddlCategory.SelectedValue), Int64.Parse(ddlSubCategory.SelectedValue));
foreach (ProductUI product in products)
{
int i = 0;
System.Data.DataRow row = dt.NewRow();
row[i++] = product.ProductName;
row[i++] = product.ProductCode;
row[i++] = product.Amount;
row[i++] = product.RecomendedPrice;
row[i++] = product.Description;
row[i++] = ProductController.ConvertListToString(product.AnimalLst);
SupplierProduct sup_prd = SupplierProduct.FetchByID(SuppliersSessionHelper.SupplierId(), product.ProductId);
if (sup_prd != null)
{
row[i++] = sup_prd.Price;
}
//row[i++] = product.CategoryName;
// row[i++] = product.SubCategoryName;
// row[i++] = product.ProductRate;
dt.Rows.Add(row);
}
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=ProductsExport_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension);
Response.Charset = @"UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = ex.FileContentType;
Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble());
Response.Write(ex.ToString());
Response.End();
}
public void AddSupplierProduct(AddSupplierProductRequest request)
{
SupplierProduct model = this._supplierProductRepository.FindBy(request.Id);
if (model == null)
{
throw new EntityIsInvalidException <string>(request.Id.ToString());
}
this._supplierProductRepository.Add(model);
this._uow.Commit();
}
private void ButtonAddMapping_Click(object sender, EventArgs e)
{
SupplierProduct suppProduct = new SupplierProduct {
Product_Code_Internal = TextEditCode.Text ?? string.Empty,
Product_Type = "WAY"
};
_selectedRecord.SupplierProduct.Add(suppProduct);
BindSupplierProducts();
GridViewSupplierProduct.FocusedRowHandle = BindingSourceSupplierProduct.Count - 1;
}
public void RemoveSupplierProduct(int id)
{
SupplierProduct model = this._supplierProductRepository.FindBy(id);
if (model == null)
{
throw new EntityIsInvalidException <string>(id.ToString());
}
this._supplierProductRepository.Remove(model);
this._uow.Commit();
}
