public async Task <bool> CheckDisplayNameAlreadyUsed(Logic.Interfaces.IConnectionUtility connectionUtility, string displayName)
{
var totalusers = await Logic.DB.DBUtility.GetScalar <int>(connectionUtility, "Select COUNT(1) From students Where student_display_name = @displayName AND is_deleted = 0",
new Dictionary <string, object> {
{ "displayName", displayName }
});
if (totalusers > 0)
{
return(true);
}
return(false);
}
public async Task <bool> CheckEmailAlreadyRegistered(Logic.Interfaces.IConnectionUtility connectionUtility, string emailAddressToCheck)
{
var totalusers = await Logic.DB.DBUtility.GetScalar <int>(connectionUtility, @"Select COUNT(1) From students Where student_email = @email AND is_deleted = 0",
new Dictionary <string, object> {
{ "email", emailAddressToCheck }
});
if (totalusers > 0)
{
return(true);
}
return(false);
}
public CreateAccountController(ILogger <CreateAccountController> logger, Logic.DB.StudentDBConnectionUtility connectionUtility)
{
_logger = logger;
_connectionUtility = connectionUtility;
}
