public ActionResult StudentsByCourses(int?id)
{
Course_tbl course = db.Course_tbl.Find(id);
var students = db.Student_tbl.Where(c => c.Level == course.Level);
return(View(students.ToList()));
}
public ActionResult DeleteConfirmed(string id)
{
Course_tbl course_tbl = db.Course_tbl.Find(id);
db.Course_tbl.Remove(course_tbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Name,Lecturer,PDFs_Links,Level")] Course_tbl course_tbl)
{
if (ModelState.IsValid)
{
db.Entry(course_tbl).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Lecturer = new SelectList(db.Lecturer_tbl, "Code_ID", "Name", course_tbl.Lecturer);
return(View(course_tbl));
}
public ActionResult Edit(Course_tbl course_tbl)
{
if (ModelState.IsValid)
{
db.Entry(course_tbl).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Prof = new SelectList(db.Lecturer_tbl.Where(m => m.Role == "Prof"), "ID", "Name");
ViewBag.Assistant = new SelectList(db.Lecturer_tbl.Where(m => m.Role == "Assistant"), "ID", "Name");
return(View(course_tbl));
}
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Course_tbl course_tbl = db.Course_tbl.Find(id);
if (course_tbl == null)
{
return(HttpNotFound());
}
return(View(course_tbl));
}
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Course_tbl course_tbl = db.Course_tbl.Find(id);
course_tbl.PDFs = db.File_tbl.Where(m => m.CourseID == course_tbl.ID).Count().ToString();
if (course_tbl == null)
{
return(HttpNotFound());
}
return(PartialView(course_tbl));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Course_tbl course_tbl = db.Course_tbl.Find(id);
if (course_tbl == null)
{
return(HttpNotFound());
}
ViewBag.Lecturer = new SelectList(db.Lecturer_tbl, "Code_ID", "Name", course_tbl.Lecturer);
return(View(course_tbl));
}
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Course_tbl course_tbl = db.Course_tbl.Find(id);
if (course_tbl == null)
{
return(HttpNotFound());
}
//Allow lecturers of this course and admins to access
if (User.Identity.Name != db.Lecturer_tbl.Find(course_tbl.Prof).Email&& User.Identity.Name != db.Lecturer_tbl.Find(course_tbl.Assistant).Email&& !User.IsInRole("Admin"))
{
return(new HttpStatusCodeResult(HttpStatusCode.Unauthorized));
}
ViewBag.Prof = new SelectList(db.Lecturer_tbl.Where(m => m.Role == "Prof"), "ID", "Name");
ViewBag.Assistant = new SelectList(db.Lecturer_tbl.Where(m => m.Role == "Assistant"), "ID", "Name");
//course_ID = id;
return(View(course_tbl));
}
protected void btn_submit_Click(object sender, EventArgs e)
{
string IP = GetVisitorIpAddress();
Course_tbl tblCourse = new Course_tbl();
Tuple<Course_tbl, UniversityEntities> tuple = new Tuple<Course_tbl, UniversityEntities>(null, null);
if (btn_submit.Text == "Submit")
{
try
{
tblCourse.CenterID = 1;
tblCourse.CourseType = ddltype.SelectedValue;
tblCourse.Degree = txtbx_coursename.Text;
//tblCourse.CourseSubjects = txtbx_subjects.Text;
tblCourse.CourseDuration = txtbx_duration.Text;
tblCourse.CourseDesc = txtbx_desc.Text;
tblCourse.IsBitDeleted = false;
tblCourse.CreatedBy = "Admin";
tblCourse.CreatedDate = Convert.ToDateTime(System.DateTime.Now);
tblCourse.CreatedIP = IP;
int courseid = ManageCourseBAL.SaveCourse(tblCourse);
lblmsg.Text = "Course added sucessfully!!!";
lblmsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#ff6230");
}
catch
{
//Exception
}
finally
{
BindGrid(grid_course.PageSize, grid_course.PageIndex);
Clear();
}
}
else if (btn_submit.Text == "Update")
{
try
{
tblCourse.CourseID = Convert.ToInt32(lblid.Text);
tblCourse.CourseType = ddltype.SelectedValue;
tblCourse.Degree = txtbx_coursename.Text;
//tblCourse.CourseSubjects = txtbx_subjects.Text;
tblCourse.CourseDuration = txtbx_duration.Text;
tblCourse.CourseDesc = txtbx_desc.Text;
tblCourse.ModifiedBy = "Admin";
tblCourse.ModifiedDate = Convert.ToDateTime(System.DateTime.Now);
tblCourse.ModifiedIP = IP;
int subid = ManageCourseBAL.UpdateCourse(tblCourse);
lblmsg.Text = "Record Updated Sucessfully";
lblmsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#ff6230");
Clear();
}
catch
{
//Exception
}
finally
{
BindGrid(grid_course.PageSize, grid_course.PageIndex);
Clear();
}
}
}
