/// <summary>
/// TODO
/// </summary>
/// <param name="nIdCourse"></param>
/// <returns></returns>
public static Course getCourse(int nIdCourse)
{
DataRow oRow = DAL_Course.DonneCoursePourId(nIdCourse)[0];
Course course = new Course(Convert.ToInt32(oRow["Id"]), oRow["Titre"].ToString(), oRow["Description"].ToString(),
Convert.ToDateTime(oRow["DateStart"].ToString()),
Convert.ToDateTime(oRow["DateEnd"].ToString()), oRow["Ville"].ToString());
return(course);
}
/// <summary>
/// TODO
/// </summary>
/// <returns></returns>
public static List <Course> ListeCoursesDisponibles()
{
List <Course> courses = new List <Course>();
DA_Courses.CourseDataTable dt = DAL_Course.DonneCoursesEnCours();
foreach (DataRow oRow in dt)
{
Course course = new Course(Convert.ToInt32(oRow["Id"]), oRow["Titre"].ToString(), oRow["Description"].ToString(),
Convert.ToDateTime(oRow["DateStart"].ToString()), Convert.ToDateTime(oRow["DateEnd"].ToString()), oRow["Ville"].ToString());
courses.Add(course);
}
return(courses);
}
public static string NombreCoursesDipoParVille()
{
DataTable dt = DAL_Course.DonneNombreCoursesDispoParVille();
DataTable TableStats = new DataTable();
TableStats.Columns.Add("category", typeof(string));
TableStats.Columns.Add("value", typeof(Int32));
foreach (DataRow oRow in dt.Rows)
{
object[] o = { oRow["Ville"].ToString(), oRow["nb"] };
TableStats.Rows.Add(o);
}
string Json = Common.Utilitaire.DataTableToJsonWithJsonNet(TableStats);
return(Json);
}
/// <summary>
/// Insert une nouvelle course en BDD
/// </summary>
/// <param name="course"></param>
public static void addCourse(Course course)
{
DAL_Course.Insert(course.Titre, course.Description, course.DateDebut, course.DateFin, course.Ville);
}
