void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "UPDATE {0} SET " + "{1}=?, {2}=?, {3}=?, {4}=?, {5}=?, {6}=? " + "WHERE {7}=? AND {8}=?;", TableName, // Data GetFieldName(QueryValues.CharName), GetFieldName(QueryValues.CorpName), GetFieldName(QueryValues.CorpID), GetFieldName(QueryValues.LimitedKey), GetFieldName(QueryValues.FullKey), GetFieldName(QueryValues.RegCode), // Key GetFieldName(QueryValues.UserID), GetFieldName(QueryValues.CharID))); // Data dbCommand.AddParameter((long)QueryValues.CharName); dbCommand.AddParameter((long)QueryValues.CorpName); dbCommand.AddParameter((long)QueryValues.CorpID); dbCommand.AddParameter((long)QueryValues.LimitedKey); dbCommand.AddParameter((long)QueryValues.FullKey); dbCommand.AddParameter((long)QueryValues.RegCode); // Key dbCommand.AddParameter((long)QueryValues.UserID); dbCommand.AddParameter((long)QueryValues.CharID); }
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "INSERT INTO {0} ({1}, {2}, {3}, {4}, {5}, " + "{6}, {7}, {8}) " + "VALUES(?,?,?,?,?,?,?,?);", TableName, // Key GetFieldName(QueryValues.UserID), GetFieldName(QueryValues.CharID), // Data GetFieldName(QueryValues.CharName), GetFieldName(QueryValues.CorpName), GetFieldName(QueryValues.CorpID), GetFieldName(QueryValues.LimitedKey), GetFieldName(QueryValues.FullKey), GetFieldName(QueryValues.RegCode))); // Key dbCommand.AddParameter((long)QueryValues.UserID); dbCommand.AddParameter((long)QueryValues.CharID); // Data dbCommand.AddParameter((long)QueryValues.CharName); dbCommand.AddParameter((long)QueryValues.CorpName); dbCommand.AddParameter((long)QueryValues.CorpID); dbCommand.AddParameter((long)QueryValues.LimitedKey); dbCommand.AddParameter((long)QueryValues.FullKey); dbCommand.AddParameter((long)QueryValues.RegCode); }
void IDBRecord.PrepareCommandDelete(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "DELETE FROM {0} " + "WHERE {1}=?;", TableName, GetFieldName(QueryValues.Key_ID))); // key dbCommand.AddParameter((long)QueryValues.Key_ID); }
void IDBRecord.PrepareCommandDelete(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "DELETE FROM {0} " + "WHERE {1}=? AND {2}=? AND {3}=?;", TableName, // key GetFieldName(QueryValues.CharID), GetFieldName(QueryValues.AccountID), GetFieldName(QueryValues.AccountKey))); // key dbCommand.AddParameter((long)QueryValues.CharID); dbCommand.AddParameter((long)QueryValues.AccountID); dbCommand.AddParameter((long)QueryValues.AccountKey); }
void IDBRecord.PrepareCommandDelete(Database.DatabaseCommand dbCommand) { IDBRecord iobj = this as IDBRecord; dbCommand.SetCommand(String.Format( "DELETE FROM {0} " + "WHERE {1}=? AND {2}=? AND {3}=? AND {4}=? AND {5}=? AND {6}=? AND {7}=?;", TableName, iobj.GetFieldName((long)QueryValues.CharID), iobj.GetFieldName((long)QueryValues.refID), iobj.GetFieldName((long)QueryValues.refTypeID), iobj.GetFieldName((long)QueryValues.date), iobj.GetFieldName((long)QueryValues.ownerID1), iobj.GetFieldName((long)QueryValues.ownerID2), iobj.GetFieldName((long)QueryValues.argID))); }
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "INSERT INTO {0} ( {1}, {2}, {3}, {4}, {5}, " + " {6}, {7}, {8}, {9}, {10}, " + "{11}, {12}, {13}, {14}, {15}, " + "{16}) " + "VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);", TableName, // key GetFieldName(QueryValues.charID), GetFieldName(QueryValues.orderID), GetFieldName(QueryValues.stationID), GetFieldName(QueryValues.typeID), GetFieldName(QueryValues.accountKey), GetFieldName(QueryValues.issued), // data GetFieldName(QueryValues.ownerID), GetFieldName(QueryValues.volEntered), GetFieldName(QueryValues.volRemaining), GetFieldName(QueryValues.minVolume), GetFieldName(QueryValues.orderState), GetFieldName(QueryValues.range), GetFieldName(QueryValues.duration), GetFieldName(QueryValues.escrow), GetFieldName(QueryValues.price), GetFieldName(QueryValues.bid))); // key dbCommand.AddParameter((long)QueryValues.charID); dbCommand.AddParameter((long)QueryValues.orderID); dbCommand.AddParameter((long)QueryValues.stationID); dbCommand.AddParameter((long)QueryValues.typeID); dbCommand.AddParameter((long)QueryValues.accountKey); dbCommand.AddParameter((long)QueryValues.issued); // data dbCommand.AddParameter((long)QueryValues.ownerID); dbCommand.AddParameter((long)QueryValues.volEntered); dbCommand.AddParameter((long)QueryValues.volRemaining); dbCommand.AddParameter((long)QueryValues.minVolume); dbCommand.AddParameter((long)QueryValues.orderState); dbCommand.AddParameter((long)QueryValues.range); dbCommand.AddParameter((long)QueryValues.duration); dbCommand.AddParameter((long)QueryValues.escrow); dbCommand.AddParameter((long)QueryValues.price); dbCommand.AddParameter((long)QueryValues.bid); }
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "UPDATE {0} SET {1}=?, {2}=?, {3}=?, {4}=?, {5}=?, " + "{6}=?, {7}=?, {8}=?, {9}=?, {10}=? " + "WHERE {11}=? AND {12}=? AND {13}=? AND {14}=? AND {15}=? AND {16}=?;", TableName, // data GetFieldName(QueryValues.ownerID), GetFieldName(QueryValues.volEntered), GetFieldName(QueryValues.volRemaining), GetFieldName(QueryValues.minVolume), GetFieldName(QueryValues.orderState), GetFieldName(QueryValues.range), GetFieldName(QueryValues.duration), GetFieldName(QueryValues.escrow), GetFieldName(QueryValues.price), GetFieldName(QueryValues.bid), // key GetFieldName(QueryValues.charID), GetFieldName(QueryValues.orderID), GetFieldName(QueryValues.stationID), GetFieldName(QueryValues.typeID), GetFieldName(QueryValues.accountKey), GetFieldName(QueryValues.issued))); // data dbCommand.AddParameter((long)QueryValues.ownerID); dbCommand.AddParameter((long)QueryValues.volEntered); dbCommand.AddParameter((long)QueryValues.volRemaining); dbCommand.AddParameter((long)QueryValues.minVolume); dbCommand.AddParameter((long)QueryValues.orderState); dbCommand.AddParameter((long)QueryValues.range); dbCommand.AddParameter((long)QueryValues.duration); dbCommand.AddParameter((long)QueryValues.escrow); dbCommand.AddParameter((long)QueryValues.price); dbCommand.AddParameter((long)QueryValues.bid); // key dbCommand.AddParameter((long)QueryValues.charID); dbCommand.AddParameter((long)QueryValues.orderID); dbCommand.AddParameter((long)QueryValues.stationID); dbCommand.AddParameter((long)QueryValues.typeID); dbCommand.AddParameter((long)QueryValues.accountKey); dbCommand.AddParameter((long)QueryValues.issued); }
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "INSERT INTO {0} ({1}, {2}, {3}, {4}) " + "VALUES(?, ?, ?, ?);", TableName, GetFieldName(QueryValues.CharID), GetFieldName(QueryValues.AccountID), GetFieldName(QueryValues.AccountKey), GetFieldName(QueryValues.balance))); // key dbCommand.AddParameter((long)QueryValues.CharID); dbCommand.AddParameter((long)QueryValues.AccountID); dbCommand.AddParameter((long)QueryValues.AccountKey); // data dbCommand.AddParameter((long)QueryValues.balance); }
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "INSERT INTO {0} ({1}, {2}, {3}, {4}, {5}) " + "VALUES(?, ?, ?, ?, ?);", TableName, GetFieldName(QueryValues.CorpID), GetFieldName(QueryValues.standingType), GetFieldName(QueryValues.ID), GetFieldName(QueryValues.Name), GetFieldName(QueryValues.standing))); // data dbCommand.AddParameter((long)QueryValues.CorpID); dbCommand.AddParameter((long)QueryValues.standingType); dbCommand.AddParameter((long)QueryValues.ID); dbCommand.AddParameter((long)QueryValues.Name); dbCommand.AddParameter((long)QueryValues.standing); }
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "UPDATE {0} SET {1}=? " + "WHERE {2}=? AND {3}=? AND {4}=?;", TableName, // data GetFieldName(QueryValues.balance), // key GetFieldName(QueryValues.CharID), GetFieldName(QueryValues.AccountID), GetFieldName(QueryValues.AccountKey))); // data dbCommand.AddParameter((long)QueryValues.balance); // key dbCommand.AddParameter((long)QueryValues.CharID); dbCommand.AddParameter((long)QueryValues.AccountID); dbCommand.AddParameter((long)QueryValues.AccountKey); }
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand) { IDBRecord iobj = this as IDBRecord; dbCommand.SetCommand(String.Format( "UPDATE {0} SET {1}=?, {2}=?, {3}=?, {4}=?, {5}=?, {6}=? " + "WHERE {7}=? AND {8}=? AND {9}=? AND {10}=? AND {11}=? AND {12}=? AND {13}=?;", TableName, // data iobj.GetFieldName((long)QueryValues.ownerName1), iobj.GetFieldName((long)QueryValues.ownerName2), iobj.GetFieldName((long)QueryValues.argName1), iobj.GetFieldName((long)QueryValues.amount), iobj.GetFieldName((long)QueryValues.balance), iobj.GetFieldName((long)QueryValues.reason), // key iobj.GetFieldName((long)QueryValues.CharID), iobj.GetFieldName((long)QueryValues.refID), iobj.GetFieldName((long)QueryValues.refTypeID), iobj.GetFieldName((long)QueryValues.date), iobj.GetFieldName((long)QueryValues.ownerID1), iobj.GetFieldName((long)QueryValues.ownerID2), iobj.GetFieldName((long)QueryValues.argID))); // data dbCommand.AddParameter((long)QueryValues.ownerName1); dbCommand.AddParameter((long)QueryValues.ownerName2); dbCommand.AddParameter((long)QueryValues.argName1); dbCommand.AddParameter((long)QueryValues.amount); dbCommand.AddParameter((long)QueryValues.balance); dbCommand.AddParameter((long)QueryValues.reason); // key dbCommand.AddParameter((long)QueryValues.CharID); dbCommand.AddParameter((long)QueryValues.refID); dbCommand.AddParameter((long)QueryValues.refTypeID); dbCommand.AddParameter((long)QueryValues.date); dbCommand.AddParameter((long)QueryValues.ownerID1); dbCommand.AddParameter((long)QueryValues.ownerID2); dbCommand.AddParameter((long)QueryValues.argID); }
void IDBRecord.PrepareCommandInsert(Database.DatabaseCommand dbCommand) { IDBRecord iobj = this as IDBRecord; dbCommand.SetCommand(String.Format( "INSERT INTO {0} ({1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}" + "{9}, {10}, {11}, {12}, {13}) " + "VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);", TableName, iobj.GetFieldName((long)QueryValues.CharID), iobj.GetFieldName((long)QueryValues.refID), iobj.GetFieldName((long)QueryValues.refTypeID), iobj.GetFieldName((long)QueryValues.date), iobj.GetFieldName((long)QueryValues.ownerID1), iobj.GetFieldName((long)QueryValues.ownerID2), iobj.GetFieldName((long)QueryValues.argID), iobj.GetFieldName((long)QueryValues.ownerName1), iobj.GetFieldName((long)QueryValues.ownerName2), iobj.GetFieldName((long)QueryValues.argName1), iobj.GetFieldName((long)QueryValues.amount), iobj.GetFieldName((long)QueryValues.balance), iobj.GetFieldName((long)QueryValues.reason))); // key dbCommand.AddParameter((long)QueryValues.CharID); dbCommand.AddParameter((long)QueryValues.refID); dbCommand.AddParameter((long)QueryValues.refTypeID); dbCommand.AddParameter((long)QueryValues.date); dbCommand.AddParameter((long)QueryValues.ownerID1); dbCommand.AddParameter((long)QueryValues.ownerID2); dbCommand.AddParameter((long)QueryValues.argID); // data dbCommand.AddParameter((long)QueryValues.ownerName1); dbCommand.AddParameter((long)QueryValues.ownerName2); dbCommand.AddParameter((long)QueryValues.argName1); dbCommand.AddParameter((long)QueryValues.amount); dbCommand.AddParameter((long)QueryValues.balance); dbCommand.AddParameter((long)QueryValues.reason); }
void IDBRecord.PrepareCommandDelete(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "DELETE FROM {0} " + "WHERE {1}=? AND {2}=? AND {3}=? AND {4}=? AND {5}=? AND {6}=?;", TableName, // key GetFieldName(QueryValues.charID), GetFieldName(QueryValues.orderID), GetFieldName(QueryValues.stationID), GetFieldName(QueryValues.typeID), GetFieldName(QueryValues.accountKey), GetFieldName(QueryValues.issued))); // key dbCommand.AddParameter((long)QueryValues.charID); dbCommand.AddParameter((long)QueryValues.orderID); dbCommand.AddParameter((long)QueryValues.stationID); dbCommand.AddParameter((long)QueryValues.typeID); dbCommand.AddParameter((long)QueryValues.accountKey); dbCommand.AddParameter((long)QueryValues.issued); }
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "UPDATE {0} SET {1}=?, {2}=?, {3}=?, {4}=?, {5}=? " + "WHERE {6}=?;", TableName, // data GetFieldName(QueryValues.CorpID), GetFieldName(QueryValues.standingType), GetFieldName(QueryValues.ID), GetFieldName(QueryValues.Name), GetFieldName(QueryValues.standing), // key GetFieldName((long)QueryValues.Key_ID))); // data dbCommand.AddParameter((long)QueryValues.CorpID); dbCommand.AddParameter((long)QueryValues.standingType); dbCommand.AddParameter((long)QueryValues.ID); dbCommand.AddParameter((long)QueryValues.Name); dbCommand.AddParameter((long)QueryValues.standing); // key dbCommand.AddParameter((long)QueryValues.Key_ID); }
void IDBRecord.PrepareCommandUpdate(Database.DatabaseCommand dbCommand) { dbCommand.SetCommand(String.Format( "UPDATE {0} SET " + " {5}=?, {6}=?, {7}=?, {8}=?, {9}=?, {10}=?, " + "{11}=?, {12}=?, {13}=?, {14}=?, {15}=?, {16}=?, " + "{17}=?, {18}=?, {19}=?, {20}=?, {21}=?, {22}=?, " + "{23}=?, {24}=?, {25}=?, {26}=?, {27}=?, {28}=?, " + "{29}=?, {30}=?, {31}=?, {32}=?, {33}=?, {34}=? " + "WHERE {1}=? AND {2}=? AND {3}=? AND {4}=?;", TableName, // key GetFieldName(QueryValues.CharID), GetFieldName(QueryValues.jobID), GetFieldName(QueryValues.installerID), GetFieldName(QueryValues.installTime), // data GetFieldName(QueryValues.assemblyLineID), GetFieldName(QueryValues.containerID), GetFieldName(QueryValues.installedItemID), GetFieldName(QueryValues.installedItemLocationID), GetFieldName(QueryValues.installedItemQuantity), GetFieldName(QueryValues.installedItemProductivityLevel), GetFieldName(QueryValues.installedItemMaterialLevel), GetFieldName(QueryValues.installedItemLicensedProductionRunsRemaining), GetFieldName(QueryValues.outputLocationID), GetFieldName(QueryValues.runs), GetFieldName(QueryValues.licensedProductionRuns), GetFieldName(QueryValues.installedInSolarSystemID), GetFieldName(QueryValues.containerLocationID), GetFieldName(QueryValues.materialMultiplier), GetFieldName(QueryValues.charMaterialMultiplier), GetFieldName(QueryValues.timeMultiplier), GetFieldName(QueryValues.charTimeMultiplier), GetFieldName(QueryValues.installedItemTypeID), GetFieldName(QueryValues.outputTypeID), GetFieldName(QueryValues.containerTypeID), GetFieldName(QueryValues.installedItemCopy), GetFieldName(QueryValues.completed), GetFieldName(QueryValues.completedSuccessfully), GetFieldName(QueryValues.installedItemFlag), GetFieldName(QueryValues.outputFlag), GetFieldName(QueryValues.activityID), GetFieldName(QueryValues.completedStatus), GetFieldName(QueryValues.beginProductionTime), GetFieldName(QueryValues.endProductionTime), GetFieldName(QueryValues.pauseProductionTime))); // data dbCommand.AddParameter((long)QueryValues.assemblyLineID); dbCommand.AddParameter((long)QueryValues.containerID); dbCommand.AddParameter((long)QueryValues.installedItemID); dbCommand.AddParameter((long)QueryValues.installedItemLocationID); dbCommand.AddParameter((long)QueryValues.installedItemQuantity); dbCommand.AddParameter((long)QueryValues.installedItemProductivityLevel); dbCommand.AddParameter((long)QueryValues.installedItemMaterialLevel); dbCommand.AddParameter((long)QueryValues.installedItemLicensedProductionRunsRemaining); dbCommand.AddParameter((long)QueryValues.outputLocationID); dbCommand.AddParameter((long)QueryValues.runs); dbCommand.AddParameter((long)QueryValues.licensedProductionRuns); dbCommand.AddParameter((long)QueryValues.installedInSolarSystemID); dbCommand.AddParameter((long)QueryValues.containerLocationID); dbCommand.AddParameter((long)QueryValues.materialMultiplier); dbCommand.AddParameter((long)QueryValues.charMaterialMultiplier); dbCommand.AddParameter((long)QueryValues.timeMultiplier); dbCommand.AddParameter((long)QueryValues.charTimeMultiplier); dbCommand.AddParameter((long)QueryValues.installedItemTypeID); dbCommand.AddParameter((long)QueryValues.outputTypeID); dbCommand.AddParameter((long)QueryValues.containerTypeID); dbCommand.AddParameter((long)QueryValues.installedItemCopy); dbCommand.AddParameter((long)QueryValues.completed); dbCommand.AddParameter((long)QueryValues.completedSuccessfully); dbCommand.AddParameter((long)QueryValues.installedItemFlag); dbCommand.AddParameter((long)QueryValues.outputFlag); dbCommand.AddParameter((long)QueryValues.activityID); dbCommand.AddParameter((long)QueryValues.completedStatus); dbCommand.AddParameter((long)QueryValues.beginProductionTime); dbCommand.AddParameter((long)QueryValues.endProductionTime); dbCommand.AddParameter((long)QueryValues.pauseProductionTime); // key dbCommand.AddParameter((long)QueryValues.CharID); dbCommand.AddParameter((long)QueryValues.jobID); dbCommand.AddParameter((long)QueryValues.installerID); dbCommand.AddParameter((long)QueryValues.installTime); }