private void deleteData(int id)
{
try
{
string DeleteSql = "Delete from stock where itemID = '" + id + "'";
if (local)
{
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
SqlCommand com = new SqlCommand(DeleteSql, sqlcon);
com.ExecuteNonQuery();
SqlDataAdapter ada = new SqlDataAdapter("select * from stock", sqlcon);
DataSet ds = new DataSet();
ada.Fill(ds, "stock");
sqlcon.Close();
}
else
{
MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
MySqlCon.Open();
MySqlCommand com = new MySqlCommand(DeleteSql, MySqlCon);
com.ExecuteNonQuery();
MySqlDataAdapter ada = new MySqlDataAdapter("select * from stock", MySqlCon);
DataSet ds = new DataSet();
ada.Fill(ds, "stock");
MySQLConnection1.CloseConn();
}
MySqlConnection MySqlCon1 = new MySqlConnection(MySQLConnection1.SqlCon);
MySqlCon1.Open();
MySqlCommand com1 = new MySqlCommand("ALTER TABLE stock AUTO_INCREMENT = 1;", MySqlCon1);
com1.ExecuteNonQuery();
MySqlDataAdapter ada1 = new MySqlDataAdapter("select * from stock", MySqlCon1);
DataSet ds1 = new DataSet();
ada1.Fill(ds1, "stock");
MySQLConnection1.CloseConn();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void updateData(int id, string name, int safe, int qty)
{
try
{
string UpdateSql = "update stock" +
" set itemName = '" + name + "'," +
"itemSafeStock = '" + safe + "'," +
"quantity = '" + qty + "'" +
"where itemID = '" + id + "'";
if (local)
{
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
SqlCommand com = new SqlCommand(UpdateSql, sqlcon);
com.ExecuteNonQuery();
SqlDataAdapter ada = new SqlDataAdapter("select * from stock", sqlcon);
DataSet ds = new DataSet();
ada.Fill(ds, "stock");
sqlcon.Close();
}
else
{
MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
MySqlCon.Open();
MySqlCommand com = new MySqlCommand(UpdateSql, MySqlCon);
com.ExecuteNonQuery();
MySqlDataAdapter ada = new MySqlDataAdapter("select * from stock", MySqlCon);
DataSet ds = new DataSet();
ada.Fill(ds, "stock");
MySQLConnection1.CloseConn();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void deleteData()
{
try
{
string DeleteSql = "Delete from staff_info where id = '" + treeView1.SelectedNode.Tag + "'";
if (local)
{
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
SqlCommand com = new SqlCommand(DeleteSql, sqlcon);
com.ExecuteNonQuery();
SqlDataAdapter ada = new SqlDataAdapter("select * from staff_info", sqlcon);
DataSet ds = new DataSet();
ada.Fill(ds, "staff_info");
sqlcon.Close();
}
else
{
MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
MySqlCon.Open();
MySqlCommand com = new MySqlCommand(DeleteSql, MySqlCon);
com.ExecuteNonQuery();
MySqlDataAdapter ada = new MySqlDataAdapter("select * from staff_info", MySqlCon);
DataSet ds = new DataSet();
ada.Fill(ds, "staff_info");
MySQLConnection1.CloseConn();
}
treeView1.Nodes.Clear();
InitTree(this.treeView1.Nodes, "0");
treeView1.ExpandAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void insertData()
{
try
{
if (!IsNumberic(txt_safe.Text))
{
MessageBox.Show("Safe stock must be a number");
return;
}
if (!IsNumberic(txt_qty.Text))
{
MessageBox.Show("Qty must be be a number");
return;
}
if (comboB_type1.Text == "")
{
MessageBox.Show("Must select the type of item");
return;
}
else
{
string InsertSql = "insert into stock(itemName,itemSafeStock,quantity,type) " +
"values ('" + txt_name1.Text + "'" +
",'" + txt_safe.Text + "'" +
",'" + txt_qty.Text + "'" +
",'" + comboB_type1.Text + "')";
if (local)
{
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
SqlCommand com = new SqlCommand(InsertSql, sqlcon);
com.ExecuteNonQuery();
SqlDataAdapter ada = new SqlDataAdapter("select * from stock", sqlcon);
DataSet ds = new DataSet();
ada.Fill(ds, "stock");
sqlcon.Close();
}
else
{
MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
MySqlCon.Open();
MySqlCommand com = new MySqlCommand(InsertSql, MySqlCon);
com.ExecuteNonQuery();
MySqlDataAdapter ada = new MySqlDataAdapter("select * from stock", MySqlCon);
DataSet ds = new DataSet();
ada.Fill(ds, "stock");
MySQLConnection1.CloseConn();
}
MessageBox.Show("successful");
txt_name1.Text = "";
txt_safe.Text = "";
txt_qty.Text = "";
comboB_type1.Text = "";
InitialGrid();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void updateData()
{
int parentID = 0;
if (cmb_position.SelectedIndex == 0)
{
parentID = 1;
}
if (cmb_position.SelectedIndex == 1)
{
parentID = 2;
}
if (cmb_position.SelectedIndex == 2)
{
parentID = 3;
}
if (cmb_position.SelectedIndex == 3)
{
parentID = 4;
}
if (!IsEmail(txt_Email.Text))
{
MessageBox.Show("the email address is invalid");
return;
}
else
{
string UpdateSql = "update staff_info" +
" set last_name = '" + txt_name.Text + "'," +
"address_id = '" + txt_Address.Text + "'," +
"phone = '" + txt_Phone.Text + "'," +
"parent_id = '" + parentID + "'," +
"gender = '" + comBox_gender.Text + "'," +
"birthday = '" + dateTimePicker1.Value.Date.ToString("yyyy-MM-dd HH:mm") + "'," +
"ssn = '" + txt_SSN.Text + "'," +
"email = '" + txt_Email.Text + "' " +
"where id = '" + treeView1.SelectedNode.Tag + "'";
try
{
if (local)
{
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
SqlCommand com = new SqlCommand(UpdateSql, sqlcon);
com.ExecuteNonQuery();
SqlDataAdapter ada = new SqlDataAdapter("select * from staff_info", sqlcon);
DataSet ds = new DataSet();
ada.Fill(ds, "staff_info");
sqlcon.Close();
}
else
{
MySqlConnection MySqlCon = new MySqlConnection(MySQLConnection1.SqlCon);
MySqlCon.Open();
MySqlCommand com = new MySqlCommand(UpdateSql, MySqlCon);
com.ExecuteNonQuery();
MySqlDataAdapter ada = new MySqlDataAdapter("select * from staff_info", MySqlCon);
DataSet ds = new DataSet();
ada.Fill(ds, "staff_info");
MySQLConnection1.CloseConn();
}
MessageBox.Show("successful");
treeView1.Nodes.Clear();
InitTree(this.treeView1.Nodes, "0");
treeView1.ExpandAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
toolStripButton1.Text = "Add";
toolStripButton1.Image = imageList1.Images[2];
toolStripButton1.Enabled = true;
initial();
}
}