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);
}
}
