public void deleteSalesPerson(SalesPerson sp)
{
string query = "DELETE FROM salesperson WHERE sid='" + sp.getSId() + "'";
if (this.connect())
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
query = "DELETE FROM employees WHERE sid='" + sp.getSId() + "'";
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
this.stopConnection();
}
public void updateSalesPerson(SalesPerson sp)
{
string query = "UPDATE salesperson SET name='" + sp.getName() + "',commission='" + sp.getCommission() + "',address='" + sp.getAddress() + "' WHERE sid='" + sp.getSId() + "'";
if (this.connect())
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
query = "UPDATE employees SET id='" + sp.getEmpId() + "',sid='" + sp.getSId() + "',password='******' WHERE sid='" + sp.getSId() + "'";
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
this.stopConnection();
}
public void addSalesPerson(SalesPerson sp)
{
if (this.connect())
{
string query = "INSERT INTO salesperson (name,commission,address) VALUES ('" + sp.getName() + "','" + sp.getCommission() + "','" + sp.getAddress() + "')";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
query = "SELECT sid FROM salesperson WHERE name = " + sp.getName() + ";";
cmd = new MySqlCommand(query, connection);
MySqlDataReader reader = cmd.ExecuteReader();
sp.setSId(reader.GetInt32(0));
query = "INSERT INTO employees (id,password,sid) VALUES ('" + sp.getEmpId() + "','" + sp.getPassword() + "','" + sp.getSId() + "')";
cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
reader.Close();
}
this.stopConnection();
}
