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