private void FillListViewClient()
{
lstClient.Columns[0].ListView.Font = new Font(lstClient.Columns[0].ListView.Font, FontStyle.Bold); //Bold
lstClient.Items.Clear();
List <ClientClass> clients = new List <ClientClass>();
clients = ClientDB_Class.GetClients();
foreach (ClientClass client in clients)
{
string[] row =
{
client.firstNameClient,
client.lastNameClient,
client.addressClient,
client.cityClient,
client.countryClient,
client.postalCodeClient,
client.companyClient,
client.phoneClient.ToString(),
client.paymentClient,
client.emailClient,
client.createdClient.ToString("d"),
client.updatedClient.ToString("d"),
client.idClient.ToString()
};
ListViewItem listClient = new ListViewItem(row);
listClient.Font = new Font(listClient.Font, FontStyle.Regular); //Regular
lstClient.Items.Add(listClient);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
lstClient.Columns[0].ListView.Font = new Font(lstClient.Columns[0].ListView.Font, FontStyle.Bold); //Bold
lstClient.Items.Clear();
List <ClientClass> searchClient = new List <ClientClass>();
searchClient = ClientDB_Class.SearchClient(txtSearch.Text);
foreach (ClientClass client in searchClient)
{
string[] row =
{
client.firstNameClient,
client.lastNameClient,
client.addressClient,
client.cityClient,
client.countryClient,
client.postalCodeClient,
client.companyClient,
client.phoneClient.ToString(),
client.paymentClient,
client.emailClient,
client.createdClient.ToString("d"),
client.updatedClient.ToString("d"),
client.idClient.ToString()
};
ListViewItem listClient = new ListViewItem(row);
listClient.Font = new Font(listClient.Font, FontStyle.Regular);
lstClient.Items.Add(listClient);
}
}
private void FillComboBoxProductName()
{
try
{
comboBoxOrderProduct.SelectedIndexChanged -= comboBoxOrderProduct_SelectedIndexChanged;
clients = ClientDB_Class.GetClients();
comboBoxOrderProduct.DataSource = clients;
comboBoxOrderProduct.DisplayMember = "firstNameClient";
comboBoxOrderProduct.ValueMember = "idClient";
comboBoxOrderProduct.SelectedIndexChanged += comboBoxOrderProduct_SelectedIndexChanged;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
private void btnModifyClient_Click(object sender, EventArgs e)
{
ClientClass modifyClient = new ClientClass();
if (lstClient.SelectedItems.Count > 0)
{
ListViewItem item = lstClient.SelectedItems[0];
modifyClient.firstNameClient = item.SubItems[0].Text;
modifyClient.lastNameClient = item.SubItems[1].Text;
modifyClient.addressClient = item.SubItems[2].Text;
modifyClient.cityClient = item.SubItems[3].Text;
modifyClient.countryClient = item.SubItems[4].Text;
modifyClient.postalCodeClient = item.SubItems[5].Text;
modifyClient.companyClient = item.SubItems[6].Text;
modifyClient.phoneClient = item.SubItems[7].Text;
modifyClient.paymentClient = item.SubItems[8].Text;
modifyClient.emailClient = item.SubItems[9].Text;
modifyClient.createdClient = Convert.ToDateTime(item.SubItems[10].Text);
modifyClient.updatedClient = Convert.ToDateTime(item.SubItems[11].Text);
modifyClient.idClient = Convert.ToInt32(item.SubItems[12].Text);
ModifyCient updateClient = new ModifyCient(modifyClient);
var result = updateClient.ShowDialog();
if (result == DialogResult.OK)
{
ClientClass changedUser = updateClient.modified;
bool returnedResult = ClientDB_Class.ModifyClient(changedUser);
if (returnedResult)
{
FillListViewClient();
MessageBox.Show("Client changed");
}
else
{
MessageBox.Show("Error");
}
}
}
else
{
MessageBox.Show("Please select a client ");
}
}
private void btnAddClient_Click(object sender, EventArgs e)
{
AddClient addClientClick = new AddClient();
var result = addClientClick.ShowDialog();
if (result == DialogResult.OK)
{
ClientClass AddClient = addClientClick.added;
bool returnedResult = ClientDB_Class.AddClient(AddClient);
if (returnedResult)
{
FillListViewClient();
MessageBox.Show("Client added");
}
else
{
MessageBox.Show("Error");
}
}
}
