//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(); } }