public List <sp_GetAllChannelsAndAlerts_Result> GetAllChannelAndAlerts(int daId)
{
try
{
IGenericDataRepository <sp_GetAllChannelsAndAlerts_Result> repository = new GenericDataRepository <sp_GetAllChannelsAndAlerts_Result>();
return(repository.ExecuteStoredProcedure("EXEC sp_GetAllChannelsAndAlerts @DAId", new SqlParameter("DAId", SqlDbType.Int)
{
Value = daId
}).ToList());
}
catch (Exception)
{
throw;
}
}
public List <sp_GetMappingViewModelData_Result> GetMappingViewModelData(int daId)
{
try
{
IGenericDataRepository <sp_GetMappingViewModelData_Result> repository = new GenericDataRepository <sp_GetMappingViewModelData_Result>();
return(repository.ExecuteStoredProcedure("EXEC sp_GetMappingViewModelData @DAID", new SqlParameter("DAID", SqlDbType.Int)
{
Value = daId
}).ToList());
}
catch (Exception)
{
throw;
}
}
public IList <sp_GetUsersToAuthorize_Result> GetAllUsersToAuthorize(int AuthID)
{
try
{
IGenericDataRepository <sp_GetUsersToAuthorize_Result> repository = new GenericDataRepository <sp_GetUsersToAuthorize_Result>();
return(repository.ExecuteStoredProcedure("EXEC sp_GetUsersToAuthorize @AuthId", new SqlParameter("AuthID", SqlDbType.Int)
{
Value = AuthID
}).ToList());
}
catch (Exception)
{
throw;
}
}
public IList <sp_GetInterfaceMapping_Result> GetInterfaceData(int daId)
{
try
{
IGenericDataRepository <sp_GetInterfaceMapping_Result> repository = new GenericDataRepository <sp_GetInterfaceMapping_Result>();
return(repository.ExecuteStoredProcedure("EXEC sp_GetInterfaceMapping @daId", new SqlParameter("daId", SqlDbType.Int)
{
Value = daId
}).ToList());
}
catch (Exception)
{
throw;
}
}
public List <sp_GetAllBusinessRules_Result> GetBusinessRules(int daId)
{
try
{
IGenericDataRepository <sp_GetAllBusinessRules_Result> repository = new GenericDataRepository <sp_GetAllBusinessRules_Result>();
return(repository.ExecuteStoredProcedure("EXEC sp_GetAllBusinessRules @daId", new SqlParameter("daId", SqlDbType.Int)
{
Value = daId
}).ToList());
}
catch (Exception)
{
throw;
}
}
public IList <sp_GetAuthorizers_Result> GetAdminUsersToAuthorize(string userrole, int userid)
{
try
{
IGenericDataRepository <sp_GetAuthorizers_Result> repository = new GenericDataRepository <sp_GetAuthorizers_Result>();
return(repository.ExecuteStoredProcedure("EXEC sp_GetAuthorizers @RoleName, @UserID ", new SqlParameter("RoleName", SqlDbType.VarChar)
{
Value = userrole
}, new SqlParameter("UserID", SqlDbType.Int)
{
Value = userid
}).ToList());
}
catch (Exception)
{
throw;
}
}
public IList <sp_GetUserAccessInView_Result> GetUserViewAccessPermissions(string screenname, int roleid)
{
try
{
IGenericDataRepository <sp_GetUserAccessInView_Result> repository = new GenericDataRepository <sp_GetUserAccessInView_Result>();
return(repository.ExecuteStoredProcedure("EXEC sp_GetUserAccessInView @ScreenName, @RoleID ", new SqlParameter("ScreenName", SqlDbType.VarChar)
{
Value = screenname
}, new SqlParameter("RoleID", SqlDbType.Int)
{
Value = roleid
}).ToList());
}
catch (Exception)
{
throw;
}
}