public ActionResult ShowStudents(string cid)
{
// cid = "1";
//string cid = "1";
LearnDal learnDal = new LearnDal();
StudentDal studentDal = new StudentDal();
StudentViewModel viewModel = new StudentViewModel();
List <string> usernames = new List <string>();
foreach (Learn learn in learnDal.learns)
{
if (learn.cid.Equals(cid))
{
usernames.Add(learn.Susername);
}
}
viewModel.students = new List <Student>();
foreach (Student student in studentDal.Dalstudents)
{
if (usernames.Contains(student.username))
{
viewModel.students.Add(student);
}
}
return(View(viewModel.students));
}
// GET: Lecturer
public ActionResult ShowSchedule()
{
// Session["username"] = "******";
ScheduleDal sheduleDal = new ScheduleDal();
LearnDal learnDal = new LearnDal();
CourseDal courseDal = new CourseDal();
ScheduleViewModel scheduleViewModel = new ScheduleViewModel();
scheduleViewModel.learns = new List <Learn>();
scheduleViewModel.courses = new List <Course>();
List <string> shids = new List <string>();
List <string> cids = new List <string>();
foreach (Course course in courseDal.courses.ToList <Course>())
{
if (course.Lecturer.Equals(Session["username"].ToString()))
{
cids.Add(course.cid);
scheduleViewModel.courses.Add(course);
}
}
foreach (Learn learn in learnDal.learns.ToList <Learn>())
{
if (cids.Contains(learn.cid))
{
shids.Add(learn.shid);
scheduleViewModel.learns.Add(learn);
}
}
scheduleViewModel.schedules = new List <Shedule>();
foreach (Shedule shedule in sheduleDal.schedules.ToList <Shedule>())
{
if (shids.Contains(shedule.shid))
{
scheduleViewModel.schedules.Add(shedule);
}
}
List <ScheduleViewModel> models = new List <ScheduleViewModel>();
ScheduleViewModel model;
for (int i = 0; i < scheduleViewModel.courses.Count && i < scheduleViewModel.learns.Count && i < scheduleViewModel.schedules.Count; i++)
{
model = new ScheduleViewModel();
model.schedule = scheduleViewModel.schedules.ElementAt(i);
model.Learn = scheduleViewModel.learns.ElementAt(i);
model.course = scheduleViewModel.courses.ElementAt(i);
models.Add(model);
}
return(View(models));
}
public ActionResult add()
{
string username = Request.Form["username"];
string cid = Request.Form["cid"];
if (ModelState.IsValid)
{
CourseDal c = new CourseDal();
Course course = c.courses.Find(cid);
StudentDal s = new StudentDal();
Student student = s.Dalstudents.Find(username);
if (student == null)
{
ModelState.AddModelError(string.Empty, "Student Name not exists.");
return(View("addStudent"));
}
if (course == null)
{
ModelState.AddModelError(string.Empty, "Course cid not exists.");
return(View("addStudent"));
}
LearnDal learn = new LearnDal();
Learn l = new Learn();
l.cid = course.cid;
l.Susername = student.username;
l.shid = course.shid;
learn.learns.Add(l);
try
{
learn.SaveChanges();
}
catch (Exception)
{
ModelState.AddModelError(string.Empty, "this student already not exists.");
}
}
return(View("Homepage"));
}
public ActionResult ShowExams()
{
LearnDal learnDal = new LearnDal();
CourseDal courseDal = new CourseDal();
Session["username"] = "******";
ScheduleViewModel scheduleViewModel = new ScheduleViewModel();
scheduleViewModel.learns = new List <Learn>();
foreach (Learn learn in learnDal.learns.ToList <Learn>())
{
if (learn.Susername.Equals(Session["username"]))
{
scheduleViewModel.learns.Add(learn);
}
}
List <string> cids = new List <string>();
foreach (Learn learn in scheduleViewModel.learns)
{
if (!cids.Contains(learn.cid))
{
cids.Add(learn.cid);
}
}
//scheduleViewModel.schedules = sheduleDal.schedules.ToList<Shedule>();
scheduleViewModel.courses = new List <Course>();
foreach (Course course in courseDal.courses.ToList <Course>())
{
if (cids.Contains(course.cid))
{
scheduleViewModel.courses.Add(course);
}
}
return(View(scheduleViewModel.courses));
}
public ActionResult update()
{
//CourseDal c = new CourseDal();
// StudentDal st = new StudentDal();
LearnDal l = new LearnDal();
Grade g = new Grade();
g.cid = Request.Form["cid"];
g.username = Request.Form["username"];
g.grade1 = Request.Form["grade"];
string a1 = Request.Form["update"];
if (a1 == null)
{
a1 = "i";
}
Gradedal dal = new Gradedal();
List <Grade> s = dal.grade.ToList <Grade>();
if (l.learns.Find(g.username, g.cid) == null)
{
ModelState.AddModelError(string.Empty, "Student Name not exists.");
return(View("editGrade"));
}
if (a1.Equals("u"))
{
Grade a = dal.grade.Find(g.username, g.cid);
if (a == null)
{
ModelState.AddModelError(string.Empty, " this Student didnt have grade in this course to update.");
return(View("editGrade"));
}
a.grade1 = g.grade1;
try
{
dal.SaveChanges();
}
catch (SqlException)
{
ModelState.AddModelError(string.Empty, "The Student have grade in this course you can do update.");
}
}
if (a1.Equals("i"))
{
dal.grade.Add(g);
dal.SaveChanges();
}
return(View("editGrade"));
}
