private bool doViewReportsWithSubElements(contentManagerService1 cCMS, ref List<CogObject> reports, string cogVersion, string baseReportPath)
{
if (cCMS == null)
{
reports = null;
return false;
}
// Declare query properties array for report
propEnum[] reportProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString, propEnum.creationTime,
propEnum.metadataModelPackage, propEnum.ancestors, propEnum.disabled};
// Declare properties to retrieve for package object internal to report object
refProp packageProps = new refProp();
packageProps.refPropName = propEnum.metadataModelPackage;
packageProps.properties = new propEnum[] { propEnum.searchPath, propEnum.storeID,
propEnum.defaultName, propEnum.disabled,
propEnum.ancestors };
// Declare sort properties for reports and users
//reports
sort[] reportSort = new sort[] { new sort() };
reportSort[0].order = orderEnum.ascending;
reportSort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps= new refProp[] { packageProps };
// Declare search path for reports and for a single user, based on CAMID
searchPathMultipleObject reportsPath = new searchPathMultipleObject();
searchPathMultipleObject userPath = new searchPathMultipleObject();
//Set search paths to get reports. Userpath must be set
//separately for each individual based on CAMID
reportsPath.Value = "/content//report";
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(reportsPath, reportProps, reportSort, qo);
if (bc.Length > 0)
{
foreach (baseClass report_item in bc)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.report report = (cognosdotnet_2_0.report)report_item;
CogObject rpt = new CogObject();
rpt.ID = report_item.storeID.value.Value;
rpt.AddAttribute("ID", rpt.ID);
rpt.AddAttribute("Name", report_item.defaultName.value);
rpt.AddAttribute("CreationTime", report_item.creationTime.value.ToString());
rpt.AddAttribute("Type", "Report");
rpt.AddAttribute("Disabled", report.disabled.value.ToString());
// Make sure package or model is not null
if (report.metadataModelPackage.value!= null)
{
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)report.metadataModelPackage.value[0];
rpt.AddAttribute("Package_Path", report.metadataModelPackage.value[0].searchPath.value);
rpt.AddAttribute("Package_Name", getPackageName(rpt.getAttributeValue("Package_Path")));
rpt.AddAttribute("Package_Disabled", package.disabled.value.ToString());
}
else
{
rpt.AddAttribute("Package_Path", "null");
rpt.AddAttribute("Package_Name", "null");
rpt.AddAttribute("Package_Disabled", "null");
}
// Make sure owner is not null
if (report_item.owner.value != null)
{
getUserAccount(cCMS, report_item.owner.value[0].searchPath.value, ref rpt);
rpt.AddAttribute("Author_CAMID", report_item.owner.value[0].searchPath.value);
}
else
{
rpt.AddAttribute("Author_CAMID", "Unknown");
}
String version = cogVersion;
rpt.AddAttribute("Version", cogVersion);
rpt.AddAttribute("Path", report_item.searchPath.value);
rpt.AddAttribute("URL", baseReportPath + report_item.searchPath.value);
getSubElements(cCMS, report_item.searchPath.value, ref rpt);
/* This gets some limited auditing information. Most of this can be found
* more easily in the Raw Usage report of the Business Intelligence Dashboard
* package on perform-dev.tyson.com. Uncommenting the following line will
* cause a dramatic increase in runtime for this program
*/
//getAuditInfo(ref cog);
reports.Add(rpt);
}
}
else
{
reports = null;
}
return true;
}
static void DoSort(int[] arr, sort methodSort)
{
// сортировка неупорядоченного массива
Console.WriteLine("Несортированный массив: " + String.Join(", ", arr));
countChange = 0; // обнуление счетчиков операций
countCompare = 0; // и времени
int[] sortArr = methodSort(arr);
Console.WriteLine("\nОтсортированный неупорядоченный массив: " + String.Join(", ", sortArr));
Console.WriteLine("Затрачено {0} сравнений, {1} перессылок",
countCompare, countChange);
// сортировка упорядоченного по возрастанию массива
countChange = 0; // обнуление счетчиков операций
countCompare = 0; // и времени
int[] sortSortedUpArr = methodSort(sortArr);
Console.WriteLine("\nОтсортированный упорядоченный по возрастанию массив: " + String.Join(", ", sortSortedUpArr));
Console.WriteLine("Затрачено {0} сравнений, {1} перессылок",
countCompare, countChange);
Array.Reverse(sortArr);
countChange = 0; // обнуление счетчиков операций
countCompare = 0; // и времени
int[] sortSortedDownArr = methodSort(sortArr);
Console.WriteLine("\nОтсортированный упорядоченный по убыванию массив: " + String.Join(", ", sortSortedDownArr));
Console.WriteLine("Затрачено {0} сравнений, {1} перессылок",
countCompare, countChange);
}
public static int[] BubleSort(int[] arr, sort a)
{
for (int i = 0; i < arr.Length; i++)
{
for (int j = 0; j < arr.Length - i - 1; j++)
{
if (a == "increace")
{
if (arr[j] > arr[j + 1])
{
var swap = arr[j];
arr[j] = arr[j + 1];
arr[j + 1] = swap;
}
}
if (a = "decrease")
{
if (arr[j] < arr[j + 1])
{
var swap = arr[j];
arr[j] = arr[j + 1];
arr[j + 1] = swap;
}
}
}
}
return(arr);
}
private static void Main()
{
var scs = new sort(SimpleChoiseSort);
var msd = new sort(RadixSort);
while (true)
{
var length = Ask.Num("Введите длину массива: ");
var arr = Generate(length); // генерация массива
Console.WriteLine(String.Join(", ", arr)); // выписать массив
var simple = (int[])arr.Clone();
var radix = (int[])arr.Clone();
// несортированный массив
Try(simple, scs);
Try(radix, msd);
// сортированный массив
Try(simple, scs);
Try(radix, msd);
// развернуть
Array.Reverse(simple);
Array.Reverse(radix);
// сортированный в обратном порядке
Try(simple, scs);
Try(radix, msd);
OC.Stay();
}
}
public List <JsonLocalization> GetAll(pagination pagination, sort sort, string search, string search_operator, string filter)
{
dynamic searchFilter = string.Empty;
var operater = string.IsNullOrEmpty(search_operator) ? null : JObject.Parse(search_operator);
var templocalization = localization.AsEnumerable();
if (!string.IsNullOrEmpty(search) && search.Length > 2)
{
searchFilter = JObject.Parse(search);
foreach (var _search in searchFilter)
{
if (!object.ReferenceEquals(null, _search.Value) && !string.IsNullOrEmpty(_search.Value.ToString()))
{
switch ((string)_search.Name)
{
case "Resource":
templocalization = templocalization.Where(a => a.Key.Contains(_search.Value.ToString()));
break;
//case "Arabic":
// templocalization = templocalization.//Where(a => a.LocalizedValue.Contains(_search.Value.ToString()));//Contains(_search.Value.ToString())
// break;
//case "English":
// break;
}
}
}
}
return(templocalization.ToList());
}
private static void Merge(process[] input, int low, int middle, int high, sort type)
{
int left = low;
int right = middle + 1;
process[] tmp = new process[(high - low) + 1];
int tmpIndex = 0;
while ((left <= middle) && (right <= high))
{
if ((input[left].arrivalTime < input[right].arrivalTime) && type == sort.arrivalTime)
{
tmp[tmpIndex] = input[left];
left = left + 1;
}
else if ((input[left].priority < input[right].priority) && type == sort.priority)
{
tmp[tmpIndex] = input[left];
left = left + 1;
}
else if ((input[left].index < input[right].index) && type == sort.index)
{
tmp[tmpIndex] = input[left];
left = left + 1;
}
else
{
tmp[tmpIndex] = input[right];
right = right + 1;
}
tmpIndex = tmpIndex + 1;
}
if (left <= middle)
{
while (left <= middle)
{
tmp[tmpIndex] = input[left];
left = left + 1;
tmpIndex = tmpIndex + 1;
}
}
if (right <= high)
{
while (right <= high)
{
tmp[tmpIndex] = input[right];
right = right + 1;
tmpIndex = tmpIndex + 1;
}
}
for (int i = 0; i < tmp.Length; i++)
{
input[low + i] = tmp[i];
}
}
public static void SortMerge(process[] input, int low, int high, sort type)
{
if (low < high)
{
int middle = (low / 2) + (high / 2);
SortMerge(input, low, middle, type);
SortMerge(input, middle + 1, high, type);
Merge(input, low, middle, high, type);
}
}
public void sorted(DienThoai[] list, sort cmp)
{
for (int i = 0; i < list.Length - 1; i++)
{
for (int j = i + 1; j < list.Length; j++)
{
if (cmp(list[i], list[j]))
{
DienThoai t = list[i];
list[i] = list[j];
list[j] = t;
}
}
}
}
static void Main(string[] args)
{
int IComparable.CompareTo(object obj)
{
sort s = (sort)obj;
return(String.Compare(this.make, s.make));
}
Shuffle myShuffle = new Shuffle();
foreach (Shuffle s in myShuffle.Cards)
{
Console.WriteLine(s);
}
}
static void Try(int[] arr, sort method)
{
var time = Stopwatch.StartNew(); // подготовка:
countChange = 0; // обнуление счетчиков операций
countEqual = 0; // и времени
Console.WriteLine();
Console.WriteLine("Массив:");
Console.WriteLine(String.Join(", ", arr));
Console.WriteLine("Результат: ");
method(arr); // сортируем тута
Console.WriteLine(String.Join(", ", arr));
Console.WriteLine("Затрачено {0} тиков, {1} сравнений, {2} перессылок",
time.ElapsedTicks, countEqual, countChange);
time.Reset();
}
public static void SortDetection(int[] arr, sort a)
{
int res = 0;
for (int i = 0; i < arr.Length - 1; i++)
{
if (a == "increase")
{
if (arr[i] > arr[i + 1])
{
res = 1;
}
else
{
res = 2;
break;
}
}
if (a == "decrease")
{
if (arr[i] < arr[i + 1])
{
res = 1;
}
else
{
res = 2;
break;
}
}
}
if (res == 2)
{
Console.WriteLine("Array is sorted");
}
else
{
Console.WriteLine("Array is unsorted");
}
}
private bool doViewQueriesWithSubElements(contentManagerService1 cCMS, ref List<CogObject> queries, string cogVersion, string baseQueryPath)
{
if (cCMS == null)
{
queries = null;
return false;
}
//queries
propEnum[] queryProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString, propEnum.creationTime,
propEnum.metadataModelPackage, propEnum.ancestors, propEnum.disabled};
// Declare properties to retrieve for package object internal to report object
refProp packageProps = new refProp();
packageProps.refPropName = propEnum.metadataModelPackage;
packageProps.properties = new propEnum[] { propEnum.searchPath, propEnum.storeID,
propEnum.defaultName, propEnum.disabled,
propEnum.ancestors };
//queries
sort[] querySort = new sort[] { new sort() };
querySort[0].order = orderEnum.ascending;
querySort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { packageProps };
searchPathMultipleObject userPath = new searchPathMultipleObject();
searchPathMultipleObject queriesPath = new searchPathMultipleObject();
queriesPath.Value = "/content//query";
// Make call to get all queries. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcQueries = cCMS.query(queriesPath, queryProps, querySort, qo);
if (bcQueries.Length > 0)
{
foreach (baseClass query_item in bcQueries)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)query_item;
CogObject qry = new CogObject();
qry.ID = query_item.storeID.value.Value;
qry.AddAttribute("ID", qry.ID);
qry.AddAttribute("Name", query_item.defaultName.value);
qry.AddAttribute("CreationTime", query_item.creationTime.value.ToString());
qry.AddAttribute("Type", "Query");
qry.AddAttribute("Disabled", query.disabled.value.ToString());
// Make sure package or package is not null
if (query.metadataModelPackage.value != null)
{
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)query.metadataModelPackage.value[0];
qry.AddAttribute("Package_Path", query.metadataModelPackage.value[0].searchPath.value);
qry.AddAttribute("Package_Name", getPackageName(qry.getAttributeValue("Package_Path")));
qry.AddAttribute("Package_Disabled", package.disabled.value.ToString());
}
else
{
qry.AddAttribute("Package_Path", "null");
qry.AddAttribute("Package_Name", "null");
qry.AddAttribute("Package_Disabled", "null");
}
// Make sure owner is not null
if (query_item.owner.value != null)
{
getUserAccount(cCMS, query_item.owner.value[0].searchPath.value, ref qry);
qry.AddAttribute("Author_CAMID", query_item.owner.value[0].searchPath.value);
}
else
{
qry.AddAttribute("Author_CAMID", "Unknown");
}
qry.AddAttribute("Version", cogVersion);
qry.AddAttribute("Path", query_item.searchPath.value);
qry.AddAttribute("URL", baseQueryPath + query_item.searchPath.value);
getSubElements(cCMS, query_item.searchPath.value, ref qry);
/* This gets some limited auditing information. Most of this can be found
* more easily in the Raw Usage report of the Business Intelligence Dashboard
* package on perform-dev.tyson.com. Uncommenting the following line will
* cause a dramatic increase in runtime for this program
*/
//getAuditInfo(ref cog);
queries.Add(qry);
}
}
else
{
queries = null;
}
return true;
}
static void Main(string[] args)//主程序
{
#region 使用递归
string n = "从0到";
string j = "0";
Console.Write("您想从0输出到:");
j = Console.ReadLine();
Console.WriteLine("开始输入");
Console.WriteLine("从0到{0}:{1}", j, recursion(n));
#endregion
#region 排序
sort data = new sort();
Console.WriteLine("请输入编号，姓名，年龄，学号。之间用回车间隔。");
data.saves(Console.ReadLine(), Console.ReadLine(), Console.ReadLine(), Console.ReadLine());
Console.WriteLine("是否想查看数据?如果是请输入y，如果否请输入n");
string pd = Console.ReadLine();
if (pd == "y")
{
data.forout(data.allsave, 0);
}
Console.WriteLine("是否进行排序？如果是，请输入想按照编号、姓名、年龄还是学号排序，并选择逆序还是顺序排序。输入格式例：姓名+逆序 如果不想排序请输入n");
#region 选择排序方式
string choose = Console.ReadLine();
switch (choose)
{
case "编号+顺序":
data.usesort(data.allsave, 0);
data.forout(data.allsave, 0);
break;
case "姓名+顺序":
data.usesort(data.allsave, 1);
data.forout(data.allsave, 0);
break;
case "年龄+顺序":
data.usesort(data.allsave, 2);
data.forout(data.allsave, 0);
break;
case "学号+顺序":
data.usesort(data.allsave, 3);
data.forout(data.allsave, 0);
break;
case "编号+逆序":
data.usesort(data.allsave, 0);
data.forout(data.allsave, data.nowjs);
break;
case "姓名+逆序":
data.usesort(data.allsave, 1);
data.forout(data.allsave, data.nowjs);
break;
case "年龄+逆序":
data.usesort(data.allsave, 2);
data.forout(data.allsave, data.nowjs);
break;
case "学号+逆序":
data.usesort(data.allsave, 3);
data.forout(data.allsave, data.nowjs);
break;
}
#endregion
}
/**
* Method to take in a list of paths to cognos objects and disable them.
* pwnsauce...
*/
public void disableCogObjects()
{
System.IO.TextReader reader = new StreamReader("objectsToDisable.txt");
StreamWriter errorWriter = new StreamWriter("objectsNotFoundC8.txt");
StreamWriter successWriter = new StreamWriter("objectsFoundC8.txt");
// Declare query properties array for report
propEnum[] props = new propEnum[] { propEnum.defaultName, propEnum.disabled,
propEnum.searchPath};
// Declare sort properties for reports and users
//reports
sort[] sorts = new sort[] { };
// Object representing path to single report
searchPathMultipleObject reportSearchPath = new searchPathMultipleObject();
// Query options
queryOptions qo = new queryOptions();
// Read in first path
string path = reader.ReadLine();
List<baseClass> objectsToDisable = new List<baseClass>();
// Loop through all the paths and generate a list of objects
// to disable
while (path != null)
{
reportSearchPath.Value = path;
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
try
{
baseClass[] bc = cCMS.query(reportSearchPath, props, sorts, qo);
if (bc.Length > 0)
{
booleanProp bp = new booleanProp();
bp.value = true;
bc[0].disabled = bp;
// Add the object to our List of things to disable
objectsToDisable.Add(bc[0]);
successWriter.WriteLine(path);
}
else
{
errorWriter.WriteLine(path);
}
}
// The exception will simply say "The client did something wrong"
// if the path line from the file is nothing resembling a path in the current
// cognos environment
catch (Exception e)
{
errorWriter.WriteLine(path);
}
path = reader.ReadLine();
}
reader.Close();
errorWriter.Close();
successWriter.Close();
updateOptions updateOptions = new updateOptions();
cCMS.update(objectsToDisable.ToArray(), updateOptions);
}
private bool doViewObjectsByPackage(contentManagerService1 cCMS, ref List<CogObject> packages, string cogVersion, string basePackagePath)
{
if (cCMS == null)
{
packages = null;
return false;
}
// Same query options used for all calls
queryOptions qo = new queryOptions();
//queries
propEnum[] packageProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString,
propEnum.metadataModelPackage, propEnum.policies, propEnum.ancestors};
//queries
sort[] pkgSort = new sort[] { new sort() };
pkgSort[0].order = orderEnum.ascending;
pkgSort[0].propName = propEnum.defaultName;
searchPathMultipleObject packagesPath = new searchPathMultipleObject();
packagesPath.Value = "/content//package";
// Make call to get all queries. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcPackages = cCMS.query(packagesPath, packageProps, pkgSort, qo);
if (bcPackages.Length > 0)
{
foreach (baseClass package_item in bcPackages)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)package_item;
CogObject pkg = new CogObject();
pkg.ID = package_item.storeID.value.Value;
pkg.AddAttribute("ID", pkg.ID);
pkg.AddAttribute("Name", package_item.defaultName.value);
pkg.AddAttribute("Type", "Package");
addSecurityPolicies(ref pkg, package_item);
if (package_item.owner.value != null)
{
getUserAccount(cCMS, package_item.owner.value[0].searchPath.value, ref pkg);
pkg.AddAttribute("Author_CAMID", package_item.owner.value[0].searchPath.value);
}
else
{
pkg.AddAttribute("Author_CAMID", "Unknown");
}
pkg.AddAttribute("Version", cogVersion);
pkg.AddAttribute("URL", basePackagePath + package_item.searchPath.value);
/* Run another query to retrieve all reports for given package based on package path
*/
List<CogObject> children = new List<CogObject>();
getObjectsForPackage(cCMS, ref children, cogVersion, basePackagePath, package_item.searchPath.value +
"//report | " + package_item.searchPath.value + "//query | " +
package_item.searchPath.value + "//reportView");
pkg.addSubElements(children);
packages.Add(pkg);
}
}
else
{
packages = null;
}
return true;
}
/// <summery> /// Search users and pages with keyword /// /// <typeparam name=""></typeparam> mixed qStr /// <typeparam name=""></typeparam> mixed type /// <returns></returns> Indexed /// </summery> public function search(qStr, type = Search.SEARCH_TYPE_USER_AND_PAGE, sort, page = 1, limit = Search.SEARCH_RESULT_PER_PAGE)
public PagingList <EmailTransfer> GetAll(pagination pagination, sort sort, string search, string search_operator, string filter)
{
dynamic searchFilter = string.Empty;
var operater = string.IsNullOrEmpty(search_operator) ? null : JObject.Parse(search_operator);
IQueryable <EmailTransfer> query = _context.Set <EmailTransfer>();
if (!string.IsNullOrEmpty(filter) && filter.Length > 2)
{
searchFilter = JObject.Parse(filter);
foreach (var _filter in searchFilter)
{
string fitlterstr = (string)_filter.Value;
var result = fitlterstr.Split(',').Where(r => !string.IsNullOrEmpty(r)).ToList();
if (result.Count() > 1)
{
int count = 0;
result.ForEach(s =>
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).FirstOrDefault().Value : "eq";
switch ((string)_filter.Key)
{
case "":
//query = query.Where(a=>a.Sector == Se)
break;
default:
var tempQuery = query;
query = count == 0 ? query.Where <EmailTransfer>(
(object)_filter.Key, (object)s,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)) :
query.Concat <EmailTransfer>(tempQuery.Where <EmailTransfer>(
(object)_filter.Key, (object)s,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)));
count = count + 1;
break;
}
});
}
else if (!string.IsNullOrEmpty(_filter.Value))
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).FirstOrDefault().Value : "eq";
query = query.Where <EmailTransfer>(
(object)_filter.Key, (object)result.FirstOrDefault(),
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
}
}
}
if (!string.IsNullOrEmpty(search) && search.Length > 2)
{
searchFilter = JObject.Parse(search);
foreach (var _search in searchFilter)
{
if (!Object.ReferenceEquals(null, _search.Value) && !String.IsNullOrEmpty(_search.Value.ToString()))
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _search.Name).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _search.Name).FirstOrDefault().Value : "eq";
string checkCurrentKey = Convert.ToString(_search.Value);
if (checkCurrentKey.Split(',').Count() > 1)
{
int i;
if (!(int.TryParse(checkCurrentKey.Split(',')[0].ToString(), out i)))
{
query = query.Where <EmailTransfer>(
(object)_search.Key, (object)_search.Value,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
}
else
{
int count = 0;
foreach (var _tempSearchKey in checkCurrentKey.Split(',').ToList())
{
if (!string.IsNullOrEmpty(_tempSearchKey))
{
var tempQuery = query;
query = count == 0 ? query.Where <EmailTransfer>(
(object)_search.Key, (object)_tempSearchKey,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)) :
query.Concat <EmailTransfer>(tempQuery.Where <EmailTransfer>(
(object)_search.Key, (object)_tempSearchKey,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)));
count = count + 1;
}
}
}
}
else
{
string strFk = (string)_search.Value;
switch ((string)_search.Name)
{
case "Message":
string[] statusen = { "message" };
string[] statusar = { "نص الرسالة" };
int[] result;
if (!_globalSettings.CurrentUser.IsRtl)
{
result = statusen.Select((x, i) => x.Contains(strFk) ? i : -1).Where(x => x != -1).ToArray();
}
else
{
result = statusar.Select((x, i) => x.Contains(strFk) ? i : -1).Where(x => x != -1).ToArray();
}
if (result.Count() == 0)
{
query = query.Except(query);
}
break;
case "UserCounts":
query = query.Where(a => ((string.IsNullOrEmpty(a.UserCounts.ToString()) ? "" : a.UserCounts.ToString())).Contains(strFk));
break;
default:
query = query.Where <EmailTransfer>(
(object)_search.Key, (object)_search.Value,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
break;
}
}
}
}
}
query = query.OrderBy <EmailTransfer>(sort.predicate, !sort.reverse ? "asc" : "");
return(new PagingList <EmailTransfer>(query, pagination.start / 10, pagination.Count == 0 ? 10 : pagination.Count));
//return _context.Set<T>();
}
private bool report_ReportViewDuration(ref _Worksheet oSheet, int[] cellCount)
{
if (cCMS == null)
{
return false;
}
// Declare query properties array for report
propEnum[] reportProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.retentions, propEnum.owner };
// Properties used to get account class information for the owner
refProp ownerProps = new refProp();
ownerProps.refPropName = propEnum.owner;
ownerProps.properties = new propEnum[] { propEnum.searchPath, propEnum.defaultName };
// Declare sort properties for reports and users
//reports
sort[] reportSort = new sort[] { new sort() };
reportSort[0].order = orderEnum.ascending;
reportSort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { ownerProps };
// Declare search path for reports and for a single user, based on CAMID
searchPathMultipleObject objectsPath = new searchPathMultipleObject();
searchPathMultipleObject userPath = new searchPathMultipleObject();
//Set search paths to get reports. Userpath must be set
//separately for each individual based on CAMID
objectsPath.Value = "//reportView";
//objectsPath.Value = "/content/package[@name='National Accounts']/report[@name='(0226) NA Ebit by Customer/Minor Line - Combined']";
//objectsPath.Value = "CAMID(\"ADS:u:cn=miller\\, barret,ou=new,ou=groups,ou=general,ou=tyson team members\")/folder[@name='My Folders']/reportView[@name='Report View of (0224) Combined Sales']";
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(objectsPath, reportProps, reportSort, qo);
if (bc.Length > 0)
{
foreach (baseClass report_item in bc)
{
// Cast base class object to more specific report object for access to more
// properties
if (report_item is reportView)
{
cognosdotnet_2_0.reportView reportv = (cognosdotnet_2_0.reportView)report_item;
foreach (retentionRule rule in reportv.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.searchPath.value;
//Increment the column count
cellCount[1]++;
if (reportv.owner.value == null)
{
oSheet.Cells[cellCount[0], cellCount[1]] = "unknown";
}
else
{
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.owner.value[0].defaultName.value;
}
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
}
}
}
}
}
return true;
}
/// <summary>
/// Application entry point.
/// </summary>
/// <param name="args">Standard command-line arguments.</param>
public static void Main( string[] args )
{
// Attempt a simple CM query.
string searchPath = "//report";
string userName = "******";
string userPassword = "******";
string userNamespace = "ADS";
char[] arg_separator = { '=' };
foreach( string arg in args )
{
string[] command = arg.Split( arg_separator, 2 );
switch( command[0] )
{
case "--search":
searchPath = command[1];
break;
case "--uid":
userName = command[1];
break;
case "--pwd":
userPassword = command[1];
break;
case "--namespace":
userNamespace = command[1];
break;
default:
throw new ApplicationException( "Unknown argument: " + arg );
}
}
// Concatenate the read filter to the searchPath this way we
// ask CM to only return the objects we have read acces on.
//searchPath = searchPath + "[permission('read')]";
// Create the ReportNet connection object.
Console.WriteLine( "Creating CognosReportNetService..." );
contentManagerService1 cmService = new contentManagerService1();
cmService.Url = "http://cogpbi1.tyson.com:9300/p2pd/servlet/dispatch";
//logon to Cognos 8
logon(cmService, userName, userPassword, userNamespace);
propEnum[] props = new propEnum[] { propEnum.searchPath,
propEnum.defaultName, propEnum.policies,
propEnum.permissions, propEnum.members };
sort[] s = new sort[]{ new sort() };
s[0].order = orderEnum.ascending;
s[0].propName = propEnum.defaultName;
queryOptions qo = new queryOptions();
Console.WriteLine( "\nReports:\n" );
// Look for all of the reports.
searchPathMultipleObject spMulti = new searchPathMultipleObject();
spMulti.Value = "/content//package";
//"/content/package[@name='Sales']//report";
baseClass[] bc = null;
try
{
bc = cmService.query(spMulti, props, s, qo );
if( bc.Length > 0 )
{
foreach( baseClass report_item in bc )
{
Console.WriteLine( " {0}", report_item.searchPath.value);
policy[] p = report_item.policies.value;
if (p.Length > 0)
{
foreach( policy pol in p )
{
Console.WriteLine( " {0}", pol.securityObject.searchPath.value);
permission[] perm = pol.permissions;
foreach( permission prm in perm )
Console.WriteLine( " {0} {1}",prm.name, prm.access.ToString());
}
}
}
}
}
catch( System.Web.Services.Protocols.SoapHeaderException ex )
{
displayException(ex);
}
catch( System.Web.Services.Protocols.SoapException ex )
{
displayException(ex);
}
}
public void disableCogObjects(string startDate, int daysBack)
{
List<string> reportPaths = getPathToDisableList(startDate, daysBack);
/* Debugging
List<string> reportPaths = new List<string>();
reportPaths.Add("/content/package[@name='Supply Chain']/folder[@name='Demand']/report[@name='(0014) Product Group Summary'])&ui.name=(0014) Product Group Summary&ui.format=XLS&ui.backURL=/cognos8/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/cc.xts&m_folder=iAB52A69DC50C4C77AC3A623A085EF52A");
*/
List<string> exceptionPaths = getExceptionPathList();
writePathToDisableList(reportPaths);
Console.WriteLine("Please check the file: objectsToDisable.txt in the program executable folder " +
"to make sure everything looks good. Do you want to proceed? Enter 'yes' or 'no' (case insensitive).");
string userChoice = Console.ReadLine();
if(userChoice.ToLower() == "yes")
{
StreamWriter errorWriter = new StreamWriter("objectsNotFoundC8.txt");
StreamWriter successWriter = new StreamWriter("objectsFoundC8.txt");
// Declare query properties array for report
propEnum[] props = new propEnum[] { propEnum.defaultName, propEnum.disabled,
propEnum.searchPath};
// Declare sort properties for reports and users
//reports
sort[] sorts = new sort[] { };
// Object representing path to single report
searchPathMultipleObject reportSearchPath = new searchPathMultipleObject();
// Query options
queryOptions qo = new queryOptions();
List<baseClass> objectsToDisable = new List<baseClass>();
// Loop through all the paths and generate a list of objects
// to disable
for (int i = 0; i < reportPaths.Count; i++)
{
string path = reportPaths[i];
// If the path is not in the exception list, then add it to
// the list of paths to be disabled
if (!checkAgainstExceptions(path, exceptionPaths))
{
reportSearchPath.Value = path;
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
try
{
baseClass[] bc = cCMS.query(reportSearchPath, props, sorts, qo);
if (bc.Length > 0)
{
booleanProp bp = new booleanProp();
bp.value = true;
bc[0].disabled = bp;
// Add the object to our List of things to disable
objectsToDisable.Add(bc[0]);
successWriter.WriteLine(path);
}
else
{
errorWriter.WriteLine(path);
}
}
// The exception will simply say "The client did something wrong"
// if the path line from the file is nothing resembling a path in the current
// cognos environment
catch (Exception e)
{
errorWriter.WriteLine(path);
}
}
}
errorWriter.Close();
successWriter.Close();
updateOptions updateOptions = new updateOptions();
cCMS.update(objectsToDisable.ToArray(), updateOptions);
}
else
{
Console.WriteLine("User entered something other than 'yes'. Aborting...");
}
}
public static IObservable<user> SetSortBy(sort sort)
{
return client.get<user>("users/view", new p() { { "sort", ((int)sort).ToString() } });
}
private bool extractTablesAndFieldsFromModels()
{
bool success = true;
System.IO.StreamWriter writer = new StreamWriter("ModelTablesAndFields.csv");
writer.WriteLine("Model Name|Table Name|Field Name");
// Same query options used for all calls
queryOptions qo = new queryOptions();
propEnum[] packageProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName };
//model sorting
sort[] pkgSort = new sort[] { new sort() };
pkgSort[0].order = orderEnum.ascending;
pkgSort[0].propName = propEnum.defaultName;
searchPathMultipleObject packagePath = new searchPathMultipleObject();
packagePath.Value = "//package";
// Make call to get all queries. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcPackages = cCMS.query(packagePath, packageProps, pkgSort, qo);
foreach (baseClass pkg in bcPackages)
{
//Model properties
propEnum[] modelProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName, propEnum.model };
//model sorting
sort[] mdlSort = new sort[] { new sort() };
mdlSort[0].order = orderEnum.ascending;
mdlSort[0].propName = propEnum.defaultName;
searchPathMultipleObject modelsPath = new searchPathMultipleObject();
modelsPath.Value = pkg.searchPath.value + "/model";
// Make call to get all models. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcmodels = cCMS.query(modelsPath, modelProps, mdlSort, qo);
// Latest model should always be at the end of the array
model latestModel = (model)bcmodels[bcmodels.Length - 1];
/* Uncomment the following code to write a model XML out to file */
if (pkg.defaultName.value == "Commitments")
{
System.IO.StreamWriter xmlWriter = new StreamWriter("model.xml");
xmlWriter.Write(latestModel.model1.value);
xmlWriter.Close();
// Write out the database tables and fields used in the current model
//extractAndWriteTablesAndFields(ref writer, pkg.defaultName.value, latestModel.model1.value);
}
}
writer.Close();
return success;
}
/* Does the bulk of the work to extract information on Users' MyFolder objects
*/
private bool doViewUsersMyFolderContentsWithSubElements(contentManagerService1 cCMS, ref List<CogObject> cogs, string cogVersion, string baseReportPath)
{
string camid = "//account"; //this is the search path for all user accounts
string userSearchPaths = "";
// We will display My Folders and My Pages for all users in namespace
propEnum[] props = new propEnum[]{propEnum.searchPath,
propEnum.objectClass,propEnum.defaultName,propEnum.portalPages,
propEnum.ancestors, propEnum.owner};
// Same query options used for all calls
queryOptions qo = new queryOptions();
// Create sort object
sort[] accountSort = new sort[] { new sort() };
accountSort[0].order = orderEnum.ascending;
accountSort[0].propName = propEnum.defaultName;
//query for all accounts
searchPathMultipleObject spMulti = new searchPathMultipleObject();
spMulti.Value = camid;
baseClass[] bc = cCMS.query(spMulti, props, accountSort, qo);
if (bc != null && bc.Length > 0)
{
// Set different properties to grab for the reports, queries, or report views
props = new propEnum[]{propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString, propEnum.creationTime,
propEnum.metadataModelPackage, propEnum.ancestors, propEnum.disabled};
// Declare properties to retrieve for package object internal to report object
refProp packageProps = new refProp();
packageProps.refPropName = propEnum.metadataModelPackage;
packageProps.properties = new propEnum[] { propEnum.searchPath, propEnum.storeID,
propEnum.defaultName, propEnum.disabled,
propEnum.ancestors };
// Properties used to get base class information if the object is a report view
refProp reportProps = new refProp();
reportProps.refPropName = propEnum.@base;
reportProps.properties = new propEnum[] { propEnum.metadataModelPackage, propEnum.storeID,
propEnum.searchPath, propEnum.disabled };
qo.refProps = new refProp[] { packageProps, reportProps };
for (int i = 0; i < bc.Length; i++)
{
//Query the Content Store for all objects in My Folders for user bc[i]
userSearchPaths = bc[i].searchPath.value + "/folder[@name='My Folders']//report |" +
bc[i].searchPath.value + "/folder[@name='My Folders']//query |" +
bc[i].searchPath.value + "/folder[@name='My Folders']//reportView";
spMulti.Value = userSearchPaths;
baseClass[] contents = cCMS.query(spMulti, props, new sort[] { }, qo);
if (contents != null && contents.Length > 0)
{
//Display all objects in My Folders for user bc[i]
for (int j = 0; j < contents.Length; j++)
{
CogObject cog = new CogObject();
/*
* Check whether object is a more specific type (e.g. query or report)
*/
if (contents[j] is report)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.report report = (cognosdotnet_2_0.report)contents[j];
cog.AddAttribute("Type", "Report");
cog.AddAttribute("CreationTime", contents[j].creationTime.value.ToString());
// Make sure package or Package is not null
if (report.metadataModelPackage.value != null)
{
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)report.metadataModelPackage.value[0];
cog.AddAttribute("Package_Path", report.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
cog.AddAttribute("Package_Disabled", package.disabled.value.ToString());
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
cog.AddAttribute("Package_Disabled", "null");
}
cog.AddAttribute("Disabled", report.disabled.value.ToString());
}
else if (contents[j] is query)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)contents[j];
cog.AddAttribute("Type", "Query");
// Make sure package or Package is not null
if (query.metadataModelPackage.value != null)
{
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)query.metadataModelPackage.value[0];
cog.AddAttribute("Package_Path", query.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
cog.AddAttribute("Package_Disabled", package.disabled.value.ToString());
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
cog.AddAttribute("Package_Disabled", "null");
}
cog.AddAttribute("Disabled", query.disabled.value.ToString());
}
else if (contents[j] is reportView)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.reportView reportView = (cognosdotnet_2_0.reportView)contents[j];
cog.AddAttribute("Type", "ReportView");
// Make sure package or Package is not null
if (reportView.packageBase != null)
{
cog.AddAttribute("Package_Path", reportView.packageBase.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
}
if ([email protected] != null)
{
cog.AddAttribute("BaseID", [email protected][0].storeID.value.Value);
cog.AddAttribute("BasePath", [email protected][0].searchPath.value);
if ([email protected][0] is report)
{
report tempReport = (report)[email protected][0];
if (tempReport.metadataModelPackage.value[0] != null)
{
cog.AddAttribute("BasePackage_Path", tempReport.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("BasePackage_Name", getPackageName(cog.getAttributeValue("BasePackage_Path")));
}
}
else if ([email protected][0] is query)
{
query tempQuery = (query)[email protected][0];
if (tempQuery.metadataModelPackage.value[0] != null)
{
cog.AddAttribute("BasePackage_Path", tempQuery.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("BasePackage_Name", getPackageName(cog.getAttributeValue("BasePackage_Path")));
}
}
cog.AddAttribute("Disabled", reportView.disabled.value.ToString());
}
}
// Make sure owner is not null
if (contents[j].owner.value != null)
{
/* We will get the author based on who's folder the report is in. This may
* not be strictly true. Uncomment the following line to get the old method.
* Also comment out or remove the line farther below that sets the Author_Name
* attribute*/
//getUserAccount(cCMS, contents[j].owner.value[0].searchPath.value, ref cog);
cog.AddAttribute("Author_CAMID", contents[j].owner.value[0].searchPath.value);
}
else
{
cog.AddAttribute("Author_CAMID", "Unknown");
}
cog.AddAttribute("Author_Name", bc[i].defaultName.value);
cog.AddAttribute("Version", cogVersion);
cog.AddAttribute("Name", contents[j].defaultName.value);
cog.AddAttribute("Path", contents[j].searchPath.value);
cog.AddAttribute("URL", baseReportPath + contents[j].searchPath.value);
cog.AddAttribute("MyFolder", "TRUE");
getSubElements(cCMS, contents[j].searchPath.value, ref cog);
/* This gets some limited auditing information. Most of this can be found
* more easily in the Raw Usage report of the Business Intelligence Dashboard
* package on perform-dev.tyson.com. Uncommenting the following line will
* cause a dramatic increase in runtime for this program
*/
//getAuditInfo(ref cog);
cogs.Add(cog);
}
}
}
}
else
{
cogs = null;
}
return true;
}
//type : to get User By there Roles
public PagingList <User> GetAll(pagination pagination, sort sort, string search, string search_operator, string filter, string type)
{
dynamic searchFilter = string.Empty;
var operater = string.IsNullOrEmpty(search_operator) ? null : JObject.Parse(search_operator);
IQueryable <User> query = _context.Set <User>().Where(x => x.IsDeleted != true).Include(e => e.fk_UserRoleMap).ThenInclude(y => y.UserRole.fk_UserRoleMap).Where(a => a.fk_UserRoleMap.Where(r => r.UserRole.Name != UserRoleName.Guest).Count() > 0);
HashSet <int> ids = new HashSet <int>()
{
7
};
query = type != null ? (type == UserRoleName.User ? query.Where(x => x.fk_UserRoleMap.Where(u => u.UserRole.Name == UserRoleName.User).Count() > 0) : query.Where(x => x.fk_UserRoleMap.Where(u => u.UserRole.Name == type).Count() > 0)) : query;
if (!string.IsNullOrEmpty(filter) && filter.Length > 2)
{
searchFilter = JObject.Parse(filter);
foreach (var _filter in searchFilter)
{
string fitlterstr = (string)_filter.Value;
var result = fitlterstr.Split(',').Where(r => !string.IsNullOrEmpty(r)).ToList();
if (result.Count() > 1)
{
int count = 0;
result.ForEach(s =>
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).FirstOrDefault().Value : "eq";
switch ((string)_filter.Key)
{
case "":
//query = query.Where(a=>a.Sector == Se)
break;
default:
var tempQuery = query;
query = count == 0 ? query.Where <User>(
(object)_filter.Key, (object)s,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)) :
query.Concat <User>(tempQuery.Where <User>(
(object)_filter.Key, (object)s,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)));
count = count + 1;
break;
}
});
}
else if (!string.IsNullOrEmpty(_filter.Value))
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).FirstOrDefault().Value : "eq";
query = query.Where <User>(
(object)_filter.Key, result.FirstOrDefault(),
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
}
}
}
if (!string.IsNullOrEmpty(search) && search.Length > 2)
{
searchFilter = JObject.Parse(search);
foreach (var _search in searchFilter)
{
if (!object.ReferenceEquals(null, _search.Value) && !string.IsNullOrEmpty(_search.Value.ToString()))
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _search.Name).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _search.Name).FirstOrDefault().Value : "eq";
string checkCurrentKey = Convert.ToString(_search.Value);
if (checkCurrentKey.Split(',').Count() > 1)
{
int i;
if (!(int.TryParse(checkCurrentKey.Split(',')[0].ToString(), out i)))
{
query = query.Where <User>(
(object)_search.Name, (object)_search.Value,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
}
else
{
int count = 0;
var temp2 = query; /////3-- all 163,164,171
foreach (var _tempSearchKey in checkCurrentKey.Split(',').ToList())
{
if (!string.IsNullOrEmpty(_tempSearchKey))
{
var tempQuery = query;
query = count == 0 ? query.Where <User>((object)_search.Name, (object)_tempSearchKey, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)) :
query.Concat <User>(temp2.Where <User>((object)_search.Name, (object)_tempSearchKey, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)));
count = count + 1;
}
}
}
}
else
{
string strFk = (string)_search.Value;
switch ((string)_search.Name)
{
//case "SectorStr":
// query = query.Where(a => a.FK_Sector.Name.Contains(strFk) && a.FK_Sector.ModulType == 1);
// break;
case "Name":
query = query.Where(a => ((string.IsNullOrEmpty(a.Name) ? "" : a.Name)).Contains(strFk));
break;
case "Email":
query = query.Where(a => ((string.IsNullOrEmpty(a.Email) ? "" : a.Email)).Contains(strFk));
break;
case "Mobile":
query = query.Where(a => ((string.IsNullOrEmpty(a.Mobile) ? "" : a.Mobile)).Contains(strFk));
break;
default:
query = query.Where <User>(
(object)_search.Name, (object)_search.Value,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
break;
}
}
}
}
}
query = query.OrderBy <User>(sort.predicate, !sort.reverse ? "asc" : "");
return(new PagingList <User>(query, pagination.start / 10, pagination.Count == 0 ? 10 : pagination.Count));
//return _context.Set<T>();
}
public static void Main(string[] args)
{
//Creates objects to call functions and methods from
menuSystem menuObject = new menuSystem();
textFiles textFilesObject = new textFiles();
sort algorithmObject = new sort();
output outputObject = new output();
//Uses the menu class to get the input options from the user
string weatherStation = menuObject.getWeatherStation();
string whatToView = menuObject.getWhatToView();
int menuChoiceTime = menuObject.getWhatTime();
int menuChoiceDo = menuObject.getWhatToDo();
int menuChoiceOutput = menuObject.getOutputType();
//Initialise variables
string year = "";
string month = "";
//Reads in the year and months
string[] yearLines = System.IO.File.ReadAllLines(@"CMP1124M_Weather_Data/Year.txt");
string[] monthLines = System.IO.File.ReadAllLines(@"CMP1124M_Weather_Data/Month.txt");
//Gets the year and month from the user and validates it
if (menuChoiceTime == 1)
{
year = menuObject.getYear(yearLines);
}
else if (menuChoiceTime == 2)
{
year = menuObject.getYear(yearLines);
month = menuObject.getMonth(year, yearLines, monthLines, menuChoiceTime);
}
else if (menuChoiceTime == 4)
{
month = menuObject.getMonth(year, yearLines, monthLines, menuChoiceTime);
}
//Assigns an array the correct text file based on what the user wants to view
double[] data = textFilesObject.loadInData(weatherStation, whatToView);
//Initliases variables
int menuAlgorithmChoice;
object[] returnArrays;
int stepCounter;
//Switch for doing what the user has specified
switch (menuChoiceDo)
{
//If user chosen to sort
case 1:
case 2:
//Get which sorting algorithm the user wants to use
menuAlgorithmChoice = menuObject.getSortingAlgorithm();
//Selects what algorithm to use via a nested switch statement
switch (menuAlgorithmChoice)
{
case 1: //Use Insertion Sort
algorithmObject.InsertionSort(data, yearLines, monthLines, menuChoiceTime, month, year, menuChoiceDo, menuChoiceOutput);
break;
case 2: //Use QuickSort
//Initialise the step counter
stepCounter = 0;
returnArrays = algorithmObject.Quicksort(data, 0, data.Length - 1, yearLines, monthLines, menuChoiceTime, month, year, menuChoiceDo, stepCounter);
//Retrieve the arrays from the object array created by the quicksort function
data = (double[])returnArrays[0];
yearLines = (string[])returnArrays[1];
monthLines = (string[])returnArrays[2];
stepCounter = (int)returnArrays[3];
//If the user wants to view the data backwards then reverse the array
if (menuChoiceDo == 2)
{
Array.Reverse(data);
Array.Reverse(monthLines);
Array.Reverse(yearLines);
}
//output the steps the algorithm took
Console.WriteLine("This Algorithm took {0} steps", stepCounter);
//Call the output method
outputObject.doOutput(menuChoiceOutput, data, menuChoiceTime, year, month, yearLines, monthLines);
break;
case 3: //Use Bubblesort
algorithmObject.Bubblesort(data, yearLines, monthLines, menuChoiceTime, month, year, menuChoiceDo, menuChoiceOutput);
break;
//default class
default:
Console.WriteLine("Error");
break;
}
break; //End of outside case 1 and 2
case 3: //Find the Median value
//Initialise the step counter
stepCounter = 0;
//Gets the sorted data
returnArrays = algorithmObject.Quicksort(data, 0, data.Length - 1, yearLines, monthLines, menuChoiceTime, month, year, menuChoiceDo, stepCounter);
//Retrieves the data from the object as needed to return 3 vairbales
data = (double[])returnArrays[0];
yearLines = (string[])returnArrays[1];
monthLines = (string[])returnArrays[2];
stepCounter = (int)returnArrays[3];
//output the steps the algorithm took
Console.WriteLine("This Algorithm took {0} steps", stepCounter);
//Call the output method to output the median values
outputObject.doOutputMedian(menuChoiceOutput, data, menuChoiceTime, year, month, yearLines, monthLines);
break;
//Max and Min
case 4:
//Initialise the step counter
stepCounter = 0;
//Retrieve sorted array
returnArrays = algorithmObject.Quicksort(data, 0, data.Length - 1, yearLines, monthLines, menuChoiceTime, month, year, menuChoiceDo, stepCounter);
//Retrieves and assigns individual lists
data = (double[])returnArrays[0];
yearLines = (string[])returnArrays[1];
monthLines = (string[])returnArrays[2];
stepCounter = (int)returnArrays[3];
//output the steps the algorithm took
Console.WriteLine("This Algorithm took {0} steps", stepCounter);
//Call the output method to output the data
outputObject.doOutputMinMax(menuChoiceOutput, data, menuChoiceTime, year, month, yearLines, monthLines);
break;
case 5: //Sort Chronoligcally
//Calls the output method to output the data
outputObject.doOutput(menuChoiceOutput, data, menuChoiceTime, year, month, yearLines, monthLines);
break;
case 6: //Sort Chronoligcally Backwards
//Reveres the arrays to display them from old to new
Array.Reverse(data);
Array.Reverse(yearLines);
Array.Reverse(monthLines);
//use the output class and the user selected output to output the data
outputObject.doOutput(menuChoiceOutput, data, menuChoiceTime, year, month, yearLines, monthLines);
break;
default:
Console.WriteLine("Error");
break;
}
}
/* Method to query the content store for the object at the given path and populate the
* referenced object with user name information of the owner or author
*/
private void getUserAccount(contentManagerService1 cCMS, string searchPath, ref CogObject cog)
{
searchPathMultipleObject userPath = new searchPathMultipleObject();
userPath.Value = searchPath;
// Same query options used for all calls
queryOptions qo = new queryOptions();
//users
propEnum[] userProps = new propEnum[] { propEnum.userName, propEnum.name, propEnum.user };
sort[] userSort = new sort[] { new sort() };
userSort[0].order = orderEnum.ascending;
userSort[0].propName = propEnum.userName;
/* Run another query to retrieve the account object based on the CAMID.
UserID is pulled from the account object. CAMID's for users who no
longer work here will return no account objects. Author set to ""
in this case.
*/
baseClass[] bcUserAccount = cCMS.query(userPath, userProps, userSort, qo);
if (bcUserAccount.Length > 0)
{
cognosdotnet_2_0.account account = (cognosdotnet_2_0.account)bcUserAccount[0];
cog.AddAttribute("Author", account.userName.value);
cog.AddAttribute("Author_Name", account.name.value[0].value);
}
else
{
string wholeName = getAuthorName(userPath.Value);
cog.AddAttribute("Author_Name", wholeName);
}
}
/// <summary>
/// Application entry point.
/// </summary>
/// <param name="args">Standard command-line arguments.</param>
public static void Main( string[] args )
{
// Attempt a simple CM query.
string searchPath = "//report";
string userName = "******";
string userPassword = "******";
string userNamespace = "namespaceID";
char[] arg_separator = { '=' };
foreach( string arg in args )
{
string[] command = arg.Split( arg_separator, 2 );
switch( command[0] )
{
case "--search":
searchPath = command[1];
break;
case "--uid":
userName = command[1];
break;
case "--pwd":
userPassword = command[1];
break;
case "--namespace":
userNamespace = command[1];
break;
default:
throw new ApplicationException( "Unknown argument: " + arg );
}
}
// Concatenate the read filter to the searchPath this way we
// ask CM to only return the objects we have read acces on.
searchPath = searchPath + "[permission('read')]";
// Create the ReportNet connection object.
Console.WriteLine( "Creating CognosReportNetService..." );
CognosReportNetService crn = new CognosReportNetService();
crn.Url = "http://localhost:8080/series8/cgi-bin/cognos.cgi";
// Add the authentication information, if any.
//
// Another option would be to use the logon() methods...
CAM cam = new CAM();
cam.action = "logonAs";
hdrSession header = new hdrSession();
if( userName != null )
{
formFieldVar[] vars = new formFieldVar[3];
vars[0] = new formFieldVar();
vars[0].name = "CAMNamespace";
vars[0].value = userNamespace;
vars[0].format = formatEnum.not_encrypted;
vars[1] = new formFieldVar();
vars[1].name = "CAMUsername";
vars[1].value = userName;
vars[1].format = formatEnum.not_encrypted;
vars[2] = new formFieldVar();
vars[2].name = "CAMPassword";
vars[2].value = userPassword;
vars[2].format = formatEnum.not_encrypted;
header.formFieldVars = vars;
}
else
{
cam.action = "logon";
}
biBusHeader bibus = new biBusHeader();
bibus.CAM = cam;
bibus.hdrSession = header;
crn.biBusHeaderValue = bibus;
try
{
propEnum[] props = new propEnum[] { propEnum.searchPath,
propEnum.defaultName, propEnum.policies,
propEnum.permissions, propEnum.members };
sort[] s = new sort[]{ new sort() };
s[0].order = orderEnum.ascending;
s[0].propName = propEnum.defaultName;
queryOptions qo = new queryOptions();
// Look for all of the reports.
Console.WriteLine( "\nReports:\n" );
baseClass[] bc = crn.query( "/content//report", props, s, qo );
if( bc.Length > 0 )
{
foreach( baseClass report_item in bc )
{
Console.WriteLine( " {0}", report_item.searchPath.value);
policy[] p = report_item.policies.value;
if (p.Length > 0)
{
foreach( policy pol in p )
{
Console.WriteLine( " {0}", pol.securityObject.searchPath.value);
permission[] perm = pol.permissions;
foreach( permission prm in perm )
Console.WriteLine( " {0} {1}",prm.name, prm.access.ToString());
}
}
}
}
}
catch( System.Web.Services.Protocols.SoapHeaderException ex )
{
Console.WriteLine( "SOAP Header Exception:" );
Console.WriteLine( "Actor : " + ex.Actor );
Console.WriteLine( "Code : " + ex.Code );
Console.WriteLine( "Detail : " + ex.Detail );
Console.WriteLine( "Message: " + ex.Message );
// We can access the SOAP fault information through
// the ex.Detail property.
System.Xml.XmlNode node = ex.Detail;
Console.WriteLine( node.OuterXml );
}
catch( System.Web.Services.Protocols.SoapException ex )
{
Console.WriteLine( "SOAP Exception:" );
Console.WriteLine( "Actor : " + ex.Actor );
Console.WriteLine( "Code : " + ex.Code );
Console.WriteLine( "Detail : " + ex.Detail );
Console.WriteLine( "Message: " + ex.Message );
// We can access the SOAP fault information through
// the ex.Detail property.
System.Xml.XmlNode node = ex.Detail;
Console.WriteLine( node.OuterXml );
}
}
private bool turnOffMyFolderContentDuration(int[] cellCount)
{
Microsoft.Office.Interop.Excel.Application oXL = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook oWB;
Microsoft.Office.Interop.Excel._Worksheet oSheet;
Microsoft.Office.Interop.Excel.Range oRange;
// Create Excel Application
oXL.Visible = true;
//Get a new workbook.
oWB = (Microsoft.Office.Interop.Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
oSheet = (Microsoft.Office.Interop.Excel._Worksheet)oWB.ActiveSheet;
string camid = "//account"; //this is the search path for all user accounts
//string camid = "CAMID(\"ADS:u:cn=miller\\, barret,ou=new,ou=groups,ou=general,ou=tyson team members\")";
string userSearchPaths = "";
// We will display My Folders and My Pages for all users in namespace
propEnum[] props = new propEnum[]{propEnum.searchPath,
propEnum.objectClass,propEnum.defaultName,propEnum.portalPages,
propEnum.ancestors, propEnum.owner};
// Same query options used for all calls
queryOptions qo = new queryOptions();
// Create sort object
sort[] accountSort = new sort[] { new sort() };
accountSort[0].order = orderEnum.ascending;
accountSort[0].propName = propEnum.defaultName;
//query for all accounts
searchPathMultipleObject spMulti = new searchPathMultipleObject();
spMulti.Value = camid;
baseClass[] bc = cCMS.query(spMulti, props, accountSort, qo);
if (bc != null && bc.Length > 0)
{
// Set different properties to grab for the reports, queries, or report views
props = new propEnum[]{propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString, propEnum.creationTime,
propEnum.metadataModelPackage, propEnum.ancestors, propEnum.disabled, propEnum.user,
propEnum.retentions };
// Declare properties to retrieve for package object internal to report object
refProp packageProps = new refProp();
packageProps.refPropName = propEnum.metadataModelPackage;
packageProps.properties = new propEnum[] { propEnum.searchPath, propEnum.storeID,
propEnum.defaultName, propEnum.disabled,
propEnum.ancestors };
// Properties used to get base class information if the object is a report view
refProp reportProps = new refProp();
reportProps.refPropName = propEnum.@base;
reportProps.properties = new propEnum[] { propEnum.metadataModelPackage, propEnum.storeID,
propEnum.searchPath, propEnum.disabled };
qo.refProps = new refProp[] { packageProps, reportProps };
retentionRuleArrayProp retentionRules = new retentionRuleArrayProp();
retentionRule[] outputRule = new retentionRule[1];
outputRule[0] = new retentionRule();
outputRule[0].objectClass = classEnum.reportVersion;
outputRule[0].prop = propEnum.creationTime;
outputRule[0].maxDuration = null;
//outputRule[0].maxObjects = "1";
List<baseClass> turnOffDurationList = new List<baseClass>();
for (int i = 0; i < bc.Length; i++)
{
//Query the Content Store for all objects in My Folders for user bc[i]
userSearchPaths = bc[i].searchPath.value + "/folder[@name='My Folders']//report"; /*+
bc[i].searchPath.value + "/folder[@name='My Folders']//query |" +
bc[i].searchPath.value + "/folder[@name='My Folders']//reportView";*/
spMulti.Value = userSearchPaths;
baseClass[] contents = cCMS.query(spMulti, props, new sort[] { }, qo);
if (contents != null && contents.Length > 0)
{
//Disable Duration all objects in My Folders for user bc[i]
for (int j = 0; j < contents.Length; j++)
{
/*
* Check whether object is a more specific type (e.g. query or report)
*/
if (contents[j] is report)
{
cognosdotnet_2_0.report report = (cognosdotnet_2_0.report)contents[j];
foreach (retentionRule rule in report.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = report.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = report.searchPath.value;
//Increment the column count
cellCount[1]++;
oSheet.Cells[cellCount[0], cellCount[1]] = bc[i].defaultName.value;
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
report.retentions = retentionRules;
turnOffDurationList.Add(contents[j]);
}
}
}
else if (contents[j] is query)
{
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)contents[j];
foreach (retentionRule rule in query.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = query.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = query.searchPath.value;
//Increment the column count
cellCount[1]++;
oSheet.Cells[cellCount[0], cellCount[1]] = bc[i].defaultName.value;
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
query.retentions = retentionRules;
turnOffDurationList.Add(contents[j]);
}
}
}
else if (contents[j] is reportView)
{
cognosdotnet_2_0.reportView reportView = (cognosdotnet_2_0.reportView)contents[j];
foreach (retentionRule rule in reportView.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = reportView.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = reportView.searchPath.value;
//Increment the column count
cellCount[1]++;
oSheet.Cells[cellCount[0], cellCount[1]] = bc[i].defaultName.value;
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
reportView.retentions = retentionRules;
turnOffDurationList.Add(contents[j]);
}
}
}
}
if (turnOffDurationList.Count > 0)
{
cCMS.update(turnOffDurationList.ToArray(), new updateOptions());
}
}
}
}
return true;
}
private bool turnOffAndReport_QueryDuration(ref _Worksheet oSheet, int[] cellCount)
{
if (cCMS == null)
{
return false;
}
// Declare query properties array for report
propEnum[] reportProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.retentions, propEnum.owner };
// Properties used to get account class information for the owner
refProp ownerProps = new refProp();
ownerProps.refPropName = propEnum.owner;
ownerProps.properties = new propEnum[] { propEnum.searchPath, propEnum.defaultName };
// Declare sort properties for reports and users
//reports
sort[] reportSort = new sort[] { new sort() };
reportSort[0].order = orderEnum.ascending;
reportSort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { ownerProps };
// Declare search path for reports and for a single user, based on CAMID
searchPathMultipleObject objectsPath = new searchPathMultipleObject();
searchPathMultipleObject userPath = new searchPathMultipleObject();
//Set search paths to get reports. Userpath must be set
//separately for each individual based on CAMID
objectsPath.Value = "//query";
//objectsPath.Value = "/content/package[@name='National Accounts']/report[@name='(0226) NA Ebit by Customer/Minor Line - Combined']";
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(objectsPath, reportProps, reportSort, qo);
retentionRuleArrayProp retentionRules = new retentionRuleArrayProp();
retentionRule[] outputRule = new retentionRule[1];
outputRule[0] = new retentionRule();
outputRule[0].objectClass = classEnum.reportVersion;
outputRule[0].prop = propEnum.creationTime;
outputRule[0].maxDuration = null;
//outputRule[0].maxObjects = "1";
List<baseClass> turnOffDurationList = new List<baseClass>();
if (bc.Length > 0)
{
foreach (baseClass report_item in bc)
{
retentionRules.value = outputRule;
// Cast base class object to more specific report object for access to more
// properties
if (report_item is query)
{
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)report_item;
foreach (retentionRule rule in query.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = query.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = query.searchPath.value;
//Increment the column count
cellCount[1]++;
if (query.owner.value == null)
{
oSheet.Cells[cellCount[0], cellCount[1]] = "unknown";
}
else
{
oSheet.Cells[cellCount[0], cellCount[1]] = query.owner.value[0].defaultName.value;
}
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
query.retentions = retentionRules;
turnOffDurationList.Add(report_item);
}
}
}
}
if (turnOffDurationList.Count > 0)
{
cCMS.update(turnOffDurationList.ToArray(), new updateOptions());
}
}
return true;
}
private bool turnOffReportViewDuration(int[] cellCount)
{
Microsoft.Office.Interop.Excel.Application oXL = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook oWB;
Microsoft.Office.Interop.Excel._Worksheet oSheet;
Microsoft.Office.Interop.Excel.Range oRange;
// Create Excel Application
oXL.Visible = true;
//Get a new workbook.
oWB = (Microsoft.Office.Interop.Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
oSheet = (Microsoft.Office.Interop.Excel._Worksheet)oWB.ActiveSheet;
if (cCMS == null)
{
return false;
}
// Declare query properties array for report
propEnum[] reportProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.retentions, propEnum.owner };
// Properties used to get account class information for the owner
refProp ownerProps = new refProp();
ownerProps.refPropName = propEnum.owner;
ownerProps.properties = new propEnum[] { propEnum.searchPath, propEnum.defaultName };
// Declare sort properties for reports and users
//reports
sort[] reportSort = new sort[] { new sort() };
reportSort[0].order = orderEnum.ascending;
reportSort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { ownerProps };
// Declare search path for reports and for a single user, based on CAMID
searchPathMultipleObject objectsPath = new searchPathMultipleObject();
searchPathMultipleObject userPath = new searchPathMultipleObject();
//Set search paths to get reports. Userpath must be set
//separately for each individual based on CAMID
objectsPath.Value = "//reportView";
//objectsPath.Value = "/content/package[@name='National Accounts']/report[@name='(0226) NA Ebit by Customer/Minor Line - Combined']";
//objectsPath.Value = "CAMID(\"ADS:u:cn=miller\\, barret,ou=new,ou=groups,ou=general,ou=tyson team members\")/folder[@name='My Folders']/reportView[@name='Report View of (0224) Combined Sales']";
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(objectsPath, reportProps, reportSort, qo);
retentionRuleArrayProp retentionRules = new retentionRuleArrayProp();
retentionRule[] outputRule = new retentionRule[1];
outputRule[0] = new retentionRule();
outputRule[0].objectClass = classEnum.reportVersion;
outputRule[0].prop = propEnum.creationTime;
outputRule[0].maxDuration = null;
//outputRule[0].maxObjects = "1";
retentionRules.value = outputRule;
List<baseClass> turnOffDurationList = new List<baseClass>();
if (bc.Length > 0)
{
foreach (baseClass report_item in bc)
{
// Cast base class object to more specific report object for access to more
// properties
if (report_item is reportView)
{
cognosdotnet_2_0.reportView reportv = (cognosdotnet_2_0.reportView)report_item;
foreach (retentionRule rule in reportv.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.searchPath.value;
//Increment the column count
cellCount[1]++;
if (reportv.owner.value == null)
{
oSheet.Cells[cellCount[0], cellCount[1]] = "unknown";
}
else
{
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.owner.value[0].defaultName.value;
}
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
reportv.retentions = retentionRules;
turnOffDurationList.Add(report_item);
}
}
}
}
if (turnOffDurationList.Count > 0)
{
cCMS.update(turnOffDurationList.ToArray(), new updateOptions());
}
}
return true;
}
private bool getObjectsForPackage(contentManagerService1 cCMS, ref List<CogObject> objects, string cogVersion,
string basePath, string pathToObjectsInPackage)
{
if (cCMS == null)
{
objects = null;
return false;
}
// Declare query properties array for reports, queries and for users
propEnum[] cogProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString,
propEnum.metadataModelPackage, propEnum.user,propEnum.actualExecutionTime,
propEnum.policies};
// Declare sort properties for reports
sort[] cogSort = new sort[] { new sort() };
cogSort[0].order = orderEnum.ascending;
cogSort[0].propName = propEnum.defaultName;
// Same query options used for all calls
queryOptions qo = new queryOptions();
searchPathMultipleObject objectsPath = new searchPathMultipleObject();
// Declare search path for reports and for a single user, based on CAMID
objectsPath.Value = pathToObjectsInPackage;
// Run query to get all objects in package. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(objectsPath, cogProps, cogSort, qo);
if (bc.Length > 0)
{
foreach (baseClass cog_item in bc)
{
CogObject cog = new CogObject();
cog.ID = cog_item.storeID.value.Value;
cog.Name = cog_item.defaultName.value;
cog.AddAttribute("ID", cog.ID);
cog.AddAttribute("Name", cog_item.defaultName.value);
cog.AddAttribute("Version", cogVersion);
cog.AddAttribute("URL", basePath + cog_item.searchPath.value);
addSecurityPolicies(ref cog, cog_item);
/* Get owner/author information for this object
*/
if (cog_item.owner.value != null)
{
getUserAccount(cCMS, cog_item.owner.value[0].searchPath.value, ref cog);
cog.AddAttribute("Author_CAMID", cog_item.owner.value[0].searchPath.value);
}
else
{
cog.AddAttribute("Author_CAMID", "Unknown");
}
/*
* Check whether object is a more specific type (e.g. query or report)
*/
if (cog_item is report)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.report report = (cognosdotnet_2_0.report)cog_item;
cog.AddAttribute("Type", "Report");
// Make sure package or Package is not null
if (report.metadataModelPackage.value != null)
{
cog.AddAttribute("Package_Path", report.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
}
}
else if (cog_item is query)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)cog_item;
cog.AddAttribute("Type", "Query");
// Make sure package or Package is not null
if (query.metadataModelPackage.value != null)
{
cog.AddAttribute("Package_Path", query.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
}
}
else if (cog_item is reportView)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.reportView reportView = (cognosdotnet_2_0.reportView)cog_item;
cog.AddAttribute("Type", "ReportView");
// Make sure package or Package is not null
if (reportView.packageBase != null)
{
cog.AddAttribute("Package_Path", reportView.packageBase.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
}
}
getSubElements(cCMS, cog_item.searchPath.value, ref cog);
// Add the object to the list
objects.Add(cog);
}
}
return true;
}
public IActionResult Dashboard()
{
if (HttpContext.Session.GetString("Name") != null)
{
List <Plan> OldPlan = dbContext.Planes
.Include(w => w.Guests)
.Include(w => w.Creator)
.ToList();
List <Plan> Plans = new List <Plan>();
List <Plan> P = new List <Plan>();
foreach (Plan x in OldPlan)
{
if (DateTime.ParseExact(x.Date, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).Add(DateTime.ParseExact(x.Time, "hh:mm tt", System.Globalization.CultureInfo.InvariantCulture).TimeOfDay) >= DateTime.Now)
{
P.Add(x);
}
}
/////////////////
List <sort> forsort = new List <sort>();
foreach (Plan x in P)
{
sort sort = new sort();
sort.PlanId = x.PlanId;
sort.TotalTime = DateTime.ParseExact(x.Date, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).Add(DateTime.ParseExact(x.Time, "hh:mm tt", System.Globalization.CultureInfo.InvariantCulture).TimeOfDay);
forsort.Add(sort);
System.Console.WriteLine("id:" + sort.PlanId + "time" + sort.TotalTime);
}
;
for (int v = forsort.Count - 1; v > 0; v--)
{
for (int z = forsort.Count - 1; z > 0; z--)
{
if (forsort[z].TotalTime > forsort[z - 1].TotalTime)
{
sort temp = forsort[z];
forsort[z] = forsort[z - 1];
forsort[z - 1] = temp;
}
}
}
for (int o = forsort.Count - 1; o >= 0; o--)
{
foreach (Plan y in P)
{
if (y.PlanId == forsort[o].PlanId)
{
Plans.Add(y);
System.Console.WriteLine("id:" + y.PlanId + "time" + y.Date + y.Time);
}
}
}
/////////////
User user = dbContext.Useres
.Include(u => u.Join)
.FirstOrDefault(u => u.UserId == (int)HttpContext.Session.GetInt32("id"));
Dashboard_wrapper Dashboard_wrapper = new Dashboard_wrapper
{
AllPlan = Plans,
User = user
};
return(View(Dashboard_wrapper));
}
else
{
return(RedirectToAction("Index"));
}
}
public PagingList <EmailTransferUser> GetAll(pagination pagination, sort sort, string search, string search_operator, string filter)
{
dynamic searchFilter = string.Empty;
var operater = string.IsNullOrEmpty(search_operator) ? null : JObject.Parse(search_operator);
IQueryable <EmailTransferUser> query = _context.Set <EmailTransferUser>();
if (!string.IsNullOrEmpty(filter) && filter.Length > 2)
{
searchFilter = JObject.Parse(filter);
foreach (var _filter in searchFilter)
{
string fitlterstr = (string)_filter.Value;
var result = fitlterstr.Split(',').Where(r => !string.IsNullOrEmpty(r)).ToList();
if (result.Count() > 1)
{
int count = 0;
result.ForEach(s =>
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).FirstOrDefault().Value : "eq";
switch ((string)_filter.Key)
{
case "":
//query = query.Where(a=>a.Sector == Se)
break;
default:
var tempQuery = query;
query = count == 0 ? query.Where <EmailTransferUser>(
(object)_filter.Key, (object)s,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)) :
query.Concat <EmailTransferUser>(tempQuery.Where <EmailTransferUser>(
(object)_filter.Key, (object)s,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)));
count = count + 1;
break;
}
});
}
else if (!string.IsNullOrEmpty(_filter.Value))
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _filter.Key).FirstOrDefault().Value : "eq";
query = query.Where <EmailTransferUser>(
(object)_filter.Key, (object)result.FirstOrDefault(),
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
}
}
}
if (!string.IsNullOrEmpty(search) && search.Length > 2)
{
searchFilter = JObject.Parse(search);
foreach (var _search in searchFilter)
{
if (!string.IsNullOrEmpty(_search.Value))
{
string op = operater.Descendants().OfType <JProperty>().Where(p => p.Name == _search.Key).Count() > 0 ? (string)operater.Descendants().OfType <JProperty>().Where(p => p.Name == _search.Key).FirstOrDefault().Value : "eq";
string checkCurrentKey = Convert.ToString(_search.Value);
if (checkCurrentKey.Split(',').Count() > 1)
{
int i;
if (!(int.TryParse(checkCurrentKey.Split(',')[0].ToString(), out i)))
{
query = query.Where <EmailTransferUser>(
(object)_search.Key, (object)_search.Value,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
}
else
{
int count = 0;
foreach (var _tempSearchKey in checkCurrentKey.Split(',').ToList())
{
if (!string.IsNullOrEmpty(_tempSearchKey))
{
var tempQuery = query;
query = count == 0 ? query.Where <EmailTransferUser>(
(object)_search.Key, (object)_tempSearchKey,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)) :
query.Concat <EmailTransferUser>(tempQuery.Where <EmailTransferUser>(
(object)_search.Key, (object)_tempSearchKey,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op)));
count = count + 1;
}
}
}
}
else
{
string strFk = (string)_search.Value;
switch ((string)_search.Key)
{
default:
query = query.Where <EmailTransferUser>(
(object)_search.Key, (object)_search.Value,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), op));
break;
}
}
}
}
}
query = query.OrderBy <EmailTransferUser>(sort.predicate, !sort.reverse ? "asc" : "");
return(new PagingList <EmailTransferUser>(query, pagination.start / 10, pagination.Count == 0 ? 10 : pagination.Count));
}
private bool getQueriesForPackage(contentManagerService1 cCMS, ref List<CogObject> queries, string cogVersion,
string baseQueryPath, string pathToQueriesInPackage)
{
if (cCMS == null)
{
queries = null;
return false;
}
// Same query options used for all calls
queryOptions qo = new queryOptions();
//queries
propEnum[] queryProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString,
propEnum.metadataModelPackage};
//users
propEnum[] userProps = new propEnum[] { propEnum.userName, propEnum.name, propEnum.user };
//queries
sort[] querySort = new sort[] { new sort() };
querySort[0].order = orderEnum.ascending;
querySort[0].propName = propEnum.defaultName;
//users
sort[] userSort = new sort[] { new sort() };
userSort[0].order = orderEnum.ascending;
userSort[0].propName = propEnum.userName;
searchPathMultipleObject userPath = new searchPathMultipleObject();
searchPathMultipleObject queriesPath = new searchPathMultipleObject();
queriesPath.Value = pathToQueriesInPackage;
// Make call to get all queries. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcQueries = cCMS.query(queriesPath, queryProps, querySort, qo);
if (bcQueries.Length > 0)
{
foreach (baseClass query_item in bcQueries)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)query_item;
CogObject qry = new CogObject();
qry.ID = query_item.storeID.value.Value;
qry.AddAttribute("ID", qry.ID);
qry.AddAttribute("Name", query_item.defaultName.value);
qry.AddAttribute("Type", "AdHoc");
qry.AddAttribute("Package_Path", query.metadataModelPackage.value[0].searchPath.value);
qry.AddAttribute("Package_Name", getPackageName(qry.getAttributeValue("Package_Path")));
if (query_item.owner.value != null)
{
getUserAccount(cCMS, query_item.owner.value[0].searchPath.value, ref qry);
qry.AddAttribute("Author_CAMID", query_item.owner.value[0].searchPath.value);
}
else
{
qry.AddAttribute("Author_CAMID", "Unknown");
}
qry.AddAttribute("Version", cogVersion);
qry.AddAttribute("URL", baseQueryPath + query_item.searchPath.value);
queries.Add(qry);
}
}
else
{
queries = null;
}
return true;
}
private void getSubElements(contentManagerService1 cCMS, string objectSearchPath, ref CogObject cog)
{
searchPathMultipleObject subElementPath = new searchPathMultipleObject();
subElementPath.Value = objectSearchPath + "/*";
// Same query options used for all calls
queryOptions qo = new queryOptions();
//users
propEnum[] subElementProps = new propEnum[] { propEnum.storeID, propEnum.searchPath, propEnum.defaultName,
propEnum.user, propEnum.status, propEnum.requestedExecutionTime,
propEnum.actualExecutionTime, propEnum.actualCompletionTime,
propEnum.eventID, propEnum.ownerEventID, propEnum.asOfTime,
propEnum.canBurst, propEnum.contact, propEnum.contactEMail,
propEnum.metadataModel, propEnum.metadataModelPackage,
propEnum.options, propEnum.parameters, propEnum.runOptions,
propEnum.serverGroup, propEnum.specification, propEnum.active,
propEnum.credential, propEnum.dailyPeriod, propEnum.endDate,
propEnum.endType, propEnum.everyNPeriods, propEnum.startDate,
propEnum.taskID, propEnum.timeZoneID, propEnum.triggerName, propEnum.type,
propEnum.weeklyFriday, propEnum.weeklyMonday, propEnum.weeklySaturday,
propEnum.weeklySunday, propEnum.weeklyThursday, propEnum.weeklyTuesday,
propEnum.weeklyWednesday, propEnum.yearlyAbsoluteDay, propEnum.yearlyAbsoluteMonth,
propEnum.yearlyRelativeDay, propEnum.yearlyRelativeWeek, propEnum.ancestors,
propEnum.creationTime, propEnum.modificationTime, propEnum.name, propEnum.usage,
propEnum.version};
sort[] subElementSort = new sort[] { new sort() };
subElementSort[0].order = orderEnum.ascending;
subElementSort[0].propName = propEnum.defaultName;
baseClass[] bc = cCMS.query(subElementPath, subElementProps, subElementSort, qo);
if (bc.Length > 0)
{
foreach (baseClass item in bc)
{
CogObject cogItem = new CogObject();
if (item is history)
{
cognosdotnet_2_0.history hist = (history)item;
addHistoryAttributes(cogItem, hist);
}
else if (item is schedule)
{
cognosdotnet_2_0.schedule sched = (schedule)item;
cog.AddAttribute("ActiveSchedule", sched.active.value.ToString());
addScheduleAttributes(ref cogItem, sched);
}
else if (item is reportVersion)
{
cognosdotnet_2_0.reportVersion rver = (reportVersion)item;
addReportVersionAttributes(ref cogItem, rver);
}
cog.addSubElement(cogItem);
}
}
}
static void Main(string[] args)
{
DanhSachHangHoa DSHH = new DanhSachHangHoa();
QuanLyHangHoa ql = new QuanLyHangHoa();
while (true)
{
Console.Clear();
Console.WriteLine("====================== DANH SACH CHUC NANG ======================");
Console.WriteLine("Nhap {0} de Thoat", (int)Menu.Thoat);
Console.WriteLine("Nhap {0} de Nhap du lieu tu file", (int)Menu.NhapTuFile);
Console.WriteLine("Nhap {0} de Xuat file du lieu", (int)Menu.Xuat);
Console.WriteLine("Nhap {0} de In danh sach mat hang co so luong tren 10", (int)Menu.InDSMHSLTren10);
Console.WriteLine("Nhap {0} de In danh sach mat hang co ten la TAI NGHE", (int)Menu.XuatDSTaiNghe);
Console.WriteLine("Nhap {0} de Tim mat hang co tong so tien cao nhat", (int)Menu.TimMatHangCoTongTienCaoNhat);
Console.WriteLine("Nhap {0} de Mat Hang co Thanh Tien cao nhat", (int)Menu.MatHangThanhTienMax);
Console.WriteLine("Nhap {0} de Tim gia lon nhat cua mat hang X", (int)Menu.TimMaxMatHangX);
Console.WriteLine("Nhap {0} de Sap xep", (int)Menu.SapXep);
Console.WriteLine("Nhap {0} de xoa hang hoa co mo ta X", (int)Menu.XoaHangHoaMoTaX);
Menu nhap = (Menu)int.Parse(Console.ReadLine());
switch (nhap)
{
case Menu.Thoat:
return;
case Menu.NhapTuFile:
{
Console.Clear();
DSHH.NhapThuFile();
DSHH.Xuat();
}
break;
case Menu.Xuat:
{
Console.Clear();
DSHH.Xuat();
}
break;
case Menu.InDSMHSLTren10:
{
Console.Clear();
ql.InDSHHSLMuoi(DSHH).Xuat();
}
break;
case Menu.XuatDSTaiNghe:
{
Console.Clear();
ql.TimDSTaiNghe(DSHH).Xuat();
}
break;
case Menu.TimMatHangCoTongTienCaoNhat:
{
Console.Clear();
ql.TimMHTongTienMax(DSHH);
} break;
case Menu.MatHangThanhTienMax:
{
Console.Clear();
ql.TimMatHangThanhTienMax(DSHH).Xuat();
} break;
case Menu.TimMaxMatHangX:
{
Console.Clear();
while (true)
{
Console.WriteLine("Xin moi nhap ten hang hoa gom (MAY TINH, QUAN AO, GIAY, TAI NGHE)");
string ten = Console.ReadLine();
try
{
ql.TimDSMatHangX(DSHH, ten).Xuat();
Console.WriteLine("Hang hoa Thanh tien cao nhat mat hang {0} la: ", ten + "\n");
ql.TimSoTienMaxMHX(DSHH, ten).Xuat();
break;
}
catch
{
Console.WriteLine("Mat hang vua nhap khong ton tai, xin moi nhap lai!!");
}
}
} break;
case Menu.SapXep:
{
Console.Clear();
Console.WriteLine("Nhap {0} de Sap xep tang theo thanh tien!", (int)sort.TangTheoTien);
Console.WriteLine("Nhap {0} de Sap xep giam theo thanh tien!", (int)sort.GianTheoTien);
Console.WriteLine("Nhap {0} de Sap xep tang theo so luong", (int)sort.TangSL);
Console.WriteLine("Nhap {0} de sap xep tang theo ten", (int)sort.SapXepTangTen);
Console.WriteLine("Nhap {0} de Sap xep tang theo chieu dai ten", (int)sort.SapXepTangTheoChieuDaiTen);
sort n = (sort)int.Parse(Console.ReadLine());
switch (n)
{
case sort.TangTheoTien:
{
Console.Clear();
ql.SapXep(DSHH).Xuat();
}
break;
case sort.GianTheoTien:
{
Console.Clear();
ql.SapXepGiam(DSHH).Xuat();
}
break;
case sort.TangSL:
{
Console.Clear();
ql.SapXepTangSL(DSHH).Xuat();
} break;
case sort.SapXepTangTen:
{
Console.Clear();
ql.SapXepTheoTen(DSHH).Xuat();
} break;
case sort.SapXepTangTheoChieuDaiTen:
{
Console.Clear();
ql.SapXepTangChieuDaiTen(DSHH).Xuat();
} break;
default:
break;
}
} break;
case Menu.XoaHangHoaMoTaX:
{
Console.Clear();
DSHH.Xuat();
string ten;
Console.WriteLine("Xin moi nhap ten hang hoa: ");
ten = Console.ReadLine();
ql.XoaHangHoaX(DSHH, ten);
DSHH.Xuat();
} break;
default:
break;
}
Console.ReadLine();
}
Console.ReadLine();
}
