public void AddUser(User user, string password)
{
string salt = PasswordHelper.GenerateSalt();
string passwordHash = PasswordHelper.HashPassword(password, salt);
user.PasswordSalt = salt;
user.PasswordHash = passwordHash;
using (var context = new SharedTasksDataContext(_connectionstring))
{
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
}
//using (var connection = new SqlConnection(_connectionstring))
//using (var command = connection.CreateCommand())
//{
// command.CommandText = "INSERT INTO [User](FirstName, LastName, EmailAddress, PasswordHash, PasswordSalt)" +
// " VALUES (@firstname, @lastname, @emailAddress, @passwordHash, @passwordSalt)";
// command.Parameters.AddWithValue("@firstname", user.FirstName);
// command.Parameters.AddWithValue("@lastname", user.LastName);
// command.Parameters.AddWithValue("@EmailAddress", user.EmailAddress);
// command.Parameters.AddWithValue("@passwordHash", passwordHash);
// command.Parameters.AddWithValue("@passwordSalt", salt);
// connection.Open();
// command.ExecuteNonQuery();
//}
}
public void AddTask(Task task)
{
using (var context = new SharedTasksDataContext(_connectionstring))
{
context.Tasks.InsertOnSubmit(task);
context.SubmitChanges();
}
}
