internal static ObservableCollection<CustomerSmartDataEntity> GetAllCustomers()
{
ObservableCollection<CustomerSmartDataEntity> customerList = new ObservableCollection<CustomerSmartDataEntity>();
DataSet result = null;
try
{
result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetAllCustomers, null);
if (result == null || result.Tables == null || result.Tables.Count == 0)
return customerList;
CustomerSmartDataEntity newCustomer = null;
for (int rowIndex = 0; rowIndex < result.Tables[0].Rows.Count; rowIndex++)
{
newCustomer = new CustomerSmartDataEntity();
newCustomer.ID = result.Tables[0].Rows[rowIndex][ColumnNames.ID].ToString();
newCustomer.FirstName = result.Tables[0].Rows[rowIndex][ColumnNames.FirstName].ToString();
newCustomer.LastName = result.Tables[0].Rows[rowIndex][ColumnNames.LastName].ToString();
newCustomer.Address = result.Tables[0].Rows[rowIndex][ColumnNames.Address].ToString();
newCustomer.Phone = result.Tables[0].Rows[rowIndex][ColumnNames.Phone].ToString();
newCustomer.Fax = result.Tables[0].Rows[rowIndex][ColumnNames.Fax].ToString();
newCustomer.Email = result.Tables[0].Rows[rowIndex][ColumnNames.Email].ToString();
newCustomer.Misc = result.Tables[0].Rows[rowIndex][ColumnNames.Misc].ToString();
newCustomer.Image = @"F:\Balram Data\Important\GitRepositories\GlassProductManager\GlassProductManager\Logo.jpg";
customerList.Add(newCustomer);
}
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return customerList;
}
private bool IsSearchCriteriaMatched(CustomerSmartDataEntity currentRow)
{
return currentRow.FirstName.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.LastName.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.Address.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.Phone.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.Fax.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.QuoteNumber.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.SONumber.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.WorksheetNumber.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.InvoiceNumber.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.PONumber.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.Email.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower()) ||
currentRow.Misc.ToString()
.ToLower()
.Contains(txtSearch.Text
.ToLower());
}
internal static ObservableCollection<CustomerSmartDataEntity> GetAllCustomerDetails()
{
ObservableCollection<CustomerSmartDataEntity> customerList = new ObservableCollection<CustomerSmartDataEntity>();
DataSet result = null;
try
{
result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetAllCustomerDetails, null);
if (result == null || result.Tables == null || result.Tables.Count == 0)
return customerList;
CustomerSmartDataEntity newCustomer = null;
for (int rowIndex = 0; rowIndex < result.Tables[0].Rows.Count; rowIndex++)
{
newCustomer = new CustomerSmartDataEntity();
newCustomer.ID = result.Tables[0].Rows[rowIndex][ColumnNames.ID].ToString();
newCustomer.FirstName = result.Tables[0].Rows[rowIndex][ColumnNames.FirstName].ToString();
newCustomer.LastName = result.Tables[0].Rows[rowIndex][ColumnNames.LastName].ToString();
newCustomer.Address = result.Tables[0].Rows[rowIndex][ColumnNames.Address].ToString();
newCustomer.Phone = result.Tables[0].Rows[rowIndex][ColumnNames.Phone].ToString();
newCustomer.Fax = result.Tables[0].Rows[rowIndex][ColumnNames.Fax].ToString();
newCustomer.Email = result.Tables[0].Rows[rowIndex][ColumnNames.Email].ToString();
newCustomer.Misc = result.Tables[0].Rows[rowIndex][ColumnNames.Misc].ToString();
newCustomer.SONumber = result.Tables[0].Rows[rowIndex][ColumnNames.SONumber].ToString();
newCustomer.WorksheetNumber = result.Tables[0].Rows[rowIndex][ColumnNames.WorksheetNumber].ToString();
newCustomer.PONumber = result.Tables[0].Rows[rowIndex][ColumnNames.PONumber].ToString();
newCustomer.InvoiceNumber = result.Tables[0].Rows[rowIndex][ColumnNames.InvoiceNumber].ToString();
newCustomer.FullName = newCustomer.LastName + ", " + newCustomer.FirstName;
newCustomer.QuoteNumber = result.Tables[0].Rows[rowIndex][ColumnNames.QuoteNumber].ToString();
customerList.Add(newCustomer);
}
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return customerList;
}
