public static string GetBaseSchema(Helpers.GeneralHelpers.APPLICATION_TYPES appType)
{
string sBaseSchemaName = string.Empty;
if (appType == Helpers.GeneralHelpers.APPLICATION_TYPES.agreements)
{
sBaseSchemaName = AppHelpers.Agreement.AGREEMENTSBASE_SCHEMA;
}
else if (appType == Helpers.GeneralHelpers.APPLICATION_TYPES.devpacks)
{
sBaseSchemaName = AppHelpers.DevPacks.DEVPACKBASEEDIT_SCHEMA;
}
return(sBaseSchemaName);
}
//public static string GetQry(ContentURI uri,
// bool isPageSearch)
//{
// string sQry = string.Empty;
// switch (uri.URIDataManager.AppType)
// {
// case GeneralHelpers.APPLICATION_TYPES.accounts:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchAccountsByPage";
// }
// else
// {
// sQry = "0GetSearchAccountChildren";
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.members:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchToResourceByPage";
// }
// else
// {
// sQry = "0GetSearchMemberChildren";
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.networks:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchNetworkByPage";
// }
// else
// {
// sQry = "0GetSearchNetworkChildren";
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.locals:
// //no page search
// if (isPageSearch == false)
// {
// sQry = "0GetSearchLocalChildren";
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.addins:
// //no page search
// if (isPageSearch == false)
// {
// sQry = "0GetSearchAddInChildren";
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.agreements:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchServiceByPage";
// }
// else
// {
// sQry = "0GetSearchServiceChildren";
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.prices:
// switch (uri.URIDataManager.SubAppType)
// {
// case GeneralHelpers.SUBAPPLICATION_TYPES.inputprices:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchInputByPage";
// }
// else
// {
// sQry = "0GetSearchInputChildren";
// }
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.outputprices:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchOutputByPage";
// }
// else
// {
// sQry = "0GetSearchOutputChildren";
// }
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.outcomeprices:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchOutcomeByPage";
// }
// else
// {
// sQry = "0GetSearchOutcomeChildren";
// }
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.operationprices:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchOperationByPage";
// }
// else
// {
// sQry = "0GetSearchOperationChildren";
// }
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.componentprices:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchComponentByPage";
// }
// else
// {
// sQry = "0GetSearchComponentChildren";
// }
// break;
// default:
// break;
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.economics1:
// switch (uri.URIDataManager.SubAppType)
// {
// case GeneralHelpers.SUBAPPLICATION_TYPES.budgets:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchBudgetsByPage";
// }
// else
// {
// sQry = "0GetSearchBudgetChildren";
// }
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.investments:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchInvestmentsByPage";
// }
// else
// {
// sQry = "0GetSearchInvestmentChildren";
// }
// break;
// default:
// break;
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.devpacks:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchDevPackByPage";
// }
// else
// {
// sQry = "0GetSearchDevPackChildren";
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.linkedviews:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchLinkedViewByPage";
// }
// else
// {
// sQry = "0GetSearchLinkedViewChildren";
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.resources:
// if (isPageSearch == true)
// {
// sQry = "0GetSearchResourceByPage";
// }
// else
// {
// sQry = "0GetSearchResourceChildren";
// }
// break;
// default:
// //don't render any ui
// break;
// }
// return sQry;
//}
//private static string GetSearchByServiceQry(ContentURI uri)
//{
// string sQry = string.Empty;
// switch (uri.URIDataManager.AppType)
// {
// case GeneralHelpers.APPLICATION_TYPES.accounts:
// sQry = "0GetSearchAccount";
// break;
// case GeneralHelpers.APPLICATION_TYPES.members:
// sQry = "0GetSearchToResourceByService";
// break;
// case GeneralHelpers.APPLICATION_TYPES.networks:
// sQry = "0GetSearchNetworkByService";
// break;
// case GeneralHelpers.APPLICATION_TYPES.locals:
// sQry = "0GetSearchLinkedViewByService";
// break;
// case GeneralHelpers.APPLICATION_TYPES.addins:
// sQry = "0GetSearchLinkedViewByService";
// break;
// case GeneralHelpers.APPLICATION_TYPES.agreements:
// sQry = "0GetSearchServiceByService";
// break;
// case GeneralHelpers.APPLICATION_TYPES.prices:
// switch (uri.URIDataManager.SubAppType)
// {
// case GeneralHelpers.SUBAPPLICATION_TYPES.inputprices:
// sQry = "0GetSearchInputByService";
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.outputprices:
// sQry = "0GetSearchOutputByService";
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.outcomeprices:
// sQry = "0GetSearchOutcomeByService";
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.operationprices:
// sQry = "0GetSearchOperationByService";
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.componentprices:
// sQry = "0GetSearchComponentByService";
// break;
// default:
// break;
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.economics1:
// switch (uri.URIDataManager.SubAppType)
// {
// case GeneralHelpers.SUBAPPLICATION_TYPES.budgets:
// sQry = "0GetSearchBudgetsByService";
// break;
// case GeneralHelpers.SUBAPPLICATION_TYPES.investments:
// sQry = "0GetSearchInvestmentsByService";
// break;
// default:
// break;
// }
// break;
// case GeneralHelpers.APPLICATION_TYPES.devpacks:
// sQry = "0GetSearchDevPackByService";
// break;
// case GeneralHelpers.APPLICATION_TYPES.linkedviews:
// sQry = "0GetSearchLinkedViewByService";
// break;
// case GeneralHelpers.APPLICATION_TYPES.resources:
// sQry = "0GetSearchResourceByService";
// break;
// default:
// //don't render any ui
// break;
// }
// return sQry;
//}
private static bool NeedsTypeIdSearchParam(Helpers.GeneralHelpers.APPLICATION_TYPES appType)
{
bool bNeedsTypeId = false;
if (appType
== GeneralHelpers.APPLICATION_TYPES.linkedviews ||
appType
== GeneralHelpers.APPLICATION_TYPES.devpacks ||
appType
== GeneralHelpers.APPLICATION_TYPES.resources ||
appType
== GeneralHelpers.APPLICATION_TYPES.prices ||
appType
== GeneralHelpers.APPLICATION_TYPES.economics1)
{
bNeedsTypeId = true;
}
return(bNeedsTypeId);
}
public static void GetParentsOfRecursiveNodesIds(
EditHelper.ArgumentsEdits addsArguments,
Helpers.GeneralHelpers.APPLICATION_TYPES appType,
out string recursiveParentKeyName,
out string recursiveParentId)
{
recursiveParentKeyName = string.Empty;
recursiveParentId = string.Empty;
switch (appType)
{
case Helpers.GeneralHelpers.APPLICATION_TYPES.devpacks:
AppHelpers.DevPacks.GetParentOfRecursiveNodesId(addsArguments,
out recursiveParentKeyName, out recursiveParentId);
break;
default:
//don't render any ui
break;
}
}
public static string GetForeignKeyName(Helpers.GeneralHelpers.APPLICATION_TYPES appType,
Helpers.GeneralHelpers.SUBAPPLICATION_TYPES subAppType, string parentNodeName,
bool isBaseKey)
{
string sForeignKeyName = string.Empty;
string sChildForeignName = string.Empty;
string sBaseForeignKeyName = string.Empty;
switch (appType)
{
case Helpers.GeneralHelpers.APPLICATION_TYPES.accounts:
AppHelpers.Accounts.GetChildForeignKeyName(parentNodeName,
out sForeignKeyName);
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.members:
AppHelpers.Members.GetChildForeignKeyName(parentNodeName,
out sChildForeignName, out sBaseForeignKeyName);
if (isBaseKey == true)
{
sForeignKeyName = sBaseForeignKeyName;
}
else
{
sForeignKeyName = sChildForeignName;
}
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.networks:
AppHelpers.Networks.GetChildForeignKeyName(parentNodeName,
out sChildForeignName, out sBaseForeignKeyName);
if (isBaseKey == true)
{
sForeignKeyName = sBaseForeignKeyName;
}
else
{
sForeignKeyName = sChildForeignName;
}
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.locals:
AppHelpers.Locals.GetChildForeignKeyName(parentNodeName,
out sChildForeignName, out sBaseForeignKeyName);
if (isBaseKey == true)
{
sForeignKeyName = sBaseForeignKeyName;
}
else
{
sForeignKeyName = sChildForeignName;
}
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.addins:
AppHelpers.AddIns.GetChildForeignKeyName(parentNodeName,
out sChildForeignName, out sBaseForeignKeyName);
if (isBaseKey == true)
{
sForeignKeyName = sBaseForeignKeyName;
}
else
{
sForeignKeyName = sChildForeignName;
}
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.agreements:
AppHelpers.Agreement.GetChildForeignKeyNames(parentNodeName,
out sChildForeignName, out sBaseForeignKeyName);
if (isBaseKey == true)
{
sForeignKeyName = sBaseForeignKeyName;
}
else
{
sForeignKeyName = sChildForeignName;
}
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.prices:
AppHelpers.Prices.GetChildForeignKeyName(subAppType, parentNodeName,
out sForeignKeyName);
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.economics1:
AppHelpers.Economics1.GetChildForeignKeyName(subAppType, parentNodeName,
out sForeignKeyName);
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.devpacks:
AppHelpers.DevPacks.GetChildForeignKeyName(parentNodeName,
out sChildForeignName, out sBaseForeignKeyName);
if (isBaseKey == true)
{
sForeignKeyName = sBaseForeignKeyName;
}
else
{
sForeignKeyName = sChildForeignName;
}
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.linkedviews:
AppHelpers.LinkedViews.GetChildForeignKeyName(parentNodeName,
out sForeignKeyName);
break;
case Helpers.GeneralHelpers.APPLICATION_TYPES.resources:
AppHelpers.Resources.GetChildForeignKeyName(parentNodeName,
out sForeignKeyName);
break;
default:
//don't render any ui
break;
}
return(sForeignKeyName);
}
