public IActionResult OnPost()
{
NewProduct.Description = ProductDescription;
NewProduct.Id = OldProduct.Id;
int click = Int32.Parse(Request.Form["click"]);
if (click == 1)
{
ProductsDB.UpdateProduct(NewProduct, _configuration);
string currentShoppingCart = Request.Cookies["ShoppingCart"];
if (currentShoppingCart != null && currentShoppingCart != "")
{
string newShoppingCart = ProductsCookies.UpdateProduct(currentShoppingCart, NewProduct);
var cookieOptions = new CookieOptions {
Expires = DateTime.Now.AddDays(1)
};
Response.Cookies.Append("ShoppingCart", newShoppingCart, cookieOptions);
}
return(RedirectToPage("/Index"));
}
else
{
return(RedirectToPage("/Index"));
}
}
/// <summary>
/// Add button adds new products to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// @Author - Rohit
private void btnAddProducts_Click(object sender, EventArgs e)
{
products = ProductsDB.GetAllProducts();
if (products.FindIndex(prod => prod.ProductName == txtProductName.Text) >= 0)
{
MessageBox.Show("That product is already added.");
}
else
{
try
{
ComProductId.Enabled = false; // disables the product id textbox (not required while adding products)
string ProdName = txtProductName.Text;
if (ProdName == "") // null value validation on product name
{
MessageBox.Show("Null and Dublicate values are not allowed.", "Error"); // message box pop uo
}
else // if product name is not null add the new product using Add product method
{
ProductsDB.AddProducts(ProdName);
ShowProductsInProductsTab(); // Updates data grid view
LoadComboBox(); // updates combo box to view the added product immediately
MessageBox.Show("New product succesfully added.", "Add Product"); // message box pop up
clear(); // clears the fields after adding new product
}
ComProductId.Enabled = true; // After the product is added, enable the product id textbox
}
catch (FormatException) // catches any format issues and null value exceptions
{
MessageBox.Show("Null values are not allowed, Type correct information.", "Null Value / Incorrect Format");
}
}
}
/// <summary>
/// Modify the current selected product in the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// @Author - Rohit
private void btnModifyProducts_Click(object sender, EventArgs e)
{
products = ProductsDB.GetAllProducts();
if (products.FindIndex(prod => prod.ProductName == txtProductName.Text) >= 0)
{
MessageBox.Show("That product is already added.");
}
else
{
try
{
int ProdID = Convert.ToInt32(ComProductId.SelectedItem);
string ProdName = txtProductName.Text;
if (string.IsNullOrEmpty(ProdName) || ComProductId.SelectedItem == null) // validation for null product name
{
MessageBox.Show("Please enter product name and select product ID.", "Incorrect Value");
}
else // if the product name is not null then use the modify method form database access class to modify the product
{
ProductsDB.ModifyProducts(ProdName, ProdID);
MessageBox.Show("Product name updated successfully", "Update"); // message pop up
clear(); // clears the fields after modifying
ShowProductsInProductsTab(); // updates the datagridview after modifying the products
}
}
catch (FormatException) // catches any format issues and null value exceptions
{
MessageBox.Show("Null values are not allowed", "Null Value Exception"); // message pop up
}
}
}
// Tab Two Changed (by using ALL, EDIT, ADD btn): change UI appearance accordingly
private void twoTab_SelectedIndexChanged(object sender, EventArgs e)
{
twoBtnViewAll.BackColor = Color.DarkCyan;;
twoBtnEdit.BackColor = Color.DarkCyan;
twoBtnAdd.BackColor = Color.DarkCyan;
twoBtnSave.Visible = true;
if (twoTab.SelectedIndex == 0)
{
twoBtnSave.Visible = false;
// 'ALL' tab, load all Product Supplier data and fill DataSource
_psList = Products_suppliersDB.GetAllProductSupplierWithNames().OrderBy(ps => ps.ProdName).ToList();
// use List to make a SortableBindingList
var _sortableList = new SortableBindingList <ProductSupplierWithName>(_psList);
productSupplierWithNameBindingSource.DataSource = _sortableList;
// databinding for combo boxes
suppliersBindingSource.DataSource = SuppliersDB.GetSuppliers().OrderBy(s => s.SupName);
productsBindingSource.DataSource = ProductsDB.GetProducts();
}
else if (twoTab.SelectedIndex == 2)
{
// 'ADD' tab
// select nothing when load
twoCmbAddProdName.SelectedIndex = -1;
twoCmbAddSuppName.SelectedIndex = -1;
}
// 'EDIT' tab
}
private void loadList()
{
if (comboBoxSupplier.SelectedValue != null)
{
int supID = Convert.ToInt32(comboBoxSupplier.SelectedValue);
selectedSupplierID = supID;
try
{
// run the slq query method (included in ProductSupplier table)
list = ProductsDB.GetProducts(supID);
// run the toher sql query method (the not in)
notInList = ProductsDB.GetProdNotInList(supID);
// Display info
lstProducts.DataSource = list;
lstProducts.DisplayMember = "ProdName";
lstProducts.ValueMember = "ProductId";
listProducts.DataSource = notInList;
listProducts.DisplayMember = "ProdName";
listProducts.ValueMember = "ProductId";
}
catch (SqlException ex)
{
throw ex;
}
}
}
//delete product button
private void btnProdDelete_Click(object sender, EventArgs e)
{
string res = ProductsDB.DeleteProduct((int)LBProducts.SelectedValue);
if (res != null)
{
if (res == "SUCCESS")
{
KeyValuePair <string, int> vv = new KeyValuePair <string, int>("", -99);
foreach (KeyValuePair <string, int> v in ProductsDB.Products)
{
if (v.Value == (int)LBProducts.SelectedValue)
{
vv = v;
}
}
if (vv.Value != -99)
{
ProductsDB.Products.Remove(vv);
}
MessageBox.Show("Delete successful.", "Success");
}
else
{
MessageBox.Show("Did not delete: " + res, "Error");
}
}
}
/// <summary>
/// Update All List of Infos
/// </summary>
private void UpdateAllInfos()
{
AllPackages = PackagesDB.GetPackages();
AllProducts = ProductsDB.GetProducts();
AllSuppliers = SuppliersDB.GetSuppliers();
ProSupLinkages = ProSupDB.GetProSups();
PacProSupLinkages = PacProSupDB.GetPacProSup();
}
public void ProductsDbGetProductsReturnsListProductAndInt()
{
//Assign
var productsDb = new ProductsDB();
//Act + Assert
Assert.IsTrue(productsDb.GetProducts() is List <(Product, int)>);
}
public ActionResult DeleteConfirmed(int id)
{
ProductsDB productsDB = db.Products.Find(id);
db.Products.Remove(productsDB);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void ProductsDbAddProductReturnsTrue()
{
//Assign
var productsDb = new ProductsDB();
var product = new Product();
//Act + Assert
Assert.IsTrue(productsDb.AddProduct(product));
}
public void ProductsDbGetProductReturnsProductAndInt()
{
//Assign
var productsDb = new ProductsDB();
var product = new Product();
productsDb.AddProduct(product);
//Act + Assert
Assert.AreEqual(productsDb.GetProduct(product.Name).Item1, product);
}
public void ProductsDbChangeProductInfoReturnsTrue()
{
//Assign
var productsDb = new ProductsDB();
var product = new Product();
productsDb.AddProduct(product);
//Act + Assert
Assert.IsTrue(productsDb.ChangeProductInfo(product.Id, new Product(), 0));
}
public ActionResult Edit([Bind(Include = "id,price,model_name,product_name,size,counting_unit")] ProductsDB productsDB)
{
if (ModelState.IsValid)
{
db.Entry(productsDB).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(productsDB));
}
public ActionResult Create([Bind(Include = "id,price,model_name,product_name,size,counting_unit")] ProductsDB productsDB)
{
if (ModelState.IsValid)
{
db.Products.Add(productsDB);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(productsDB));
}
public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
return(Page());
}
else
{
ProductsDB.AddProduct(NewProduct, _configuration);
return(RedirectToPage("/Index"));
}
}
// Convenient Method: find if there is a duplicated product name in DB, return bool
private bool FindDuplicatedProductName(string productName)
{
if (ProductsDB.GetProducts().Find(p => p.ProdName == productName) == null)
{
return(false);
}
else
{
MessageBox.Show("The product you input already exists.", "Duplicated Name");
return(true);
}
}
//Method for OK button to add new product to list and database
private void btnOK_Click(object sender, EventArgs e)
{
string name = txtProdName.Text.ToString(); //get text from textbox
int i = ProductsDB.AddNewProduct(name.ToUpper()); //change input to uppercase
KeyValuePair <string, int> val = new KeyValuePair <string, int>(name, i); //create key value pair for databse
ProductsDB.Products.Add(val); //add new value pair to database
MessageBox.Show("Created new product.", "Success"); //popup confirmation
this.Close();
}
/// <summary>
/// Once the products tab is selected, populate the combo box and datagrid view
/// </summary>
/// @Author - Rohit
private void LoadComboBox()
{
ComProductId.Items.Clear(); // clear the grid view
List <Products> dispProducts = ProductsDB.GetAllProducts(); // get products from database
ViewProducts.DataSource = dispProducts; // display them
// loop through products and add ids to drop down
foreach (Products prod in dispProducts)
{
ComProductId.Items.Add(prod.ProductID.ToString());
}
}
// GET: Products/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProductsDB productsDB = db.Products.Find(id);
if (productsDB == null)
{
return(HttpNotFound());
}
return(View(productsDB));
}
// ----- 3RD NAV BTN: Products -----
// Tab Three Changed (by using ALL, EDIT, ADD btn): change UI appearance accordingly
private void threeTab_SelectedIndexChanged(object sender, EventArgs e)
{
threeBtnSave.Visible = true;
threeBtnAll.BackColor = Color.DarkCyan;
threeBtnEdit.BackColor = Color.DarkCyan;
threeBtnAdd.BackColor = Color.DarkCyan;
if (threeTab.SelectedIndex == 0)
{
// view ALL mode: hide save button
threeBtnSave.Visible = false;
// bind data to grid view
var productsList = ProductsDB.GetProducts();
var _sortableProducts = new SortableBindingList <Products>(productsList);
productsBindingSource.DataSource = _sortableProducts;
}
}
public IActionResult OnPost()
{
int click = Int32.Parse(Request.Form["click"]);
if (click == 1)
{
Product = ProductsDB.GetProduct(Product.Id, _configuration);
string currentShoppingCart = Request.Cookies["ShoppingCart"];
string newShoppingCart = ShoppingCartCookie.AddProduct(Product, currentShoppingCart);
var cookieOptions = new CookieOptions {
Expires = DateTime.Now.AddDays(1)
};
Response.Cookies.Append("ShoppingCart", newShoppingCart, cookieOptions);
}
return(RedirectToPage("/Index"));
}
protected override void SetUp()
{
mProps = new ProductsProps();
mOldProps = new ProductsProps();
if (this.mConnectionString == "")
{
mdbReadable = new ProductsDB();
mdbWriteable = new ProductsDB();
}
else
{
mdbReadable = new ProductsDB(this.mConnectionString);
mdbWriteable = new ProductsDB(this.mConnectionString);
}
}
/// <summary>
/// Once product id is selected form drop down, product name is retrieved from the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// @Author - Rohit
private void ComProductId_SelectedValueChanged(object sender, EventArgs e)
{
try
{
int ProductID = Convert.ToInt32(ComProductId.SelectedItem);
Products myProduct = ProductsDB.GetProducts(ProductID);
txtProductName.Text = myProduct.ProductName;
}
catch (FormatException) // format exception to only accept an positive integer
{
MessageBox.Show("Select or type valid Product ID", "Incorrect Input");
}
catch (NullReferenceException) // exception handled for null values
{
MessageBox.Show("Product Id does not exist.", "Incorrect Input");
}
}
// Load data for main form (first tab - Packages).
private void loadMainFormData()
{
try
{
// access packages from db in thread (ASYNCHRONOUS) - Probably uneccessary
/*Thread pkgWork = new Thread(() =>
* Thread pkgWork = new Thread(() =>
* {
* packages = PackageDB.GetPackages();
* });
*
* // access all products from db in thread
* Thread prodWork = new Thread(() =>
* {
* products = ProductsDB.GetAllProducts();
* });
*
* pkgWork.Start();
* prodWork.Start();
*
* pkgWork.Join();
* prodWork.Join();*/
packages = PackageDB.GetPackages();
products = ProductsDB.GetAllProducts();
// access products and suppliers associated with current package
PackageDB.GetPackageProducts(packages[pkgPos].PackageId, out pkgProducts, out pkgProdSupps);
ShowPackages();
ShowAllProducts();
ShowPkgProducts(pkgProducts, pkgProdSupps);
}
catch (Exception ex)
{
MessageBox.Show("Error while loading data.\n\n" + ex.Message,
ex.GetType().ToString());
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
if (Validator.IsPresentCombo(productIdComboBox, "ID") && Validator.IsPresent(prodNameTextBox, "New Product Name") && Validator.IsCorrectLength(prodNameTextBox, "Name", 20) && Validator.IsNameValid(prodNameTextBox, "Name"))
{
Products findOldProduct = FindOldProduct(productIdComboBox);
if (findOldProduct != null)
{
Products newProduct = productUpdate(prodNameTextBox, CreateObject(findOldProduct));
bool Success = ProductsDB.UpdateProduct(findOldProduct, newProduct);
if (Success)
{
MessageBox.Show("Product is updated :)");
}
UpdateAllInfos();
productsDataGridView.DataSource = AllProducts;
}
else
{
MessageBox.Show("Cant find Product ID");
}
}
else
{
MessageBox.Show("Please re-enter. ");
}
}
//catch the other error and show the ex error message from db class
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
private void btnProAdd_Click(object sender, EventArgs e)
{
try
{
if (Validator.IsPresent(txtNewProductName, "New Product Name") && Validator.IsCorrectLength(txtNewProductName, "Name", 20) && Validator.IsNameValid(txtNewProductName, "Name"))
{
Products newProduct = productUpdate1(txtNewProductName);
newProduct.ProductId = ProductsDB.AddProduct(newProduct);
MessageBox.Show("Product is updated :)");
UpdateAllInfos();
productsDataGridView.DataSource = AllProducts;
}
}
//catch the other error and show the ex error message from db class
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
public bool Consume(string username, string product, int quantity)
{
IProductsDB productsDB = new ProductsDB();
IProductsManager productsManager = new ProductsManager(productsDB);
decimal price = productsManager.GetProductPrice(product) * quantity;
Account account = GetAccountByUsername(username);
if (account.Amount - price < 0)
{
return(false);
}
account.Amount -= price;
var nbRowsAffected = AccountDb.UpdateAccount(account);
if (nbRowsAffected == 0)
{
return(false);
}
return(true);
}
public void OnGet(int id)
{
Product = ProductsDB.GetProduct(id, _configuration);
}
public HttpResponseMessage Delete(int id)
{
ProductsDB.TblProducts.Remove(ProductsDB.TblProducts.FirstOrDefault(x => x.ProductId == id));
return(ToJson(ProductsDB.SaveChanges()));
}
public HttpResponseMessage Put(int id, [FromBody] TblProduct value)
{
ProductsDB.Entry(value).State = EntityState.Modified;
return(ToJson(ProductsDB.SaveChanges()));
}
