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