private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text != "")
{
dbconnection.Open();
String query = "update sparepart set SparePart_Name=@Name,SparePart_Info=@info where SparePart_ID='" + row1.Cells[0].Value + "'";
MySqlCommand com = new MySqlCommand(query, dbconnection);
com.Parameters.Add("@Name", MySqlDbType.VarChar, 255).Value = txtName.Text;
com.Parameters.Add("@info", MySqlDbType.VarChar, 255).Value = txtInfo.Text;
com.ExecuteNonQuery();
sparePart.DisplaySparePart(dbconnection);
MessageBox.Show("udpate success");
txtName.Focus();
}
else
{
MessageBox.Show("enter name");
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
dbconnection.Close();
}
dbconnection.Close();
}
private void btnAddSparePart_Click(object sender, EventArgs e)
{
try
{
dbconnection.Open();
string query = "select SparePart_ID from sparepart where SparePart_Name='" + txtName.Text + "'";
MySqlCommand com = new MySqlCommand(query, dbconnection);
if (com.ExecuteScalar() == null)
{
if (txtName.Text != "")
{
string qeury = "insert into sparepart (SparePart_Name,SparePart_Info)values(@Name,@info)";
com = new MySqlCommand(qeury, dbconnection);
com.Parameters.Add("@Name", MySqlDbType.VarChar, 255);
com.Parameters["@Name"].Value = txtName.Text;
com.Parameters.Add("@info", MySqlDbType.VarChar, 255);
com.Parameters["@info"].Value = txtInfo.Text;
com.ExecuteNonQuery();
sparePart.DisplaySparePart(dbconnection);
MessageBox.Show("add success");
clear();
txtName.Focus();
}
else
{
MessageBox.Show("enter Name");
}
}
else
{
MessageBox.Show("This Store already exist");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
dbconnection.Close();
}