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