示例#1
0
        public static int getNumberofClassesEnrolled(string email)
        {
            int id                = 0;
            int count             = 0;
            SE_ProjectEntities db = new SE_ProjectEntities();

            if (db.StudentTbls.Any(s => s.Email.Equals(email)))
            {
                id = DLSInterface.GetIdByEmail(email);
                foreach (StudentClassOTM k in db.StudentClassOTMs)
                {
                    if (k.Student_Id == id)
                    {
                        count++;
                    }
                }
            }
            else
            {
                id = DLSInterface.GetIdByEmail(email);
                foreach (TeacherClassOTM s in db.TeacherClassOTMs)
                {
                    if (s.Teacher_Id == id)
                    {
                        count++;
                    }
                }
            }

            return(count);
        }
示例#2
0
        public static bool isTeacher(string email)
        {
            SE_ProjectEntities db = new SE_ProjectEntities();

            if (db.TeacherTbls.Any(t => t.Email.Equals(email)))
            {
                return(true);
            }
            return(false);
        }
示例#3
0
        public static void ImageFromEmail(string email)
        {
            SE_ProjectEntities db = new SE_ProjectEntities();

            if (db.Profiles.Any(p => p.Email.Equals(email)))
            {
                profileImage = db.Profiles.Where(p => p.Email.Equals(email)).FirstOrDefault().ProfilePicture;
            }
            else
            {
                profileImage = null;
            }
        }
示例#4
0
        public static string getNameByEmail(string email)
        {
            SE_ProjectEntities db     = new SE_ProjectEntities();
            string             result = "";

            if (db.TeacherTbls.Any(t => t.Email.Equals(email)))
            {
                result = db.TeacherTbls.Where(t => t.Email.Equals(email)).FirstOrDefault().Name;
            }
            else if (db.StudentTbls.Any(s => s.Email.Equals(email)))
            {
                result = db.StudentTbls.Where(t => t.Email.Equals(email)).FirstOrDefault().Name;
            }
            return(result);
        }
示例#5
0
        public static string GetNameById(int id)
        {
            SE_ProjectEntities db = new SE_ProjectEntities();

            if (db.TeacherTbls.Any(t => t.Id == id))
            {
                return(db.TeacherTbls.Where(t => t.Id == id).FirstOrDefault().Name);
            }
            else if (db.StudentTbls.Any(s => s.Id == id))
            {
                return(db.StudentTbls.Where(s => s.Id == id).FirstOrDefault().Name);
            }
            else
            {
                return(null);
            }
        }
示例#6
0
        public static int GetIdByEmail(string email)
        {
            SE_ProjectEntities db = new SE_ProjectEntities();

            foreach (TeacherTbl k in db.TeacherTbls)
            {
                if (k.Email == email)
                {
                    return(k.Id);
                }
            }
            foreach (StudentTbl s in db.StudentTbls)
            {
                if (s.Email == email)
                {
                    return(s.Id);
                }
            }
            return(-1);
        }