//-----------------------------------
DataSet IAdminRepository.loadUserGroups(int userId, int applicationId)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = adminSchema + ".[Security.GroupsForm.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@ApplicationId", ParameterType.DBString, applicationId));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBString, userId));
ret = storedProcedure.ExecuteResourceDataSet();
return(ret);
}
//------------------------------------
void IAdminRepository.SaveGroupResources(DataTable resourcesToSave, Int32 userID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = adminSchema + ".[Security.GroupsResource.Save]";
//rguidi 3/4/2013 #20202
//storedProcedure.Parameters.Add(new StoredProcedureParameter("@GroupsResourceTypes", ParameterType.DBString, resourcesToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@GroupsResourceTypes", ParameterType.Structured, resourcesToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBString, userID));
ret = storedProcedure.ExecuteResourceDataSet();
}
void IUserRepository.saveUserForm(DataTable userToSave, Int32 userID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Security.UsersForm.Save]";
//rguidi 3/4/2013 #20202
//storedProcedure.Parameters.Add(new StoredProcedureParameter("@Users", ParameterType.DBString, userToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@Users", ParameterType.Structured, userToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
ret = storedProcedure.ExecuteResourceDataSet();
}
