private void newInventoryToolStripMenuItem_Click(object sender, EventArgs e)
{
Form NewProduct = new ManageProducts();
NewProduct.MdiParent = this;
NewProduct.Show();
}
private void button6_Click(object sender, EventArgs e)
{
Form ManageProducts = new ManageProducts();
ManageProducts.MdiParent = ParentForm;
ManageProducts.Show();
}
public static void AddNewProduct(int Barcode, string Name)
{
try
{
ConnectDatabase();
using (con)
{
using (SQLiteCommand cmd = new SQLiteCommand(con))
{
SQLiteTransaction transaction = null;
transaction = con.BeginTransaction();
cmd.CommandText = @"INSERT INTO products (product_barcode, product_name)
VALUES (@Barcode, @Name)";
cmd.Prepare();
cmd.Parameters.AddWithValue("Barcode", Barcode);
cmd.Parameters.AddWithValue("Name", Name);
cmd.ExecuteNonQuery();
transaction.Commit();
}
}
ManageProducts.labelChange("Added!", Barcode + " \n " + Name);
}
catch (SQLiteException SQLiteThrow)
{
string stringCutted = SQLiteThrow.Message.Split(' ').Last();
if (SQLiteThrow.ErrorCode == 19)
{
if (Equals(stringCutted, "products.product_name"))
{
MessageBox.Show("This product name already exist!");
}
else if (Equals(stringCutted, "products.product_barcode"))
{
MessageBox.Show("This product barcode already exist!");
}
else
{
MessageBox.Show("AddNewProduct Message19: " + SQLiteThrow.Message + "\n");
}
}
else
{
MessageBox.Show("AddNewProduct Message: " + SQLiteThrow.Message + "\n");
}
}
}
