public double FastTotalArea(string UnitName, int year) { double temp = InvalidRate; DataStructLcluArea TheData = FLcluClassesDataList.Find(delegate(DataStructLcluArea AD) { return((AD.TheYear == year) && (AD.UnitName == UnitName)); }); if (TheData.UnitName == UnitName) { temp = TheData.TotalArea; } return(temp); }
/// <summary> /// /// </summary> /// <param name="DataDirectory"></param> /// <param name="Filename"></param> public DataClassLcluArea(string DataDirectory, string Filename) { string errMessage = ""; bool isErr = false; FDataDirectory = DataDirectory; FFilename = Filename; UniDbConnection DbCon = new UniDbConnection(SQLServer.stText, "", FDataDirectory, "", "", ""); DbCon.UseFieldHeaders = true; DbCon.Open(); TheData = Tools.LoadTable(DbCon, FFilename, ref isErr, ref errMessage); if (isErr) { throw new Exception("Error loading Rate Data. " + errMessage); } // build data arrays int arraysize = TheData.Rows.Count; // FTurfArray = new double[arraysize]; FWoodsArray = new double[arraysize]; FWaterArray = new double[arraysize]; FPastureArray = new double[arraysize]; FCropsArray = new double[arraysize]; FFallowarray = new double[arraysize]; FIndArray = new double[arraysize]; FCommArray = new double[arraysize]; FPaved = new double[arraysize]; FEightArray = new double[arraysize]; FQuarterArray = new double[arraysize]; FThirdArray = new double[arraysize]; FHalfArray = new double[arraysize]; FAcreArray = new double[arraysize]; FTotalArray = new double[arraysize]; // //FAcresIndArray = new double[arraysize]; // FYearArray = new double[arraysize]; //int CodeI = 0; foreach (DataRow DR in TheData.Rows) { // Get name and code // EDIT QUAY 2/19/18 // Setup to use region or state codes string namestr = DR[FNameFieldStr].ToString(); string codestr = DR[FCodeFieldStr].ToString(); // END EDIT // Decided not to use code in DataTable int codeint = Tools.ConvertToInt32(codestr, ref isErr, ref errMessage); if (!isErr) { string turffStr = DR[FAreaTurfFieldStr].ToString(); string woodsStr = DR[FAreaWoodsFieldStr].ToString(); string waterStr = DR[FAreaWaterFieldStr].ToString(); string pastureStr = DR[FAreaPastureFieldStr].ToString(); string cropsStr = DR[FAreaRowCropsFieldStr].ToString(); string fallowStr = DR[FAreaFallowFieldStr].ToString(); string indStr = DR[FAreaIndFieldStr].ToString(); string commStr = DR[FAreaCommFieldStr].ToString(); string pavedStr = DR[FAreaPavedFieldStr].ToString(); string eigthStr = DR[FAreaEigthAcreFieldStr].ToString(); string quarterStr = DR[FAreaQuarterAcreFieldStr].ToString(); string thirdStr = DR[FAreaThirdAcreFieldStr].ToString(); string halfStr = DR[FAreaHalfAcreFieldStr].ToString(); string acreStr = DR[FAreaAcreFieldStr].ToString(); string totalStr = DR[FAreaTotalFieldStr].ToString(); // //string rindacresstr = DR[FAcerageIndFieldStr].ToString(); string ryearsstr = DR[FcurrentYearFieldStr].ToString(); double tempTurf = Tools.ConvertToDouble(turffStr, ref isErr, ref errMessage); if (!isErr) { double tempWoods = Tools.ConvertToDouble(woodsStr, ref isErr, ref errMessage); if (!isErr) { double tempWater = Tools.ConvertToDouble(waterStr, ref isErr, ref errMessage); if (!isErr) { double tempPasture = Tools.ConvertToDouble(pastureStr, ref isErr, ref errMessage); if (!isErr) { double tempCrops = Tools.ConvertToDouble(cropsStr, ref isErr, ref errMessage); if (!isErr) { double tempFallow = Tools.ConvertToDouble(fallowStr, ref isErr, ref errMessage); if (!isErr) { double tempInd = Tools.ConvertToDouble(indStr, ref isErr, ref errMessage); if (!isErr) { double tempComm = Tools.ConvertToDouble(commStr, ref isErr, ref errMessage); if (!isErr) { double tempPaved = Tools.ConvertToDouble(pavedStr, ref isErr, ref errMessage); if (!isErr) { double tempEigth = Tools.ConvertToDouble(eigthStr, ref isErr, ref errMessage); if (!isErr) { double tempQuarter = Tools.ConvertToDouble(quarterStr, ref isErr, ref errMessage); if (!isErr) { double tempThird = Tools.ConvertToDouble(thirdStr, ref isErr, ref errMessage); if (!isErr) { double tempHalf = Tools.ConvertToDouble(halfStr, ref isErr, ref errMessage); if (!isErr) { double tempAcre = Tools.ConvertToDouble(acreStr, ref isErr, ref errMessage); if (!isErr) { int tempYear = Tools.ConvertToInt32(ryearsstr, ref isErr, ref errMessage); if (!isErr) { double tempTot = Tools.ConvertToInt32(totalStr, ref isErr, ref errMessage); if (!isErr) { // OK DataStructLcluArea AD = new DataStructLcluArea(codestr, tempYear, tempTurf, tempWoods, tempWater, tempPasture, tempCrops, tempFallow, tempInd, tempComm, tempPaved, tempEigth, tempQuarter, tempThird, tempHalf, tempAcre, tempTot, namestr); FLcluClassesDataList.Add(AD); } } } } } } } } } } } } } } } } } } }