public User Login(string email, string password)
{
var userReader = Reader.GetTableReader(UserRequest.User(email, password));
userReader.Read();
var role = new Role(userReader["RoleId"].ToString());
var user = new User(
userReader["Email"].ToString(),
userReader["Password"].ToString(),
userReader["FirstName"].ToString(),
userReader["LastName"].ToString(),
role
);
if (role.roleId == "R")
{
var runnerReader = Reader.GetTableReader(UserRequest.RunnerData(email));
runnerReader.Read();
var runner = new RunnerData(
runnerReader["Gender"].ToString(),
runnerReader["Date"].ToString(),
runnerReader["CountryCode"].ToString(),
runnerReader["CountryName"].ToString()
);
user.runnerData = runner;
}
return(user);
}
private RunnerData GetRunnerData(string email)
{
var runnerReader = Reader.GetTableReader(UserRequest.RunnerData(email));
runnerReader.Read();
var country = new Country(
runnerReader["CountryCode"].ToString(),
runnerReader["CountryName"].ToString()
);
var runner = new RunnerData(
runnerReader["RunnerId"].ToString(),
runnerReader["Gender"].ToString(),
runnerReader["Date"].ToString(),
country
);
return(runner);
}
public static string UpdateRunnerData(RunnerData runner, string email)
{
return($"UPDATE [Runner] SET Gender = '{runner.gender}', DateOfBirth = '{Convert.ToDateTime(runner.birthday)}', CountryCode = '{runner.countryCode}' " +
$"WHERE Email = '{email}'");
}
public static string UpdateRunnerData(RunnerData runner, string email)
{
return($"UPDATE [Runner] SET Gender = '{runner.gender}', DateOfBirth = @DateOfBirth, CountryCode = '{runner.country.code}' " +
$"WHERE Email = '{email}'");
}