public SQLFileAccessOperations(string connectionString, string tableName, SQLFileAccessInfo rule, int rootNodeId = 1)
{
connectionStr = connectionString;
AccessRules = rule;
TableName = tableName;
RootNode = rootNodeId;
Connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionString].ConnectionString;
Connection.Open();
operation = new SQLFileExplorerOperations(connectionString, tableName);
}
public SQLFileAccessInfo SQLGetRules()
{
SQLFileAccessInfo rules = new SQLFileAccessInfo();
SqlDataReader myReader = null;
string connectionString = "FileExplorerConnection";
SqlConnection Connection = new SqlConnection();
Connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionString].ConnectionString;
Connection.Open();
SqlCommand myCommand = new SqlCommand("select * from Permission", Connection);
myReader = myCommand.ExecuteReader();
List <SQLAccessRule> datas = new List <SQLAccessRule>();
while (myReader.Read())
{
SQLAccessRule data = new SQLAccessRule();
data.Copy = (Permission)Enum.Parse(typeof(Permission), myReader["Copy"].ToString(), true);
if (!string.IsNullOrEmpty(myReader["Download"].ToString()))
{
data.Download = (Permission)Enum.Parse(typeof(Permission), myReader["Download"].ToString(), true);
}
data.Edit = (Permission)Enum.Parse(typeof(Permission), myReader["Edit"].ToString(), true);
data.Read = (Permission)Enum.Parse(typeof(Permission), myReader["Read"].ToString(), true);
if (!string.IsNullOrEmpty(myReader["EditContents"].ToString()))
{
data.EditContents = (Permission)Enum.Parse(typeof(Permission), myReader["EditContents"].ToString(), true);
}
if (!string.IsNullOrEmpty(myReader["Upload"].ToString()))
{
data.Upload = (Permission)Enum.Parse(typeof(Permission), myReader["Upload"].ToString(), true);
}
data.Path = myReader["Path"].ToString();
data.Role = myReader["Role"].ToString();
datas.Add(data);
}
rules.Rules = datas;
rules.Role = Session["Role"].ToString();
if (isLocal)
{
rules.RootPath = "~/localFolder/";
}
else
{
rules.RootPath = "~/Products/";
}
return(rules);
}
