internal static ObservableCollection<WorksheetEntity> GetWorksheetMasterData() { ObservableCollection<WorksheetEntity> quoteMasterData = null; try { var result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetWorksheetMasterData, null); if (result == null || result.Tables == null || result.Tables.Count == 0) { return quoteMasterData; } quoteMasterData = new ObservableCollection<WorksheetEntity>(); WorksheetEntity temp = null; object dbValue = null; for (int rowIndex = 0; rowIndex < result.Tables[0].Rows.Count; rowIndex++) { temp = new WorksheetEntity(); dbValue = result.Tables[0].Rows[rowIndex][ColumnNames.WSNumber]; temp.WorksheetNumber = dbValue == DBNull.Value ? string.Empty : dbValue.ToString(); dbValue = result.Tables[0].Rows[rowIndex][ColumnNames.ConfirmedDate]; temp.CreatedOn = dbValue == DBNull.Value ? string.Empty : dbValue.ToString(); dbValue = result.Tables[0].Rows[rowIndex][ColumnNames.QuoteNumber]; temp.QuoteNumber = dbValue == DBNull.Value ? string.Empty : dbValue.ToString(); dbValue = result.Tables[0].Rows[rowIndex][ColumnNames.RequestedShipDate]; temp.DeliveryDate = dbValue == DBNull.Value ? string.Empty : dbValue.ToString(); dbValue = result.Tables[0].Rows[rowIndex][ColumnNames.FullName]; temp.FullName = dbValue == DBNull.Value ? string.Empty : dbValue.ToString(); dbValue = result.Tables[0].Rows[rowIndex][ColumnNames.Progress]; temp.Progress = dbValue == DBNull.Value ? string.Empty : dbValue.ToString(); dbValue = result.Tables[0].Rows[rowIndex][ColumnNames.TotalQuantity]; temp.TotalQuantity = dbValue == DBNull.Value ? string.Empty : dbValue.ToString(); // Get progress for current worksheet SqlParameter pWsNumber = new SqlParameter(); pWsNumber.ParameterName = "wsNumber"; pWsNumber.Value = temp.WorksheetNumber; var progressResult = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetWorksheetProgress, pWsNumber); if (progressResult == null || progressResult.Tables == null || progressResult.Tables.Count == 0) { continue; } dbValue = progressResult.Tables[0].Rows[0][ColumnNames.Progress]; temp.Progress = dbValue == DBNull.Value ? string.Empty : dbValue.ToString(); quoteMasterData.Add(temp); } } catch (Exception ex) { Logger.LogException(ex); } return quoteMasterData; }
private bool IsSearchCriteriaMatched(WorksheetEntity currentRow) { return currentRow.WorksheetNumber.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.CreatedOn.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.FullName.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.DeliveryDate.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.TotalQuantity.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.QuoteNumber.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()) || currentRow.Progress.ToString() .ToLower() .Contains(txtSearch.Text .ToLower()); }