private void button_UpdateCustomer_Click(object sender, EventArgs e)
{
ClsBLL clsBllObj = new ClsBLL();
Customer customerObj = new Customer();
customerObj.CustomerID1 = textBox_CustomerID.Text.Trim();
customerObj.CompanyName1 = textBox_CompanyName.Text.Trim();
customerObj.ContactName1 = textBox_ContactName.Text.Trim();
customerObj.ContactTitle1 = textBox_ContactTitle.Text.Trim();
customerObj.Address1 = textBox_Address.Text.Trim();
customerObj.City1 = textBox_City.Text.Trim();
customerObj.Country1 = textBox_Country.Text.Trim();
customerObj.Fax1 = textBox_Fax.Text.Trim();
customerObj.Phone1 = textBox_Phone.Text.Trim();
customerObj.PostalCode1 = textBox_PostalCode.Text.Trim();
customerObj.Region1 = textBox_Region.Text.Trim();
try
{
int rowsAffected = clsBllObj.UpdateCustomer(customerObj);
if (rowsAffected == 1)
{
MessageBox.Show("Customer details updated successfully");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button_ViewAllCustomers_Click(object sender, EventArgs e)
{
ClsBLL ClsBllObj = new ClsBLL();
dataGrid_CustomerDetails.DataSource = ClsBllObj.ViewAllCustomers();
this.button_Search.Enabled = true;
//label_CustomerID.Visible = true;
//textBox_CustomerID.Visible = true;
//button_Search.Visible = true;
//dataGrid_CustomerDetails.Visible = true;
}
private void button_Login_Click(object sender, EventArgs e)
{
Homepage HomeFormObj = new Homepage();
ClsBLL clSBLLObj = new ClsBLL();
if (clSBLLObj.Login(textBox_Username.Text, textBox_Password.Text))
{
MessageBox.Show("Login Successful");
HomeFormObj.ShowDialog();
this.Hide();
}
else
{
MessageBox.Show("Login Unsuccessful. Either the username or the password is incorrect");
}
}
private void button_DeleteCustomer_Click(object sender, EventArgs e)
{
//Get CustomerID value from the selected row of DataGridView
string customerID = dataGrid_CustomerDetails.SelectedRows[0].Cells[0].Value.ToString().Trim();
var resultMessageBox = MessageBox.Show("Are you sure you want to permanently delete the selected Customer?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (resultMessageBox == DialogResult.Yes)
{
// user clicked yes
ClsBLL ClsBllObj = new ClsBLL();
ClsBllObj.DeleteCustomer(customerID);
MessageBox.Show("Customer \"" + customerID + "\" has been deleted successfully.");
dataGrid_CustomerDetails.DataSource = ClsBllObj.ViewAllCustomers();
}
else
{
// user clicked no
}
}
private void button_Search_Click(object sender, EventArgs e)
{
string customerID = textBox_CustomerID.Text;
ClsBLL bLLObj = new ClsBLL();
DataTable dT = new DataTable();
if (customerID != string.Empty)
{
Customer customerObj = bLLObj.SearchCustomer(customerID);
if (customerObj.CustomerID1 == null)
{
MessageBox.Show("Could not find a customer with the CustomerID:\"" + customerID + "\".");
}
else
{
dT.Columns.Add("CustomerID", typeof(string));
dT.Columns.Add("CompanyName", typeof(string));
dT.Columns.Add("ContactName", typeof(string));
dT.Columns.Add("ContactTitle", typeof(string));
dT.Columns.Add("Address", typeof(string));
dT.Columns.Add("City", typeof(string));
dT.Columns.Add("Region", typeof(string));
dT.Columns.Add("PostalCode", typeof(string));
dT.Columns.Add("Country", typeof(string));
dT.Columns.Add("Phone", typeof(string));
dT.Columns.Add("Fax", typeof(string));
dT.Rows.Add(customerObj.CustomerID1, customerObj.CompanyName1, customerObj.ContactName1, customerObj.ContactTitle1, customerObj.Address1, customerObj.City1, customerObj.Region1, customerObj.PostalCode1, customerObj.Country1, customerObj.Phone1, customerObj.Fax1);
dataGrid_CustomerDetails.DataSource = dT;
dataGrid_CustomerDetails.Visible = true;
}
}
else
{
MessageBox.Show("Please enter a Customer ID");
}
}
