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();
}
}
}
private void List()
{
using (MySqlConnection Connection = new MySqlConnection(MyConString))
{
try
{
Connection.Open();
MySqlCommand cmd = new MySqlCommand(qry, Connection);
MySqlDataReader reader;
reader = cmd.ExecuteReader();
int Count = 0;
if (reader.HasRows)
{
while (reader.Read())
{
ClientInfo Client = new ClientInfo
{
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
Street = reader["Street"].ToString(),
City = reader["City"].ToString(),
Province = reader["Province"].ToString(),
Zip = reader["Zip"].ToString(),
E_Mail = reader["E_Mail"].ToString(),
Books_purchased = int.Parse(reader["Books_purchased"].ToString()),
Books_hired = int.Parse(reader["Books_hired"].ToString()),
};
Clients[Count] = Client;
Count++;
}
}
else
{
MessageBox.Show("No Clients where found", "Clients", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Connection.Close();
}
}
}
public ClientHandler(out ClientInfo[] clientInfo)
{
ListWithOutFilter();
clientInfo = Clients;
}
public ClientHandler(out ClientInfo[] clientInfo, string Column, string Value)
{
ListWithFilter(Column, Value);
clientInfo = Clients;
}
private bool SaveOrUpdateOrDeleteSQL(SaveOrUpdateOrDelete saveOrUpdateDelete)
{
bool success;
ClientInfo Client = new ClientInfo
{
FirstName = edtFirstName.Text,
LastName = edtLastName.Text,
Street = edtStreet.Text,
City = edtCity.Text,
Province = edtProvince.Text,
Zip = edtZip.Text,
E_Mail = edtEMail.Text,
Books_purchased = int.Parse(edtPurchased.Text),
Books_hired = int.Parse(edtHired.Text),
};
new ClientHandler(Client, saveOrUpdateDelete, out success);
return success;
}