private void SetForecastedResult(SqlCommand cm, ForecastedResult p)
{
DatabaseHelper.InsertDateTimeParam("@DurationDateTime", cm, p.DurationDateTime);
DatabaseHelper.InsertInt32Param("@FacilityId", cm, p.FacilityId);
DatabaseHelper.InsertMoneyParam("@ForecastId", cm, p.ForecastId);
DatabaseHelper.InsertDoubleParam("@ForecastValue", cm, p.ForecastValue);
DatabaseHelper.InsertInt32Param("@HistoricalValue", cm, p.HistoricalValue);
DatabaseHelper.InsertBooleanParam("@IsHistorical", cm, p.IsHistorical);
DatabaseHelper.InsertInt32Param("@TestId", cm, p.TestId);
DatabaseHelper.InsertDoubleParam("@TotalForecastValue", cm, p.TotalForecastValue);
DatabaseHelper.InsertStringNVarCharParam("@TestType", cm, p.TestType);
}
public void SaveForecastedResult(ForecastedResult fr, SqlTransaction tr)
{
string sql = "INSERT INTO ForecastedResult ([ForecastId],[FacilityId] ,[TestId], [TestType], [IsHistorical] ,[HistoricalValue], ";
sql += "[ForecastValue] ,[DurationDateTime],[TotalForecastValue]) VALUES (@ForecastId, @FacilityId, @TestId, @TestType, @IsHistorical, ";
sql += "@HistoricalValue, @ForecastValue, @DurationDateTime, @TotalForecastValue) SELECT @@identity";
using (SqlCommand cm = new SqlCommand(sql, DefaultConnection, tr))
{
SetForecastedResult(cm, fr);
fr.Id = int.Parse(cm.ExecuteScalar().ToString());
}
}
private void FetchForecastedResult(SqlDataReader dr, ForecastInfo test)
{
while (dr.Read())
{
ForecastedResult p = new ForecastedResult()
{
Id = DatabaseHelper.GetInt32("Id", dr),
TestId = DatabaseHelper.GetInt32("TestId", dr),
DurationDateTime = DatabaseHelper.GetDateTime("DurationDateTime", dr),
FacilityId = DatabaseHelper.GetInt32("FacilityId", dr),
ForecastId = DatabaseHelper.GetInt32("ForecastId", dr),
ForecastValue = DatabaseHelper.GetDouble("ForecastValue", dr),
HistoricalValue = DatabaseHelper.GetInt32("HistoricalValue", dr),
IsHistorical = DatabaseHelper.GetBoolean("IsHistorical", dr),
TotalForecastValue = DatabaseHelper.GetDouble("TotalForecastValue", dr),
TestType = DatabaseHelper.GetString("TestType", dr)
};
test.ForecastedResults.Add(p);
}
}