//////////////////////////////////////////////////////events for components///////////////////////////////////////////////////////////////////
private void treeViewAdminNav_AfterSelect(object sender, TreeViewEventArgs e)
{
TreeNode treeNode = treeViewAdminNav.SelectedNode;
if (treeNode.Name.Equals("nodeProduct") && !(this.Name.Equals("ProductViewForm")))
{
ProductViewForm viewProductPage = new ProductViewForm();
this.Hide();
viewProductPage.ShowDialog();
this.Close(); //close previous form
}
else if (treeNode.Name.Equals("nodeUser") && !(this.Name.Equals("UserViewForm")))
{
UserViewForm viewUserPage = new UserViewForm();
this.Hide();
viewUserPage.ShowDialog();
this.Close(); //close previous form
}
else if (treeNode.Name.Equals("nodeStock") && !(this.Name.Equals("StockViewForm")))
{
StockViewForm viewStockPage = new StockViewForm();
this.Hide();
viewStockPage.ShowDialog();
this.Close(); //close previous form
}
}
private void lblStockTable_Click(object sender, EventArgs e)
{
StockViewForm stockViewPage = new StockViewForm();
this.Hide();
stockViewPage.ShowDialog();
this.Close();
}
private void btnAdd_Click(object sender, EventArgs e)
{
String stockName = txtStockName.Text;
decimal stockQty = numUpDownStockQty.Value;
decimal stockPrice = 0;
decimal value = 0;
if (decimal.TryParse(txtStockCost.Text, out value))
{
txtStockCost.Text = String.Format("{0:0.00}", value);
//setting paid amount
stockPrice = value;
}
String supplierLink = txtSupplierLink.Text;
DateTime dateTime = DateTime.Now;
if ((!stockName.Equals("")) && (stockQty > 0) && (stockPrice > 0) && (!supplierLink.Equals("")))
{
db.Sqlite_cmd = db.SqlConn.CreateCommand();//ask database what to query
db.Sqlite_cmd.CommandText = "INSERT INTO stock (stock_name,stock_quantity,stock_cost,supplier_link,last_restock_date) " +
"VALUES('" + stockName + "', " + stockQty + ", " + stockPrice + ",'" + supplierLink + "','" + dateTime.ToString("yyyy-MM-dd HH:mm:ss") + "')";
db.Sqlite_datareader = db.Sqlite_cmd.ExecuteReader();//reads the database
db.Sqlite_cmd.Dispose();
db.CloseDBConnection();
StockViewForm stockViewPage = new StockViewForm();
this.Hide();
stockViewPage.ShowDialog();
this.Close(); //close previous form
}
else
{
MessageBox.Show("Please Do Not Leave Any Empty Box");
}
}