protected void Page_Load(object sender, EventArgs e)
{
ItemBuilder item = new ItemBuilder("Pieza", "Playmobil");
this.LtById.Text = ItemTools.QueryById(item, 2);
this.LtByIdData.Text = Read.JsonById(2, item.ItemName, "Playmobil");
}
public static string JsonById(long id, string itemName, string instanceName)
{
var instance = CustomerFramework.Load(instanceName);
var item = new ItemBuilder(itemName, instanceName);
return(SqlStream.GetByQuerySimple(ItemTools.QueryById(item, id), instance.Config.ConnectionString));
}
public static string GetFKStream(ItemBuilder item, Dictionary <string, string> parameters, string connectionString)
{
if (item.Definition.FKList == null)
{
return(GetSqlStreamNoParams("Item_FK_" + item.ItemName, connectionString));
}
return(GetSqlQueryStreamNoParams(ItemTools.QueryFKList(item, parameters), connectionString));
}
private string GetList()
{
var res = new StringBuilder();
var listId = this.Request.QueryString["ListId"];
var itemName = this.Request.QueryString["ItemName"];
var item = new ItemBuilder(itemName, "Playmobil");
var parameters = Request.QueryString.Keys.Cast <string>().ToDictionary(k => k, v => Request.QueryString[v]);
parameters = parameters.Where(p => p.Key != "ApplicationUserId" && p.Key != "_" && p.Key != "Action" && p.Key != "ItemName" && p.Key != "ListId").ToDictionary(v => v.Key, v => v.Value);
var query = ItemTools.QueryByListId(item, parameters, listId);
var instance = CustomerFramework.Load("Playmobil");
return(SqlStream.GetByQuery(query, instance.Config.ConnectionString));
}
//set all the reference scripts
private void SetScripts()
{
GameObject scriptHolder = GameObject.Find("ScriptHolder");
int currentScene = SceneManager.GetActiveScene().buildIndex;
if (currentScene == 1)
{
userTools = scriptHolder.GetComponent <UserTools>();
itemTools = scriptHolder.GetComponent <ItemTools>();
tempGetDefaultItem = scriptHolder.GetComponent <TempGetDefaultItem>();
selectedItemScript = scriptHolder.GetComponent <SelectedItemScript>();
afkTimeScript = scriptHolder.GetComponent <AfkTimeScript>();
playTimeScript = scriptHolder.GetComponent <PlayTimeScript>();
statsUI = scriptHolder.GetComponent <StatsUI>();
customiseUserUI = scriptHolder.GetComponent <CustomiseUserUI>();
shopItemsManager = scriptHolder.GetComponent <ShopItemsManager>();
leftItemManager = scriptHolder.GetComponent <LeftItemManager>();
playerUI = scriptHolder.GetComponent <PlayerUI>();
}
else if (currentScene == 2)
{
}
}
/// <summary>
/// Constructs a new Item instance based on the data of this object.
/// </summary>
/// <returns></returns>
public Item ToItem()
{
return(new Item {
Name = Name, Price = Price, Type = ItemTools.FromString(Type), NormalizedImageName = ImageName, Count = Count, Logs = new List <ItemLog>()
});
}
public DefaultClass()
{
INVOICE_TOOLS.InitDetails();
//OtherSettingTools.InitEstimateDetails();
//OtherSettingTools.InitChallanDetails();
//OtherSettingTools.InitCreditNoteDetails();
//OtherSettingTools.InitPurchaseOrderDetails();
//OtherSettingTools.InitAdvanceReceiptVoucherDetails();
//OtherSettingTools.InitRefundVoucherDetails();
//OtherSettingTools.InitReceiptVoucherDetails();
//OtherSettingTools.InitAdvancePaymentVoucherDetails();
//OtherSettingTools.InitPaymentVoucherDetails();
//OtherSettingTools.InitDebitNoteDetails();
OtherSettingTools.CallAllFunctionOfOtherSettingTools();
UnitTools.GetUnit();
ComodityCodeTools.GetHSNCode();
ComodityCodeTools.GetSACCode();
BillingTermTools.GetBillingTerms();
EmployeeDesignationTools.GetDesignation();
BAnkTools.GetBank();
UserTools.GetUserName();
StateTool.GetState();
FinancialYearTools.GetYear();
SubGroupTools.GetIncomeExpenseGroup();
SubGroupTools.GetUnder();
CashOrBankAccountTools.GetCashAccount();
CashOrBankAccountTools.GetBankAcHead();
Supplier.GetSuppliers();
BillClas.GetAccountHeadForExpense();
ExpenseTools.GetExpenseAccountHead();
AccountHeadTools.SetCategory();
ItemTools.GetItem();
ItemTools.GetItemCategory();
ItemTools.GetSubCategory();
ItemTools.GetItemCompany();
AccountHeadTools.GetSalesLedgerID();
AccountHeadTools.GetSalesReturnLedgerID();
AccountHeadTools.GetPurchaseLedgerID();
AccountHeadTools.GetPurchaseReturnLedgerID();
Customertools.GetCustomers();
///ledgers
LedgerTools.GetAllLedgers();
LedgerTools.GetAccountLedgers();
LedgerTools.GetPartyLedgers();
LedgerTools.GetBankLedgers();
LedgerTools.GetCashLedgers();
LedgerTools.GetCash_BankLedgers();
LedgerTools.GetCustomerLedgers();
LedgerTools.GetSupplierLedgers();
LedgerTools.GetOtherLedgers();
LedgerTools.GetReceivableAccountHeadID();
SubAccountTools.GetSubAccountForExpense();
CashCustomersTools.GetCashCustomers();
}
/// <summary>
/// Constructor that instantiates FFACE
/// </summary>
/// <param name="processID">The Process ID of the POL Process you want to interface with.</param>
public FFACE (int processID)
{
// create our FFACE instance
_InstanceID = CreateInstance((UInt32)processID);
#region Find Windower Plugin Path
System.Diagnostics.Process[] Processes = System.Diagnostics.Process.GetProcessesByName("pol");
if (Processes.Length > 0)
foreach (System.Diagnostics.ProcessModule mod in Processes[0].Modules)
{
if (mod.ModuleName.ToLower() == "hook.dll")
{
WindowerPath = mod.FileName.Substring(0, mod.FileName.Length - 8) + @"\plugins\";
ParseResources.UseFFXIDatFiles = false;
break;
}
}
// Fix for non-windower users
if (String.IsNullOrEmpty(WindowerPath))
{
string ExePath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location);
// If we have a resources folder, use the resource parser otherwise let it default to using .dat reader
if (System.IO.Directory.Exists(ExePath + @"\resources\"))
{
WindowerPath = ExePath;
ParseResources.UseFFXIDatFiles = false;
}
}
#endregion
// Find out if we should be using structs or not
System.Diagnostics.FileVersionInfo fileInfo = System.Diagnostics.FileVersionInfo.GetVersionInfo(FFACE_LIBRARY);
// Need 4, 1, 0, 14 or later. Adjust these settings as needed.
UInt64 version = ( (UInt64)fileInfo.FileMajorPart << 48 ) + ( (UInt64)fileInfo.FileMinorPart << 32 ) + ( (UInt64)fileInfo.FileBuildPart << 16 ) + (UInt64)fileInfo.FilePrivatePart;
if (fileInfo.FileMajorPart != 4)
throw new Exception(NEED_v410_24_OR_HIGHER);
else if (version < 0x0004000100000018UL) // 0004 0001 0000 000E (4, 1, 0, 14) // // 0004 0001 0000 0018 (4, 1, 0, 24)
throw new Exception(NEED_v410_24_OR_HIGHER);
/*if (fileInfo.FileMajorPart != 4)
throw new Exception(NEED_v410_24_OR_HIGHER);
else if (fileInfo.FileMinorPart < 1)
throw new Exception(NEED_v410_24_OR_HIGHER);
else if (fileInfo.FileBuildPart < 0)
throw new Exception(NEED_v410_24_OR_HIGHER);
else if (fileInfo.FilePrivatePart < 14)
throw new Exception(NEED_v410_24_OR_HIGHER);*/
// instantiate our classes
Player = new PlayerTools(_InstanceID);
Target = new TargetTools(_InstanceID);
Party = new PartyTools(_InstanceID);
Fish = new FishTools(_InstanceID);
Windower = new WindowerTools(_InstanceID);
Timer = new TimerTools(_InstanceID);
Chat = new ChatTools(_InstanceID);
Item = new ItemTools(this);
NPC = new NPCTools(_InstanceID);
Menu = new MenuTools(this);
Search = new SearchTools(_InstanceID);
Navigator = new NavigatorTools(this);
Resources = ParseResources.Instance;
#region Party Members
// instantiate our party members
PartyMember = new System.Collections.Generic.Dictionary<byte, PartyMemberTools>();
PartyMember.Add(0, new PartyMemberTools(_InstanceID, 0));
PartyMember.Add(1, new PartyMemberTools(_InstanceID, 1));
PartyMember.Add(2, new PartyMemberTools(_InstanceID, 2));
PartyMember.Add(3, new PartyMemberTools(_InstanceID, 3));
PartyMember.Add(4, new PartyMemberTools(_InstanceID, 4));
PartyMember.Add(5, new PartyMemberTools(_InstanceID, 5));
PartyMember.Add(6, new PartyMemberTools(_InstanceID, 6));
PartyMember.Add(7, new PartyMemberTools(_InstanceID, 7));
PartyMember.Add(8, new PartyMemberTools(_InstanceID, 8));
PartyMember.Add(9, new PartyMemberTools(_InstanceID, 9));
PartyMember.Add(10, new PartyMemberTools(_InstanceID, 10));
PartyMember.Add(11, new PartyMemberTools(_InstanceID, 11));
PartyMember.Add(12, new PartyMemberTools(_InstanceID, 12));
PartyMember.Add(13, new PartyMemberTools(_InstanceID, 13));
PartyMember.Add(14, new PartyMemberTools(_InstanceID, 14));
PartyMember.Add(15, new PartyMemberTools(_InstanceID, 15));
PartyMember.Add(16, new PartyMemberTools(_InstanceID, 16));
PartyMember.Add(17, new PartyMemberTools(_InstanceID, 17));
#endregion
} // @ public FFACEWrapper(uint processID)
/// <summary>
/// Constructor that instantiates FFACE
/// </summary>
/// <param name="processID">The Process ID of the POL Process you want to interface with.</param>
public FFACE(int processID)
{
// create our FFACE instance
_InstanceID = CreateInstance((UInt32)processID);
#region Find Windower Plugin Path
System.Diagnostics.Process[] Processes = System.Diagnostics.Process.GetProcessesByName("pol");
if (Processes.Length > 0)
{
foreach (System.Diagnostics.ProcessModule mod in Processes[0].Modules)
{
if (mod.ModuleName.ToLower() == "hook.dll")
{
WindowerPath = mod.FileName.Substring(0, mod.FileName.Length - 8) + @"\plugins\";
ParseResources.UseFFXIDatFiles = false;
break;
}
}
}
// Fix for non-windower users
if (String.IsNullOrEmpty(WindowerPath))
{
string ExePath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location);
// If we have a resources folder, use the resource parser otherwise let it default to using .dat reader
if (System.IO.Directory.Exists(ExePath + @"\resources\"))
{
WindowerPath = ExePath;
ParseResources.UseFFXIDatFiles = false;
}
}
#endregion
// Find out if we should be using structs or not
System.Diagnostics.FileVersionInfo fileInfo = System.Diagnostics.FileVersionInfo.GetVersionInfo(FFACE_LIBRARY);
// Need 4, 1, 0, 14 or later. Adjust these settings as needed.
UInt64 version = ((UInt64)fileInfo.FileMajorPart << 48) + ((UInt64)fileInfo.FileMinorPart << 32) + ((UInt64)fileInfo.FileBuildPart << 16) + (UInt64)fileInfo.FilePrivatePart;
if (fileInfo.FileMajorPart != 4)
{
throw new Exception(NEED_v410_24_OR_HIGHER);
}
else if (version < 0x0004000100000018UL) // 0004 0001 0000 000E (4, 1, 0, 14) // // 0004 0001 0000 0018 (4, 1, 0, 24)
{
throw new Exception(NEED_v410_24_OR_HIGHER);
}
/*if (fileInfo.FileMajorPart != 4)
* throw new Exception(NEED_v410_24_OR_HIGHER);
* else if (fileInfo.FileMinorPart < 1)
* throw new Exception(NEED_v410_24_OR_HIGHER);
* else if (fileInfo.FileBuildPart < 0)
* throw new Exception(NEED_v410_24_OR_HIGHER);
* else if (fileInfo.FilePrivatePart < 14)
* throw new Exception(NEED_v410_24_OR_HIGHER);*/
// instantiate our classes
Player = new PlayerTools(_InstanceID);
Target = new TargetTools(_InstanceID);
Party = new PartyTools(_InstanceID);
Fish = new FishTools(_InstanceID);
Windower = new WindowerTools(_InstanceID);
Timer = new TimerTools(_InstanceID);
Chat = new ChatTools(_InstanceID);
Item = new ItemTools(this);
NPC = new NPCTools(_InstanceID);
Menu = new MenuTools(this);
Search = new SearchTools(_InstanceID);
Navigator = new NavigatorTools(this);
Resources = ParseResources.Instance;
#region Party Members
// instantiate our party members
PartyMember = new System.Collections.Generic.Dictionary <byte, PartyMemberTools>();
PartyMember.Add(0, new PartyMemberTools(_InstanceID, 0));
PartyMember.Add(1, new PartyMemberTools(_InstanceID, 1));
PartyMember.Add(2, new PartyMemberTools(_InstanceID, 2));
PartyMember.Add(3, new PartyMemberTools(_InstanceID, 3));
PartyMember.Add(4, new PartyMemberTools(_InstanceID, 4));
PartyMember.Add(5, new PartyMemberTools(_InstanceID, 5));
PartyMember.Add(6, new PartyMemberTools(_InstanceID, 6));
PartyMember.Add(7, new PartyMemberTools(_InstanceID, 7));
PartyMember.Add(8, new PartyMemberTools(_InstanceID, 8));
PartyMember.Add(9, new PartyMemberTools(_InstanceID, 9));
PartyMember.Add(10, new PartyMemberTools(_InstanceID, 10));
PartyMember.Add(11, new PartyMemberTools(_InstanceID, 11));
PartyMember.Add(12, new PartyMemberTools(_InstanceID, 12));
PartyMember.Add(13, new PartyMemberTools(_InstanceID, 13));
PartyMember.Add(14, new PartyMemberTools(_InstanceID, 14));
PartyMember.Add(15, new PartyMemberTools(_InstanceID, 15));
PartyMember.Add(16, new PartyMemberTools(_InstanceID, 16));
PartyMember.Add(17, new PartyMemberTools(_InstanceID, 17));
#endregion
} // @ public FFACEWrapper(uint processID)
/// <summary>
/// Constructor that instantiates FFACE
/// </summary>
/// <param name="processID">The Process ID of the POL Process you want to interface with.</param>
public FFACE(int processID)
{
// create our FFACE instance
_InstanceID = CreateInstance((UInt32)processID);
if (!System.IO.Directory.Exists(WindowerPath) && !ParseResources.UseFFXIDatFiles)
ParseResources.UseFFXIDatFiles = true;
//#region Find Windower Plugin Path
//System.Diagnostics.Process[] Processes = System.Diagnostics.Process.GetProcessesByName("pol");
//if (Processes.Length > 0)
// foreach (System.Diagnostics.ProcessModule mod in Processes[0].Modules)
// {
// if (mod.ModuleName.ToLower() == "hook.dll")
// {
// WindowerPath = mod.FileName.Substring(0, mod.FileName.Length - 8) + @"\plugins\";
// break;
// }
// }
//if (String.IsNullOrEmpty(WindowerPath))
// WindowerPath = "Windower path could not be found";
//#endregion
// Find out if we should be using structs or not
System.Diagnostics.FileVersionInfo fileInfo = System.Diagnostics.FileVersionInfo.GetVersionInfo(FFACE_LIBRARY);
// Need 4, 1, 0, 14 or later. Adjust these settings as needed.
UInt64 version = ((UInt64)fileInfo.FileMajorPart << 48) + ((UInt64)fileInfo.FileMinorPart << 32) + ((UInt64)fileInfo.FileBuildPart << 16) + (UInt64)fileInfo.FilePrivatePart;
if (fileInfo.FileMajorPart != 4)
throw new Exception(NEED_v410_14_OR_HIGHER);
else if (version < 0x000400010000000EUL) // 0004 0001 0000 000E (4, 1, 0, 14)
throw new Exception(NEED_v410_14_OR_HIGHER);
/*if (fileInfo.FileMajorPart != 4)
throw new Exception(NEED_v410_14_OR_HIGHER);
else if (fileInfo.FileMinorPart < 1)
throw new Exception(NEED_v410_14_OR_HIGHER);
else if (fileInfo.FileBuildPart < 0)
throw new Exception(NEED_v410_14_OR_HIGHER);
else if (fileInfo.FilePrivatePart < 14)
throw new Exception(NEED_v410_14_OR_HIGHER);*/
// instantiate our classes
Player = new PlayerTools(_InstanceID);
Target = new TargetTools(_InstanceID);
Party = new PartyTools(_InstanceID);
Fish = new FishTools(_InstanceID);
Windower = new WindowerTools(_InstanceID);
Timer = new TimerTools(_InstanceID);
Chat = new ChatTools(_InstanceID);
Item = new ItemTools(this);
NPC = new NPCTools(_InstanceID);
Menu = new MenuTools(this);
Search = new SearchTools(_InstanceID);
Navigator = new NavigatorTools(this);
//Resources = ParseResources.Instance;
#region Party Members
// instantiate our party members
PartyMember = new System.Collections.Generic.Dictionary<byte, PartyMemberTools>();
PartyMember.Add(0, new PartyMemberTools(_InstanceID, 0));
PartyMember.Add(1, new PartyMemberTools(_InstanceID, 1));
PartyMember.Add(2, new PartyMemberTools(_InstanceID, 2));
PartyMember.Add(3, new PartyMemberTools(_InstanceID, 3));
PartyMember.Add(4, new PartyMemberTools(_InstanceID, 4));
PartyMember.Add(5, new PartyMemberTools(_InstanceID, 5));
PartyMember.Add(6, new PartyMemberTools(_InstanceID, 6));
PartyMember.Add(7, new PartyMemberTools(_InstanceID, 7));
PartyMember.Add(8, new PartyMemberTools(_InstanceID, 8));
PartyMember.Add(9, new PartyMemberTools(_InstanceID, 9));
PartyMember.Add(10, new PartyMemberTools(_InstanceID, 10));
PartyMember.Add(11, new PartyMemberTools(_InstanceID, 11));
PartyMember.Add(12, new PartyMemberTools(_InstanceID, 12));
PartyMember.Add(13, new PartyMemberTools(_InstanceID, 13));
PartyMember.Add(14, new PartyMemberTools(_InstanceID, 14));
PartyMember.Add(15, new PartyMemberTools(_InstanceID, 15));
PartyMember.Add(16, new PartyMemberTools(_InstanceID, 16));
PartyMember.Add(17, new PartyMemberTools(_InstanceID, 17));
#endregion
}
/// <summary>
/// Constructor that instantiates FFACE
/// </summary>
/// <param name="processID">The Process ID of the POL Process you want to interface with.</param>
public FFACE(int processID)
{
// create our FFACE instance
_InstanceID = CreateInstance((UInt32)processID);
if (!System.IO.Directory.Exists(WindowerPath) && !ParseResources.UseFFXIDatFiles)
{
ParseResources.UseFFXIDatFiles = true;
}
//#region Find Windower Plugin Path
//System.Diagnostics.Process[] Processes = System.Diagnostics.Process.GetProcessesByName("pol");
//if (Processes.Length > 0)
// foreach (System.Diagnostics.ProcessModule mod in Processes[0].Modules)
// {
// if (mod.ModuleName.ToLower() == "hook.dll")
// {
// WindowerPath = mod.FileName.Substring(0, mod.FileName.Length - 8) + @"\plugins\";
// break;
// }
// }
//if (String.IsNullOrEmpty(WindowerPath))
// WindowerPath = "Windower path could not be found";
//#endregion
// Find out if we should be using structs or not
System.Diagnostics.FileVersionInfo fileInfo = System.Diagnostics.FileVersionInfo.GetVersionInfo(FFACE_LIBRARY);
// Need 4, 1, 0, 14 or later. Adjust these settings as needed.
UInt64 version = ((UInt64)fileInfo.FileMajorPart << 48) + ((UInt64)fileInfo.FileMinorPart << 32) + ((UInt64)fileInfo.FileBuildPart << 16) + (UInt64)fileInfo.FilePrivatePart;
if (fileInfo.FileMajorPart != 4)
{
throw new Exception(NEED_v410_14_OR_HIGHER);
}
else if (version < 0x000400010000000EUL) // 0004 0001 0000 000E (4, 1, 0, 14)
{
throw new Exception(NEED_v410_14_OR_HIGHER);
}
/*if (fileInfo.FileMajorPart != 4)
* throw new Exception(NEED_v410_14_OR_HIGHER);
* else if (fileInfo.FileMinorPart < 1)
* throw new Exception(NEED_v410_14_OR_HIGHER);
* else if (fileInfo.FileBuildPart < 0)
* throw new Exception(NEED_v410_14_OR_HIGHER);
* else if (fileInfo.FilePrivatePart < 14)
* throw new Exception(NEED_v410_14_OR_HIGHER);*/
// instantiate our classes
Player = new PlayerTools(_InstanceID);
Target = new TargetTools(_InstanceID);
Party = new PartyTools(_InstanceID);
Fish = new FishTools(_InstanceID);
Windower = new WindowerTools(_InstanceID);
Timer = new TimerTools(_InstanceID);
Chat = new ChatTools(_InstanceID);
Item = new ItemTools(this);
NPC = new NPCTools(_InstanceID);
Menu = new MenuTools(this);
Search = new SearchTools(_InstanceID);
Navigator = new NavigatorTools(this);
//Resources = ParseResources.Instance;
#region Party Members
// instantiate our party members
PartyMember = new System.Collections.Generic.Dictionary <byte, PartyMemberTools>();
PartyMember.Add(0, new PartyMemberTools(_InstanceID, 0));
PartyMember.Add(1, new PartyMemberTools(_InstanceID, 1));
PartyMember.Add(2, new PartyMemberTools(_InstanceID, 2));
PartyMember.Add(3, new PartyMemberTools(_InstanceID, 3));
PartyMember.Add(4, new PartyMemberTools(_InstanceID, 4));
PartyMember.Add(5, new PartyMemberTools(_InstanceID, 5));
PartyMember.Add(6, new PartyMemberTools(_InstanceID, 6));
PartyMember.Add(7, new PartyMemberTools(_InstanceID, 7));
PartyMember.Add(8, new PartyMemberTools(_InstanceID, 8));
PartyMember.Add(9, new PartyMemberTools(_InstanceID, 9));
PartyMember.Add(10, new PartyMemberTools(_InstanceID, 10));
PartyMember.Add(11, new PartyMemberTools(_InstanceID, 11));
PartyMember.Add(12, new PartyMemberTools(_InstanceID, 12));
PartyMember.Add(13, new PartyMemberTools(_InstanceID, 13));
PartyMember.Add(14, new PartyMemberTools(_InstanceID, 14));
PartyMember.Add(15, new PartyMemberTools(_InstanceID, 15));
PartyMember.Add(16, new PartyMemberTools(_InstanceID, 16));
PartyMember.Add(17, new PartyMemberTools(_InstanceID, 17));
#endregion
} // @ public FFACEWrapper(uint processID)
