///<summary>
/// Written by Claus
/// GET: GetXenaData - fiscal period data
///</summary>
public static List <LedgerGroupData> LedgerGroupData(string token, int fiscalID, DateTime fromData, DateTime toData)
{
//create an instanse of a ledgergroupdata
List <LedgerGroupData> ledgerGroupDataList = new List <LedgerGroupData>(); // A new empty list of LedgerGroupData
//
//create a list of the tokens received from xena - tokens here are key/value pairs
//Next we call xena, pass in the accesstoken, to retrieve our data from the api
long fromXenaEpoch = TimeInEpoch(fromData);
long toXenaEpoch = TimeInEpoch(toData);
int fiscalPeriodId = 169626878; // Needs to be dynamic!
string url = "Fiscal/" + fiscalID +
"/Transaction/LedgerGroupData" +
"?fiscalPeriodId=" + fiscalPeriodId +
"&FiscalDateFrom=" + fromXenaEpoch +
"&FiscalDateTo=" + toXenaEpoch;
List <JToken> jTokenList = XenaLogic.CallXena(token, url); // List with JTokens from Xena's Array
//take each token in the token list and add them to the ledgergroup list
foreach (JToken jToken in jTokenList)
{
ledgerGroupDataList.Add(new LedgerGroupData(jToken)); // Adds each Entity to a LedgerGroupData
}
foreach (LedgerGroupData ledgerGroupData in ledgerGroupDataList)
{
ledgerGroupData.LedgerGroupDetailDataList = LedgerGroupDetailData(token, fiscalID, ledgerGroupData.Group, fromXenaEpoch, toXenaEpoch);
}
return(ledgerGroupDataList);
}
///<summary>
/// Written by Claus and Thomas
/// GET: list of ledgertag objects - the account names
///</summary>
public static List <LedgerTags> LedgerTag(string token, int fiscalID) //Takes the helper object xena to easier connect to xena
{
List <LedgerTags> LedgerTagList = new List <LedgerTags>();
//create a list of the tokens received from xena - tokens here are key/value pairs
//Next we call xena, pass in the accesstoken, to retrieve our data from the api
string url = "Fiscal/" + fiscalID +
"/LedgerTag";
List <JToken> jTokenList = XenaLogic.CallXena(token, url);
//take each token in the token list and add them to the ledgergroup list
foreach (JToken jToken in jTokenList)
{
if (jToken["Id"].Type != JTokenType.Null && int.Parse(jToken["Id"].ToString()) != 0)
{
if (int.Parse(jToken["Number"].ToString()) != 8900 && int.Parse(jToken["Number"].ToString()) != 8920)
{
LedgerTagList.Add(new LedgerTags(jToken)); // Adds each Entity to a LedgerTag list
}
}
}
return(LedgerTagList);
}
///<summary>
/// Written by Claus
///</summary>
public static List <LedgerGroupDetailData> LedgerGroupDetailData(string token, int fiscalID, string group, long fromXenaEpoch, long toXenaEpoch)
{
//create an instanse of a ledgergroupdata
List <LedgerGroupDetailData> ledgerGroupDetailDataList = new List <LedgerGroupDetailData>();
//create a list of the tokens received from xena - tokens here are key/value pairs
//Next we call xena, pass in the accesstoken, to retrieve our data from the api
int fiscalPeriodId = 169626878; // Needs to be dynamic!
string url = "Fiscal/" + fiscalID +
"/Transaction/LedgerGroupDataDetail" +
"?fiscalPeriodId=" + fiscalPeriodId +
"&FiscalDateFrom=" + fromXenaEpoch +
"&FiscalDateTo=" + toXenaEpoch +
"&ledgerAccount=" + group +
"&_=1512035981799";
List <JToken> jTokenList = XenaLogic.CallXena(token, url); // List with JTokens from Xena's Array
//take each token in the token list and add them to the ledgergroup list
foreach (JToken jToken in jTokenList)
{
ledgerGroupDetailDataList.Add(new LedgerGroupDetailData(jToken)); // Adds each Entity to a LedgerGroupData
}
return(ledgerGroupDetailDataList);
}
///<summary>
/// Written by Mikael
///</summary>
public static List <ExtraLedgerTag> GetProductTag(string token)
{
List <ExtraLedgerTag> ExtraLedgerTagList = new List <ExtraLedgerTag>();
//create a list of the tokens received from xena - tokens here are key/value pairs
//Next we call xena, pass in the accesstoken, to retrieve our data from the api
List <JToken> jTokenList = XenaLogic.CallXena(token,
"Fiscal/98437/Transaction/LedgerGroupDataDetail?fiscalPeriodId=169626878&FiscalDateFrom=17197&FiscalDateTo=17535&ledgerAccount=Xena_Domain_Income_Accounts_Product_Consumption&_=1512035981799"); // List with JTokens from Xena's Array
//take each token in the token list and add them to the ledgergroup list
foreach (JToken jToken in jTokenList)
{
ExtraLedgerTagList.Add(new ExtraLedgerTag(jToken)); // Adds each Entity to a LedgerGroupData
}
return(ExtraLedgerTagList);
}
///<summary>
/// Written by Claus
/// GET: list of ledgeraccount objects - the group names
///</summary>
public static List <LedgerAccounts> LedgerAccount(string token, int fiscalID) //Takes the helper object xena to easier connect to xena
{
List <LedgerAccounts> LedgerAccountList = new List <LedgerAccounts>();
//create a list of the tokens received from xena - tokens here are key/value pairs
//Next we call xena, pass in the accesstoken, to retrieve our data from the api
string url = "Fiscal/" + fiscalID +
"/LedgerTagGroup/LedgerAccount";
List <JToken> jTokenList = XenaLogic.CallXena(token, url);
//take each token in the token list and add them to the ledgeraccount list
foreach (JToken jToken in jTokenList)
{
LedgerAccountList.Add(new LedgerAccounts(jToken)); // Adds each Entity to a Ledger account list
}
return(LedgerAccountList);
}
