internal static ObservableCollection<QuoteMasterEntity> GetQuoteMasterData() { ObservableCollection<QuoteMasterEntity> quoteMasterData = null; try { var result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetQuoteMasterData, null); if (result == null || result.Tables == null || result.Tables.Count == 0) { return quoteMasterData; } quoteMasterData = new ObservableCollection<QuoteMasterEntity>(); QuoteMasterEntity temp = null; for (int rowIndex = 0; rowIndex < result.Tables[0].Rows.Count; rowIndex++) { temp = new QuoteMasterEntity(); temp.QuoteStatus = result.Tables[0].Rows[rowIndex][ColumnNames.Status] == DBNull.Value ? string.Empty : result.Tables[0].Rows[rowIndex][ColumnNames.Status].ToString(); temp.QuoteNumber = result.Tables[0].Rows[rowIndex][ColumnNames.QuoteNumber] == DBNull.Value ? string.Empty : result.Tables[0].Rows[rowIndex][ColumnNames.QuoteNumber].ToString(); temp.FullName = result.Tables[0].Rows[rowIndex][ColumnNames.FullName] == DBNull.Value ? string.Empty : result.Tables[0].Rows[rowIndex][ColumnNames.FullName].ToString(); temp.CreatedOn = result.Tables[0].Rows[rowIndex][ColumnNames.CreatedOn] == DBNull.Value ? string.Empty : result.Tables[0].Rows[rowIndex][ColumnNames.CreatedOn].ToString(); temp.Total = result.Tables[0].Rows[rowIndex][ColumnNames.Total] == DBNull.Value ? string.Empty : double.Parse(result.Tables[0].Rows[rowIndex][ColumnNames.Total].ToString()).ToString("0.00"); temp.EstimatedShipDate = result.Tables[0].Rows[rowIndex][ColumnNames.EstimatedShipDate] == DBNull.Value ? string.Empty : result.Tables[0].Rows[rowIndex][ColumnNames.EstimatedShipDate].ToString(); temp.PaymentType = result.Tables[0].Rows[rowIndex][ColumnNames.PaymentType] == DBNull.Value ? string.Empty : result.Tables[0].Rows[rowIndex][ColumnNames.PaymentType].ToString(); temp.CustomerPONumber = result.Tables[0].Rows[rowIndex][ColumnNames.CustomerPONumber] == DBNull.Value ? string.Empty : result.Tables[0].Rows[rowIndex][ColumnNames.CustomerPONumber].ToString(); quoteMasterData.Add(temp); } } catch (Exception ex) { Logger.LogException(ex); } return quoteMasterData; }
private bool IsSearchCriteriaMatched(QuoteMasterEntity currentRow) { return currentRow.QuoteStatus.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.QuoteNumber.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.FullName.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.CreatedOn.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.Total.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.EstimatedShipDate.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.PaymentType.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.CustomerPONumber.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()); }