public async Task <IEnumerable <ChannelModel> > GetAllChannelsAsync()
{
string storedProcedure = "dbo.Channels_Get_All";
return(await _dataGateway.LoadData <ChannelModel, dynamic>(storedProcedure,
new { },
_connectionString.SqlConnectionString));
}
public async Task <IEnumerable <ScopeModel> > GetAllScopes()
{
string storedProcedure = "dbo.Scope_Get_All";
return(await _dataGateway.LoadData <ScopeModel, dynamic>(storedProcedure,
new { },
_connectionString.SqlConnectionString));
}
public async Task <IEnumerable <AccessPolicyPairingModel> > GetAllAccessPoliciesPairings()
{
string storedProcedure = "dbo.AccessPolicyPairing_Get_All";
return(await _dataGateway.LoadData <AccessPolicyPairingModel, dynamic>(storedProcedure,
new { },
_connectionString.SqlConnectionString));
}
public async Task <IEnumerable <UserAccountSettingsModel> > GetAllSettings()
{
var storedProcedure = "dbo.UserAccountSettings_Get_All";
return(await _dataGateway.LoadData <UserAccountSettingsModel, dynamic>(storedProcedure,
new { },
_connectionString.SqlConnectionString));
}
public async Task <IEnumerable <FriendsListJunctionModel> > GetAllUserFriendBlocks(int userId)
{
string storedProcedure = "dbo.FriendBlockList_GetAll_ByUserId";
return(await _dataGateway.LoadData <FriendsListJunctionModel, dynamic>(storedProcedure,
new
{
UserId = userId
},
_connectionString.SqlConnectionString));
}
public async Task <IEnumerable <LoginAttemptsModel> > GetAllLoginAttempts()
{
try
{
string storedProcedure = "dbo.LoginAttempts_Get_All";
return(await _dataGateway.LoadData <LoginAttemptsModel, dynamic>(storedProcedure,
new { },
_connectionString.SqlConnectionString));
}
catch (SqlCustomException e)
{
throw new SqlCustomException(e.Message, e.InnerException);
}
}
public async Task <IEnumerable <UserAccountCodeModel> > GetAllUserAccountCodes()
{
try
{
var storedProcedure = "dbo.UserAccountCode_Get_All";
return(await _dataGateway.LoadData <UserAccountCodeModel, dynamic>(storedProcedure,
new { },
_connectionString.SqlConnectionString));
}
catch (SqlCustomException e)
{
throw new SqlCustomException(e.Message, e.InnerException);
}
}
public async Task <IEnumerable <DALLoginTrackerModel> > GetAllLogins()
{
string storedProcedure = "dbo.LoginTracker_GetALL";
return(await _dataGateway.LoadData <DALLoginTrackerModel, dynamic>(storedProcedure,
new { },
_connectionString.SqlConnectionString));
}
// doesnt like the star change it.
public async Task <IEnumerable <DALListingModel> > GetAllListings()
{
string storedProcedure = "dbo.ListingSearch_GetAllListings";
return(await _dataGateway.LoadData <DALListingModel, dynamic>(storedProcedure,
new { },
_connectionString.SqlConnectionString));
}
public async Task <IEnumerable <UserReportsModel> > GetAllReports()
{
string storedProcedure = "dbo.UserReports_GetAll";
return(await _dataGateway.LoadData <UserReportsModel, dynamic>(storedProcedure,
new
{
},
_connectionString.SqlConnectionString));
}
public async Task <string> GetStatusTokenByUserId(int userId)
{
try
{
var storedProcedure = "dbo.AccountVerification_GetStatusToken_ByUserId";
var row = await _dataGateway.LoadData <string, dynamic>(storedProcedure,
new
{
UserId = userId
},
_connectionString.SqlConnectionString);
return(row.FirstOrDefault());
}
catch (SqlCustomException e)
{
throw new SqlCustomException(e.Message, e.InnerException);
}
}
public async Task <DALCollaborationModel> GetListing(int id)
{
var query = "Select * from Collaboration where Id = @Id";
var row = await _dataGateway.LoadData <DALCollaborationModel, dynamic>(query,
new
{
ID = id
},
_connectionString.SqlConnectionString);
return(row.FirstOrDefault());
}
