Пример #1
0
        public bool StudentExist(string studentNumber, string password)
        {
            using (var userContext = new ceit_gwa_databaseEntities1())
            {
                //var user = userContext.CeitUsers.Where(u => u.LoginAccount == studentNumber && u.Password == password).FirstOrDefault();
                try
                {
                    var test = userContext.CeitUsers.Where(u => u.LoginAccount == studentNumber && u.Password == password).FirstOrDefault();
                }
                catch (Exception ex)
                {
                    DebugErrorMessage.CatchError(ex);
                }
                string user = null;
                //user = Convert.ToString(userContext.CeitUsers.Where(u => u.LoginAccount == studentNumber && u.Password == password).FirstOrDefault());

                if (user != null)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
        }
Пример #2
0
        protected virtual void Seed(ceit_gwa_databaseEntities1 context)
        {
            /// Our seed code
            string newid = Convert.ToString(Guid.NewGuid());

            //var admin = new CeitAdministrator { AdminId = newid, AdminName = "admin" };
            //var user = new CeitUser { AdminAccount = newid, Roles = 2, DateCreated = DateTime.Now, DateUpdated = DateTime.Now, Password = "******" };

            context.CeitAdministrators.Add(new CeitAdministrator {
                AdminId = newid, AdminName = "admin"
            });
            context.CeitUsers.Add(new CeitUser {
                AdminAccount = newid, Roles = 2, DateCreated = DateTime.Now, DateUpdated = DateTime.Now, Password = "******"
            });
            context.CeitCourses.Add(new CeitCourse {
                Name = "CPE", Text = "CPE", Value = "BS in Computer Engineering", Status = "Active"
            });
            context.CeitCourses.Add(new CeitCourse {
                Name = "ICT", Text = "ICT", Value = "Information Communication Technology", Status = "Active"
            });
            context.CeitCourses.Add(new CeitCourse {
                Name = "CPET", Text = "CPET", Value = "Computer Engineering Technology", Status = "Active"
            });
            context.CeitSecurityQuestions.Add(new CeitSecurityQuestion {
                SecurityQuestions = "What is your favorite color?"
            });
            context.CeitUserRoles.Add(new CeitUserRole {
                Roles = "Student", RolesFor = "Students"
            });
            context.CeitUserRoles.Add(new CeitUserRole {
                Roles = "Admin", RolesFor = "Administrators"
            });
            context.CeitUserRoles.Add(new CeitUserRole {
                Roles = "SuperUser", RolesFor = "SuperUsers"
            });
            context.CeitYearLevels.Add(new CeitYearLevel {
                YearLevel = "1st Year"
            });
            context.CeitYearLevels.Add(new CeitYearLevel {
                YearLevel = "2nd Year"
            });
            context.CeitYearLevels.Add(new CeitYearLevel {
                YearLevel = "3rd Year"
            });
            context.CeitYearLevels.Add(new CeitYearLevel {
                YearLevel = "4th Year"
            });
            context.CeitYearLevels.Add(new CeitYearLevel {
                YearLevel = "5th Year"
            });


            //context.SaveChanges();
            try
            {
                context.SaveChanges();
            }
            catch (Exception ex)
            {
                DebugErrorMessage.CatchError(ex);
            }
        }