Пример #1
0
        private void metroButtonNewStockItem_Click(object sender, EventArgs e)
        {
            String itemCode    = StockItemList[metroComboBoxItemType.SelectedIndex];
            String ItemName    = TextBoxItemName.Text;
            String ItemPrice   = TextBoxPrice.Text;
            int    stockout    = (int)numericUpDown1.Value;
            double price       = 0;
            String timeUpdated = DateTime.Now.ToString();

            if (double.TryParse(ItemPrice, out price))
            {
                try {
                    Con.Open();
                    SqlDataAdapter ada = new SqlDataAdapter("SELECT* FROM StockItems", Con);
                    DataTable      dt  = new DataTable();
                    ada.Fill(dt);
                    int counts = dt.Rows.Count;
                    int id     = counts + 1;
                    cmd = new SqlCommand(@"INSERT INTO StockItems
                         ([StockID]
                          ,[ItemCode]
                          ,[ItemName]
                          ,[ItemPrice]
                          ,[StockCount]
                          ,[DateUpdated])
                          VALUES('" + id + "','" + itemCode + "','" + ItemName + "','"
                                         + ItemPrice + "','" + stockout + "','" + timeUpdated + "')", Con);
                    cmd.ExecuteNonQuery();
                    Con.Close();
                    Stock_Managment _emplyForm = new Stock_Managment();
                    _emplyForm.Show();

                    this.Dispose();
                }
                catch (Exception ex) {
                    MessageBox.Show(ex.ToString());
                    Con.Close();
                }
            }
            else
            {
                MessageBox.Show("invalide Price");
            }
        }
Пример #2
0
        private void metroTileStock_Click(object sender, EventArgs e)
        {
            Stock_Managment sm = new Stock_Managment();

            sm.Show();
        }