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