public async Task <GoodFoodUserDto> Register(string username, string password)
{
if (await IsUserExits(username))
{
throw new RestException(HttpStatusCode.BadRequest, new { Username = "******" });
}
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
string insertCommandText = @"INSERT INTO [dbo].[goodfooduser] (user_name, user_password_hash, user_password_salt)
values (@user_Name,@user_password_hash,@user_password_salt)";
SqlParameter user_name = new SqlParameter("@user_Name", username);
SqlParameter user_password_hash = new SqlParameter("@user_password_hash", passwordHash);
SqlParameter user_password_salt = new SqlParameter("@user_password_salt", passwordSalt);
Int32 rows = await SqlHelper.ExecuteNonQueryAsync(conStr, insertCommandText, CommandType.Text, user_name, user_password_hash, user_password_salt);
if (rows >= 1)
{
var user = new GoodFoodUserDto
{
Username = username
};
return(user);
}
throw new Exception("Problem creating user");
}
public async Task <List <GoodFoodUserDto> > GetAllUser()
{
try
{
List <GoodFoodUserDto> allusers = new List <GoodFoodUserDto>();
string selectCommandText = @"SELECT UserName FROM GoodFoodUser";
using (SqlDataReader reader = await SqlHelper.ExecuteReaderAsync(conStr, selectCommandText,
CommandType.Text))
{
while (reader.Read())
{
var user = new GoodFoodUserDto
{
UserName = reader["UserName"].ToString()
};
allusers.Add(user);
}
await reader.CloseAsync();
}
return(allusers);
}
catch (System.Exception)
{
throw new Exception("Problem to get users");
}
}
public async Task <List <GoodFoodUserDto> > GetAllUser()
{
List <GoodFoodUserDto> allusers = new List <GoodFoodUserDto>();
string selectCommandText = "dbo.getAllUsernames";
using (SqlDataReader reader = await SqlHelper.ExecuteReaderAsync(conStr, selectCommandText,
CommandType.StoredProcedure))
{
while (reader.Read())
{
var user = new GoodFoodUserDto
{
Username = reader["user_name"].ToString()
};
allusers.Add(user);
}
await reader.CloseAsync();
}
return(allusers);
}
