private void LoadCustomers()
{
string query = @"SELECT c.CustomerId AS [Customer ID], c.Name, c.Phone as [Contact No.],
CONVERT(nVARCHAR(19), c.Date, 106) as [Inst. Date], b.BrandName as [Brand Name],
p.ProductName as [Product Name], s.Name AS [Salesman]
FROM Customer AS c LEFT OUTER JOIN
Brand AS b ON c.BrandId = b.BrandId LEFT OUTER JOIN
Product AS p ON c.ProductId = p.ProductId LEFT OUTER JOIN
Salesman AS s ON c.SalesmanId = s.SalesmanId";
switch (cboSearch.Text)
{
case "All":
break;
case "Customer ID":
long CustId;
try
{
CustId = Int64.Parse(txtSearch.Text);
query = query + " WHERE CustomerId = " + CustId.ToString();
}
catch (Exception)
{
MessageBox.Show("Invalid Customer ID, please enter valid Customer ID", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
break;
case "Contact No.":
query = query + " WHERE c.Phone like '%" + txtSearch.Text + "%'";
break;
case "Customer Name":
query = query + " WHERE c.Name like '%" + txtSearch.Text + "%'";
break;
case "Salesman Name":
query = query + " WHERE s.Name like '%" + txtSearch.Text + "%'";
break;
case "Brand":
query = query + " WHERE b.BrandName like '%" + txtSearch.Text + "%'";
break;
case "Product":
query = query + " WHERE p.ProductName like '%" + txtSearch.Text + "%'";
break;
}
//query = "select * from customer";
dtCustomers = dbWrapper.SelectData(query);
gridCustomer.DataSource = dtCustomers;
lblCount.Text = "Count: " + dtCustomers.Rows.Count.ToString();
txtCustomerName.Focus();
btnDelete.Enabled = false;
gridCustomer.Columns.Cast <DataGridViewColumn>().ToList().ForEach(f => f.SortMode = DataGridViewColumnSortMode.NotSortable);
}
private void btGetCustId_Click(object sender, EventArgs e)
{
int custId = 0;
int.TryParse(txtCustId.Text, out custId);
CustomerForm customerList = new CustomerForm();
customerList.isOpenByCustomerSelectUserControl = true;
customerList.CustId = custId;
customerList.ShowDialog();
if (customerList.CustId != 0)
{
CustId = customerList.CustId;
txtCustId.Text = CustId.ToString();
}
}
