//DataTable dbtable;
private void button10_Click(object sender, EventArgs e)
{
if ((txtBoxCode.Text == "") || (txtBoxDescription.Text == "") || (txtBoxDiscount.Text == "") || (textBox2.Text == "") || (textBox8.Text == "") || (textBox11.Text == "") || (textBox10.Text == ""))
{
MessageBox.Show("All the fields must be Filled");
}
else
{
int textboxCode = int.Parse(txtBoxCode.Text);
string txtboxDescription = txtBoxDescription.Text;
decimal txtboxDiscount = decimal.Parse(txtBoxDiscount.Text);
decimal lowestPrice = decimal.Parse(textBox2.Text);
decimal price = decimal.Parse(textBox8.Text);
int textBox111 = int.Parse(textBox11.Text);
int textBox100 = int.Parse(textBox10.Text);
ItemDBConnection adminDb = new ItemDBConnection();
adminDb.Insert(textboxCode, txtboxDescription, txtboxDiscount, lowestPrice, price, textBox111, textBox100);
clearItem();
}
}
private void button15_Click(object sender, EventArgs e)
{
if ((txtBoxCode.Text == "") || (txtBoxDescription.Text == "") || (txtBoxDiscount.Text == "") || (textBox2.Text == "") || (textBox8.Text == "") || (txtBoxOther.Text == ""))
{
MessageBox.Show("All the fields must be Filled");
}
else
{
int textboxCode = int.Parse(txtBoxCode.Text);
ItemDBConnection itemdel = new ItemDBConnection();
itemdel.Delete(textboxCode);
clearItem();
}
}
private void button13_Click(object sender, EventArgs e)
{
if ((txtBoxCode.Text == "") || (txtBoxDescription.Text == "") || (txtBoxDiscount.Text == "") || (textBox2.Text == "") || (textBox8.Text == "") || (txtBoxOther.Text == ""))
{
MessageBox.Show("All the fields must be Filled");
}
else
{
int textboxCode = int.Parse(txtBoxCode.Text);
string txtboxDescription = txtBoxDescription.Text;
decimal txtboxDiscount = decimal.Parse(txtBoxDiscount.Text);
decimal lowestPrice = decimal.Parse(textBox2.Text);
decimal price = decimal.Parse(textBox8.Text);
string txtboxOther = txtBoxOther.Text;
ItemDBConnection itemupda = new ItemDBConnection();
itemupda.Update(textboxCode, txtboxDescription, txtboxDiscount, lowestPrice, price, txtboxOther);
clearItem();
}
}
