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