Exemple #1
0
        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);
        }
Exemple #2
0
        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);
        }
Exemple #3
0
        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);
        }