public EditCoursePage(Course EditCourse) { InitializeComponent(); CurrentCourseDays = new CourseDays(); if (EditCourse == null) { Action = "Add"; CurrentCourse = new Course(); } else { Action = "Edit"; CurrentCourse = EditCourse; OriginalId = EditCourse.Id; if (CurrentCourse.Days.Length > 0) { if (CurrentCourse.Days.Contains(",")) { foreach (string DayId in CurrentCourse.Days.Split(',')) { CurrentCourseDays.SetSelectedValue(int.Parse(DayId), true); } } else { CurrentCourseDays.SetSelectedValue(int.Parse(CurrentCourse.Days), true); } } } SetUIText(); }
public EditCoursePage() { InitializeComponent(); Action = "Add"; CurrentCourseDays = new CourseDays(); SetUIText(); }
private static List <CourseDays> parse_courseDays(SqlDataReader rdr) { List <CourseDays> courseDaysList = new List <CourseDays>(); while (rdr.Read()) { CourseDays courseDays = new CourseDays(); courseDays.id = Convert.ToInt64(rdr["id"]); courseDays.course_id = Convert.ToInt64(rdr["course_id"]); courseDays.day = (days_of_week_enum)Convert.ToInt64(rdr["day"]); try { courseDays.from_time = Convert.ToDateTime(rdr["from_time"]); } catch (Exception) { courseDays.from_time = DateTime.Now; } try { courseDays.to_time = Convert.ToDateTime(rdr["to_time"]); } catch (Exception) { courseDays.to_time = DateTime.Now; } courseDaysList.Add(courseDays); } return(courseDaysList); }
private static long addCourseDay(CourseDays courseDays) { long id = 0; using (SqlConnection con = new SqlConnection(Database.connection_string)) { con.Open(); SqlCommand com = new SqlCommand("Course", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@course_id", courseDays.course_id); com.Parameters.AddWithValue("@day", courseDays.day); com.Parameters.AddWithValue("@from_time", courseDays.from_time); com.Parameters.AddWithValue("@to_time", courseDays.to_time); com.Parameters.AddWithValue("@Action", "InsertCourseDay"); SQL_Utility.Stored_Procedure(ref com); SqlDataReader rdr = com.ExecuteReader(); if (rdr.Read()) { id = Convert.ToInt64(rdr[0]); } } return(id); }
public static long addCourse(Course_Insert_Helper helper) { Course course = new Course { instructor_id = 0, branch_id = helper.branch_id, course_type_id = helper.CourseType, name = helper.name, name_ar = helper.name_ar, description = helper.description, description_ar = helper.description_ar, start_date = Convert.ToDateTime(helper.start_date), end_date = Convert.ToDateTime(helper.end_date), capacity = helper.capacity, capacity_is_visible = is_visible_enum.visible, old_price = helper.old_price, new_price = helper.new_price, expiration_register_date = Convert.ToDateTime(helper.expiration_register_date), course_duration_in_hours = helper.course_duration_in_hours, no_of_days_per_week = helper.no_of_days_per_week, no_of_hours_per_day = helper.no_of_hours_per_day, center_or_instructor = center_or_instructor_enum.center, is_visible = is_visible_enum.visible }; long course_id = addCourse(course); int i = 0; foreach (int item in helper.Days) { CourseDays day = new CourseDays(); day.course_id = course_id; day.day = (days_of_week_enum)item; day.to_time = Convert.ToDateTime(helper.Tos[i]); day.from_time = Convert.ToDateTime(helper.froms[i]); addCourseDay(day); i++; } return(course_id); }
public override string ToString() { string[] items = new string[Times.Count]; for (int i = 0; i < Times.Count; i++) { items[i] = Times[i].ToString(); } return(string.Format("Title: {0}, Code: {1}, Instructor: {2}," + " Buildings: {3}, Classes: {4}, Days: {5}, Times: {6}", CourseTitle, CourseCode, CourseInstructor, string.Join(",", Buildings.ToArray()), string.Join(",", Classes.ToArray()), string.Join(",", CourseDays.ToArray()), string.Join(",", items) )); }
public DaysPage(ref CourseDays coursedays) { InitializeComponent(); CurrentCourseDays = coursedays; SetUIText(); }