public ActionResult SaveStudentTutor(StudentTutorViewModel studentTutor)
{
GetUser();
var result = new ResultViewModel();
using (context = new ETutorEntities())
{
try
{
studentTutor.selectedStudents.ForEach(f =>
{
var studenttutor = context.StudentTutor_tbl.Where(w => w.StudentId == f.id).FirstOrDefault();
if (studenttutor != null)
{
studenttutor.IsCurrent = false;
studenttutor.UpdatedBy = user.userId;
studenttutor.UpdateOn = DateTime.Now;
}
var StudentTutor = new StudentTutor_tbl
{
StudentId = f.id,
TutorId = studentTutor.tutorId != null ? studentTutor.tutorId.id : null,
CreatedBy = user.userId,
CreateOn = DateTime.Now,
UpdatedBy = user.userId,
UpdateOn = DateTime.Now,
IsCurrent = true
};
context.StudentTutor_tbl.Add(StudentTutor);
context.SaveChanges();
});
result.isSuccess = true;
result.message = "Save success";
}
catch (Exception e)
{
result.isSuccess = false;
result.message = e.Message;
}
}
return(new JsonResult {
Data = result, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = int.MaxValue
});
}
public ActionResult GetUsers()
{
GetUser();
var tutors = new List <DropdownViewModel>();
var students = new List <DropdownViewModel>();
var userlist = new List <DropdownViewModel>();
using (context = new ETutorEntities())
{
tutors = context.Role_tbl.Where(w => w.Name == "Tutor").SelectMany(s => s.UserRole_tbl).Select(s => s.User_tbl).Select(s => new DropdownViewModel
{
id = s.Id,
label = s.UserName
}).Distinct().ToList();
students = context.Role_tbl.Where(w => w.Name == "Student").SelectMany(s => s.UserRole_tbl).Select(s => s.User_tbl).Select(s => new DropdownViewModel
{
id = s.Id,
label = s.UserName
}).Distinct().ToList();
userlist = context.Role_tbl.Where(w => w.Name != "Admin").SelectMany(s => s.UserRole_tbl).Select(s => s.User_tbl).Select(s => new DropdownViewModel
{
id = s.Id,
label = s.UserName
}).Distinct().ToList();
}
var users = new StudentTutorViewModel();
users.tutors = tutors;
users.students = students;
users.users = userlist;
return(new JsonResult {
Data = users, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = int.MaxValue
});
}