public WorkoutPlan(DbDataReader reader)
{
_id = reader.GetInt64(0);
_title = reader.GetValue(1).ToString() == "" ? "" : reader.GetString(1);
_period = reader.GetValue(2).ToString() == "" ? (byte)0 : reader.GetByte(2);
_creatorId = reader.GetValue(3).ToString() == "" ? 0 : reader.GetInt64(3);
}
public SelectedSnapshot Map(DbDataReader reader)
{
var persistenceId = reader.GetString(0);
var sequenceNr = reader.GetInt64(1);
var timestamp = new DateTime(reader.GetInt64(2));
var metadata = new SnapshotMetadata(persistenceId, sequenceNr, timestamp);
var snapshot = GetSnapshot(reader);
return new SelectedSnapshot(metadata, snapshot);
}
private BasicOutboundInvoiceItem ReadOutboundInvoiceItemFromDataReader (DbDataReader reader)
{
int outboundInvoiceItemId = reader.GetInt32(0);
int outboundInvoiceId = reader.GetInt32(1);
string description = reader.GetString(2);
Int64 amountCents = reader.GetInt64(3);
return new BasicOutboundInvoiceItem(outboundInvoiceItemId, outboundInvoiceId, description, amountCents);
}
public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null)
{
var persistenceId = reader.GetString(0);
var sequenceNr = reader.GetInt64(1);
var isDeleted = reader.GetBoolean(2);
var payload = GetPayload(reader);
return new Persistent(payload, sequenceNr, persistenceId, isDeleted, sender);
}
public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null)
{
var persistenceId = reader.GetString(PersistenceIdIndex);
var sequenceNr = reader.GetInt64(SequenceNrIndex);
var isDeleted = reader.GetBoolean(IsDeletedIndex);
var manifest = reader.GetString(ManifestIndex);
// timestamp is SQL-journal specific field, it's not a part of casual Persistent instance
var payload = GetPayload(reader, manifest);
return new Persistent(payload, sequenceNr, persistenceId, manifest, isDeleted, sender);
}
private BasicPayrollAdjustment ReadPayrollAdjustmentFromDataReader(DbDataReader reader)
{
int payrollAdjustmentId = reader.GetInt32(0);
int payrollAdjustmentTypeId = reader.GetInt32(1);
int payrollItemId = reader.GetInt32(2);
Int64 amountCents = reader.GetInt64(3);
string description = reader.GetString(4);
bool open = reader.GetBoolean(5);
int salaryId = reader.GetInt32(6);
return new BasicPayrollAdjustment(payrollAdjustmentId, payrollItemId,
(PayrollAdjustmentType) payrollAdjustmentTypeId,
amountCents, description, open, salaryId);
}
static int GetInt64(IntPtr L)
{
try
{
ToLua.CheckArgsCount(L, 2);
System.Data.Common.DbDataReader obj = (System.Data.Common.DbDataReader)ToLua.CheckObject(L, 1, typeof(System.Data.Common.DbDataReader));
int arg0 = (int)LuaDLL.luaL_checknumber(L, 2);
long o = obj.GetInt64(arg0);
LuaDLL.tolua_pushint64(L, o);
return(1);
}
catch (Exception e)
{
return(LuaDLL.toluaL_exception(L, e));
}
}
private BasicPayrollItem ReadPayrollItemFromDataReader(DbDataReader reader)
{
int payrollItemId = reader.GetInt32(0);
int personId = reader.GetInt32(1);
int organizationId = reader.GetInt32(2);
int countryId = reader.GetInt32(3);
DateTime employedDate = reader.GetDateTime(4);
int reportsToPersonId = reader.GetInt32(5);
Int64 baseSalaryCents = reader.GetInt64(6);
int budgetId = reader.GetInt32(7);
bool open = reader.GetBoolean(8);
DateTime terminatedDate = reader.GetDateTime(9);
int subtractiveTaxLevelId = reader.GetInt32(10);
double additiveTaxLevel = reader.GetDouble(11);
return new BasicPayrollItem(payrollItemId, personId, organizationId, countryId, employedDate,
reportsToPersonId, baseSalaryCents, budgetId, open, terminatedDate, subtractiveTaxLevelId, additiveTaxLevel);
}
private BasicInboundInvoice ReadInboundInvoiceFromDataReader(DbDataReader reader)
{
int inboundInvoiceId = reader.GetInt32(0);
int organizationId = reader.GetInt32(1);
DateTime createdDateTime = reader.GetDateTime(2);
int createdByPersonId = reader.GetInt32(3);
DateTime dueDate = reader.GetDateTime(4);
Int64 amountCents = reader.GetInt64(5);
int budgetId = reader.GetInt32(6);
bool attested = reader.GetBoolean(7);
bool open = reader.GetBoolean(8);
string supplier = reader.GetString(9);
string payToAccount = reader.GetString(10);
string ocr = reader.GetString(11);
string invoiceReference = reader.GetString(12);
DateTime closedDateTime = reader.GetDateTime(13);
int closedByPersonId = reader.GetInt32(14);
return new BasicInboundInvoice(inboundInvoiceId, organizationId, createdDateTime, dueDate,
amountCents, budgetId, supplier, payToAccount, ocr, invoiceReference,
attested, open, closedDateTime, closedByPersonId);
}
private void mapValues(DbDataReader reader, object record)
{
foreach (var accessor in this.accessors) {
var index = reader.GetOrdinal(accessor.Name);
if (reader.IsDBNull(index)) {
continue;
}
if (accessor.PropertyType == typeof(string)) {
accessor.Set(record, reader.GetString(index));
} else if (accessor.PropertyType == typeof(int) || accessor.PropertyType == typeof(int?)) {
accessor.Set(record, reader.GetInt32(index));
} else if (accessor.PropertyType == typeof(long) || accessor.PropertyType == typeof(long?)) {
accessor.Set(record, reader.GetInt64(index));
} else if (accessor.PropertyType == typeof(DateTime) || accessor.PropertyType == typeof(DateTime?)) {
accessor.Set(record, reader.GetDateTime(index));
} else if (accessor.PropertyType == typeof(char) || accessor.PropertyType == typeof(char?)) {
accessor.Set(record, reader.GetChar(index));
}
}
}
private void ProcessRecord(DbDataReader record, DbOperation dbOperation)
#endif
{
var id = record.GetInt64(0);
ScaleoutMessage message = SqlPayload.FromBytes(record);
_logger.LogVerbose(String.Format("{0}SqlReceiver last payload ID={1}, new payload ID={2}", _loggerPrefix, _lastPayloadId, id));
if (id > _lastPayloadId + 1)
{
_logger.LogError(String.Format("{0}Missed message(s) from SQL Server. Expected payload ID {1} but got {2}.", _loggerPrefix, _lastPayloadId + 1, id));
}
else if (id <= _lastPayloadId)
{
_logger.LogInformation(String.Format("{0}Duplicate message(s) or payload ID reset from SQL Server. Last payload ID {1}, this payload ID {2}", _loggerPrefix, _lastPayloadId, id));
}
_lastPayloadId = id;
// Update the Parameter with the new payload ID
dbOperation.Parameters[0].Value = _lastPayloadId;
_logger.LogVerbose(String.Format("{0}Updated receive reader initial payload ID parameter={1}", _loggerPrefix, _dbOperation.Parameters[0].Value));
_logger.LogVerbose(String.Format("{0}Payload {1} containing {2} message(s) received", _loggerPrefix, id, message.Messages.Count));
Received((ulong)id, message);
}
/// <summary>
/// Конструктор класса WorkType
/// </summary>
public WorkType(DbDataReader reader)
{
this._id = reader.GetInt16(0);
this._sportTypeId = reader.GetByte(1);
this._userId = reader.GetInt64(2);
this._count = reader.GetInt32(3);
this._value = reader.GetString(4);
}
/// <summary>
/// Конструктор класса Workout
/// </summary>
public Workout(DbDataReader reader)
{
this._id = reader.GetValue(0).ToString() == "" ? (long)0 : reader.GetInt64(0);
this._date = reader.GetValue(1).ToString() == "" ? (long)0 : reader.GetInt64(1);
this._timeBegin = reader.GetValue(2).ToString() == "" ? (long)0 : reader.GetInt64(2);
this._timeEnd = reader.GetValue(3).ToString() == "" ? (long)0 : reader.GetInt64(3);
this._warmUp = reader.GetValue(4).ToString() == "" ? (byte)0 : reader.GetByte(4);
this._musclesGroupId = reader.GetValue(5).ToString() == "" ? (Int16)0 : reader.GetInt16(5);
this._workoutPlanId = reader.GetValue(6).ToString() == "" ? (long)0 : reader.GetInt64(6);
this._workoutTypeId = reader.GetValue(7).ToString() == "" ? (Int16)0 : reader.GetInt16(7);
this._athleteId = reader.GetValue(8).ToString() == "" ? (long)0 : reader.GetInt64(8);
this._createDate = reader.GetValue(9).ToString() == "" ? (long)0 : reader.GetInt64(9);
this._workoutPlanTypeId = reader.GetValue(10).ToString() == "" ? (Int16)0 : reader.GetInt16(10);
}
protected override object ReadInternal(DbDataReader reader, int ordinal, SqlRandomTableColumn columnInfo, Type asType)
{
ValidateReadType(typeof(Int64), asType);
if (reader.IsDBNull(ordinal))
return DBNull.Value;
return reader.GetInt64(ordinal);
}
private BasicFinancialAccountRow ReadFinancialAccountRowFromDataReader (DbDataReader reader)
{
int accountId = reader.GetInt32(0);
int transactionId = reader.GetInt32(1);
DateTime transactionDateTime = reader.GetDateTime(2);
string comment = reader.GetString(3);
Int64 amountCents = reader.GetInt64(4);
DateTime rowDateTime = reader.GetDateTime(5);
int rowCreatedByPersonId = reader.GetInt32(6);
return new BasicFinancialAccountRow(accountId, transactionId, transactionDateTime, comment, amountCents, rowDateTime, rowCreatedByPersonId);
}
private BasicFinancialTransactionRow ReadFinancialTransactionRowFromDataReader(DbDataReader reader)
{
int rowId = reader.GetInt32(0);
int accountId = reader.GetInt32(1);
int transactionId = reader.GetInt32(2);
Int64 amountCents = reader.GetInt64(3);
DateTime createdDateTime = reader.GetDateTime(4);
int createdByPersonId = reader.GetInt32(5);
return new BasicFinancialTransactionRow(rowId, accountId, transactionId, amountCents, createdDateTime, createdByPersonId);
}
protected virtual IPersistedRawEvent ReadEvent(DbDataReader reader, Stream stream)
{
// select order
// Field: GlobalSequence, EventID, StreamHash, StreamName, EventType, UtcTimestamp, Metadata, Payload, PayloadFormat
// Index: 0 1 2 3 4 5 6 7 8
if (stream != null)
stream = new Stream(stream, reader.GetString(3));
else
stream = new Stream((byte[])reader[2], reader.GetString(3));
return new PersistedRawEvent
{
GlobalSequence = reader.GetInt64(0),
EventID = reader.GetGuid(1),
Stream = stream,
EventType = reader.GetString(4),
UtcTimestamp = reader.GetDateTime(5),
Metadata = reader.IsDBNull(6) ? null : (byte[])reader[6],
Payload = (byte[])reader[7],
PayloadFormat = reader.GetInt32(8)
};
}
protected LabTask readTask(DbDataReader dataReader)
{
LabTask taskInfo = new LabTask();
try
{
taskInfo.taskID = dataReader.GetInt64(0);
taskInfo.labAppID = dataReader.GetInt32(1);
if (!dataReader.IsDBNull(2))
taskInfo.experimentID = dataReader.GetInt64(2);
taskInfo.groupName = dataReader.GetString(3);
taskInfo.startTime = dataReader.GetDateTime(4);
taskInfo.endTime = dataReader.GetDateTime(5);
taskInfo.Status = (LabTask.eStatus)dataReader.GetInt32(6);
if (!DBNull.Value.Equals(dataReader.GetValue(7)))
taskInfo.couponID = dataReader.GetInt64(7);
if (!DBNull.Value.Equals(dataReader.GetValue(8)))
taskInfo.issuerGUID = dataReader.GetString(8);
if (!dataReader.IsDBNull(9))
taskInfo.storage = dataReader.GetString(9);
if (!dataReader.IsDBNull(10))
taskInfo.data = dataReader.GetString(10);
}
catch (Exception e)
{
taskInfo = null;
}
return taskInfo;
}
/// <summary>
/// Конструктор класса Work
/// </summary>
public Work(DbDataReader reader)
{
this.id = reader.GetInt64(0);
this.resultId = reader.GetValue(1).ToString() == "" ? 0 : reader.GetInt64(1);
this.workoutId = reader.GetValue(2).ToString() == "" ? 0 : reader.GetInt64(2);
this.workTypeId = reader.GetValue(3).ToString() == "" ? 0 : reader.GetInt64(3);
this.comment = reader.GetValue(4).ToString() == "" ? "" : reader.GetString(4);
}
private static Int64? GetInt64(DbDataReader reader, int index)
{
if (reader.IsDBNull(index))
return null;
else
return reader.GetInt64(index);
}
/// <summary>
/// Конструктор класса результата работы
/// </summary>
public Result(DbDataReader reader, System.Globalization.NumberFormatInfo format)
{
this._id = reader.GetInt64(0);
if (this._id > 11967)
this._time = reader.GetValue(1).ToString() == "" ? (long)0 : (long)reader.GetValue(1);
this._time = reader.GetValue(1).ToString() == "" ? (long)0 : (long)reader.GetValue(1);
this._weight = reader.GetValue(2).ToString() == "" ? (float)0 : float.Parse(reader.GetValue(2).ToString(), format);
object o = reader.GetValue(3);
this._repeat = reader.GetValue(3).ToString() == "" ? (Int16)0 : reader.GetInt16(3);
this._distance = reader.GetValue(4).ToString() == "" ? (float)0 : float.Parse(reader.GetValue(4).ToString(), format);
this._points = reader.GetValue(5).ToString() == "" ? 0 : reader.GetInt32(5);
this._place = reader.GetValue(6).ToString() == "" ? 0 : reader.GetInt32(6);
this._comment = reader.GetValue(7).ToString() == "" ? "" : reader.GetString(7);
}
public User(DbDataReader record)
{
this._id = record.GetInt64(0);
this._name = record.GetValue(1).ToString() == "" ? "" : record.GetString(1);
this._lastName = record.GetValue(2).ToString() == "" ? "" : record.GetString(2);
this._fatherName = record.GetValue(3).ToString() == "" ? "" : record.GetString(3);
this._phone = record.GetValue(4).ToString() == "" ? "" : record.GetString(4);
this._bDay = record.GetValue(5).ToString() == "" ? 0 : record.GetInt64(5);
this._sex = record.GetValue(6).ToString() == "" ? "" : record.GetString(6);
this._login = record.GetValue(7).ToString() == "" ? "" : record.GetString(7);
this._password = record.GetValue(8).ToString() == "" ? "" : record.GetString(8);
this._createDate = record.GetValue(9).ToString() == "" ? 0 : record.GetInt64(9);
}
private void SetDBTable(DbDataReader reader)
{
dataGridTableSearch.ItemsSource = null;
if (reader != null)
{
DataTable dt = new DataTable();
dt.Columns.Add("№");
dt.Columns.Add("Дата тренировки");
dt.Columns.Add("Тип тренировки");
dt.Columns.Add("Тип работы");
dt.Columns.Add("Время");
dt.Columns.Add("Вес");
dt.Columns.Add("Повторы");
while (reader.Read())
{
dt.Rows.Add(reader.GetInt64(0),
OtherMethods.GetDate((long)reader.GetInt64(1)),
reader.GetString(2),
reader.GetString(3),
OtherMethods.GetTime((long)reader.GetInt64(4)),
reader.GetValue(5).ToString() == "" ? (float)0 : float.Parse(reader.GetValue(5).ToString(), format),
reader.GetValue(6).ToString() == "" ? (Int16)0 : reader.GetInt16(6));
}
dataGridTableSearch.ItemsSource = dt.DefaultView;
}
}
protected ProcessAgentInfo readAgentInfo(DbDataReader dataReader)
{
long idIn = -1;
long idOut = -1;
string passIn = null;
string passOut = null;
ProcessAgentInfo info = new ProcessAgentInfo();
info.agentId = dataReader.GetInt32(0);
info.agentGuid = dataReader.GetString(1);
if (!DBNull.Value.Equals(dataReader.GetValue(2)))
info.agentName = dataReader.GetString(2);
info.agentType = (ProcessAgentType.AgentType) dataReader.GetInt32(3);
if (!DBNull.Value.Equals(dataReader.GetValue(4)))
info.codeBaseUrl = dataReader.GetString(4);
info.webServiceUrl = dataReader.GetString(5);
if (!DBNull.Value.Equals(dataReader.GetValue(6)))
info.domainGuid = dataReader.GetString(6);
if (!DBNull.Value.Equals(dataReader.GetValue(7)))
info.issuerGuid = dataReader.GetString(7);
if (!DBNull.Value.Equals(dataReader.GetValue(8)))
idIn = dataReader.GetInt64(8);
if (!DBNull.Value.Equals(dataReader.GetValue(9)))
passIn = dataReader.GetString(9);
if (!DBNull.Value.Equals(dataReader.GetValue(10)))
idOut =dataReader.GetInt64(10);
if (!DBNull.Value.Equals(dataReader.GetValue(11)))
passOut = dataReader.GetString(11);
if (!DBNull.Value.Equals(dataReader.GetValue(12)))
info.retired = dataReader.GetBoolean(12);
if (info.issuerGuid != null)
{
if (idIn > 0)
{
Coupon couponIn = new Coupon();
couponIn.couponId = idIn;
couponIn.issuerGuid = info.issuerGuid;
couponIn.passkey = passIn;
info.identIn = couponIn;
}
else
{
info.identIn = null;
}
if (idOut > 0)
{
Coupon couponOut = new Coupon();
couponOut.couponId = idOut;
couponOut.issuerGuid = info.issuerGuid;
couponOut.passkey = passOut;
info.identOut = couponOut;
}
else
{
info.identOut = null;
}
}
return info;
}
private static List<iSearch_Title_Result> DataReader_To_Simple_Result_List2(DbDataReader Reader, List<string> MetadataFieldNames)
{
// Create return list
List<iSearch_Title_Result> returnValue = new List<iSearch_Title_Result>();
// Create some lists used during the construction
Dictionary<int, Database_Title_Result> titleLookupByRowNumber = new Dictionary<int, Database_Title_Result>();
Dictionary<int, Database_Item_Result> itemLookupByItemID = new Dictionary<int, Database_Item_Result>();
Dictionary<int, int> rowNumberLookupByItemID = new Dictionary<int, int>();
// May have not values returned
if (Reader.FieldCount < 5)
return null;
// Get all the main title values first
int minimumRownumber = -1;
while (Reader.Read())
{
// Create new database title object for this
Database_Title_Result result = new Database_Title_Result
{
RowNumber = Reader.GetInt32(0),
BibID = Reader.GetString(1),
GroupTitle = Reader.GetString(2),
OPAC_Number = Reader.GetInt32(3),
OCLC_Number = Reader.GetInt64(4),
GroupThumbnail = Reader.GetString(5),
MaterialType = Reader.GetString(6),
Primary_Identifier_Type = Reader.GetString(7),
Primary_Identifier = Reader.GetString(8)
};
titleLookupByRowNumber.Add(result.RowNumber, result);
if (minimumRownumber == -1)
{
minimumRownumber = result.RowNumber;
}
}
// Move to the item system-required information table
Reader.NextResult();
// If there were no titles, then there are no results
if (titleLookupByRowNumber.Count == 0)
return returnValue;
// Step through all the item rows, build the item, and add to the title
Database_Title_Result titleResult = titleLookupByRowNumber[minimumRownumber];
returnValue.Add(titleResult);
int lastRownumber = titleResult.RowNumber;
while (Reader.Read())
{
// Ensure this is the right title for this item
int thisRownumber = Reader.GetInt32(0);
if (thisRownumber != lastRownumber)
{
titleResult = titleLookupByRowNumber[thisRownumber];
lastRownumber = thisRownumber;
// Add this title to the list
returnValue.Add(titleResult);
}
// Create new database item object for this
Database_Item_Result result = new Database_Item_Result
{
ItemID = Reader.GetInt32(1),
VID = Reader.GetString(2),
Title = Reader.GetString(3),
IP_Restriction_Mask = Reader.GetInt16(4),
MainThumbnail = Reader.GetString(5),
Level1_Index = (short)Reader.GetInt32(6),
Level1_Text = Reader.GetString(7),
Level2_Index = (short)Reader.GetInt32(8),
Level2_Text = Reader.GetString(9),
Level3_Index = (short)Reader.GetInt32(10),
Level3_Text = Reader.GetString(11),
PubDate = Reader.GetString(12),
PageCount = Reader.GetInt32(13),
Link = Reader.GetString(14),
Spatial_KML = Reader.GetString(15),
COinS_OpenURL = Reader.GetString(16)
};
// Save to the hash lookup for adding display metadata
itemLookupByItemID[result.ItemID] = result;
rowNumberLookupByItemID[result.ItemID] = thisRownumber;
// Add this to the title object
titleResult.Add_Item_Result(result);
}
// Move to the item aggregation-configured display information table
Reader.NextResult();
// Set some values for checking for uniformity of values
const int ITEMS_TO_CHECK_IN_EACH_TITLE = 20;
bool first_item_analyzed = true;
List<bool> checking_fields = new List<bool>();
int display_fields_count = 0;
int itemcount = 0;
int lastRowNumber = -1;
while (Reader.Read())
{
// Get the item id and then work back to the local title id
int itemId = Reader.GetInt32(0);
int rowNumber = rowNumberLookupByItemID[itemId];
// If this is the very first item analyzed, need to do some work first
if (first_item_analyzed)
{
// Save the number of display fields
display_fields_count = Reader.FieldCount - 1;
// Add a boolean for each display field
for (int i = 0; i < display_fields_count; i++)
{
// Add the default boolean value here
checking_fields.Add(true);
// Save the metadata label
MetadataFieldNames.Add(Reader.GetName(i + 1));
}
// Done with the first row analysis, so ensure it does not repeat
first_item_analyzed = false;
}
// Is this is the start of a new title row?
if (lastRowNumber != rowNumber)
{
// Get this title object
titleResult = titleLookupByRowNumber[rowNumber];
// Set items analyzed for this title to zero
itemcount = 0;
// Back to checking each metadata field since this is a new title
for (int i = 0; i < display_fields_count; i++)
checking_fields[i] = true;
// Save this row numbe as the last row number analyzed
lastRowNumber = rowNumber;
}
if (itemcount == 0)
{
// Set all the initial display values (at the title level) from
// this item's display information
titleResult.Metadata_Display_Values = new string[display_fields_count];
for (int i = 0; i < display_fields_count; i++)
{
titleResult.Metadata_Display_Values[i] = Reader.GetString(i + 1);
}
}
else if (itemcount < ITEMS_TO_CHECK_IN_EACH_TITLE)
{
// Compare the values attached with each display piece of metadata
// from the title with this additional, individual item. If the
// values are the same, it should display at the title level, but
// if they are different, we will not display the values at that level
for (int i = 0; i < display_fields_count; i++)
{
// If we already found a mismatch for this metadata field, then
// no need to continue checking
if (checking_fields[i])
{
if (String.Compare(titleResult.Metadata_Display_Values[i], Reader.GetString(i + 1), StringComparison.InvariantCultureIgnoreCase) != 0)
{
titleResult.Metadata_Display_Values[i] = "*";
checking_fields[i] = false;
}
}
}
}
}
return returnValue;
}
private int CheckDbAndIndex(DbDataReader dbreader, IndexReader ixreader, List<Difference> result)
{
var versionId = dbreader.GetInt32(0);
var dbNodeTimestamp = dbreader.GetInt64(1);
var dbVersionTimestamp = dbreader.GetInt64(2);
var termDocs = ixreader.TermDocs(new Lucene.Net.Index.Term(LucObject.FieldName.VersionId, Lucene.Net.Util.NumericUtils.IntToPrefixCoded(versionId)));
Lucene.Net.Documents.Document doc = null;
int docid = -1;
if (termDocs.Next())
{
docid = termDocs.Doc();
doc = ixreader.Document(docid);
var indexNodeTimestamp = ParseLong(doc.Get(LucObject.FieldName.NodeTimestamp));
var indexVersionTimestamp = ParseLong(doc.Get(LucObject.FieldName.VersionTimestamp));
var nodeId = ParseInt(doc.Get(LucObject.FieldName.NodeId));
var version = doc.Get(LucObject.FieldName.Version);
var p = doc.Get(LucObject.FieldName.Path);
if (termDocs.Next())
{
result.Add(new Difference(IndexDifferenceKind.MoreDocument)
{
DocId = docid,
NodeId = nodeId,
VersionId = versionId,
Version = version,
Path = p,
DbNodeTimestamp = dbNodeTimestamp,
DbVersionTimestamp = dbVersionTimestamp,
IxNodeTimestamp = indexNodeTimestamp,
IxVersionTimestamp = indexVersionTimestamp,
});
}
if (dbVersionTimestamp != indexVersionTimestamp)
{
result.Add(new Difference(IndexDifferenceKind.DifferentVersionTimestamp)
{
DocId = docid,
VersionId = versionId,
DbNodeTimestamp = dbNodeTimestamp,
DbVersionTimestamp = dbVersionTimestamp,
IxNodeTimestamp = indexNodeTimestamp,
IxVersionTimestamp = indexVersionTimestamp,
NodeId = nodeId,
Version = version,
Path = p
});
}
if (dbNodeTimestamp != indexNodeTimestamp)
{
var ok = false;
var isLastDraft = doc.Get(LucObject.FieldName.IsLastDraft);
if (isLastDraft != BooleanIndexHandler.YES)
{
var latestDocs = ixreader.TermDocs(new Lucene.Net.Index.Term(LucObject.FieldName.NodeId, Lucene.Net.Util.NumericUtils.IntToPrefixCoded(nodeId)));
Lucene.Net.Documents.Document latestDoc = null;
while (latestDocs.Next())
{
var latestdocid = latestDocs.Doc();
var d = ixreader.Document(latestdocid);
if (d.Get(LucObject.FieldName.IsLastDraft) != BooleanIndexHandler.YES)
continue;
latestDoc = d;
break;
}
var latestPath = latestDoc.Get(LucObject.FieldName.Path);
if (latestPath == p)
ok = true;
}
if (!ok)
{
result.Add(new Difference(IndexDifferenceKind.DifferentNodeTimestamp)
{
DocId = docid,
VersionId = versionId,
DbNodeTimestamp = dbNodeTimestamp,
DbVersionTimestamp = dbVersionTimestamp,
IxNodeTimestamp = indexNodeTimestamp,
IxVersionTimestamp = indexVersionTimestamp,
NodeId = nodeId,
Version = version,
Path = p
});
}
}
}
else
{
result.Add(new Difference(IndexDifferenceKind.NotInIndex)
{
DocId = docid,
VersionId = versionId,
DbNodeTimestamp = dbNodeTimestamp,
DbVersionTimestamp = dbVersionTimestamp,
});
}
return docid;
}
/// <summary>
/// Vendor-independent database reader.
/// </summary>
public static int ReadInt(DbDataReader dataReader, int column)
{
if (DatabaseLanguageIsMsSql.Value)
return dataReader.GetInt32(column);
else if (DatabaseLanguageIsOracle.Value)
return Convert.ToInt32(dataReader.GetInt64(column)); // On some systems, reading from NUMERIC(10) column will return Int64, and GetInt32 would fail.
else
throw new FrameworkException(UnsupportedLanguageError);
}
// Copy multiple fields from reader to SmiTypedGetterSetter
// Supports V200 code path, without damaging backward compat for V100 code.
// Main differences are supporting DbDataReader, and for binary, character, decimal and Udt types.
// Assumes caller enforces that reader and setter metadata are compatible
internal static void FillCompatibleSettersFromReader(SmiEventSink_Default sink, SmiTypedGetterSetter setters, IList<SmiExtendedMetaData> metaData, DbDataReader reader) {
for (int i = 0; i < metaData.Count; i++) {
if (reader.IsDBNull(i)) {
ValueUtilsSmi.SetDBNull_Unchecked(sink, setters, i);
}
else {
switch (metaData[i].SqlDbType) {
case SqlDbType.BigInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int64));
SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i));
break;
case SqlDbType.Binary:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Bit:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Boolean));
SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i));
break;
case SqlDbType.Char:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.DateTime:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime));
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
break;
case SqlDbType.Decimal: { // block to scope sqlReader local to avoid conflicts
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlDecimal));
// Support full fidelity for SqlDataReader
SqlDataReader sqlReader = reader as SqlDataReader;
if (null != sqlReader) {
SetSqlDecimal_Unchecked(sink, setters, i, sqlReader.GetSqlDecimal(i));
}
else {
SetSqlDecimal_Unchecked(sink, setters, i, new SqlDecimal(reader.GetDecimal(i)));
}
}
break;
case SqlDbType.Float:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Double));
SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i));
break;
case SqlDbType.Image:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Int:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int32));
SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i));
break;
case SqlDbType.Money:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney));
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
break;
case SqlDbType.NChar:
case SqlDbType.NText:
case SqlDbType.NVarChar:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Real:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Single));
SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i));
break;
case SqlDbType.UniqueIdentifier:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Guid));
SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i));
break;
case SqlDbType.SmallDateTime:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime));
SetDateTime_Checked(sink, setters, i,metaData[i], reader.GetDateTime(i));
break;
case SqlDbType.SmallInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int16));
SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i));
break;
case SqlDbType.SmallMoney:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney));
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
break;
case SqlDbType.Text:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Timestamp:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.TinyInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Byte));
SetByte_Unchecked(sink, setters, i, reader.GetByte(i));
break;
case SqlDbType.VarBinary:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.VarChar:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.String));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Xml: {
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlXml));
SqlDataReader sqlReader = reader as SqlDataReader;
if (null != sqlReader) {
SetSqlXml_Unchecked(sink, setters, i, sqlReader.GetSqlXml(i));
}
else {
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
}
}
break;
case SqlDbType.Variant: { // block to scope sqlReader local and avoid conflicts
// Support better options for SqlDataReader
SqlDataReader sqlReader = reader as SqlDataReader;
SqlBuffer.StorageType storageType = SqlBuffer.StorageType.Empty;
object o;
if (null != sqlReader) {
o = sqlReader.GetSqlValue(i);
storageType = sqlReader.GetVariantInternalStorageType(i);
}
else {
o = reader.GetValue(i);
}
ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(metaData[i].SqlDbType, metaData[i].IsMultiValued, o, null,
//
SmiContextFactory.KatmaiVersion
);
if ((storageType == SqlBuffer.StorageType.DateTime2) || (storageType == SqlBuffer.StorageType.Date))
SetCompatibleValueV200(sink, setters, i, metaData[i], o, typeCode, 0, 0, null, storageType);
else
SetCompatibleValueV200(sink, setters, i, metaData[i], o, typeCode, 0, 0, null);
}
break;
case SqlDbType.Udt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
// Skip serialization for Udt types.
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
// SqlDbType.Structured should have been caught before this point for TVPs. SUDTs will still need to implement.
case SqlDbType.Date:
case SqlDbType.DateTime2:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime));
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
break;
case SqlDbType.Time: { // block to scope sqlReader local and avoid conflicts
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.TimeSpan));
SqlDataReader sqlReader = reader as SqlDataReader;
TimeSpan ts;
if (null != sqlReader) {
ts = sqlReader.GetTimeSpan(i);
} else {
ts = (TimeSpan)reader.GetValue(i);
}
SetTimeSpan_Checked(sink, setters, i, metaData[i], ts);
}
break;
case SqlDbType.DateTimeOffset: { // block to scope sqlReader local and avoid conflicts
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTimeOffset));
SqlDataReader sqlReader = reader as SqlDataReader;
DateTimeOffset dto;
if (null != sqlReader) {
dto = sqlReader.GetDateTimeOffset(i);
} else {
dto = (DateTimeOffset)reader.GetValue(i);
}
SetDateTimeOffset_Unchecked(sink, setters, i, dto);
}
break;
default:
// In order for us to get here we would have to have an
// invalid instance of SqlDbType, or one would have to add
// new member to SqlDbType without adding a case in this
// switch, hence the assert - it must be
Debug.Assert(false, "unsupported DbType:" + metaData[i].SqlDbType.ToString());
throw ADP.NotSupported();
}
}
}
}
protected virtual SelectedSnapshot ReadSnapshot(DbDataReader reader)
{
var persistenceId = reader.GetString(0);
var sequenceNr = reader.GetInt64(1);
var timestamp = reader.GetDateTime(2);
var metadata = new SnapshotMetadata(persistenceId, sequenceNr, timestamp);
var snapshot = GetSnapshot(reader);
return new SelectedSnapshot(metadata, snapshot);
}
/// <summary>
/// Конструктор класса Athlete
/// </summary>
/// <param name="record"></param>
public Athlete(DbDataReader record)
{
this._id = record.GetInt64(0);
this._sportTypeId = record.GetValue(1).ToString() == "" ? (byte)0 : record.GetByte(1);
this._sportCategoryId = record.GetValue(2).ToString() == "" ? (byte)0 : record.GetByte(2);
this._address = record.GetValue(3).ToString() == "" ? "" : record.GetString(3);
this._place = record.GetValue(4).ToString() == "" ? "" : record.GetString(4);
this._userId = record.GetValue(5).ToString() == "" ? 0 : record.GetInt64(5);
this._createDate = record.GetValue(6).ToString() == "" ? 0 : record.GetInt64(6);
}
internal static void FillCompatibleSettersFromReader(SmiEventSink_Default sink, SmiTypedGetterSetter setters, IList<SmiExtendedMetaData> metaData, DbDataReader reader)
{
for (int i = 0; i < metaData.Count; i++)
{
object sqlValue;
DateTimeOffset dateTimeOffset;
TimeSpan timeSpan;
ExtendedClrTypeCode code;
if (reader.IsDBNull(i))
{
SetDBNull_Unchecked(sink, setters, i);
continue;
}
switch (metaData[i].SqlDbType)
{
case SqlDbType.BigInt:
{
SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i));
continue;
}
case SqlDbType.Binary:
{
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.Bit:
{
SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i));
continue;
}
case SqlDbType.Char:
{
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.DateTime:
{
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
continue;
}
case SqlDbType.Decimal:
{
SqlDataReader reader6 = reader as SqlDataReader;
if (reader6 == null)
{
break;
}
SetSqlDecimal_Unchecked(sink, setters, i, reader6.GetSqlDecimal(i));
continue;
}
case SqlDbType.Float:
{
SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i));
continue;
}
case SqlDbType.Image:
{
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.Int:
{
SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i));
continue;
}
case SqlDbType.Money:
{
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
continue;
}
case SqlDbType.NChar:
case SqlDbType.NText:
case SqlDbType.NVarChar:
{
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.Real:
{
SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i));
continue;
}
case SqlDbType.UniqueIdentifier:
{
SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i));
continue;
}
case SqlDbType.SmallDateTime:
{
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
continue;
}
case SqlDbType.SmallInt:
{
SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i));
continue;
}
case SqlDbType.SmallMoney:
{
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
continue;
}
case SqlDbType.Text:
{
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.Timestamp:
{
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.TinyInt:
{
SetByte_Unchecked(sink, setters, i, reader.GetByte(i));
continue;
}
case SqlDbType.VarBinary:
{
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.VarChar:
{
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.Variant:
{
SqlDataReader reader4 = reader as SqlDataReader;
if (reader4 == null)
{
goto Label_0311;
}
sqlValue = reader4.GetSqlValue(i);
goto Label_0319;
}
case SqlDbType.Xml:
{
SqlDataReader reader5 = reader as SqlDataReader;
if (reader5 == null)
{
goto Label_02E4;
}
SetSqlXml_Unchecked(sink, setters, i, reader5.GetSqlXml(i));
continue;
}
case SqlDbType.Udt:
{
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.Date:
case SqlDbType.DateTime2:
{
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
continue;
}
case SqlDbType.Time:
{
SqlDataReader reader3 = reader as SqlDataReader;
if (reader3 == null)
{
goto Label_03A0;
}
timeSpan = reader3.GetTimeSpan(i);
goto Label_03AE;
}
case SqlDbType.DateTimeOffset:
{
SqlDataReader reader2 = reader as SqlDataReader;
if (reader2 == null)
{
goto Label_03D5;
}
dateTimeOffset = reader2.GetDateTimeOffset(i);
goto Label_03E2;
}
default:
throw ADP.NotSupported();
}
SetSqlDecimal_Unchecked(sink, setters, i, new SqlDecimal(reader.GetDecimal(i)));
continue;
Label_02E4:
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
Label_0311:
sqlValue = reader.GetValue(i);
Label_0319:
code = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(metaData[i].SqlDbType, metaData[i].IsMultiValued, sqlValue, null, 210L);
SetCompatibleValueV200(sink, setters, i, metaData[i], sqlValue, code, 0, 0, null);
continue;
Label_03A0:
timeSpan = (TimeSpan) reader.GetValue(i);
Label_03AE:
SetTimeSpan_Checked(sink, setters, i, metaData[i], timeSpan);
continue;
Label_03D5:
dateTimeOffset = (DateTimeOffset) reader.GetValue(i);
Label_03E2:
SetDateTimeOffset_Unchecked(sink, setters, i, dateTimeOffset);
}
}
