/// <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); }