public static List <SimmerCalculationsClass> getSimmerCalculationsByTestNumber(string testNumber)
{
if (string.IsNullOrWhiteSpace(testNumber))
{
throw new ArgumentException("Test Number cannot be empty");
}
List <SimmerCalculationsClass> theList = null;
try
{
TestDSTableAdapters.WBTSimmerCalculationsTableAdapter adapter = new TestDSTableAdapters.WBTSimmerCalculationsTableAdapter();
TestDS.WBTSimmerCalculationsDataTable theTable = adapter.GetSimmerCalculationsByTestNumber(testNumber);
if (theTable != null && theTable.Rows.Count > 0)
{
theList = new List <SimmerCalculationsClass>();
foreach (TestDS.WBTSimmerCalculationsRow theRow in theTable.Rows)
{
SimmerCalculationsClass theData = FillRecord(theRow);
theList.Add(theData);
}
}
}
catch (Exception q)
{
log.Error("Error gettint SimmerCalculations with test number " + testNumber, q);
throw q;
}
return(theList);
}
private static SimmerCalculationsClass FillRecord(TestDS.WBTSimmerCalculationsRow row)
{
SimmerCalculationsClass obj = new SimmerCalculationsClass();
// Insert here the code to recover the object from row
obj.testSimmerCalcID = row.testSimmerCalcID;
obj.surveyID = row.surveyID;
obj.questionnaireID = row.questionnaireID;
obj.testNumber = row.testNumber;
obj.fsm = row.IsfsmNull() ? (decimal?)null : row.fsm;
obj.deltacs = row.IsdeltacsNull() ? (decimal?)null : row.deltacs;
obj.fsd = row.IsfsdNull() ? (decimal?)null : row.fsd;
obj.wsv = row.IswsvNull() ? (decimal?)null : row.wsv;
obj.wsr = row.IswsrNull() ? (decimal?)null : row.wsr;
obj.deltats = row.IsdeltatsNull() ? (decimal?)null : row.deltats;
obj.hs = row.IshsNull() ? (decimal?)null : row.hs;
obj.rsb = row.IsrsbNull() ? (decimal?)null : row.rsb;
obj.SCs = row.IsSCsNull() ? (decimal?)null : row.SCs;
obj.FPs = row.IsFPsNull() ? (decimal?)null : row.FPs;
obj.TDR = row.IsTDRNull() ? (decimal?)null : row.TDR;
obj.SES = row.IsSESNull() ? (decimal?)null : row.SES;
obj.BF = row.IsBFNull() ? (decimal?)null : row.BF;
obj.BE = row.IsBENull() ? (decimal?)null : row.BE;
return(obj);
}
