// GET: Course public ActionResult Index() { if (Session["PERSONAL_NO"] != null) { CourseModel model = new CourseModel(); CourseDS source = new CourseDS(); DataSet ds = new DataSet(); List <CourseModel> dataList = new List <CourseModel>(); ds = source.GetListOfCourses(); foreach (DataRow dr in ds.Tables[0].Rows) { CourseModel i = new CourseModel(); i.CourseId = dr["COURSE_ID"].ToString(); i.CourseName = dr["COURSE_CODE"].ToString(); i.CourseDesc = dr["COURSE_DESC"].ToString(); dataList.Add(i); } model.ListCourse = dataList; return(View(model)); } else { return(RedirectToAction("Index", "Login", new { area = "" })); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { CourseDS.InsertParameters["Crs_Id"].DefaultValue = txt_courseId.Text; CourseDS.InsertParameters["Crs_Name"].DefaultValue = txt_courseName.Text; CourseDS.InsertParameters["Crs_Duration"].DefaultValue = txt_courseDuration.Text; CourseDS.Insert(); txt_courseDuration.Text = txt_courseName.Text = txt_courseId.Text = ""; GridView1.DataBind(); Master.ShowAlert("Success", "Row inserted successfully"); } catch (Exception) { Master.ShowAlert("Error", "Cannot insert a row with the provided data"); } }
protected void lbtnEnroll_Click(object sender, EventArgs e) { DataView dv = (DataView)CourseDS.Select(DataSourceSelectArguments.Empty); { foreach (DataRowView dr in dv) { if (DateTime.Today >= DateTime.Parse(dr[5].ToString())) //Check Enroll Date with Start Date { lblMsg.Text = "This course can't enroll now!!"; } else { Response.Redirect("~/Enroll.aspx?cid=" + dr[7].ToString()); } } } }
public string UpdateCourse(Course course) { return(CourseDS.UpdateCourse(course)); }
public List <Course> GetCourseType() { return(CourseDS.GetAllCourseType()); }
public List <Course> GetCourseBySemester(int SemesterId) { return(CourseDS.GetCourseBySemester(SemesterId)); }
public List <Course> GetActiveCourse() { return(CourseDS.GetActiveCourse()); }