//====================== public static List <TestItemGroup> GetByTestType(TestType testType) { string cmdText = @" select * from Checksum_Config_ItemGroup where ID in (select GroupID from Checksum_Config_TestType_Groups where TestTypeID = @testTypeID:int)" ; List <TestItemGroup> list = new List <TestItemGroup>(); using (DataManager.Current.OpenConnection()) { SqlCommand cmd = DataManager.CreateCommand(cmdText); cmd.Parameters["@testTypeID"].Value = testType.ID; using (ThingReader <TestItemGroup> reader = new ThingReader <TestItemGroup>(cmd.ExecuteReader())) { while (reader.Read()) { list.Add(reader.Current); } } } return(list); }
//====================== public static List <TestItemDefinition> GetByGroup(TestItemGroup group) { string cmdText = @" select * from Checksum_Config_TestDefinition where DefinitionID in (select DefinitionID from Checksum_Config_ItemGroup_Definitions where GroupID = @groupID:int)" ; List <TestItemDefinition> list = new List <TestItemDefinition>(); using (DataManager.Current.OpenConnection()) { SqlCommand cmd = DataManager.CreateCommand(cmdText); cmd.Parameters["@groupID"].Value = flow.ID; using (ThingReader <TestItemDefinition> reader = new ThingReader <TestItemDefinition>(cmd.ExecuteReader(), new ThingTranslation[] { new ThingTranslation(fields => group, "GroupID") })) { while (reader.Read()) { list.Add(reader.Current); } } } return(list); }
public Dictionary <int, List <CalculatedPermission> > GetCalculatedPermissions(int ID) //TODO: CHANGE TO GET { int currentUser; ThingReader <CalculatedPermission> calculatedPermissionReader; currentUser = ID; Dictionary <int, List <CalculatedPermission> > calculatedPermissionDic = new Dictionary <int, List <CalculatedPermission> >(); using (SqlConnection conn = new SqlConnection(AppSettings.GetConnectionString("Easynet.Edge.Core.Data.DataManager.Connection", "String"))) { SqlCommand sqlCommand = DataManager.CreateCommand("User_CalculatePermissions(@UserID:Int)", CommandType.StoredProcedure); sqlCommand.Connection = conn; sqlCommand.Connection.Open(); sqlCommand.Parameters["@UserID"].Value = currentUser; calculatedPermissionReader = new ThingReader <CalculatedPermission>(sqlCommand.ExecuteReader(), null); while (calculatedPermissionReader.Read()) { if (!calculatedPermissionDic.ContainsKey(calculatedPermissionReader.Current.AccountID)) { calculatedPermissionDic.Add(calculatedPermissionReader.Current.AccountID, new List <CalculatedPermission>()); } calculatedPermissionDic[calculatedPermissionReader.Current.AccountID].Add(calculatedPermissionReader.Current); } } return(calculatedPermissionDic); }
public static Test GetByID(int testID) { const string SELECT = "select * from Checksum_Data_Test where TestID = @testID:int"; using (DataManager.Current.OpenConnection()) { SqlCommand cmd = DataManager.CreateCommand(SELECT); cmd.Parameters["@testID"].Value = testID; using (ThingReader <Test> reader = new ThingReader <Test>(cmd.ExecuteReader)) { return(reader.Read() ? reader.Current : null); } } }
public bool GetSpecificPermissionValue(PermissionRequest permissionRequest) { bool hasPermission = false; try { int currentUser; ThingReader <CalculatedPermission> calculatedPermissionReader; currentUser = System.Convert.ToInt32(OperationContext.Current.IncomingMessageProperties["edge-user-id"]); List <CalculatedPermission> calculatedPermissionList = new List <CalculatedPermission>(); using (DataManager.Current.OpenConnection()) { SqlCommand sqlCommand = DataManager.CreateCommand("User_CalculatePermissions(@UserID:Int)", CommandType.StoredProcedure); sqlCommand.Parameters["@UserID"].Value = currentUser; calculatedPermissionReader = new ThingReader <CalculatedPermission>(sqlCommand.ExecuteReader(), null); while (calculatedPermissionReader.Read()) { calculatedPermissionList.Add(calculatedPermissionReader.Current); } calculatedPermissionReader.Dispose(); } if (calculatedPermissionList != null && calculatedPermissionList.Count > 0) { if (string.IsNullOrEmpty(permissionRequest.Path)) { if (calculatedPermissionList.Count > 0) { CalculatedPermission calculatedPermissions = calculatedPermissionList.Find(calculatedPermission => calculatedPermission.AccountID == permissionRequest.AccountID); if (calculatedPermissions != null) { hasPermission = true; } } } else { CalculatedPermission calculatedPermissions = calculatedPermissionList.Find(calculatedPermission => calculatedPermission.AccountID == permissionRequest.AccountID && calculatedPermission.Path.Trim().ToUpper() == permissionRequest.Path.Trim().ToUpper()); if (calculatedPermissions != null) { hasPermission = true; } } } } catch (Exception ex) { ErrorMessageInterceptor.ThrowError(HttpStatusCode.InternalServerError, ex.Message); } return(hasPermission); }
public bool GetSpecificPermissionValue(PermissionRequest permissionRequest) //TODO: CHANGE TO GET { bool hasPermission = false; int currentUser; ThingReader <CalculatedPermission> calculatedPermissionReader; currentUser = System.Convert.ToInt32(CurrentContext.Request.Headers["edge-user-id"]); List <CalculatedPermission> calculatedPermissionList = new List <CalculatedPermission>(); using (SqlConnection conn = new SqlConnection(AppSettings.GetConnectionString("Easynet.Edge.Core.Data.DataManager.Connection", "String"))) { SqlCommand sqlCommand = DataManager.CreateCommand("User_CalculatePermissions(@UserID:Int)", CommandType.StoredProcedure); sqlCommand.Connection = conn; conn.Open(); sqlCommand.Parameters["@UserID"].Value = currentUser; calculatedPermissionReader = new ThingReader <CalculatedPermission>(sqlCommand.ExecuteReader(), null); while (calculatedPermissionReader.Read()) { calculatedPermissionList.Add(calculatedPermissionReader.Current); } calculatedPermissionReader.Dispose(); } if (calculatedPermissionList != null && calculatedPermissionList.Count > 0) { if (string.IsNullOrEmpty(permissionRequest.Path)) { if (calculatedPermissionList.Count > 0) { CalculatedPermission calculatedPermissions = calculatedPermissionList.Find(calculatedPermission => calculatedPermission.AccountID == permissionRequest.AccountID); if (calculatedPermissions != null) { hasPermission = true; } } } else { CalculatedPermission calculatedPermissions = calculatedPermissionList.Find(calculatedPermission => calculatedPermission.AccountID == permissionRequest.AccountID && calculatedPermission.Path.Trim().ToUpper() == permissionRequest.Path.Trim().ToUpper()); if (calculatedPermissions != null) { hasPermission = true; } } } return(hasPermission); }
//====================== public static TestType GetByID(int id) { string cmdText = "select * from Checksum_Config_TestType where TestTypeID = @id:int"; using (DataManager.Current.OpenConnection()) { SqlCommand cmd = DataManager.CreateCommand(cmdText); cmd.Parameters["@id"].Value = id; using (ThingReader <TestType> reader = new ThingReader <TestType>(cmd.ExecuteReader())) { if (reader.Read()) { return(reader.Current); } else { return(null); } } } }
public List <Group> GetUserAssociateGroups(string ID) { List <Group> associateGroups = new List <Group>(); using (DataManager.Current.OpenConnection()) { SqlCommand sqlCommand = DataManager.CreateCommand(@"SELECT DISTINCT T0.GroupID ,T1.Name FROM User_GUI_UserGroupUser T0 INNER JOIN User_GUI_UserGroup T1 ON T0.GroupID=T1.GroupID WHERE T0.UserID=@UserID:Int" ); sqlCommand.Parameters["@UserID"].Value = int.Parse(ID); using (ThingReader <Group> thingReader = new ThingReader <Group>(sqlCommand.ExecuteReader(), null)) { while (thingReader.Read()) { associateGroups.Add((Group)thingReader.Current); } } } return(associateGroups); }