public void DeleteAllUserData() { using (var db = new SmartPoolContext()) { db.Database.ExecuteSqlCommand("DELETE [UserSet]"); } }
public void AssignPoolToUser(int userId) { using (var db = new SmartPoolContext()) { } }
public void FuckAll() { using (var db = new SmartPoolContext()) { db.Database.ExecuteSqlCommand("DELETE [Pool]"); } }
public void DeleteAllMonitorUnitData() { using (var db = new SmartPoolContext()) { db.Database.ExecuteSqlCommand("DELETE [MonitorUnitSet]"); } }
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(); } }
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(); } }
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(); } } }
// 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; } }
//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]; }
// 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(); } }