private async void btnAdd_Click(object sender, EventArgs e)
{
if (numProducts.Value == 0)
{
MessageBox.Show("Not able to add 0 number of products!");
}
else
{
Model.Products product = (Model.Products)dgvProducts.SelectedRows[0].DataBoundItem;
var model = await _productsService.GetById <Model.Products>(product.Id);
if (GetExistedInModel(model.Id))
{
SetQuantityFoExisting(model.Id);
}
else
{
InputProductsAdd tmp = new InputProductsAdd
{
ProductId = model.Id,
Name = model.Name,
Quantity = (int)numProducts.Value
};
_productsAdd.Add(tmp);
}
dgvProducts.AutoGenerateColumns = false;
dgvInputProducts.DataSource = null;
dgvProducts.DataSource = null;
dgvInputProducts.DataSource = _productsAdd;
await FilterProducts();
}
}
public ActionResult AddProduct(FormCollection fc)
{
int id = Convert.ToInt32(XCommon.CreateId.CreateNum());
int price = Convert.ToInt32(fc["pPrice"]);
int pcate = Convert.ToInt32(fc["pCategoryId"]);
Model.Products product = new Model.Products()
{
productId = id,
price = price,
pcategoryId = pcate,
pname = fc["pName"].Trim(),
origin = fc["pOrigin"].Trim(),
pUrl = fc["photo"].Trim(),
Descript = fc["pDes"].Trim(),
Phot = 0,
};
if (ProductBll.addEntity(product))
{
return(Json(new { flag = true, JsonRequestBehavior.AllowGet }));
}
else
{
return(Json(new { flag = false, JsonRequestBehavior.AllowGet }));
}
}
public ActionResult Post(Model.Products product)
{
product.Id = _dummyData.Products.Count;
product.IsDeleted = 0;
_dummyData.Products.Add(product);
return(Ok(product));
}
public ActionResult UpdateProduct(FormCollection fc)
{
int id = Convert.ToInt32(fc["pId"]);
int price = Convert.ToInt32(fc["pPrice"]);
int pcate = Convert.ToInt32(fc["pCategoryId"]);
Model.Products up = new Model.Products()
{
productId = id,
price = price,
pcategoryId = pcate,
pname = fc["pName"].Trim(),
origin = fc["pOrigin"].Trim(),
};
List <string> s = new List <string>()
{
"price", "pcategoryId", "pname", "origin"
};
if (ProductBll.UpdateEntityFields(up, s))
{
return(Json(new { flag = true, JsonRequestBehavior.AllowGet }));
}
else
{
return(Json(new { flag = false, JsonRequestBehavior.AllowGet }));
}
}
public ProductViewModel()
{
Product = new Model.Products();
Log.Info("Before: get list of all product in Productviewmodel");
Products = new ObservableCollection <Model.Products>(DatabaseAndQueries.Queries.GetAllData <Products>());
Products.CollectionChanged += new System.Collections.Specialized.NotifyCollectionChangedEventHandler(Products_CollectionChanged);
Log.Info("Before: get list of all product in Productviewmodel,successfully");
}
public bool Update(Model.Products products)
{
String sql = "update Products set ProductName='{0}',Unit='{1}',UnitPrice={2},UpdatePerson='{3}',UpdateTime='{4}',State={5} where Id='{6}'";
sql = String.Format(sql, products.ProductName, products.Unit, products.UnitPrice, products.UpdatePerson, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
products.State, products.Id);
return(DataBase.Base_cmd(sql));
}
private async Task LoadProductsFromOrder(int productTypesId = 0)
{
try
{
OutputsSearchRequest orequest = new OutputsSearchRequest
{
OrderId = _orders.Id
};
var output = await _outputsService.Get <List <Model.Outputs> >(orequest);
OutputProductsSearchRequest oprequest = new OutputProductsSearchRequest
{
OutputId = output.FirstOrDefault().Id,
};
var result = await _outputProductsService.Get <List <Model.OutputProducts> >(oprequest);
List <Model.Products> list = new List <Model.Products>();
foreach (var item in result)
{
Model.Products tmp = await _products.GetById <Model.Products>(item.ProductId);
list.Add(tmp);
}
var query = list.AsQueryable();
if (!string.IsNullOrWhiteSpace(txtSearchName?.Text))
{
query = query.Where(x => x.Name.StartsWith(txtSearchName.Text));
}
query = query.OrderBy(x => x.Name);
var finalResults = query.ToList();
dgvProducts.AutoGenerateColumns = false;
var productTypesProducts = new List <Model.Products>();
if (productTypesId != 0)
{
foreach (var item in finalResults)
{
if (item.ProductTypeId == productTypesId)
{
productTypesProducts.Add(item);
}
}
dgvProducts.DataSource = productTypesProducts;
}
else
{
dgvProducts.DataSource = finalResults;
}
}
catch (Exception ex)
{
MessageBox.Show("This order has no products in list", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public List <Model.Products> GetAlikeProducts(int productId)
{
LoadProducts(productId);
List <Model.Reviews.Reviews> reviewsOfObservableProduct = new List <Model.Reviews.Reviews>();
List <Database.Reviews> reviewsFromDatabase = _context.Reviews.Where(x => x.ProductId == productId).OrderBy(y => y.UserId).ToList();
_mapper.Map(reviewsFromDatabase, reviewsOfObservableProduct);
List <Model.Reviews.Reviews> stackOfReviews1 = new List <Model.Reviews.Reviews>();
List <Model.Reviews.Reviews> stackOfReviews2 = new List <Model.Reviews.Reviews>();
List <Model.Products> recommendedProducts = new List <Model.Products>();
foreach (var item in products)
{
foreach (Model.Reviews.Reviews o in reviewsOfObservableProduct)
{
if (item.Value.Where(x => x.UserId == o.UserId).Count() > 0)
{
stackOfReviews1.Add(o);
stackOfReviews2.Add(item.Value.Where(x => x.UserId == o.UserId).First());
}
}
double alike = 0;
alike = GetSimilarity(stackOfReviews1, stackOfReviews2);
if (alike > 0.95)
{
Database.Products element1 = _context.Products.Include(y => y.ProductType).Include(y => y.OutputProducts).Where(x => x.Id == item.Key).FirstOrDefault();
Model.Products element2 = new Model.Products();
element2.Id = element1.Id;
element2.Image = element1.Image;
element2.ImageThumb = element1.ImageThumb;
element2.Name = element1.Name;
element2.Code = element1.Code;
element2.Description = element1.Description;
element2.Price = element1.Price;
element2.ProductTypeId = element1.ProductTypeId;
element2.Status = element1.Status;
recommendedProducts.Add(element2);
}
stackOfReviews1.Clear();
stackOfReviews2.Clear();
}
return(recommendedProducts);
}
public override String get(HttpContext context)
{
BLL.ProductsBLL productsBLL = new BLL.ProductsBLL();
Model.Products products = new Model.Products();
string[] st = context.Request.Params["wherestr"].ToString().Split(',');
products.ProductName = st[0];
DataTable dt = productsBLL.GetAllProducts(products);
return(MyData.Utils.EasyuiDataGridJson(dt));
}
public DataTable GetAllProducts(Model.Products products)
{
String sql = "select * from Products where 1=1 ";
if (!String.IsNullOrWhiteSpace(products.ProductName))
{
sql += " and ProductName='" + products.ProductName + "'";
}
return(DataBase.Base_dt(sql));
}
private async void cmbSecond_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
var idObj = cmbSecond.SelectedValue; //idObj because it is object in service
if (int.TryParse(idObj.ToString(), out int id)) //so we need to parse it
{
product2 = await _products.GetById <Model.Products>(id);
}
}
catch
{
MessageBox.Show("Just a second to load...", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool Insert(Model.Products products)
{
String sql = "insert into Products ([Id],[ProductName],[Unit] ,[UnitPrice],[CreatePerson],[CreateTime],[UpdatePerson],[UpdateTime],[State]) values (";
sql += "'" + products.Id + "',";
sql += "'" + products.ProductName + "',";
sql += "'" + products.Unit + "',";
sql += "" + products.UnitPrice + ",";
sql += "'" + products.CreatePerson + "',";
sql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sql += "'" + products.UpdatePerson + "',";
sql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sql += products.State + ")";
return(DataBase.Base_cmd(sql));
}
private async Task SetMaxQunatityForAdd()
{
Model.Products product = (Model.Products)dgvProducts.SelectedRows[0].DataBoundItem;
int numToSubs = 0;
foreach (var item in _productsAdd)
{
if (item.ProductId == product.Id)
{
numToSubs = item.Quantity;
}
}
numProducts.Maximum = await Helper.numInStorage(product.Id) - numToSubs;
}
//绑定数据
private void ShowInfo()
{
Model.User userMod = new Model.User();
BLL.User userBll = new BLL.User();
Model.Products proMod = new Model.Products();
BLL.Products proBll = new BLL.Products();
userMod = userBll.GetModel(Convert.ToInt32(model.UserID));
proMod = proBll.GetModel(Convert.ToInt32(model.ParentId));
this.lbChanel.Text = model.Title;
this.lbProducts.Text = proMod.Title;
this.lbBak1.Text = model.Bak1;
this.lbUser.Text = userMod.Name;
this.ddlStatus.SelectedValue = model.Status.ToString();
}
public override String update(HttpContext context)
{
BLL.ProductsBLL productsBLL = new BLL.ProductsBLL();
Model.Products products = new Model.Products();
products.Id = context.Request.Params["Id"].ToString();
products.ProductName = context.Request.Params["ProductName"].ToString();
products.Unit = context.Request.Params["Unit"].ToString();
products.UnitPrice = Convert.ToDecimal(context.Request.Params["UnitPrice"].ToString());
products.UpdatePerson = userName;
products.State = Convert.ToInt32(context.Request.Params["State"].ToString());
if (productsBLL.Update(products))
{
return("0");
}
else
{
return("保存失败");
}
}
private async void dgvProducts_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
Model.Products product = (Model.Products)dgvProducts.SelectedRows[0].DataBoundItem;
var model = await _productsService.GetById <Model.Products>(product.Id);
InputProductsAdd tmp = new InputProductsAdd
{
ProductId = model.Id,
Name = model.Name,
Quantity = 1
};
_productsAdd.Add(tmp);
dgvProducts.AutoGenerateColumns = false;
dgvInputProducts.DataSource = null;
dgvProducts.DataSource = null;
dgvInputProducts.DataSource = _productsAdd;
await LoadProducts();
}
public ActionResult Put(Model.Products product)
{
var data = _dummyData.Products.FirstOrDefault(c => c.Id == product.Id);
if (data != null)
{
data.Name = product.Name;
data.ProductType = product.ProductType;
data.Price = product.Price;
}
else
{
data = new Model.Products();
{
int Id = _dummyData.Products.Count;
int Price = product.Price;
string Name = product.Name;
int ProductType = product.ProductType;
};
_dummyData.Products.Add(data);
}
return(Ok(data));
}
public frmProductsCompareBoth(Model.Products products1, Model.Products products2)
{
InitializeComponent();
_product1 = products1;
_product2 = products2;
}
//private List<ProductIngredientAdd> _ingredientSee = new List<ProductIngredientAdd>();
public frmIngredientsProduct(Model.Products product)
{
InitializeComponent();
_product = product;
}
public frmProductEdit(Model.Products product)
{
InitializeComponent();
_product = product;
}
