protected void btn_add_Click(object sender, EventArgs e)
{
var programid = Convert.ToInt32(ProgramList.SelectedValue);
var course = new Courses()
{
CourseID = txt_courseid.Text,
CourseName = txt_coursename.Text,
Credits = Convert.ToDecimal(txt_credit.Text),
TotalHours = Convert.ToInt32(txt_totalhours.Text),
ClassroomType = Convert.ToInt32(txt_classroomtype.Text),
Term = Convert.ToInt32(txt_term.Text),
Tuition = Convert.ToDecimal(txt_tuition.Text),
Description = txt_description.Text
};
CoursesController coursesController = new CoursesController();
coursesController.AddCourse(course);
var programCourse = new ProgramCourses();
programCourse.Active = true;
programCourse.Comments = "";
programCourse.CourseID = course.CourseID;
programCourse.ProgramID = programid;
programCourse.Required = true;
ProgramCoursesController programCoursesController = new ProgramCoursesController();
programCoursesController.AddProgramCourse(programCourse);
FindPrograms_Click(null, null);
}
public void AddProgramCourse(ProgramCourses programCourses)
{
using (var context = new StarTEDContext())
{
context.ProgramCourses.Add(programCourses);
context.SaveChanges();
}
}
protected void ProgramCoursesGridView_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow agvrow = ProgramCoursesGridView.Rows[ProgramCoursesGridView.SelectedIndex];
//try
//{
ProgramCoursesController sysmgr = new ProgramCoursesController();
ProgramCourses info = sysmgr.ProgramCourse_Find(int.Parse(agvrow.Cells[1].Text));
updateView(info);
//}
}
public void RemoveProgramCourse(ProgramCourses programCourses)
{
using (var context = new StarTEDContext())
{
var id = programCourses.ProgramCourseID;
var entity = context.ProgramCourses.Where(t => t.ProgramCourseID == id).FirstOrDefault();
if (entity == null)
{
return;
}
context.ProgramCourses.Remove(entity);
context.SaveChanges();
}
}
public void UpdateProgramCourse(ProgramCourses programCourse)
{
using (var context = new StarTEDContext())
{
var entity = context.ProgramCourses.Where(t => t.ProgramCourseID == programCourse.ProgramCourseID).FirstOrDefault();
if (entity == null)
{
return;
}
entity.Active = programCourse.Active;
entity.Comments = programCourse.Comments;
entity.CourseID = programCourse.CourseID;
entity.ProgramCourseID = programCourse.ProgramCourseID;
entity.ProgramID = programCourse.ProgramID;
entity.Required = programCourse.Required;
entity.SectionLimit = programCourse.SectionLimit;
context.SaveChanges();
}
}
private void updateView(ProgramCourses info)
{
ProgramsController programsController = new ProgramsController();
CoursesController coursesController = new CoursesController();
var programid = info.ProgramID;
var program = programsController.Programs_FindByProgramID(programid);
var courseid = info.CourseID;
var course = coursesController.Courses_GetCourse(courseid);
lbl_programid.Text = programid.ToString();
txt_courseid.Text = courseid;
lbl_programname.Text = program.ProgramName;
txt_coursename.Text = course.CourseName;
txt_credit.Text = course.Credits.ToString();
txt_totalhours.Text = course.TotalHours.ToString();
txt_classroomtype.Text = course.ClassroomType.ToString();
txt_term.Text = course.Term.ToString();
txt_tuition.Text = course.Tuition.ToString();
txt_description.Text = course.Description;
}
