public ActionResult AddAttendence(List <attendence> model) { CMSEntities db = new CMSEntities(); int id = model[0].ass_course_id; System.DateTime date = model[0].date; assigned_course assCourse = db.assigned_course.Where(x => x.Id == id).FirstOrDefault(); List <attendence> atten = db.attendences.Where(x => x.ass_course_id == id && x.date == date).ToList(); if (atten.Count == 0) { foreach (attendence item in model) { student s = db.students.Where(x => x.rollno == item.rollno).FirstOrDefault(); item.assigned_course = assCourse; item.student = s; db.attendences.Add(item); } db.SaveChanges(); return(JavaScript("Attendence Submitted!")); } return(JavaScript("Error: Attendence for this date already submitted!")); }
public ActionResult AddAttendence(string course, string degree, string batch) { using (CMSEntities db = new CMSEntities()) { assigned_course assCourse = db.assigned_course.Where(x => x.course == course && x.degree1.title == degree && x.batch1.name == batch).FirstOrDefault(); if (assCourse != null) { List <student> studentList = db.students.Where(x => x.degree1.title == degree && x.batch1.name == batch).ToList(); List <attendence> model = new List <attendence>(); for (int i = 0; i < studentList.Count; i++) { attendence atten = new attendence(); atten.ass_course_id = assCourse.Id; atten.rollno = studentList[i].rollno; atten.status = false; atten.assigned_course = assCourse; atten.student = studentList[i]; atten.date = DateTime.Now; model.Add(atten); } return(View(model)); } } return(View()); }
public ActionResult AssignCourse(assigned_course model) { if (ModelState.IsValid) { CMSEntities db = new CMSEntities(); var assCourse = db.assigned_course.Where(x => x.course == model.course && x.batch == model.batch && x.degree == model.degree).FirstOrDefault(); if (assCourse != null) { return(JavaScript("Error: Such course is already assigned to '" + assCourse.t_username + "'")); } else { db.assigned_course.Add(model); db.SaveChanges(); } return(JavaScript("Course Assigned successfully!")); } return(View(model)); }
public ActionResult AssignCourse(CMSEntities db) { assigned_course model = new assigned_course(); IEnumerable <SelectListItem> degList = db.degrees.Select(c => new SelectListItem { Value = c.title, Text = c.title.ToUpper() }); model.degreeList = degList; IEnumerable <SelectListItem> batList = db.batches.Select(c => new SelectListItem { Value = c.name, Text = c.name.ToUpper() }); model.batchList = batList; IEnumerable <SelectListItem> courseList = db.courses.Select(c => new SelectListItem { Value = c.name, Text = c.name.ToUpper() }); model.courseList = courseList; IEnumerable <SelectListItem> tUnameList = db.Teachers.Select(c => new SelectListItem { Value = c.username, Text = c.username }); model.tUnameList = tUnameList; return(View(model)); }