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