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()); }