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; }