Exemple #1
0
 public void DeleteAllUserData()
 {
     using (var db = new SmartPoolContext())
     {
         db.Database.ExecuteSqlCommand("DELETE [UserSet]");
     }
 }
Exemple #2
0
 public void AssignPoolToUser(int userId)
 {
     using (var db = new SmartPoolContext())
     {
         
     }
 }
Exemple #3
0
 public void FuckAll()
 {
     using (var db = new SmartPoolContext())
     {
         db.Database.ExecuteSqlCommand("DELETE [Pool]");
     }
 }
Exemple #4
0
 public void DeleteAllMonitorUnitData()
 {
     using (var db = new SmartPoolContext())
     {
         db.Database.ExecuteSqlCommand("DELETE [MonitorUnitSet]");
     }
 }
Exemple #5
0
 public void AddMonitorUnit(Pool pool, string name, string serialNumber, int pin)
 {
     MonitorUnit tempMonitorUnit = new MonitorUnit { PoolId = pool.Id, Name = name, SerialNumber = serialNumber, Pin = pin };
     using (var db = new SmartPoolContext())
     {
         db.MonitorUnitSet.Add(tempMonitorUnit);
         db.SaveChanges();
     }
 }
Exemple #6
0
        public void AddPool(User owner, string name, double length, double width, double depth)
        {
            Pool tempPool = new Pool { Name = name, Length = length, Width = width, Depth = depth, UserId = owner.Id};

            using (var db = new SmartPoolContext())
            {
                db.PoolSet.Add(tempPool);
                db.SaveChanges();
            }
        }
Exemple #7
0
 public void AddUser(string firstname, string middelname, string lastname, string email, string password)
 {
     using (var db = new SmartPoolContext())
     {
         if (FindUserByEmail(email) != null)
         {
             User tempUser = new User { Email = email, Firstname = firstname, Lastname = lastname, Password = password, Middlename = middelname };
             db.UserSet.Add(tempUser);
             db.SaveChanges();
         }
     }
 }
Exemple #8
0
            // authenticates and provides a user with a corresponding session
            public UserSession Authenticate(string email, string password)
            {
                // returns null if user could not be authenticated based on the input   
                using (var db = new SmartPoolContext())
                {
                    // queries the database for users with the specified input
                    var userQuery = from users in db.Users
                        where users.Email == email && users.Password == password
                        select users.UserId;

                    // checks to see whether the input was matched by the query
                    var userId = new UserIdentity(userQuery.First(), password);
                    return userQuery.Any() ? new UserSession(userId, true) : null;
                }
            }
Exemple #9
0
        //public void RemoveUser(string email)
        //{
        //    using (var db = new SmartPoolContext())
        //    {

        //        db.PoolSet.RemoveRange(FindUserByEmail(email)[0].Pool);
        //        if (FindUserByEmail(email).Count != 0)
        //        {
        //            foreach (var pool in FindUserByEmail(email)[0].Pool)
        //            {
        //                db.PoolSet.Remove(pool);
        //            }
        //            //db.PoolSet.RemoveRange(FindUserByEmail(email)[0].Pool);
        //            //db.UserSet.Remove(FindUserByEmail(email)[0]);

        //            db.SaveChanges();
        //        }
        //    }
        //}

        public User FindUserByEmail(string email)
        {
            List<User> searchResults = new List<User>();

            using (var db = new SmartPoolContext())
            {
                var searchByEmail = from search in db.UserSet
                                    where search.Email.Equals(email)
                                    select search;

                foreach (var user in searchByEmail)
                {
                    searchResults.Add(user);
                }
            }
            return searchResults[0];
        }
Exemple #10
0
        // confirms write access to data related to the user id contained in the session
        public bool ConfirmWriteAccess(UserSession session)
        {
            if (session == null || session.Authenticated() == false) return false;

            // returns false if user could not be authenticated based on the input   
            using (var db = new SmartPoolContext())
            {
                // queries the database for users matching input session
                var userQuery = from users in db.UserSet
                                where
                                    users.Id == session.Identity().AuthenticatedId &&
                                    users.Password == session.Identity().Password
                                select users.Id;

                // returns true if the input was matched by the query
                return userQuery.Any();
            }
        }