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);
}
