private void btnClients_Click(object sender, EventArgs e)
{
frmViewClients frm = new frmViewClients();
this.Hide();
frm.ListClientsOrFilter(false);
if (frm.ShowDialog(this) == DialogResult.OK)
{
this.Show();
}
}
public ClientHandler(ClientInfo client, frmViewClients.SaveOrUpdateOrDelete saveOrUpdateDelete, out bool success)
{
if (saveOrUpdateDelete == frmViewClients.SaveOrUpdateOrDelete.Save)
{
qry = "INSERT INTO clients (FirstName,LastName,Street,City,Province,Zip,E_Mail,Books_purchased,Books_hired) " +
"VALUES (@FirstName,@LastName,@Street,@City,@Province,@Zip,@E_Mail,@Books_purchased,@Books_hired)";
}
else if (saveOrUpdateDelete == frmViewClients.SaveOrUpdateOrDelete.Update)
{
qry = "UPDATE clients SET FirstName = @FirstName,LastName = @LastName,Street = @Street,City = @City,Province = @Province," +
"Zip = @Zip,E_Mail = @E_Mail,Books_purchased = @Books_purchased,Books_hired = Books_hired WHERE FirstName = @FirstName";
}
else
{
qry = "DELETE FROM clients WHERE FirstName = @FirstName";
}
using (MySqlConnection Connection = new MySqlConnection(MyConString))
{
success = false;
try
{
MySqlCommand cmd = new MySqlCommand(qry, Connection);
cmd.Parameters.Add(new MySqlParameter("@FirstName", (object)client.FirstName));
cmd.Parameters.Add(new MySqlParameter("@LastName", (object)client.LastName));
cmd.Parameters.Add(new MySqlParameter("@Street", (object)client.Street));
cmd.Parameters.Add(new MySqlParameter("@City", (object)client.City));
cmd.Parameters.Add(new MySqlParameter("@Province", (object)client.Province));
cmd.Parameters.Add(new MySqlParameter("@Zip", (object)client.Zip));
cmd.Parameters.Add(new MySqlParameter("@E_Mail", (object)client.E_Mail));
cmd.Parameters.Add(new MySqlParameter("@Books_purchased", (object)client.Books_purchased));
cmd.Parameters.Add(new MySqlParameter("@Books_hired", (object)client.Books_hired));
Connection.Open();
cmd.ExecuteNonQuery();
success = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Connection.Close();
}
}
}