// GET: Dashboard
        public ActionResult Index()
        {
            int role   = Convert.ToInt32(Session["UserPosition"]);
            int userId = Convert.ToInt32(Session["UserID"]);

            using (AuaDbContext db = new AuaDbContext())
            {
                var          userClases = db.UserClasses.Where(item => item.fk_User == userId).ToList();
                List <Class> Class      = new List <Class>();
                foreach (var item in userClases)
                {
                    var b = db.Classes.Where(a => a.Id == item.fk_Class).FirstOrDefault();
                    Class.Add(b);
                }
                ViewBag.Class = Class;
            }
            if (role == 0)
            {
                return(View("Class"));
            }
            else if (role == 1)
            {
                return(View("TeacherClass"));
            }
            else
            {
                return(View("Error"));
            }
        }
 public ActionResult Login(LoginDetails objUser)
 {
     if (ModelState.IsValid)
     {
         using (AuaDbContext db = new AuaDbContext())
         {
             var obj = db.LoginDetails.Where(a => a.UserName.Equals(objUser.UserName) && a.Password.Equals(objUser.Password)).FirstOrDefault();
             if (obj != null)
             {
                 Session["UserID"]       = obj.UserId.ToString();
                 Session["UserPosition"] = obj.UserPosition.ToString();
                 return(RedirectToAction("Index", "Classes"));
             }
         }
     }
     return(View("Index"));
 }
Example #3
0
        public static List <Class> GetClass(int userId)
        {
            List <Class> Class = new List <Class>();

            using (AuaDbContext db = new AuaDbContext())
            {
                var userClases = db.UserClasses.Where(item => item.fk_User == userId).ToList();

                foreach (var item in userClases)
                {
                    var b = db.Classes.Where(a => a.Id == item.fk_Class).FirstOrDefault();
                    if (b != null)
                    {
                        Class.Add(b);
                    }
                }
            }
            return(Class);
        }
Example #4
0
        public static List <Students> GetStudents(int classId)
        {
            List <Students> students = new List <Students>();

            using (AuaDbContext db = new AuaDbContext())
            {
                var userClases = db.UserClasses.Where(item => item.fk_Class == classId).ToList();

                foreach (var item in userClases)
                {
                    var b = db.Students.Where(a => a.Id == item.fk_User).FirstOrDefault();
                    if (b != null)
                    {
                        students.Add(b);
                    }
                }
            }
            return(students);
        }