public async Task <SaveStatus> RegisterUser(RegisterIDTO objRegister)
{
try
{
using (IDbConnection conn = Connection)
{
var param = new DynamicParameters();
param.Add("@FirstName", objRegister.FirstName, DbType.String, direction: ParameterDirection.Input);
param.Add("@LastName", objRegister.LastName, DbType.String, direction: ParameterDirection.Input);
param.Add("@Email", objRegister.loginDetails.Email, DbType.String, direction: ParameterDirection.Input);
param.Add("@Password", EncodeDecodeBase64.Base64Encode(objRegister.loginDetails.Password), DbType.String, direction: ParameterDirection.Input);
param.Add("@ReturnValue", DbType.Int32, direction: ParameterDirection.ReturnValue);
await conn.ExecuteAsync("usp_RegisterUser", param, commandType : CommandType.StoredProcedure);
var retValue = param.Get <int>("@ReturnValue");
SaveStatus status = (SaveStatus)retValue;
return(status);
}
}
catch (Exception e)
{
return(SaveStatus.Failure);
}
}
/// <summary>
/// Check the Login Credentials of the user
/// </summary>
/// <param name="loginInput"></param>
/// <returns></returns>
public async Task <LoginODTO> Login(LoginIDTO loginInput)
{
try
{
using (IDbConnection conn = Connection)
{
//Replace with stored procedure
string sQuery = "SELECT FirstName,LastName,UserID ,Email,NEWID() AS Token FROM UserDetails WHERE Email = @Email AND Password=@Password";
conn.Open();
var result = await conn.QueryFirstOrDefaultAsync <LoginODTO>(sQuery, new { Email = loginInput.Email, Password = EncodeDecodeBase64.Base64Encode(loginInput.Password) });
return(result);
}
}
catch (Exception e)
{
return(null);
}
}
