public static List <TestHeader> getTestHeaderBySearch(string search, int firstRow, int pageSize, ref int?totalRows)
{
List <TestHeader> theList = new List <TestHeader>();
TestHeader theTest = null;
try
{
TestDSTableAdapters.WBTTestHeaderTableAdapter theAdapter = new TestDSTableAdapters.WBTTestHeaderTableAdapter();
TestDS.WBTTestHeaderDataTable theTable = theAdapter.GetTestHeaderBySearch(search, pageSize, firstRow, ref totalRows);
if (theTable != null && theTable.Rows.Count > 0)
{
foreach (TestDS.WBTTestHeaderRow row in theTable.Rows)
{
theTest = FillRecord(row);
theList.Add(theTest);
}
}
}
catch (Exception ex)
{
log.Error("An error was ocurred while geting list with the search " + search, ex);
throw;
}
return(theList);
}
public static TestHeader getTestHeaderById(int testId)
{
if (testId <= 0)
{
throw new ArgumentException("Test ID cannot be negative or 0");
}
TestHeader obj = null;
try
{
TestDSTableAdapters.WBTTestHeaderTableAdapter adapter = new TestDSTableAdapters.WBTTestHeaderTableAdapter();
TestDS.WBTTestHeaderDataTable theTable = adapter.GetTestHeaderById(testId);
if (theTable == null || theTable.Rows.Count <= 0)
{
return(null);
}
obj = FillRecord(theTable[0]);
}
catch (Exception q)
{
log.Error("Error gettint TestHeader with test number " + testId, q);
throw q;
}
return(obj);
}
private static TestHeader FillRecord(TestDS.WBTTestHeaderRow row)
{
TestHeader obj = new TestHeader();
obj.TestIndex = row.testIndexID;
obj.TestNumber = row.testNumber;
obj.generalInfoID = row.generalInfoID;
obj.surveyID = row.surveyID;
obj.questionnaireID = row.questionnaireID;
obj.testerName = row.testerName;
obj.testDate = row.IstestDateNull() ? (DateTime?)null : row.testDate;
obj.testLocation = row.testLocation;
obj.testReplicateNumber = row.IstestReplicateNumberNull() ? "" : row.testReplicateNumber;
obj.altitude = row.IsaltitudeNull() ? (int?)null : row.altitude;
obj.stoveType = row.IsstoveTypeNull() ? "" : row.stoveType;
obj.stoveManufacturer = row.IsstoveManufacturerNull() ? "" : row.stoveManufacturer;
obj.testDescription = row.IstestDescriptionNull() ? "" : row.testDescription;
obj.potDescription = row.IspotDescriptionNull() ? "" : row.potDescription;
obj.airRelativeHumidity = row.IsairRelativeHumidityNull() ? (decimal?)null : row.airRelativeHumidity;
obj.localBoilingPoint = row.IslocalBoilingPointNull() ? (decimal?)null : row.localBoilingPoint;
obj.atmosphericP = row.IsatmosphericPNull() ? (decimal?)null : row.atmosphericP;
obj.pitotDeltaP = row.IspitotDeltaPNull() ? (decimal?)null : row.pitotDeltaP;
obj.hoodFlowRate = row.IshoodFlowRateNull() ? (decimal?)null : row.hoodFlowRate;
obj.testNotes = row.IstestNotesNull() ? "" : row.testNotes;
obj.fuelGeneralDesc = row.IsfuelGeneralDescNull() ? "" : row.fuelGeneralDesc;
obj.fuelType = row.IsfuelTypeNull() ? (int?)null : row.fuelType;
obj.fuelDescription = row.IsfuelDescriptionNull() ? "" : row.fuelDescription;
obj.fuelAverageLength = row.IsfuelAverageLengthNull() ? (int?)null : row.fuelAverageLength;
obj.crossSectionalDim = row.IscrossSectionalDimNull() ? "" : row.crossSectionalDim;
obj.measuredCalorificValues = row.IsmeasuredCalorificValuesNull() ? (bool?)null : row.measuredCalorificValues;
obj.measuredGrossCalVal = row.IsmeasuredGrossCalValNull() ? (decimal?)null : row.measuredGrossCalVal;
obj.measuredNetCalVal = row.IsmeasuredNetCalValNull() ? (decimal?)null : row.measuredNetCalVal;
obj.descOfFireStarter = row.IsdescOfFireStarterNull() ? "" : row.descOfFireStarter;
obj.hp_descFireStarted = row.Ishp_descFireStartedNull() ? "" : row.hp_descFireStarted;
obj.hp_descWhenFuelAdded = row.Ishp_descWhenFuelAddedNull() ? "" : row.hp_descWhenFuelAdded;
obj.hp_descHowMuchFuelAdded = row.Ishp_descHowMuchFuelAddedNull() ? "" : row.hp_descHowMuchFuelAdded;
obj.hp_deschowOftenFeedFuel = row.Ishp_deschowOftenFeedFuelNull() ? "" : row.hp_deschowOftenFeedFuel;
obj.hp_descAirControl = row.Ishp_descAirControlNull() ? "" : row.hp_descAirControl;
obj.st_descFireStarted = row.Isst_descFireStartedNull() ? "" : row.st_descFireStarted;
obj.st_descWhenFuelAdded = row.Isst_descWhenFuelAddedNull() ? "" : row.st_descWhenFuelAdded;
obj.st_descHowMuchFuelAdded = row.Isst_descHowMuchFuelAddedNull() ? "" : row.st_descHowMuchFuelAdded;
obj.st_deschowOftenFeedFuel = row.Isst_descHowMuchFuelAddedNull() ? "" : row.st_deschowOftenFeedFuel;
obj.st_descAirControl = row.Isst_descAirControlNull() ? "" : row.st_descAirControl;
obj.genCalcID = row.genCalcID;
obj.defaultGrossCalorificValue = row.IsdefaultGrossCalorificValueNull() ? (decimal?)null : row.defaultGrossCalorificValue;
obj.defaultNetCalorificValue = row.IsdefaultNetCalorificValueNull() ? (decimal?)null : row.defaultNetCalorificValue;
obj.charCalorificValue = row.IscharCalorificValueNull() ? (decimal?)null : row.charCalorificValue;
obj.charCarbonContent = row.IscharCarbonContentNull() ? (decimal?)null : row.charCarbonContent;
obj.assumedNetCalorificValue = row.IsassumedNetCalorificValueNull() ? (decimal?)null : row.assumedNetCalorificValue;
obj.gorssCalorificValue = row.IsgorssCalorificValueNull() ? (decimal?)null : row.gorssCalorificValue;
obj.netCalorificValue = row.IsnetCalorificValueNull() ? (decimal?)null : row.netCalorificValue;
obj.fuelCarbonContent = row.IsfuelCarbonContentNull() ? (decimal?)null : row.fuelCarbonContent;
return(obj);
}