private void mtUpdate_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Do you want to update?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr.ToString() == "Yes")
{
if (String.IsNullOrEmpty(txtname.Text) || String.IsNullOrEmpty(txtqty.Text) || String.IsNullOrEmpty(txtprice.Text) || String.IsNullOrEmpty(txtstatus.Text) || String.IsNullOrEmpty(txtdes.Text) || comboBox1.Text == "")
{
MessageBox.Show("Check if all the fields are filled", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
String name = txtname.Text;
int price = Convert.ToInt32(txtprice.Text);
int qty = Convert.ToInt32(txtqty.Text);
String status = txtstatus.Text;
String des = txtdes.Text;
int sup = comboBox1.SelectedIndex;
DBItem di = new DBItem();
int line = di.updateItem(no, name, price, qty, status, des, u_id, sup, System.DateTime.Now.ToShortDateString());
if (line == 1)
{
MessageBox.Show("Data entered successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
SqlDataAdapter da;
DBItem i = new DBItem();
da = i.getItem();
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
}
catch (Exception)
{
MessageBox.Show("Error , please try again", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
private void Items_Load(object sender, EventArgs e)
{
try
{
SqlDataAdapter da;
DBItem i = new DBItem();
da = i.getItem();
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
DBSupplier s = new DBSupplier();
SqlDataReader DR;
DR = s.getSupplier();
while (DR.Read())
{
comboBox1.Items.Add(DR[0]);
}
}
catch (Exception)
{
MessageBox.Show("Please fill out all the fields", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}