public PyDataType GetMembers(int corporationID, int startPos, int limit, SparseRowsetHeader header, Dictionary <PyDataType, int> rowsIndex)
{
// TODO: GENERATE PROPER FIELDS FOR THE FOLLOWING FIELDS
// TODO: titleMask, grantableRoles, grantableRolesAtHQ, grantableRolesAtBase, grantableRolesAtOther
// TODO: divisionID, squadronID
// TODO: CHECK IF THIS startDateTime IS THE CORP'S MEMBERSHIP OR CHARACTER'S MEMBERSHIP
MySqlConnection connection = null;
MySqlDataReader reader = Database.PrepareQuery(ref connection,
"SELECT" +
" characterID, title, startDateTime, corpRole AS roles, rolesAtHQ, rolesAtBase, rolesAtOther," +
" titleMask, 0 AS grantableRoles, 0 AS grantableRolesAtHQ, 0 AS grantableRolesAtBase," +
" 0 AS grantableRolesAtOther, 0 AS divisionID, 0 AS squadronID, 0 AS baseID, " +
" 0 AS blockRoles, gender " +
"FROM chrInformation " +
"WHERE corporationID=@corporationID " +
"LIMIT @startPos,@limit",
new Dictionary <string, object>()
{
{ "@corporationID", corporationID },
{ "@startPos", startPos },
{ "@limit", limit }
}
);
using (connection)
using (reader)
{
return(header.DataFromMySqlReader(0, reader, rowsIndex));
}
}
public PyDataType GetMembers(PyList characterIDs, int corporationID, SparseRowsetHeader header, Dictionary <PyDataType, int> rowsIndex)
{
// TODO: GENERATE PROPER FIELDS FOR THE FOLLOWING FIELDS
// TODO: titleMask, grantableRoles, grantableRolesAtHQ, grantableRolesAtBase, grantableRolesAtOther
// TODO: divisionID, squadronID
// TODO: CHECK IF THIS startDateTime IS THE CORP'S MEMBERSHIP OR CHARACTER'S MEMBERSHIP
Dictionary <string, object> parameters = new Dictionary <string, object>();
string query = "SELECT" +
" characterID, title, startDateTime, corpRole AS roles, rolesAtHQ, rolesAtBase, rolesAtOther," +
" titleMask, 0 AS grantableRoles, 0 AS grantableRolesAtHQ, 0 AS grantableRolesAtBase," +
" 0 AS grantableRolesAtOther, 0 AS divisionID, 0 AS squadronID, 0 AS baseID, " +
" 0 AS blockRoles, gender " +
"FROM chrInformation " +
"WHERE corporationID=@corporationID AND characterID IN (";
foreach (PyDataType id in characterIDs)
{
parameters["@characterID" + parameters.Count.ToString("X")] = (int)(id as PyInteger);
}
// prepare the correct list of arguments
query += String.Join(',', parameters.Keys) + ")";
parameters["@corporationID"] = corporationID;
MySqlConnection connection = null;
MySqlDataReader reader = Database.PrepareQuery(ref connection, query, parameters);
using (connection)
using (reader)
{
return(header.DataFromMySqlReader(0, reader, rowsIndex));
}
}
public PyDataType GetOffices(PyList itemIDs, int corporationID, SparseRowsetHeader header, Dictionary <PyDataType, int> rowsIndex)
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
string query = "SELECT" +
" itemID, stationID, typeID, officeFolderID " +
"FROM chrInformation " +
"LEFT JOIN invItems ON invItems.itemID = chrInformation.activeCloneID " +
"WHERE corporationID=@corporationID AND itemID IN (";
foreach (PyDataType id in itemIDs)
{
parameters["@itemID" + parameters.Count.ToString("X")] = (int)(id as PyInteger);
}
// prepare the correct list of arguments
query += String.Join(',', parameters.Keys) + ")";
parameters["@corporationID"] = corporationID;
// TODO: GENERATE PROPER FIELDS FOR THE FOLLOWING FIELDS
// TODO: titleMask, grantableRoles, grantableRolesAtHQ, grantableRolesAtBase, grantableRolesAtOther
// TODO: divisionID, squadronID
// TODO: CHECK IF THIS startDateTime IS THE CORP'S MEMBERSHIP OR CHARACTER'S MEMBERSHIP
MySqlConnection connection = null;
MySqlDataReader reader = Database.PrepareQuery(ref connection, query, parameters);
using (connection)
using (reader)
{
return(header.DataFromMySqlReader(0, reader, rowsIndex));
}
}
public PyDataType GetOffices(int corporationID, int startPos, int limit, SparseRowsetHeader header, Dictionary <PyDataType, int> rowsIndex)
{
MySqlConnection connection = null;
MySqlDataReader reader = Database.PrepareQuery(ref connection,
"SELECT" +
" itemID, stationID, typeID, officeFolderID " +
"FROM crpOffices " +
"WHERE corporationID=@corporationID " +
"LIMIT @startPos,@limit",
new Dictionary <string, object>()
{
{ "@corporationID", corporationID },
{ "@startPos", startPos },
{ "@limit", limit }
}
);
using (connection)
using (reader)
{
return(header.DataFromMySqlReader(0, reader, rowsIndex));
}
}