public static FU_Citation FromDataReader(System.Data.IDataReader r)
{
return(new FU_Citation()
{
Title = splitTitle(r.GetDataType <string>("Citation", ""), true),
Author = splitTitle(r.GetDataType <string>("Citation", ""), false),
CitationURL = r.GetDataType <string>("CitationURL")
});
}
public static GageStatsCitations FromDataReader(System.Data.IDataReader r)
{
return(new GageStatsCitations()
{
ID = r.GetDataType <Int32>("ID"),
Title = r.GetDataType <string>("Title"),
Author = r.GetDataType <string>("Author"),
CitationURL = r.GetDataType <string>("CitationURL")
});
}
public static GageStatsAgency FromDataReader(System.Data.IDataReader r)
{
return(new GageStatsAgency()
{
ID = r.GetDataType <Int32>("ID"),
Code = r.GetDataType <string>("Code"),
Name = r.GetDataType <string>("Name"),
Description = r.GetDataType <string>("Description")
});
}
public static FU_Station FromDataReader(System.Data.IDataReader r)
{
return(new FU_Station()
{
Name = r.GetDataType <string>("Name"),
Code = r.GetDataType <string>("Code"),
Location = new Point(r.GetDataType <double>("Longitude", -99.9), r.GetDataType <double>("Latitude", -99.9)),
Agency_cd = r.GetDataType <string>("Agency_cd"),
StationTypeCode = r.GetDataType <string>("StationTypeCode"),
IsRegulated = r.GetDataType <bool>("IsRegulated"),
StateCode = r.GetDataType <string>("StateCode")
});
}
public static GageStatsStations FromDataReader(System.Data.IDataReader r)
{
return(new GageStatsStations()
{
ID = r.GetDataType <Int32>("ID"),
Code = r.GetDataType <string>("Code"),
AgencyID = r.GetDataType <Int32>("AgencyID"),
Name = r.GetDataType <string>("Name"),
StationTypeID = r.GetDataType <Int32>("StationTypeID"),
IsRegulated = r.GetDataType <Boolean>("IsRegulated")
});
}
public static FU_Statistics FromDataReader(System.Data.IDataReader r)
{
return(new FU_Statistics()
{
StatisticValue = r.GetDataType <double>("StatisticValue"),
StatisticYears = r.GetDataType <double?>("YearsRec"),
StatisticError = r.GetDataType <double?>("StdError"),
StatisticVariance = r.GetDataType <double?>("Variance"),
StatisticLowerCI = r.GetDataType <double?>("LowerCI"),
StatisticUpperCI = r.GetDataType <double?>("UpperCI"),
StatisticStartDate = r.GetDataType <DateTime?>("StatStartDate"),
StatisticEndDate = r.GetDataType <DateTime?>("StatEndDate"),
StatisticRemarks = r.GetDataType <string>("StatisticRemarks"),
StatisticDefType = r.GetDataType <string>("StatisticDefType"),
StatisticCode = r.GetDataType <string>("StatLabelCode"),
StatisticTypeCode = r.GetDataType <string>("StatisticTypeCode"),
StatisticUnitAbbr = r.GetDataType <string>("UnitAbbr"),
StatisticIsPreferred = r.GetDataType <bool>("IsPreferred"),
Citation = FU_Citation.FromDataReader(r)
});
}
