// Exceptions handling
/// <summary>
/// Parse user data fields from SqlDataReader and create user data entity.
/// </summary>
/// <param name="reader">SqlDataReader with query results.</param>
/// <returns>User data entity.</returns>
private User GetUserFromReader(SqlDataReader reader)
{
/** Data columns order :
* 0 - PAROL
* 1 - DATE_E
* 2 - NIC
* 3 - KAT
*/
var expiredDate = reader.GetFieldValue<DateTime>(1);
var userName = reader.GetFieldValue<string>(2);
var userLevel = reader.GetFieldValue<int>(3);
return new User(userName, userLevel, expiredDate);
}
private static TransitAlert ReadTransitAlert(SqlDataReader reader)
{
return new TransitAlert()
{
TripId = reader.GetFieldValue<string>(reader.GetOrdinal("TripId")),
StationId = reader.GetFieldValue<string>(reader.GetOrdinal("StationId")),
RouteId = reader.GetFieldValue<string>(reader.GetOrdinal("RouteId")),
RouteName = reader.GetFieldValue<string>(reader.GetOrdinal("RouteName")),
StationName = reader.GetFieldValue<string>(reader.GetOrdinal("StationName")),
ArrivalTime = reader.GetFieldValue<DateTime>(reader.GetOrdinal("ArrivalTime")),
ArrivalTimeSeconds = reader.GetFieldValue<int>(reader.GetOrdinal("ArrivalTimeSeconds")),
Direction = reader.GetFieldValue<string>(reader.GetOrdinal("Direction")),
DestinationStationId = reader.GetFieldValue<string>(reader.GetOrdinal("DestinationStationId")),
IsRealtime = reader.GetFieldValue<bool>(reader.GetOrdinal("IsRealtime")),
};
}
/// <summary>
/// Convierte un valor en un SqlDataReader a JSON para ser incluido en un JSN array
/// </summary>
/// <param name="Lector">Referencia hacia al lector (SqlDataReader)</param>
/// <param name="Puntero">Puntero del valor a convertir dentro del lector (SqlDataReader)</param>
/// <returns>Valor para un objeto JSON</returns>
private string TomarValorJSON(ref SqlDataReader Lector,ref short Puntero)
{
return string.Format(
"\"{0}\":{1}",
Lector.GetName(Puntero),
(Lector.IsDBNull(Puntero)) ? "null" :
((Lector.GetFieldType(Puntero) == typeof(bool) || Lector.GetFieldType(Puntero) == typeof(Boolean)) ?
((Lector.GetFieldValue<bool>(Puntero)) ? "true" : "false") :
((Lector.GetFieldType(Puntero) == typeof(int) || Lector.GetFieldType(Puntero) == typeof(byte)
|| Lector.GetFieldType(Puntero) == typeof(Int16) || Lector.GetFieldType(Puntero) == typeof(float)
|| Lector.GetFieldType(Puntero) == typeof(double)) || Lector.GetFieldType(Puntero) == typeof(decimal) ?
Lector.GetFieldValue<object>(Puntero) :
(Lector.GetFieldType(Puntero) == typeof(DateTime) ? UnixTicks(Lector.GetDateTime(Puntero)) :
"\"" + Lector.GetFieldValue<object>(Puntero)
.ToString()
.Replace("\n", "<br>")
//.Replace("\t", "\\\\u09")
.Replace("\r", "<br>")
//.Replace("\\", "\\\\u2f")
//.Replace("'", "\\\\u27")
.Replace("\"", "\\\\u22")
//.Replace("{", "\\\\u7b")
//.Replace("}", "\\\\u7e")
//.Replace("[", "\\\\u5b")
//.Replace("]", "\\\\u5d")
//.Replace(":", "\\\\u3a")
+ "\""))
)
)
;
}
