//
public double FastUCOL(int rc)
{
double temp = InvalidRate;
USGSData TheData = FDataList.Find(delegate(USGSData FD) {
return((FD.rc == rc));
});
temp = TheData.urban;
return(temp);
}
public string FastRNCOL(int rc)
{
string temp = InvalidString;
USGSData TheData = FDataList.Find(delegate(USGSData FD) {
return((FD.rc == rc));
});
temp = TheData.regionName;
return(temp);
}
/// <summary>
///
/// </summary>
/// <param name="DataDirectory"></param>
/// <param name="Filename"></param>
public USGSdataClass(string DataDirectory, string Filename)
{
string errMessage = "";
bool isErr = false;
FDataDirectory = DataDirectory;
FFilename = Filename;
UniDbConnection DbCon = new UniDbConnection(SQLServer.stText, "", FDataDirectory, "", "", "")
{
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;
FString = new string[arraysize];
FRegion = new int[arraysize];
FCORuse_1 = new double[arraysize];
FCORuse_2 = new double[arraysize];
FCORuse_3 = new double[arraysize];
FCORuse_4 = new double[arraysize];
FCORuse_5 = new double[arraysize];
FCORuse_6 = new double[arraysize];
//int CodeI = 0;
foreach (DataRow DR in TheData.Rows)
{
// Decided not to use code in DataTable
// int codeint = Tools.ConvertToInt32(codestr,ref isErr,ref errMessage);
if (!isErr)
{
string FRegion = DR[FRnameFieldStr1].ToString();
string rCORuse_1 = DR[FColoradoRiverUse_1].ToString();
string rCORuse_2 = DR[FColoradoRiverUse_2].ToString();
string rCORuse_3 = DR[FColoradoRiverUse_3].ToString();
string rCORuse_4 = DR[FColoradoRiverUse_4].ToString();
string rCORuse_5 = DR[FColoradoRiverUse_5].ToString();
string rCORuse_6 = DR[FColoradoRiverUse_6].ToString();
string FString = DR[FRnameFieldStr2].ToString();
//
int Temp1 = Tools.ConvertToInt32(FRegion, ref isErr, ref errMessage);
if (!isErr)
{
double Temp2 = Tools.ConvertToDouble(rCORuse_1, ref isErr, ref errMessage);
if (!isErr)
{
double Temp3 = Tools.ConvertToDouble(rCORuse_2, ref isErr, ref errMessage);
if (!isErr)
{
double Temp4 = Tools.ConvertToDouble(rCORuse_3, ref isErr, ref errMessage);
if (!isErr)
{
double Temp5 = Tools.ConvertToDouble(rCORuse_4, ref isErr, ref errMessage);
if (!isErr)
{
double Temp6 = Tools.ConvertToDouble(rCORuse_5, ref isErr, ref errMessage);
if (!isErr)
{
double Temp7 = Tools.ConvertToDouble(rCORuse_6, ref isErr, ref errMessage);
if (!isErr)
{
string Temp8 = Tools.ConvertToString(FString, ref isErr, ref errMessage);
if (!isErr)
{
// OK
//string aUnitName, string aUnitCode, double anAcerageUrban, double anAcerageAg, double anAcerageInd, int aYear
USGSData USGSD = new USGSData(Temp1, Temp2, Temp3, Temp4, Temp5, Temp6, Temp7, Temp8);
FDataList.Add(USGSD);
//// add to dictionary
///
}
}
}
}
}
}
}
}
}
}
}
