public User GetById(int id)
{
User user = new User();
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SELECT * FROM dbo.[Users] WHERE Id = @id";
command.Parameters.AddWithValue("@id", id);
SqlDataReader dataReader = command.ExecuteReader();
if(dataReader.Read())
{
user.Id = (int)dataReader["Id"];
user.FirstName = (string)dataReader["FirstName"];
user.LastName = (string)dataReader["LastName"];
user.UserName = (string)dataReader["UserName"];
user.Password = (string)dataReader["Password"];
}
}
return user;
}