public double FastTurfRCN(string soil) { double temp = InvalidRate; DataStructLcluRCN TheData = FLcluRCNDataList.Find(delegate(DataStructLcluRCN AD) { bool v = AD.TheSoil == soil; return(v); }); if (TheData.TheSoil == soil) { temp = TheData.Turf; } return(temp); }
/// <summary> /// /// </summary> /// <param name="DataDirectory"></param> /// <param name="Filename"></param> public DataClassLcluRCN(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 Runoff Curve Number 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]; // // FSoilArray = 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); string texture = "A"; bool pass = true; string rsoilstr = DR[FsoilFieldStr].ToString(); if (pass) { // string rsoilstr = DR[FsoilFieldStr].ToString(); string turffStr = DR[FRCNTurfFieldStr].ToString(); string woodsStr = DR[FRCNWoodsFieldStr].ToString(); string waterStr = DR[FRCNWaterFieldStr].ToString(); string pastureStr = DR[FRCNPastureFieldStr].ToString(); string cropsStr = DR[FRCNRowCropsFieldStr].ToString(); string fallowStr = DR[FRCNFallowFieldStr].ToString(); string indStr = DR[FRCNIndFieldStr].ToString(); string commStr = DR[FRCNCommFieldStr].ToString(); string pavedStr = DR[FRCNPavedFieldStr].ToString(); string eigthStr = DR[FRCNEigthAcreFieldStr].ToString(); string quarterStr = DR[FRCNQuarterAcreFieldStr].ToString(); string thirdStr = DR[FRCNThirdAcreFieldStr].ToString(); string halfStr = DR[FRCNHalfAcreFieldStr].ToString(); string acreStr = DR[FRCNAcreFieldStr].ToString(); // //string rindacresstr = DR[FAcerageIndFieldStr].ToString(); //string rsoilstr = DR[FsoilFieldStr].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) { string tempSoil = rsoilstr; if (!isErr) { // OK DataStructLcluRCN AD = new DataStructLcluRCN(tempSoil, tempTurf, tempWoods, tempWater, tempPasture, tempCrops, tempFallow, tempInd, tempComm, tempPaved, tempEigth, tempQuarter, tempThird, tempHalf, tempAcre); FLcluRCNDataList.Add(AD); } } } } } } } } } } } } } } } } } }