public static PlanHistoryApi ToPlanHistoryApi(this PlanHistory planHistory)
{
return(new PlanHistoryApi
{
Id = planHistory.Id,
Plan = planHistory.Plan.Id,
PlanStatus = planHistory.PlanStatus.Id,
Date = planHistory.Date.ToString("yyyy-MM-dd")
});
}
public IList <PlanHistory> getHistory()
{
string connectionString = "Data Source=FORLOGIC357;Initial Catalog=PLANNER;" +
"Integrated Security=True";
string sqlQuery = "SELECT * FROM plan_history";
PlanStatusDAO psDAO = new PlanStatusDAO();
PlanDAO planDAO = new PlanDAO();
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(sqlQuery, connection);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Plan p = planDAO.getOnePlan((int)reader[1]);
PlanStatus ps = psDAO.getOneStatus((int)reader[2]);
PlanHistory ph = new PlanHistory((int)reader[0], p, ps, (DateTime)reader[3]);
this.planHistoryList.Add(ph);
}
reader.Close();
return(this.planHistoryList);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(this.planHistoryList);
}
finally
{
connection.Close();
}
}
}
