/// <summary>
/// Loads the entity from a <b>SqlDataReader</b> object.
/// </summary>
/// <param name="dr">The data reader to read from.</param>
/// <returns>Returns the number of columns read.</returns>
/// <remarks>
/// Always reads at the current cursor position, doesn't calls the <b>Read</b> function
/// on the <b>SqlDataReader</b> object. Reads data columns by their ordinal position in
/// the query and not by their names.
/// </remarks>
internal override int LoadFromDataReader(SqlDataReader dr)
{
int o = base.LoadFromDataReader(dr);
++o; // skip guid
this.workflowTypeName = dr.GetString(++o);
this.dateStarted = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.dateFinished = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.jobExecutionStatus = (JobExecutionState)dr.GetInt32(++o);
this.suspendTimeout = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.scheduleType = (ScheduleType)dr.GetInt32(++o);
this.scheduleTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.recurringPeriod = (RecurringPeriod)dr.GetInt32(++o);
this.recurringInterval = dr.GetInt32(++o);
this.recurringMask = dr.GetInt64(++o);
this.workflowInstanceId = dr.IsDBNull(++o) ? Guid.Empty : dr.GetGuid(o);
this.adminRequestTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
if (!dr.IsDBNull(++o))
{
XmlSerializer ser = new XmlSerializer(typeof(JobAdminRequestData));
StringReader sr = new StringReader(dr.GetString(o));
this.adminRequestData = (JobAdminRequestData)ser.Deserialize(sr);
}
else
{
this.adminRequestData = null;
}
this.adminRequestResult = dr.GetInt32(++o);
this.exceptionMessage = dr.IsDBNull(++o) ? null : dr.GetString(o);
return o;
}
public override void Map(SqlDataReader sqlDataReader)
{
this.Id = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("Id"));
this.Name = sqlDataReader.GetString(sqlDataReader.GetOrdinal("Name"));
this.Level = sqlDataReader.GetByte(sqlDataReader.GetOrdinal("Level"));
this.CountryId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("CountryId"));
}
/// <summary>
/// Constructs an instance of IStoreShard using parts of a row from SqlDataReader.
/// Used for creating the shard instance for a mapping.
/// </summary>
/// <param name="reader">SqlDataReader whose row has shard information.</param>
/// <param name="offset">Reader offset for column that begins shard information.</param>
internal SqlShard(SqlDataReader reader, int offset)
{
this.Id = reader.GetGuid(offset);
this.Version = reader.GetGuid(offset + 1);
this.ShardMapId = reader.GetGuid(offset + 2);
this.Location = new SqlLocation(reader, offset + 3).Location;
this.Status = reader.GetInt32(offset + 7);
}
/// <summary>
/// Constructs an instance of IStoreMapping using a row from SqlDataReader.
/// </summary>
/// <param name="reader">SqlDataReader whose row has mapping information.</param>
/// <param name="offset">Reader offset for column that begins mapping information.</param>
internal SqlMapping(SqlDataReader reader, int offset)
{
this.Id = reader.GetGuid(offset);
this.ShardMapId = reader.GetGuid(offset + 1);
this.MinValue = SqlUtils.ReadSqlBytes(reader, offset + 2);
this.MaxValue = SqlUtils.ReadSqlBytes(reader, offset + 3);
this.Status = reader.GetInt32(offset + 4);
this.LockOwnerId = reader.GetGuid(offset + 5);
this.StoreShard = new SqlShard(reader, offset + 6);
}
internal static Message Load(SqlDataReader reader) {
var message = new Message
{
ConversationGroupId = reader.GetGuid(0),
ConversationHandle = reader.GetGuid(1),
MessageSequenceNumber = reader.GetInt64(2),
ServiceName = reader.GetString(3),
ServiceContractName = reader.GetString(4),
MessageTypeName = reader.GetString(5),
Body = reader.IsDBNull(7) ? new byte[0] : reader.GetSqlBytes(7).Buffer
};
return message;
}
public static Exception GetError(XName commandName, CommandResult result, SqlDataReader reader)
{
Exception returnValue = null;
if (result != CommandResult.Success)
{
switch (result)
{
case CommandResult.InstanceAlreadyExists:
returnValue = new InstanceCollisionException(commandName, reader.GetGuid(1));
break;
case CommandResult.InstanceLockNotAcquired:
returnValue = new InstanceLockedException(commandName, reader.GetGuid(1), reader.GetGuid(2), ReadLockOwnerMetadata(reader));
break;
case CommandResult.InstanceNotFound:
returnValue = new InstanceNotReadyException(commandName, reader.GetGuid(1));
break;
case CommandResult.KeyAlreadyExists:
returnValue = new InstanceKeyCollisionException(commandName, Guid.Empty,
new InstanceKey(reader.GetGuid(1)), Guid.Empty);
break;
case CommandResult.KeyNotFound:
returnValue = new InstanceKeyNotReadyException(commandName, new InstanceKey(reader.GetGuid(1)));
break;
case CommandResult.InstanceLockLost:
returnValue = new InstanceLockLostException(commandName, reader.GetGuid(1));
break;
case CommandResult.InstanceCompleted:
returnValue = new InstanceCompleteException(commandName, reader.GetGuid(1));
break;
case CommandResult.KeyDisassociated:
returnValue = new InstanceKeyCompleteException(commandName, new InstanceKey(reader.GetGuid(1)));
break;
case CommandResult.StaleInstanceVersion:
returnValue = new InstanceLockLostException(commandName, reader.GetGuid(1));
break;
case CommandResult.HostLockExpired:
returnValue = new InstancePersistenceException(SR.HostLockExpired);
break;
case CommandResult.HostLockNotFound:
returnValue = new InstancePersistenceException(SR.HostLockNotFound);
break;
case CommandResult.CleanupInProgress:
returnValue = new InstancePersistenceCommandException(SR.CleanupInProgress);
break;
case CommandResult.InstanceAlreadyLockedToOwner:
returnValue = new InstanceAlreadyLockedToOwnerException(commandName, reader.GetGuid(1), reader.GetInt64(2));
break;
default:
returnValue = new InstancePersistenceCommandException(SR.UnknownSprocResult(result));
break;
}
}
return returnValue;
}
public static Guid GetUserId2(String databaseName, System.Net.NetworkCredential credential, String configName, String configVersion, out String eMail)
{
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(Common.Solution.CreateFromContext(databaseName).ConnectionString))
{
conn.Open();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("[admin].[Logon]", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(cmd);
cmd.Parameters["@UserName"].Value = credential.UserName;
cmd.Parameters["@UserPassword"].Value = credential.Password;
cmd.Parameters["@ConfigName"].Value = configName;
cmd.Parameters["@ConfigVersion"].Value = configVersion;
try
{
using (System.Data.SqlClient.SqlDataReader r = cmd.ExecuteReader())
{
if (r.Read())
{
eMail = r.GetString(1);
return(r.GetGuid(0));
}
}
}
catch (Exception e)
{
throw new ConflictVersionException(e.Message);
}
}
throw new UnauthorizedAccessException("Invalid user name or password");
}
/// <summary>
/// Constructs an instance of IStoreShardMap using a row from SqlDataReader starting at specified offset.
/// </summary>
/// <param name="reader">SqlDataReader whose row has shard map information.</param>
/// <param name="offset">Reader offset for column that begins shard map information..</param>
internal SqlShardMap(SqlDataReader reader, int offset)
{
this.Id = reader.GetGuid(offset);
this.Name = reader.GetString(offset + 1);
this.MapType = (ShardMapType)reader.GetInt32(offset + 2);
this.KeyType = (ShardKeyType)reader.GetInt32(offset + 3);
}
internal static Message Load(SqlDataReader reader) {
var message = new Message();
// RECEIVE conversation_group_id, conversation_handle,
// message_sequence_number, service_name, service_contract_name,
// message_type_name, validation, message_body
// FROM Queue
message.ConversationGroupId = reader.GetGuid(0);
message.ConversationHandle = reader.GetGuid(1);
message.MessageSequenceNumber = reader.GetInt64(2);
message.ServiceName = reader.GetString(3);
message.ServiceContractName = reader.GetString(4);
message.MessageTypeName = reader.GetString(5);
//m_validation = reader.GetString(6);
if (!reader.IsDBNull(7)) {
message.Body = reader.GetSqlBytes(7).Buffer;
} else
message.Body = new byte[0];
return message;
}
private string GetObjectValue(System.Data.SqlClient.SqlDataReader reader, int i)
{
string fieldType = reader.GetFieldType(i).ToString();
object FieldValue = null;;
if (fieldType.Contains("Int32"))
{
FieldValue = reader.GetInt32(i);
}
else if (fieldType.Contains("Int64"))
{
FieldValue = reader.GetInt64(i);
}
else if (fieldType.Contains("Decimal"))
{
FieldValue = reader.GetDecimal(i);
}
else if (fieldType.Contains("Double"))
{
FieldValue = reader.GetDouble(i);
}
else if (fieldType.Contains("DateTime"))
{
FieldValue = reader.GetDateTime(i);
}
else if (fieldType.Contains("String"))
{
FieldValue = reader.GetString(i);
}
else if (fieldType.Contains("Boolean"))
{
FieldValue = reader.GetBoolean(i);
}
else if (fieldType.Contains("Byte"))
{
FieldValue = reader.GetByte(i);
}
else if (fieldType.Contains("Guid"))
{
FieldValue = reader.GetGuid(i);
}
else
{
FieldValue = reader.GetString(i);
}
if (FieldValue != null)
{
return(FieldValue.ToString());
}
else
{
return("");
}
}
private EventDataRow ReadDataRow(SqlDataReader eventReader)
{
return new EventDataRow
{
EventJson = eventReader.GetString(1),
EventType = eventReader.GetInt32(0),
AggregateRootId = eventReader.GetGuid(2),
AggregateRootVersion = eventReader[3] as int? ?? eventReader.GetInt32(10),
EventId = eventReader.GetGuid(4),
UtcTimeStamp = DateTime.SpecifyKind(eventReader.GetDateTime(5), DateTimeKind.Utc),
//Without this the datetime will be DateTimeKind.Unspecified and will not convert correctly into Local time....
InsertionOrder = eventReader.GetInt64(6),
InsertAfter = eventReader[7] as long?,
InsertBefore = eventReader[8] as long?,
Replaces = eventReader[9] as long?,
InsertedVersion = eventReader.GetInt32(10),
ManualVersion = eventReader[11] as int?,
EffectiveVersion = eventReader[3] as int?
};
}
/// <summary>
/// Constructs an instance of IStoreLogEntry using parts of a row from SqlDataReader.
/// Used for creating the store operation for Undo.
/// </summary>
/// <param name="reader">SqlDataReader whose row has operation information.</param>
/// <param name="offset">Reader offset for column that begins operation information.</param>
internal SqlLogEntry(SqlDataReader reader, int offset)
{
this.Id = reader.GetGuid(offset);
this.OpCode = (StoreOperationCode)reader.GetInt32(offset + 1);
this.Data = reader.GetSqlXml(offset + 2);
this.UndoStartState = (StoreOperationState)reader.GetInt32(offset + 3);
SqlGuid shardIdRemoves;
shardIdRemoves = reader.GetSqlGuid(offset + 4);
this.OriginalShardVersionRemoves = shardIdRemoves.IsNull ? default(Guid) : shardIdRemoves.Value;
SqlGuid shardIdAdds;
shardIdAdds = reader.GetSqlGuid(offset + 5);
this.OriginalShardVersionAdds = shardIdAdds.IsNull ? default(Guid) : shardIdAdds.Value;
}
private Notification CreateNotification(SqlDataReader reader)
{
return new Notification
{
ID = reader.GetGuid(reader.GetOrdinal("NotificationID")),
LanguageCode = GetString(reader, "LanguageCode"),
Subject = GetString(reader, "Subject"),
TypeKey = GetString(reader, "TypeKey"),
Dispatched = reader.GetBoolean(reader.GetOrdinal("Dispatched")),
Parameter = new JavaScriptSerializer().Deserialize<Dictionary<string, string>>(
GetString(reader, "Parameter")
)
};
}
private ServiceBrokerMessage(SqlDataReader reader)
{
ConversationHandle = reader.GetGuid(0);
ServiceName = reader.GetString(1);
ServiceContractName = reader.GetString(2);
MessageTypeName = reader.GetString(3);
if (!reader.IsDBNull(4))
{
Body = reader.GetSqlBytes(4).Buffer;
}
else
{
Body = new byte[0];
}
}
public static Guid ParseGuid(System.Data.SqlClient.SqlDataReader rdr, int index)
{
Guid data = Guid.Empty;
try
{
data = rdr.GetGuid(index);
}
catch (Exception ex)
{
data = Guid.Empty;
ex.GetHashCode();
}
return(data);
}
public static ServiceBrokerMessage Load(SqlDataReader reader)
{
var message = new ServiceBrokerMessage();
message.ConversationHandle = reader.GetGuid(0);
message.ServiceName = reader.GetString(1);
message.ServiceContractName = reader.GetString(2);
message.MessageTypeName = reader.GetString(3);
if (!reader.IsDBNull(4))
{
message.Body = reader.GetSqlBytes(4).Buffer;
}
else
{
message.Body = new byte[0];
}
return message;
}
internal static SqlTrackingWorkflowInstance BuildInstance(SqlDataReader reader, string connectionString)
{
if (reader == null)
{
throw new ArgumentNullException("reader");
}
if (reader.IsClosed)
{
throw new ArgumentException(ExecutionStringManager.InvalidSqlDataReader, "reader");
}
SqlTrackingWorkflowInstance instance = new SqlTrackingWorkflowInstance(connectionString) {
WorkflowInstanceId = reader.GetGuid(1),
WorkflowInstanceInternalId = reader.GetInt64(2),
Initialized = reader.GetDateTime(3)
};
if (DBNull.Value == reader[4])
{
instance.InvokingWorkflowInstanceId = Guid.Empty;
}
else
{
instance.InvokingWorkflowInstanceId = reader.GetGuid(4);
}
instance.Status = (WorkflowStatus) reader.GetInt32(5);
if (!reader.IsDBNull(6))
{
instance.WorkflowType = Type.GetType(reader.GetString(6) + ", " + reader.GetString(7), true, false);
}
return instance;
}
/// <summary>
/// Creates a new instance of the Campanias class and populates it with data from the specified SqlDataReader.
/// </summary>
private static CampaniasInfo MakeCampanias(SqlDataReader dataReader)
{
CampaniasInfo campanias = new CampaniasInfo();
if (dataReader.IsDBNull(Cod_campania) == false)
campanias.cod_campania = dataReader.GetInt32(Cod_campania);
if (dataReader.IsDBNull(Descripcion) == false)
campanias.descripcion = dataReader.GetString(Descripcion);
if (dataReader.IsDBNull(Inicio) == false)
campanias.inicio = dataReader.GetDateTime(Inicio);
if (dataReader.IsDBNull(Fin) == false)
campanias.fin = dataReader.GetDateTime(Fin);
if (dataReader.IsDBNull(Fecha_activada) == false)
campanias.fecha_activada = dataReader.GetDateTime(Fecha_activada);
if (dataReader.IsDBNull(Publica) == false)
campanias.publica = dataReader.GetBoolean(Publica);
if (dataReader.IsDBNull(Action) == false)
campanias.Action = dataReader.GetString(Action);
if (dataReader.IsDBNull(Download) == false)
campanias.Download = dataReader.GetDateTime(Download);
if (dataReader.IsDBNull(SyncID) == false)
campanias.SyncID = dataReader.GetGuid(SyncID);
if (dataReader.IsDBNull(SyncTimeStamp) == false)
campanias.SyncTimeStamp = DateTime.MinValue;
return campanias;
}
private void SaveData(SqlDataReader readReader)
{
string errorMsg = "";
// A.SiteId, customstr5
//A.ItemId customstr4
//,a.MachineName,computername
//A.MachineIp,customstr3
//a.DocLocation,customstr10
//a.Occurred,datetime
//a.LocationType, customint1
//b.tp_Login, customstr1
//b.tp_Title, usersID
//b.tp_Email, customstr2
//Event eventType
CustomBase.Rec rec = new CustomBase.Rec();
rec.LogName = "SharePoint Recorder";
rec.CustomStr5 = readReader.GetGuid(0).ToString();
rec.CustomStr4 = readReader.GetGuid(1).ToString();
try
{
rec.ComputerName = readReader.GetString(2);
}
catch (Exception ex)
{
errorMsg += " | readReader.GetString(2) = " + readReader[2].ToString(); rec.ComputerName = "";
L.Log(LogType.FILE, LogLevel.ERROR, " timer1_Tick -->> : " + ex.ToString() + " " + rec.ComputerName);
}
try
{
rec.CustomStr3 = readReader.GetString(3);
}
catch (Exception ex)
{
errorMsg += " | readReader.GetString(3) = " + readReader[3].ToString(); rec.CustomStr3 = "";
L.Log(LogType.FILE, LogLevel.ERROR, " timer1_Tick -->> : " + ex.ToString() + " " + rec.CustomStr3);
}
try
{
rec.CustomStr10 = readReader.GetString(4);
}
catch (Exception ex) { errorMsg += " | readReader.GetString(4) = " + readReader[4].ToString(); rec.CustomStr10 = ""; }
try
{
rec.Datetime = readReader.GetDateTime(5).ToString("yyyy/MM/dd HH:mm:ss");
L.Log(LogType.FILE, LogLevel.DEBUG, " timer1_Tick -->> DateTime : " + rec.Datetime.ToString());
}
catch (Exception ex)
{
L.Log(LogType.FILE, LogLevel.ERROR, " timer1_Tick -->> There is a dateTime Error : " + ex.ToString());
L.Log(LogType.FILE, LogLevel.ERROR, " timer1_Tick -->> readReader[5] : " + readReader[5].ToString());
goto End;
}
try
{
rec.CustomInt1 = readReader.GetInt32(6);
}
catch (Exception ex)
{
errorMsg += " | readReader.GetString(6) = " + readReader[6].ToString(); rec.CustomInt1 = 0;
L.Log(LogType.FILE, LogLevel.ERROR, " timer1_Tick -->> : " + ex.ToString() + " " + rec.CustomInt1.ToString());
}
try
{
rec.CustomStr1 = readReader.GetString(7);
}
catch (Exception ex) { errorMsg += " | readReader.GetString(7) = " + readReader[7].ToString(); rec.CustomStr1 = ""; }
try
{
rec.UserName = readReader.GetString(8);
}
catch (Exception ex) { errorMsg += " | readReader.GetString(8) = " + readReader[8].ToString(); rec.UserName = ""; }
try
{
rec.CustomStr2 = readReader.GetString(9);
}
catch (Exception ex) { errorMsg += " | readReader.GetString(9) = " + readReader[9].ToString(); rec.CustomStr2 = ""; }
try
{
rec.EventType = readReader.GetString(10);
}
catch (Exception ex) { errorMsg += " | readReader.GetString(10) = " + readReader[10].ToString(); rec.EventType = ""; }
if (!string.IsNullOrEmpty(errorMsg))
{
L.Log(LogType.FILE, LogLevel.ERROR, " timer1_Tick -->> Karşılaşılan Kolon Hataları : " + errorMsg);
}
errorMsg = "";
L.Log(LogType.FILE, LogLevel.DEBUG, " timer1_Tick -->> Start sending Data");
if (usingRegistry)
{
CustomServiceBase s = base.GetInstanceService("Security Manager Sender");
s.SetData(rec);
}
else
{
CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder");
s.SetData(Dal, virtualhost, rec);
}
L.Log(LogType.FILE, LogLevel.DEBUG, " timer1_Tick -->> Finish Sending Data");
LastRecordDate = rec.Datetime;
L.Log(LogType.FILE, LogLevel.DEBUG, " timer1_Tick -->> Last Position is setted. Last rec date : " + LastRecordDate.ToString());
//SetConfigData(Id, location, "", LastRecordDate, "", "", false, max_record_send, user, password, remote_host, sleeptime, trc_level, LastRecordDate, 0, virtualhost, Dal, zone);
if (usingRegistry)
Set_Registry(last_recordnum);
else
{
CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder");
s.SetReg(Id, LastRecordDate, "", "", "", LastRecordDate);
}
End: ;
}
/// <summary>
/// Creates a new instance of the Tipo_Cliente class and populates it with data from the specified SqlDataReader.
/// </summary>
private static Tipo_ClienteInfo MakeTipo_Cliente(SqlDataReader dataReader)
{
Tipo_ClienteInfo tipo_Cliente = new Tipo_ClienteInfo();
if (dataReader.IsDBNull(Cod_Tipo) == false)
tipo_Cliente.Cod_Tipo = dataReader.GetInt32(Cod_Tipo);
if (dataReader.IsDBNull(Descripcion) == false)
tipo_Cliente.Descripcion = dataReader.GetString(Descripcion);
if (dataReader.IsDBNull(Participa) == false)
tipo_Cliente.Participa = dataReader.GetBoolean(Participa);
if (dataReader.IsDBNull(Action) == false)
tipo_Cliente.Action = dataReader.GetString(Action);
if (dataReader.IsDBNull(Download) == false)
tipo_Cliente.download = dataReader.GetDateTime(Download);
if (dataReader.IsDBNull(SyncID) == false)
tipo_Cliente.SyncID = dataReader.GetGuid(SyncID);
if (dataReader.IsDBNull(SyncTimeStamp) == false)
tipo_Cliente.SyncTimeStamp = DateTime.MinValue;
return tipo_Cliente;
}
/// <summary>
/// Creates a new instance of the Rutas class and populates it with data from the specified SqlDataReader.
/// </summary>
private static RutasInfo MakeRutas(SqlDataReader dataReader)
{
RutasInfo rutas = new RutasInfo();
if (dataReader.IsDBNull(Id) == false)
rutas.Id = dataReader.GetInt32(Id);
if (dataReader.IsDBNull(Bit_Location) == false)
rutas.Bit_Location = dataReader.GetInt32(Bit_Location);
if (dataReader.IsDBNull(Descripcion) == false)
rutas.Descripcion = dataReader.GetString(Descripcion);
if (dataReader.IsDBNull(Download) == false)
rutas.Download = dataReader.GetDateTime(Download);
if (dataReader.IsDBNull(Action) == false)
rutas.Action = dataReader.GetString(Action);
if (dataReader.IsDBNull(Orden) == false)
rutas.orden = dataReader.GetInt32(Orden);
if (dataReader.IsDBNull(SyncID) == false)
rutas.SyncID = dataReader.GetGuid(SyncID);
if (dataReader.IsDBNull(SyncTimeStamp) == false)
rutas.SyncTimeStamp = DateTime.MinValue;
return rutas;
}
/// <summary>
/// Creates a new instance of the Tipo_Calle class and populates it with data from the specified SqlDataReader.
/// </summary>
private static Tipo_CalleInfo MakeTipo_Calle(SqlDataReader dataReader)
{
Tipo_CalleInfo tipo_Calle = new Tipo_CalleInfo();
if (dataReader.IsDBNull(Cod_TipoCalle) == false)
tipo_Calle.Cod_TipoCalle = dataReader.GetInt32(Cod_TipoCalle);
if (dataReader.IsDBNull(Denominacion) == false)
tipo_Calle.Denominacion = dataReader.GetString(Denominacion);
if (dataReader.IsDBNull(Abreviatura) == false)
tipo_Calle.Abreviatura = dataReader.GetString(Abreviatura);
if (dataReader.IsDBNull(Download) == false)
tipo_Calle.Download = dataReader.GetDateTime(Download);
if (dataReader.IsDBNull(Action) == false)
tipo_Calle.Action = dataReader.GetString(Action);
if (dataReader.IsDBNull(SyncID) == false)
tipo_Calle.SyncID = dataReader.GetGuid(SyncID);
if (dataReader.IsDBNull(SyncTimeStamp) == false)
tipo_Calle.SyncTimeStamp = DateTime.MinValue;
return tipo_Calle;
}
/// <summary>
/// Froms the db reader.
/// </summary>
/// <param name="reader">The reader.</param>
/// <returns></returns>
private TaskActivity ReadFromDatabase(SqlDataReader reader)
{
//Id DescriptionId Remarks StartDate EndDate Duration CrossTabDescriptionId CustomFlags UserId SourceMachine OriginalDate
TaskActivity ta = new TaskActivity();
ta.Id = reader.GetGuid(0);
Debug.Assert(ta.Id != null, "The TaskActivity Guid cannot be null.");
ta.TaskDescription
= Engine.TaskDescriptionsProvider.FindDescription(reader.GetGuid(1));
if (!reader.IsDBNull(2))
{
ta.Remarks = reader.GetString(2);
}
ta.StartDate = reader.GetDateTime(3);
if (!reader.IsDBNull(4))
{
ta.EndDate = reader.GetDateTime(4);
}
if (!reader.IsDBNull(6))
{
ta.CrosstabTaskDescription
= Engine.TaskDescriptionsProvider.FindDescription(reader.GetGuid(6));
}
ta.CustomFlags = reader.GetInt32(7);
ta.UserId = reader.GetString(8);
ta.OriginalDate = reader.GetDateTime(9);
return ta;
}
public override void Map(SqlDataReader sqlDataReader)
{
this.Id = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("Id"));
this.Name = sqlDataReader.GetString(sqlDataReader.GetOrdinal("Name"));
this.StartYear = sqlDataReader.GetInt32(sqlDataReader.GetOrdinal("StartYear"));
}
/// <summary>
/// Creates a new instance of the Productos_Objetivo class and populates it with data from the specified SqlDataReader.
/// </summary>
private static Productos_ObjetivoInfo MakeProductos_Objetivo(SqlDataReader dataReader)
{
Productos_ObjetivoInfo productos_Objetivo = new Productos_ObjetivoInfo();
if (dataReader.IsDBNull(Cod_objetivo) == false)
productos_Objetivo.cod_objetivo = dataReader.GetInt32(Cod_objetivo);
if (dataReader.IsDBNull(Cod_entidad) == false)
productos_Objetivo.cod_entidad = dataReader.GetInt32(Cod_entidad);
if (dataReader.IsDBNull(Tipo_entidad) == false)
productos_Objetivo.tipo_entidad = dataReader.GetString(Tipo_entidad);
if (dataReader.IsDBNull(Download) == false)
productos_Objetivo.download = dataReader.GetDateTime(Download);
if (dataReader.IsDBNull(SyncID) == false)
productos_Objetivo.SyncID = dataReader.GetGuid(SyncID);
if (dataReader.IsDBNull(SyncTimeStamp) == false)
productos_Objetivo.SyncTimeStamp = DateTime.MinValue;
return productos_Objetivo;
}
private IndexBackup GetBackupFromReader(SqlDataReader reader)
{
var result = new IndexBackup();
result.IndexBackupId = reader.GetInt32(0); // IndexBackupId
result.BackupNumber = reader.GetInt32(1); // BackupNumber
result.BackupDate = reader.GetDateTime(2); // BackupDate
result.ComputerName = reader.GetSafeString(3); // ComputerName
result.AppDomainName = reader.GetSafeString(4); // AppDomain
result.BackupFileLength = reader.GetInt64(5); // BackupFileLength
result.RowGuid = reader.GetGuid(6); // RowGuid
result.Timestamp = GetLongFromBytes((byte[])reader[7]); // Timestamp
return result;
}
/// <summary>
/// Gets the user from data reader.
/// </summary>
/// <param name="user_list">The user_list.</param>
/// <returns>User from database</returns>
private static User GetUserFromDataReader( SqlDataReader user_list )
{
return new User(
user_list.GetString( 0 ),
user_list.GetString( 1 ),
user_list.GetInt32( 2 ),
user_list.GetInt32( 3 ),
user_list.GetString( 4 ),
user_list.GetBoolean( 5 ),
user_list.GetDateTime( 6 ),
user_list.GetString( 7 ),
user_list.GetBoolean( 8 ),
user_list.GetBoolean( 9 ),
user_list.GetDateTime( 10 ),
user_list.GetGuid( 11 ),
user_list.GetBoolean( 12 ),
user_list.GetBoolean( 13 ),
user_list.GetInt32( 14 ),
user_list.GetDecimal( 15 ),
user_list.GetBoolean( 16 ),
user_list.GetString( 17 ),
user_list.GetDecimal( 18 ),
user_list.GetString( 19 ),
user_list.GetString( 20 ),
user_list.GetString( 21 ),
user_list.GetString( 22 ),
user_list.GetString( 23 ),
user_list.GetString( 24 ),
user_list.GetString( 25 ),
user_list.GetString( 26 ),
user_list.GetString( 27 ),
user_list.GetString( 28 ),
user_list.GetString( 39 ),
user_list.GetString( 30 ),
user_list.GetString( 31 ),
user_list.GetInt32( 32 ),
user_list.GetBoolean( 33 ),
user_list.GetInt32( 34 ),
user_list.GetString( 35 ),
user_list.GetBoolean( 36 ),
user_list.GetBoolean( 37 ),
user_list.GetString( 38 ),
user_list.GetString( 39 ),
user_list.GetString( 40 ),
user_list.GetString( 41 ),
user_list.GetString( 42 ),
user_list.GetInt32( 43 ),
user_list.GetString( 44 ),
user_list.GetBoolean( 45 ),
user_list.GetBoolean( 46 ),
user_list.GetInt32( 47 ),
user_list.GetInt32( 48 ),
user_list.GetString( 49 ),
user_list.GetInt32( 50 ),
user_list.GetString( 51 )
);
}
/// <summary>
/// Creates a new instance of the Medicos class and populates it with data from the specified SqlDataReader.
/// </summary>
private static MedicosInfo MakeMedicos(SqlDataReader dataReader)
{
MedicosInfo medicos = new MedicosInfo();
if (dataReader.IsDBNull(Cod_Medico) == false)
medicos.Cod_Medico = dataReader.GetInt32(Cod_Medico);
if (dataReader.IsDBNull(Apellido) == false)
medicos.Apellido = dataReader.GetString(Apellido);
if (dataReader.IsDBNull(Nombre) == false)
medicos.Nombre = dataReader.GetString(Nombre);
if (dataReader.IsDBNull(Fecha_Nacimiento) == false)
medicos.Fecha_Nacimiento = dataReader.GetDateTime(Fecha_Nacimiento);
if (dataReader.IsDBNull(Cod_Sexo) == false)
medicos.Cod_Sexo = dataReader.GetInt32(Cod_Sexo);
if (dataReader.IsDBNull(Cod_Direccion) == false)
medicos.Cod_Direccion = dataReader.GetInt32(Cod_Direccion);
if (dataReader.IsDBNull(Cod_Especialidad_Prim) == false)
medicos.Cod_Especialidad_Prim = dataReader.GetInt32(Cod_Especialidad_Prim);
if (dataReader.IsDBNull(Cod_Tipo_Cliente) == false)
medicos.Cod_Tipo_Cliente = dataReader.GetInt32(Cod_Tipo_Cliente);
if (dataReader.IsDBNull(Residente) == false)
medicos.Residente = dataReader.GetBoolean(Residente);
if (dataReader.IsDBNull(Fecha_Alta) == false)
medicos.Fecha_Alta = dataReader.GetDateTime(Fecha_Alta);
if (dataReader.IsDBNull(Cod_Operador_Alta) == false)
medicos.Cod_Operador_Alta = dataReader.GetString(Cod_Operador_Alta);
if (dataReader.IsDBNull(Fecha_Baja) == false)
medicos.Fecha_Baja = dataReader.GetDateTime(Fecha_Baja);
if (dataReader.IsDBNull(Cod_Operador_Baja) == false)
medicos.Cod_Operador_Baja = dataReader.GetString(Cod_Operador_Baja);
if (dataReader.IsDBNull(Cod_Motivo) == false)
medicos.Cod_Motivo = dataReader.GetInt32(Cod_Motivo);
if (dataReader.IsDBNull(Cod_Temporario) == false)
medicos.Cod_Temporario = dataReader.GetInt32(Cod_Temporario);
if (dataReader.IsDBNull(Download) == false)
medicos.Download = dataReader.GetDateTime(Download);
if (dataReader.IsDBNull(Action) == false)
medicos.Action = dataReader.GetString(Action);
if (dataReader.IsDBNull(SyncID) == false)
medicos.SyncID = dataReader.GetGuid(SyncID);
if (dataReader.IsDBNull(SyncTimeStamp) == false)
medicos.SyncTimeStamp = DateTime.MinValue;
return medicos;
}
private List<Song> GetSongsFromReader(SqlDataReader reader)
{
List<Song> songlist = new List<Song>();
if (reader == null || !reader.HasRows)
{
return songlist; //leere Liste zurückgeben
}
//Alle Zeilen der Ergebnismenge durchlaufen.
while (reader.Read())
{
Song song = new Song();
//Alle Spalten in einer Zeile der Ergebnismenge durchlaufen
for (int i = 0; i < reader.FieldCount; i++)
{
switch (reader.GetName(i).ToLower())
{
case "songid":
song.songID = reader.GetGuid(i);
break;
case "albumid":
song.albumID = reader.GetGuid(i);
break;
case "songtitle":
//Die Tabelle erlaubt für diese Spalte auch Nullwerte,
song.songtitle = reader.IsDBNull(i) ? null : reader.GetString(i);
break;
}
}
songlist.Add(song);
}
return songlist;
}
private List<Album> GetAlbumsFromReader(SqlDataReader reader)
{
List<Album> list = new List<Album>();
if (reader == null || !reader.HasRows)
{
return list; //leere Liste zurückgeben
}
//Alle Zeilen der Ergebnismenge durchlaufen.
while (reader.Read())
{
Album album = new Album();
//Alle Spalten in einer Zeile der Ergebnismenge durchlaufen
for (int i = 0; i < reader.FieldCount; i++)
{
var test = reader.GetName(i).ToLower();
switch (reader.GetName(i).ToLower())
{
case "albumid":
album.albumID = reader.GetGuid(i);
break;
case "interpret":
album.interpret = reader.IsDBNull(i) ? null : reader.GetString(i);
break;
case "title":
//Die Tabelle erlaubt für diese Spalte auch Nullwerte,
album.title = reader.IsDBNull(i) ? null : reader.GetString(i);
break;
case "genre":
//Die Tabelle erlaubt für diese Spalte auch Nullwerte
album.genre = reader.IsDBNull(i) ? null : reader.GetString(i);
break;
case "imagepath":
album.imagepath = reader.IsDBNull(i) ? null : reader.GetString(i);
break;
case "datum":
//album.datum = reader.IsDBNull(i) ? null : reader.GetInt32(i); // !!! Fehler
//album.datum = reader[i].GetType() != typeof(DBNull) ? reader.GetInt32(i): 0;
album.datum = reader.IsDBNull(i) ? 0 : (int)reader.GetInt32(i);
break;
}
}
list.Add(album);
}
return list;
}
protected static void PopulateEntity(SqlDataReader reader, ServerEntity entity, Dictionary<string, PropertyInfo> propMap)
{
for (int i = 0; i < reader.FieldCount; i++)
{
String columnName = reader.GetName(i);
// Special case for when we select a range of values with an EntityBroker, just ignore
if (columnName.Equals("RowNum"))
continue;
if (columnName.Equals("GUID"))
{
Guid uid = reader.GetGuid(i);
entity.SetKey(new ServerEntityKey(entity.Name, uid));
continue;
}
if (columnName.Equals(entity.Name) && columnName.Contains("Enum"))
columnName = "Enum";
PropertyInfo prop;
if (!propMap.TryGetValue(columnName, out prop))
throw new EntityNotFoundException("Unable to match column to property: " + columnName, null);
if (columnName.Contains("GUID"))
columnName = columnName.Replace("GUID", "Key");
if (reader.IsDBNull(i))
{
prop.SetValue(entity, null, null);
continue;
}
Type propType = prop.PropertyType;
if (propType == typeof(String))
prop.SetValue(entity, reader.GetString(i), null);
else if (propType == typeof(ServerEntityKey))
{
Guid uid = reader.GetGuid(i);
prop.SetValue(entity, new ServerEntityKey(columnName.Replace("Key", String.Empty), uid), null);
}
else if (propType == typeof(DateTime))
prop.SetValue(entity, reader.GetDateTime(i), null);
else if (propType == typeof(DateTime?))
{
if (reader.IsDBNull(i))
{
prop.SetValue(entity, null, null);
}
else
{
prop.SetValue(entity, reader.GetDateTime(i), null);
}
}
else if (propType == typeof(bool))
prop.SetValue(entity, reader.GetBoolean(i), null);
else if (propType == typeof(Int32))
prop.SetValue(entity, reader.GetInt32(i), null);
else if (propType == typeof(Int16))
prop.SetValue(entity, reader.GetInt16(i), null);
else if (propType == typeof(double))
prop.SetValue(entity, reader.GetDouble(i), null);
else if (propType == typeof(Decimal))
prop.SetValue(entity, reader.GetDecimal(i), null);
else if (propType == typeof(float))
prop.SetValue(entity, reader.GetFloat(i), null);
else if (propType == typeof(XmlDocument))
{
SqlXml xml = reader.GetSqlXml(i);
if (xml!=null && !xml.IsNull)
{
XmlReader xmlReader = xml.CreateReader();
if (xmlReader != null)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(xmlReader);
prop.SetValue(entity, xmlDoc, null);
}
else
prop.SetValue(entity, null, null);
}
else
{
prop.SetValue(entity, null, null);
}
}
else if (typeof(ServerEnum).IsAssignableFrom(propType))
{
short enumVal = reader.GetInt16(i);
ConstructorInfo construct = prop.PropertyType.GetConstructor(new Type[0]);
ServerEnum val = (ServerEnum)construct.Invoke(null);
val.SetEnum(enumVal);
prop.SetValue(entity, val, null);
}
else
throw new EntityNotFoundException("Unsupported property type: " + propType, null);
}
}
// Copy multiple fields from reader to ITypedSettersV3
// Assumes caller enforces that reader and setter metadata are compatible
internal static void FillCompatibleITypedSettersFromReader( SmiEventSink_Default sink, ITypedSettersV3 setters, SmiMetaData[] metaData, SqlDataReader reader ) {
for ( int i = 0; i < metaData.Length; 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 ) );
ValueUtilsSmi.SetInt64_Unchecked( sink, setters, i, reader.GetInt64(i) );
break;
case SqlDbType.Binary:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) );
ValueUtilsSmi.SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 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.SqlChars ) );
SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 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:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlDecimal ) );
SetSqlDecimal_Unchecked( sink, setters, i, reader.GetSqlDecimal(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.SqlBytes ) );
SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 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_Unchecked( sink, setters, i, metaData[i], reader.GetSqlMoney(i) );
break;
case SqlDbType.NChar:
case SqlDbType.NText:
case SqlDbType.NVarChar:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) );
SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 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], reader.GetSqlMoney(i) );
break;
case SqlDbType.Text:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) );
SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 );
break;
case SqlDbType.Timestamp:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) );
SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 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.SqlBytes ) );
SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 );
break;
case SqlDbType.VarChar:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.String ) );
SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 );
break;
case SqlDbType.Xml:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlXml ) );
SetSqlXml_Unchecked( sink, setters, i, reader.GetSqlXml(i) );
break;
case SqlDbType.Variant:
object o = reader.GetSqlValue(i);
ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCode( o );
SetCompatibleValue( sink, setters, i, metaData[i], o, typeCode, 0 );
break;
case SqlDbType.Udt:
Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) );
SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 );
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();
}
}
}
}
/// <summary>
/// Creates a new instance of the Delegaciones class and populates it with data from the specified SqlDataReader.
/// </summary>
private static DelegacionesInfo MakeDelegaciones(SqlDataReader dataReader)
{
DelegacionesInfo delegaciones = new DelegacionesInfo();
if (dataReader.IsDBNull(Cod_Regional) == false)
delegaciones.Cod_Regional = dataReader.GetInt32(Cod_Regional);
if (dataReader.IsDBNull(Cod_Delegacion) == false)
delegaciones.Cod_Delegacion = dataReader.GetInt32(Cod_Delegacion);
if (dataReader.IsDBNull(Delegacion) == false)
delegaciones.Delegacion = dataReader.GetString(Delegacion);
if (dataReader.IsDBNull(Numero) == false)
delegaciones.Numero = dataReader.GetString(Numero);
if (dataReader.IsDBNull(Cod_Jefe) == false)
delegaciones.Cod_Jefe = dataReader.GetInt32(Cod_Jefe);
if (dataReader.IsDBNull(Email) == false)
delegaciones.Email = dataReader.GetString(Email);
if (dataReader.IsDBNull(LastProcess) == false)
delegaciones.LastProcess = new Byte[Convert.ToInt32(dataReader.GetBytes(0, 0, null, 0, Int32.MaxValue))];
dataReader.GetBytes(0, 0, delegaciones.LastProcess, 0, delegaciones.LastProcess.Length);
if (dataReader.IsDBNull(ActualProcess) == false)
delegaciones.ActualProcess = new Byte[Convert.ToInt32(dataReader.GetBytes(0, 0, null, 0, Int32.MaxValue))];
dataReader.GetBytes(0, 0, delegaciones.ActualProcess, 0, delegaciones.ActualProcess.Length);
if (dataReader.IsDBNull(TempTime) == false)
delegaciones.TempTime = new Byte[Convert.ToInt32(dataReader.GetBytes(0, 0, null, 0, Int32.MaxValue))];
dataReader.GetBytes(0, 0, delegaciones.TempTime, 0, delegaciones.TempTime.Length);
if (dataReader.IsDBNull(Proc_ID) == false)
delegaciones.Proc_ID = dataReader.GetInt32(Proc_ID);
if (dataReader.IsDBNull(Skip) == false)
delegaciones.Skip = dataReader.GetBoolean(Skip);
if (dataReader.IsDBNull(SyncID) == false)
delegaciones.SyncID = dataReader.GetGuid(SyncID);
if (dataReader.IsDBNull(SyncTimeStamp) == false)
delegaciones.SyncTimeStamp = DateTime.MinValue;
return delegaciones;
}
