protected void btnNewProduct_Click(object sender, EventArgs e) { //public Product(double price,string type, int supplierID) Product prod = new StandardProduct(Convert.ToInt32(txtPrice.Text), txtType.Text, Convert.ToInt32(txtSupplier.Text)); Response.Write(prod.addProduct()); }
public async Task CreateStandardProduct(StandardProduct productEntity, StandardProductCreateDto product) { if (product.ImageFile != null) { var blobName = _blobStorageService.GenerateFileName(product.ImageName); var filePath = await _blobStorageService.UploadFileBlobAsync(product.ImageFile, blobName, "standardproducts"); productEntity.ImageName = product.ImageName; productEntity.ImagePath = filePath; productEntity.BlobName = blobName; } productEntity.Status = StandardProductStatus.Produced; _repository.StandardProduct.CreateProduct(productEntity); await _repository.SaveAsync(); var productWarehouseItem = new ProductWarehouseItem() { StandardProductId = productEntity.StandardProductId, Quantity = 0 }; _repository.ProductWarehouseItem.CreateItem(productWarehouseItem); await _repository.SaveAsync(); }
public static Product SelectProduct(int pid) { Product retProduct = null; SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\werl\Documents\Visual Studio 2013\Projects\SystemsAnalysis\WebApplication2\WebApplication2\App_Data\Database.mdf;Integrated Security=True"); SqlDataReader reader; SqlCommand cmd = new SqlCommand("SELECT * FROM [Products] WHERE ProductID = " + pid, con); try { con.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { retProduct = new StandardProduct(Convert.ToInt32(reader["ProductID"]), (reader["Type"]).ToString(), Convert.ToInt32(reader["SupplierID"])); } reader.Close(); con.Close(); return(retProduct); } catch (SqlException sqlEx) { Console.Write(sqlEx.Message); return(null); } }
public IHttpActionResult GetStandardProduct(int id) { StandardProduct standardProduct = db.StandardProducts.Find(id); if (standardProduct == null) { return(NotFound()); } return(Ok(standardProduct)); }
public IHttpActionResult PostStandardProduct(StandardProduct standardProduct) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.StandardProducts.Add(standardProduct); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = standardProduct.Id }, standardProduct)); }
public static Boolean checkWithAccessory(Cart cart, int custID) { List <int> pIDs = new List <int>(); Boolean hasPhone = false, hasAccessory = false, hasBoth = false; string connectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); String sql = "SELECT ProductID FROM [ShoppingCart] WHERE CustomerID = @CustomerID"; SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader; connection.Open(); command.Parameters.Add("@CustomerID", SqlDbType.Int); command.Parameters["@CustomerID"].Value = custID; reader = command.ExecuteReader(); while (reader.HasRows) { while (reader.Read()) { pIDs.Add(reader.GetInt32(0)); } reader.NextResult(); } connection.Close(); for (int i = 0; i < pIDs.Count; i++) { if (StandardProduct.getProductType(pIDs[i]).Contains("Phone")) { hasPhone = true; } else if (StandardProduct.getProductType(pIDs[i]).Contains("Accessory")) { hasAccessory = true; } } if (hasPhone && hasAccessory) { hasBoth = true; } return(hasBoth); }
public async Task UpdateStandardProduct(StandardProduct productEntity, StandardProductUpdateDto product) { if (product.ImageFile != null) { var blobName = _blobStorageService.GenerateFileName(productEntity.ImageName); var filePath = await _blobStorageService.UploadFileBlobAsync(product.ImageFile, blobName, "standardproducts"); productEntity.ImagePath = filePath; productEntity.BlobName = blobName; } productEntity.StandardProductCategoryId = product.StandardProductCategoryId; var category = await _repository.StandardProductCategory.GetCategoryByIdAsync(productEntity.StandardProductCategoryId); productEntity.StandardProductCategory = category; _repository.StandardProduct.UpdateProduct(productEntity); await _repository.SaveAsync(); }
public static double getTotal(int custID) { double total = 0.0; List <int> pIDs = new List <int>(); List <int> quantities = new List <int>(); string connectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); String sql = "SELECT ProductID, Quantity FROM [ShoppingCart] WHERE CustomerID = @CustomerID"; SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader; connection.Open(); command.Parameters.Add("@CustomerID", SqlDbType.Int); command.Parameters["@CustomerID"].Value = custID; reader = command.ExecuteReader(); while (reader.HasRows) { while (reader.Read()) { pIDs.Add(reader.GetInt32(0)); quantities.Add(reader.GetInt32(1)); } reader.NextResult(); } connection.Close(); for (int i = 0; i < pIDs.Count; i++) { total += StandardProduct.getProductPrice(pIDs[i]) * quantities[i]; } return(total); }
public void Update(StandardProduct standard) { throw new NotImplementedException(); }
public void Insert(StandardProduct standard) { throw new NotImplementedException(); }
protected void btnEditProduct_Click(object sender, EventArgs e) { Product prod = new StandardProduct(Convert.ToInt32(lstProducts.SelectedItem.Value), Convert.ToInt32(txtPrice.Text), txtPrice.Text, Convert.ToInt32(txtSupplier.Text)); Response.Write(prod.editProduct(Convert.ToInt32(txtPrice.Text), txtType.Text, Convert.ToInt32(txtSupplier.Text))); }
public void Update(StandardProduct Product) { db.Entry(Product).State = System.Data.Entity.EntityState.Modified; }
public void Insert(StandardProduct Product) { db.StandardProducts.Add(Product); }
public void Delete(StandardProduct Product) { db.StandardProducts.Remove(Product); }
public static Product SelectProduct(int pid) { Product retProduct = null; SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\werl\Documents\Visual Studio 2013\Projects\SystemsAnalysis\WebApplication2\WebApplication2\App_Data\Database.mdf;Integrated Security=True"); SqlDataReader reader; SqlCommand cmd = new SqlCommand("SELECT * FROM [Products] WHERE ProductID = " + pid, con); try { con.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { retProduct = new StandardProduct(Convert.ToInt32(reader["ProductID"]), (reader["Type"]).ToString(), Convert.ToInt32(reader["SupplierID"])); } reader.Close(); con.Close(); return retProduct; } catch (SqlException sqlEx) { Console.Write(sqlEx.Message); return null; } }
protected void btnDeleteProduct_Click(object sender, EventArgs e) { Product prod = new StandardProduct(Convert.ToInt32(lstProducts.SelectedItem.Value), Convert.ToInt32(txtPrice.Text), txtPrice.Text, Convert.ToInt32(txtSupplier.Text)); Response.Write(prod.DeleteProduct()); }