private static Model.Product SetProduct(Data.Product dataProduct) { var product = MapDataProductToModelProduct(dataProduct); product.Categories = Category.GetCategoriesByProductId(product.Id); return(product); }
private void btnAddItem_Click(object sender, EventArgs e) { try { string text = pnlSearch.Text.Substring(0, pnlSearch.Text.IndexOf(':') - 1); int id = Convert.ToInt32(text); Data.Product product = Program.User.Inventory.GetProduct(id); if (product.Stock != 0) { Forms.GetQuantityForm form = new Forms.GetQuantityForm(product, 1); form.StyleManager = Program.MainStyleManager; if (form.ShowDialog() == DialogResult.OK) { int quantity = form.Value; AddCart(product, quantity); RefreshPrivControls(); } } else { MetroMessageBox.Show(this, product.ProductName + " is out of stock!", "Out of stock", MessageBoxButtons.OK, 150); } } catch { MainForm form = (MainForm)Parent; form.NotifText = "Select product first"; } }
public void Given_NonExistentProductName_Then_GetPoductByNameWillReturnNull() { Data.Product expected = null; Data.Product actual = sut.GetPoductByName("Book"); actual.Should().Be(expected); }
private void btnAdd_Click(object sender, EventArgs e) { NotifText = "Adding product"; try { int id = Program.User.Inventory.ProductCount + 1; string name = txtBoxName.Text; double price = Convert.ToDouble(txtBoxPrice.Text); double cost = Convert.ToDouble(txtBoxCost.Text); int quantity = Convert.ToInt32(txtBoxQuantity.Text); if (price <= 0 || cost <= 0 || quantity <= 0) { throw new Exception(); } Data.Product prod = new Data.Product(id, name, price, cost, quantity, productPicture.Image); Program.User.Inventory.AddProduct(prod); NotifText = "New product added"; DialogResult = DialogResult.OK; Dispose(); } catch { NotifText = "Invalid input(s)!"; } }
public void Given_ProductWithNameExistsInRepository_When_RemoveProductByName_Then_ProductIsRemoved() { Data.Product removedProduct = sut.GetPoductByName("Rice"); sut.RemoveProductByName("Rice"); sut.FindAllProducts().Should().NotContain(removedProduct); }
public List<Product> Product_GetByTop(string Top, string Where, string Order) { List<Data.Product> list = new List<Data.Product>(); using (SqlCommand dbCmd = new SqlCommand("sp_Product_GetByTop", GetConnection())) { Data.Product obj = new Data.Product(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Top", Top)); dbCmd.Parameters.Add(new SqlParameter("@Where", Where)); dbCmd.Parameters.Add(new SqlParameter("@Order", Order)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ProductIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
public void Given_ValidPosition_Then_GetProductByPositionReturnsProduct() { Data.Product actual = sut.GetProductByPosition(2); Data.Product expected = products.ElementAt(2); actual.Should().Be(expected); }
public static Core.Models.Product CreateProductDTO(Data.Product input) { return(input == null ? null : new Core.Models.Product() { ProductID = input.ProductId, Name = input.Name, ProductNumber = input.ProductNumber, MakeFlag = input.MakeFlag, FinishedGoodsFlag = input.FinishedGoodsFlag, Color = input.Color, SafetyStockLevel = input.SafetyStockLevel, ReorderPoint = input.ReorderPoint, StandardCost = input.StandardCost, ListPrice = input.ListPrice, Size = input.Size, SizeUnitMeasureCode = input.SizeUnitMeasureCode, WeightUnitMeasureCode = input.WeightUnitMeasureCode, Weight = input.Weight, DaysToManufacture = input.DaysToManufacture, ProductLine = input.ProductLine, Class = input.Class, Style = input.Style, ProductSubcategoryID = input.ProductSubcategoryId, ProductModelID = input.ProductModelId, SellStartDate = input.SellStartDate, SellEndDate = input.SellEndDate, DiscontinuedDate = input.DiscontinuedDate, rowguid = input.Rowguid, ModifiedDate = input.ModifiedDate, }); }
private void btnChangeQuantity_Click(object sender, EventArgs e) { try { int id = Convert.ToInt32(lblId.Text.ToString()); Data.Product product = Program.User.Inventory.GetProduct(id); int currentQuantity = 1; foreach (Item item in Cart) { if (item.Product.ID == product.ID) { currentQuantity = item.Quantity; } } Forms.GetQuantityForm form = new Forms.GetQuantityForm(product, currentQuantity); form.StyleManager = Program.MainStyleManager; if (form.ShowDialog() == DialogResult.OK) { int quantity = form.Value; AddCart(product, quantity); RefreshPrivControls(); } } catch { MainForm form = (MainForm)Parent; form.NotifText = "Select product first"; } }
public static string GetProductById(int id) { Data.Product dataProduct = Data.ProductManager.GetProductById(id); Model.Product product = SetProduct(dataProduct); string productJson = JsonConvert.SerializeObject(product); return(productJson); }
public static void Update(int id, string productJson) { Model.Product product = JsonConvert.DeserializeObject <Model.Product>(productJson); Data.Product dataProduct = MapModelProductToDataProduct(product); Data.ProductManager.Update(id, dataProduct); UpdateProductCategories(id, product); }
public void DeleteProduct(Data.Product product) { if (!_context.Products.Local.Any(p => p.Id == product.Id)) { _context.Products.Attach(product); } _context.Products.Remove(product); _context.SaveChanges(); }
public Data.Product UpdateProduct(Data.Product product) { Data.Product found = _products.First(p => p.Id == product.Id); found.Id = product.Id; found.Name = product.Name; found.Price = product.Price; found.SubCategory = product.SubCategory; return(found); }
private void PrepareBill(Data.Product Model) { bool cost = float.TryParse(Model.cost.ToString(), out float costValue); bool tax = float.TryParse(((decimal)0.13 * Model.cost).ToString(), out float taxValue); PriceValueLabel.Text = $"{Model.cost:C2}".ToString(); SalesTaxValueLabel.Text = $"{(decimal)0.13 * Model.cost:C2}"; TotalValueLabel.Text = $"{(costValue + taxValue):C2}"; }
public static Product DatabaseProductToServiceProduct(Data.Product product) { return(new Product() { Id = product.id, Name = product.product_name, Price = (double)product.price }); }
public void Given_ExistingProductName_Then_GetPoductByNameWillReturnProduct() { string existingProductName = "Rice"; Data.Product expected = products.ElementAt(0); Data.Product actual = sut.GetPoductByName(existingProductName); actual.Should().Be(expected); }
private static Data.Product MapModelProductToDataProduct(Model.Product product) { Data.Product dataProduct = new Data.Product(); dataProduct.Description = product.Description; dataProduct.Name = product.Name; dataProduct.Serial = product.Serial; dataProduct.UnitPrice = product.UnitPrice; return(dataProduct); }
public Data.Product UpdateProduct(Data.Product agenda) { if (!_context.Products.Local.Any(a => a.Id == agenda.Id)) { _context.Products.Attach(agenda); } _context.Entry(agenda).State = EntityState.Modified; _context.SaveChanges(); return(agenda); }
public Data.Product UpdateProduct(Data.Product product) { if (!_context.Products.Local.Any(sal => sal.ID == product.ID)) { _context.Products.Attach(product); } _context.Entry(product).State = EntityState.Modified; _context.SaveChanges(); return(product); }
public void UpdateProduct(Data.Product product) { Product productUpdate = _DataContext.Products.FirstOrDefault(c => c.Id.Equals(product.id)); if (productUpdate != null) { productUpdate.Name = product.product_name; productUpdate.Price = (double)product.price; } }
public void RemoveProductByName(string productName) { if (productName == null) { throw new ArgumentException("Product name cannot have null value."); } Data.Product product = GetPoductByName(productName); _products.Remove(product); }
private static Model.Product MapDataProductToModelProduct(Data.Product dataProduct) { Model.Product product = new Model.Product(); product.Description = dataProduct.Description; product.Name = dataProduct.Name; product.Serial = dataProduct.Serial; product.UnitPrice = dataProduct.UnitPrice; product.Id = dataProduct.Id; return(product); }
private string GetImageUrl(Data.Product product) { if (product.PartnerPhotos != null && product.PartnerPhotos.Count > 0) { return(product.PartnerPhotos.First().BlobUrl); } if (product.Photos != null && product.Photos.Count > 0) { return(product.Photos.First().BlobUrl); } return(string.Empty); }
} //TODO change in datetime //public decimal NeedToBuy { get { return _low95} } #endregion public Prediction(JToken json, IProductRepo productRepo) { IEnumerable <Data.Product> productlist = productRepo.GetProducts().Where(product => product.ID == (int)json["ID2"]); _product = productlist.First(); _time = (string)json["time"]; // _forecast = (int)(decimal)json["forecast"]; _low95 = (int)(decimal)json["lo95"]; _high95 = (int)(decimal)json["hi95"]; _dateDataReceived = (string)json["runtime"]; //_stock = ; , IRecipeRepo recipeRepo, IIngredientRepo ingredientRepo }
public static void Save(string productJson) { Model.Product product = JsonConvert.DeserializeObject <Model.Product>(productJson); product.Serial = GenerateSerial(); Data.Product dataProduct = MapModelProductToDataProduct(product); var date = DateTime.Now; dataProduct.CreateDateTime = date; dataProduct.UpdateDateTime = date; int productId = Data.ProductManager.Save(dataProduct); SaveProductCategories(product, productId); }
public Product(Data.Product product, List<SuggestedProducts> suggestedProducts, IProductRepo productRepo) { ID = product.ID; Name = product.Name; Price = product.Price; SubCategory = product.SubCategory; foreach (SuggestedProducts suggestedproduct in suggestedProducts) { _suggestedProducts.Add(suggestedproduct); } _iProductRepo = productRepo; }
public void Given_ValidProduct_When_AddingProduct_Then_RepositoryContainsTheProduct() { //Given ProductRepository sut = new ProductRepository(); Data.Product product = new Data.Product(3, "Book", "New", new DateTime(), new DateTime(), 100.0); //When sut.AddProduct(product); //Then sut.FindAllProducts().Contains(product); }
private void AddCart(Data.Product product, int quantity) { Item item = new Item(product, quantity); foreach (Item cartItem in Cart) { if (cartItem.Product.ID == item.Product.ID) { cartItem.Quantity = quantity; return; } } Cart.Add(item); }
public void AddProduct(Data.Product product) { if (product == null) { throw new ArgumentException("Product cannot have a null value."); } if (_products.Contains(product)) { return; } _products.Add(product); }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.Product obj = new Data.Product(); obj.Id = Id; obj.Name = txtName.Text; obj.Image1 = txtImage1.Text; obj.Image2 = string.Empty; obj.Image3 = string.Empty; obj.Image4 = string.Empty; obj.Image5 = txtKichThuoc.Text.Trim(); obj.Content = txtContent.Text; obj.Detail = fckDetail.Value; obj.GroupId = ddlGroupProduct.SelectedValue; obj.Price = txtPricePro.Text.Trim().Replace(".", string.Empty); obj.GroupName = ddlGroupProduct.SelectedItem.Text; obj.IsPopular = chkPopular.Checked ? "1" : "0"; obj.IsHot = "0"; obj.IsNew = "0"; obj.IsSpecial = chkSpecial.Checked ? "1" : "0"; obj.ChudeId = ""; foreach (ListItem item in cklChude.Items) { if (item.Selected) { obj.ChudeId += item.Value + ","; } } if (!string.IsNullOrEmpty(obj.ChudeId)) { obj.ChudeId = "," + obj.ChudeId; } obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1"; obj.Active = chkActive.Checked ? "1" : "0"; if (Insert == true) { ProductService.Product_Insert(obj); } else { ProductService.Product_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }
/// <summary> /// Method to select device image according to its type /// This method can be modified using different image for each devices /// </summary> /// <param name="Model"></param> private void SelectImage(Data.Product Model) { if (Model.platform == "Laptop") { SelectedProductPictureBox.Image = Image.FromFile("../../Resources/laptop.png"); } else if (Model.platform == "Desktop PC") { SelectedProductPictureBox.Image = Image.FromFile("../../Resources/desktop.png"); } else { SelectedProductPictureBox.Image = Image.FromFile("../../Resources/My-Computer.png"); } }
private static Data.Product ConvertNewGearToDbProduct(NewProductModel model,string category) { Data.Product p = new Data.Product(); p.Approved = false; p.Brand = model.Brand; p.Category = category; p.Title = FormInputHelper.StripInput(model.ProductName); p.Description = String.IsNullOrEmpty(model.Description) ? string.Empty : FormInputHelper.StripInput(model.Description); p.Image = String.Empty; p.SubmittedBy = System.Web.HttpContext.Current.User.Identity.Name; decimal x; Decimal.TryParse(model.Price,out x); p.MSRP = x; p.SubCategory = model.Subcategory; p.SiteUrl = !String.IsNullOrEmpty(model.SiteUrl) ? FormInputHelper.StripInput(model.SiteUrl): String.Empty; return p; }
public JsonResult Create([DataSourceRequest] DataSourceRequest request, Models.Product product) { if (product != null && ModelState.IsValid) { var productToCreate = new Data.Product { ProductID = product.Id, ProductName = product.Name, SupplierID = product.Supplier.Id, CategoryID = product.Category.Id, UnitsInStock = product.UnitsInStock, UnitPrice = product.UnitPrice, Discontinued = product.Discontinued }; _context.Products.Add(productToCreate); _context.SaveChanges(); } return Json(ModelState.IsValid ? true : ModelState.ToDataSourceResult()); }
public List<Product> Product_GetByAll() { List<Data.Product> list = new List<Data.Product>(); using (SqlCommand dbCmd = new SqlCommand("sp_Product_GetByAll", GetConnection())) { Data.Product obj = new Data.Product(); dbCmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ProductIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
public Product ProductIDataReader(IDataReader dr) { Data.Product obj = new Data.Product(); obj.ID = (dr["ID"] is DBNull) ? string.Empty : dr["ID"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString(); obj.Tag = (dr["Tag"] is DBNull) ? string.Empty : dr["Tag"].ToString(); obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString(); obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString(); obj.Decription = (dr["Decription"] is DBNull) ? string.Empty : dr["Decription"].ToString(); obj.MetaKeyword = (dr["MetaKeyword"] is DBNull) ? string.Empty : dr["MetaKeyword"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); obj.SalePrice = (dr["SalePrice"] is DBNull) ? string.Empty : dr["SalePrice"].ToString(); obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString(); obj.CreatedDate = (dr["CreatedDate"] is DBNull) ? string.Empty : dr["CreatedDate"].ToString(); obj.ProductCategoryID = (dr["ProductCategoryID"] is DBNull) ? string.Empty : dr["ProductCategoryID"].ToString(); obj.ModifiedDate = (dr["ModifiedDate"] is DBNull) ? string.Empty : dr["ModifiedDate"].ToString(); obj.Priority = (dr["Priority"] is DBNull) ? string.Empty : dr["Priority"].ToString(); obj.Image1 = (dr["Image1"] is DBNull) ? string.Empty : dr["Image1"].ToString(); obj.Image2 = (dr["Image2"] is DBNull) ? string.Empty : dr["Image2"].ToString(); obj.Image3 = (dr["Image3"] is DBNull) ? string.Empty : dr["Image3"].ToString(); obj.Image4 = (dr["Image4"] is DBNull) ? string.Empty : dr["Image4"].ToString(); obj.Image5 = (dr["Image5"] is DBNull) ? string.Empty : dr["Image5"].ToString(); obj.Detail = (dr["Detail"] is DBNull) ? string.Empty : dr["Detail"].ToString(); obj.CapacityID = (dr["CapacityID"] is DBNull) ? string.Empty : dr["CapacityID"].ToString(); obj.BranchID = (dr["BranchID"] is DBNull) ? string.Empty : dr["BranchID"].ToString(); obj.ProductCode = (dr["ProductCode"] is DBNull) ? string.Empty : dr["ProductCode"].ToString(); obj.UnitPrice = (dr["UnitPrice"] is DBNull) ? string.Empty : dr["UnitPrice"].ToString(); obj.CountSale = (dr["CountSale"] is DBNull) ? string.Empty : dr["CountSale"].ToString(); obj.CategoryName = (dr["CategoryName"] is DBNull) ? string.Empty : dr["CategoryName"].ToString(); obj.CapacityName = (dr["CapacityName"] is DBNull) ? string.Empty : dr["CapacityName"].ToString(); obj.BranchName = (dr["BranchName"] is DBNull) ? string.Empty : dr["BranchName"].ToString(); obj.PageCount = (dr["PageCount"] is DBNull) ? string.Empty : dr["PageCount"].ToString(); obj.Unit = (dr["Unit"] is DBNull) ? string.Empty : dr["Unit"].ToString(); return obj; }
public List<Product> Product_Paging_Where(string CurentPage, string PageSize, string where) { List<Data.Product> list = new List<Data.Product>(); using (SqlCommand dbCmd = new SqlCommand("sp_Product_Paging_Where", GetConnection())) { Data.Product obj = new Data.Product(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@CurentPage", CurentPage)); dbCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize)); dbCmd.Parameters.Add(new SqlParameter("@Where", where)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ProductIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
public Models.Product newProduct() { Models.Product product = new Models.Product(); var newProd = new Data.Product { name = product.name, description = product.description, price = product.price, timeStamp = product.timeStamp }; db.products.Add(newProd); try { db.SaveChanges(); } catch (Exception ex) { httpCtx.Trace.Warn("Database write Error", "Cannot create a new product", ex); return new Models.Product(); } product.productID = newProd.productID; routeDiffs(new[]{ new { op = "add", data = new { orders = new Models.Order[0], customers = new Models.Customer[0], blobs = new Models.Blob[0], products = new Models.Product[] { product } } } }); return product; }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.Product obj = new Data.Product(); obj.ID = Id; obj.Name = txtName.Text; obj.Title = txtTitle.Text; obj.Tag = Common.StringClass.NameToTag(txtName.Text); obj.Content = fckContent.Value; obj.Ord = "0"; obj.Decription = txtDecription.Text; obj.MetaKeyword = txtMetaKeyword.Text; obj.Active = chkActive.Checked ? "1" : "0"; string saleprice = txtSalePrice.Text; if (saleprice.Trim().Equals("")) saleprice = "0"; string unitPrice = txtUnitPrice.Text; if (unitPrice.Trim().Equals("")) unitPrice = "0"; obj.SalePrice = saleprice; obj.UnitPrice = unitPrice; obj.Image = txtImage.Text; obj.Unit = txtUnit.Text; obj.Priority = "1"; obj.Image1 = txtImage1.Text; obj.Image2 = txtImage2.Text; obj.Image3 = txtImage3.Text; obj.Image4 = txtImage4.Text; obj.Image5 = txtImage5.Text; obj.Detail = fckDetail.Value; obj.ProductCode = txtProductCode.Text; obj.BranchID = "0"; obj.CapacityID = "0"; obj.ProductCategoryID = ddlProductCategory.SelectedValue; if (Insert == true) { obj.CreatedDate = DateTimeClass.ConvertDateTime(DateTime.Now, "MM/dd/yyyy HH:mm:ss"); obj.ModifiedDate = DateTimeClass.ConvertDateTime(DateTime.Now, "MM/dd/yyyy HH:mm:ss"); ProductService.Product_Insert(obj); } else { obj.ModifiedDate = DateTimeClass.ConvertDateTime(DateTime.Now, "MM/dd/yyyy HH:mm:ss"); ProductService.Product_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }