private void cancel_button_Click(object sender, EventArgs e)
{
Profile_Supplier g = new Profile_Supplier();
g.Show();
this.Hide();
}
private void Supplier_Link_Click(object sender, EventArgs e)
{
Profile_Supplier g = new Profile_Supplier();
g.Show();
this.Hide();
}
private void add_button_Click(object sender, EventArgs e)
{
//add function
if (item_name_text.Text == "" || item_type_text.Text == "" || item_purchaseprice_text.Text == "" || item_sellingprice_text.Text == "" || item_supplier_text.Text == "")
{
MessageBox.Show("Please input required field.");
}
else if (item_type_text.Items.Contains(item_type_text.Text) == false)
{
MessageBox.Show("Please select an item type from list");
item_type_text.Text = String.Empty;
}
else if (measure_text.Items.Contains(measure_text.Text) == false)
{
MessageBox.Show("Please select a measurement from list");
measure_text.Text = String.Empty;
}
else
{
string y = "select * from item where item_id = '" + item_id.Text + "'";
DataTable dt = new DataTable();
dt = main.SELECT_Statement(y);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Item already exists!", "BOX", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int suppid = Convert.ToInt32(supplier_id.Text);
int typeid = Convert.ToInt32(item_type_id_fk.Text);
string query = "INSERT INTO item(item_name,item_type_id_fk, item_measurement, item_purchase_price,item_selling_price, supplier_id_item_fk, item_brand, item_size)" +
"VALUES('" + item_name_text.Text + "','" + typeid + "','" + measure_text.Text + "','" + item_purchaseprice_text.Text + "','" + item_sellingprice_text.Text + "','" + suppid + "','" + brand_text.Text + "','" + item_size.Text + "');";
main.CUD_Statement(query);
MessageBox.Show("Item Added!", "BOX", MessageBoxButtons.OK, MessageBoxIcon.Information);
Profile_Supplier g = new Profile_Supplier();
g.Show();
this.Hide();
}
}
}