public List<Chat> GetAllChatsForUser(User u) { using (SportsChatQueries query = new SportsChatQueries(new SportsChatEntities())) { return query.GetAllChatsForUserId(u.Id); } }
public void AddUser(User u) { u.DateCreated = DateTime.Now; ctx.Users.Add(u); try { ctx.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public void DeleteUser(User u) { User userToRemove = ctx.Users.Find(u.Id); if (userToRemove != null) { ctx.Users.Remove(u); } try { ctx.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
/// <summary> /// Creates a New User and adds that user to the db /// Returns the id of the User created /// </summary> /// <param name="userName"></param> /// <param name="password"></param> /// <param name="email"></param> /// <param name="firstName"></param> /// <param name="lastName"></param> public static int CreateNewUser(string userName, string password, string email, string firstName, string lastName) { User u = new User() { UserName = userName, EmailAddress = email, FirstName = firstName, LastName = lastName }; u.Guid = NewGuid(); u.Password = CreateHashedPassword(password, u.Guid); using (SportsChatQueries query = new SportsChatQueries(new SportsChatEntities())) { query.AddUser(u); User created = query.GetUserByUserNameAndPasswordHash(u.UserName, u.Password); if (created == null) { return 0; } return created.Id; } }
internal void UpdateUserTest([PexAssumeUnderTest]SportsChatQueries target, User u) { target.UpdateUser(u); // TODO: add assertions to method SportsChatQueriesTest.UpdateUserTest(SportsChatQueries, User) }
/// <summary> /// Updates the User in the db to the one passed in. /// </summary> /// <param name="u"></param> public void UpdateUser(User u) { using (SportsChatQueries query = new SportsChatQueries(new SportsChatEntities())) { query.UpdateUser(u); } }
public void UpdateUser(User u) { ctx.Entry(u).State = System.Data.Entity.EntityState.Modified; try { ctx.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }