void _ReadConfinedWaters(
DGObjects objs,
string tableNameSQL,
string conditionSQL,
string orderSQL)
{
ReadRawData(objs, tableNameSQL, orderSQL, conditionSQL);
DataTable table = objs.rawDataSet.Tables[0];
foreach (DataRow reader in table.Rows)
{
if (IsDbNull(reader, "ID"))
continue;
ConfinedWater cw = new ConfinedWater(reader);
cw.ID = ReadInt(reader, "ID").Value;
cw.BoreholeName = ReadString(reader, "BoreholeName");
cw.SiteName = ReadString(reader, "SiteName");
cw.TopElevation = ReadDouble(reader, "TopElevation");
cw.ObservationDepth = ReadDouble(reader, "ObservationDepth");
cw.StratumName = ReadString(reader, "StatumName");
cw.Layer = ReadInt(reader, "Layer");
cw.WaterTable = ReadDouble(reader, "WaterTable");
cw.ObservationDate = ReadDateTime(reader, "ObservationDate");
objs[cw.key] = cw;
}
}
public ConfinedWaterDTO(ConfinedWater cw)
{
BoreholeName = cw.BoreholeName;
SiteName = cw.SiteName;
TopElevation = cw.TopElevation;
ObservationDepth = cw.ObservationDepth;
StratumName = cw.StratumName;
Layer = cw.Layer;
WaterTable = cw.WaterTable;
ObservationDate = cw.ObservationDate;
}
public ConfinedWaterDTO getConfinedWaterById(string project, int id)
{
ConfinedWater pw = getObjectById <ConfinedWater>(project, id);
return(new ConfinedWaterDTO(pw));
}
