private static Semana DataReaderAObjeto(SqlCeDataReader rdrLector)
{
Semana Semana = new Semana();
Semana.ID = rdrLector.GetInt64(rdrLector.GetOrdinal("ID"));
Semana.Periodo = rdrLector.GetDateTime(rdrLector.GetOrdinal("Periodo"));
Semana.FechaDesde = rdrLector.GetDateTime(rdrLector.GetOrdinal("FechaDesde"));
Semana.FechaHasta = rdrLector.GetDateTime(rdrLector.GetOrdinal("FechaHasta"));
Semana.Agencia = new Agencia {
ID = rdrLector.GetInt64(rdrLector.GetOrdinal("IdAgencia"))
};
/*if (!rdrLector.IsDBNull(rdrLector.GetOrdinal("IdAgencia")))
* {
* Agencias Agencias = new Agencias(conn);
* Semana.Agencia = Agencias.GetByID(rdrLector.GetInt64(rdrLector.GetOrdinal("IdAgencia")));
* }*/
/*BSP_Tickets BSP_Tickets = new BSP_Tickets();
* Semana.TicketsBSP = BSP_Tickets.ObtenerPorSemana(Semana.ID);
*
* BO_Tickets BO_Tickets = new BO_Tickets();
* Semana.TicketsBO = BO_Tickets.ObtenerPorSemana(Semana.ID);*/
return(Semana);
}
public Tuple <LinkedList <int>, LinkedList <DateTime> > timestampsForPatientScans(int patientID)
{
LinkedList <int> scanID = new LinkedList <int>();
LinkedList <DateTime> timestamp = new LinkedList <DateTime>();
this.con = new SqlCeConnection();
this.con.ConnectionString = "Data Source=|DataDirectory|\\Patients.sdf";
this.con.Open();
SqlCeCommand selectQuery = this.con.CreateCommand();
selectQuery.CommandText = "Select Scans.scanID, timestamp from Scans join PatientScans on Scans.scanID = PatientScans.scanID where patientID = @PatientID;";
selectQuery.Parameters.Clear();
selectQuery.Parameters.Add("@PatientID", patientID);
SqlCeDataReader reader = selectQuery.ExecuteReader();
while (reader.Read())
{
scanID.AddLast(reader.GetInt32(0));
System.Diagnostics.Debug.WriteLine(reader.GetInt32(0));
timestamp.AddLast(Convert.ToDateTime(reader.GetDateTime(1).ToString()));
System.Diagnostics.Debug.WriteLine(reader.GetDateTime(1));
}
reader.Close();
return(Tuple.Create(scanID, timestamp));
}
public static void SetTDispositivo(TDispositivo dispositivo, SqlCeDataReader dr, SqlCeConnection conn)
{
dispositivo.DispositivoId = dr.GetInt32(0);
dispositivo.Nombre = dr.GetString(1);
dispositivo.Empresa = dr.GetString(2);
dispositivo.Instalacion = GetTInstalacion(dr.GetInt32(3), conn);
dispositivo.Tipo = GetTTipoDispositivo(dr.GetInt32(4), conn);
dispositivo.Funcion = dr.GetString(5);
dispositivo.Estado = dr.GetString(6);
dispositivo.CodBarras = dr.GetString(7);
if (dr[14] != DBNull.Value)
{
dispositivo.Posicion = dr.GetString(14);
}
if (dr[8] != DBNull.Value)
{
dispositivo.FechaCaducidad = dr.GetDateTime(8);
}
dispositivo.Caducado = dr.GetBoolean(9);
if (dr[10] != DBNull.Value)
{
dispositivo.FechaBaja = dr.GetDateTime(10);
}
if (dr[11] != DBNull.Value)
{
dispositivo.Modelo = GetTModeloDispositivo(dr.GetInt32(11), conn);
}
}
public Historico BuscarPorID(DateTime _id)
{
Historico c = null;
try
{
String SQL = String.Format("SELECT * FROM historico WHERE datainicio = {0} ", _id);
SqlCeDataReader data = BD.ExecutarSelect(SQL);
if (data.Read())
{
c = new Historico();
c.DataInicio = data.GetDateTime(0);
c.DataFim = data.GetDateTime(1);
c.Preco = data.GetFloat(2);
}
data.Close();
BD.FecharConexao();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(c);
}
public override DocumentVO ReadRecord(SqlCeDataReader reader)
{
DocumentVO result = new DocumentVO();
result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName));
result.InDateTime = reader.GetDateTime(reader.GetOrdinal(documentInDate));
result.InNumber = reader.GetInt32(reader.GetOrdinal(documentInNumber));
result.OutDateTime = reader.GetDateTime(reader.GetOrdinal(documentOutDate));
result.OutNumber = reader.GetInt32(reader.GetOrdinal(documentOutNumber));
result.CreationDate = reader.GetDateTime(reader.GetOrdinal(documentCreationDate));
result.Creator = udao.GetItem(reader.GetInt32(reader.GetOrdinal(documentCreatorId)));
result.LastEditDateTime = reader.GetDateTime(reader.GetOrdinal(documentLastEditDate));
result.LastEditor = udao.GetItem(reader.GetInt32(reader.GetOrdinal(documentLastEditorId)));
udao.CloseConnection();
result.Destination = ddao.GetItem(reader.GetInt32(reader.GetOrdinal(documentDestinationId)));
ddao.CloseConnection();
result.Folder = gdao.GetItem(reader.GetInt32(reader.GetOrdinal(documentFolderId)));
gdao.CloseConnection();
result.Title = reader[documentTitle].ToString();
result.Process = reader[documentProcess].ToString();
result.Subject = reader[documentSubject].ToString();
result.Party = pdao.GetItem(reader.GetInt32(reader.GetOrdinal(documentPartyId)));
pdao.CloseConnection();
result.IsDeleted = ReadBool(reader, documentIsDeleted);
return(result);
}
public static Funcionario PegarFuncionario(int id)
{
string sql = "SELECT * FROM [Funcionario] WHERE Id=@id";
SqlCeCommand comando = new SqlCeCommand(sql, conn);
comando.Parameters.Add("@id", id);
conn.Open();
SqlCeDataReader resposta = comando.ExecuteReader();
Funcionario func = new Funcionario();
while (resposta.Read())
{
func.id = resposta.GetInt32(0);
func.name = resposta.GetString(1);
func.email = resposta.GetString(2);
func.salario = resposta.GetDecimal(3);
func.sexo = resposta.GetString(4);
func.tipoContrato = resposta.GetString(5);
func.dataCadastro = resposta.GetDateTime(6);
if (resposta.IsDBNull(7))
{
func.dataAtualizacao.Equals(null);
}
else
{
func.dataAtualizacao = resposta.GetDateTime(7);
}
}
conn.Close();
return(func);
}
public static IList <TRevision> GetTRevisionesC(TPrograma programa, SqlCeConnection conn)
{
List <TRevision> revisiones = new List <TRevision>();
if (programa == null)
{
return(revisiones);
}
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM Revision WHERE programa_id = {0} ORDER BY fecha_planificada DESC",
programa.ProgramaId);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TRevision revision = new TRevision()
{
RevisionId = dr.GetInt32(0),
Usuario = GetTUsuario(dr.GetInt32(2), conn),
Dispositivo = GetTDispositivo(dr.GetInt32(1), conn),
Resultado = dr.GetString(6),
Comentario = dr.GetString(7),
TPrograma = GetTProgramaC(dr.GetInt32(8), conn),
Estado = dr.GetString(9),
Plantilla = dr.GetString(10),
Abm = dr.GetByte(12)
};
// control de nulos en fechas.
if (dr[3] != DBNull.Value)
{
revision.FechaPlanificada = dr.GetDateTime(3);
}
if (dr[4] != DBNull.Value)
{
revision.FechaProgramada = dr.GetDateTime(4);
}
if (dr[5] != DBNull.Value)
{
revision.FechaRevision = dr.GetDateTime(5);
}
if (dr.GetInt32(11) == 0)
{
revision.TTipoAnomalia = null;
}
else
{
revision.TTipoAnomalia = GetTTipoAnomalia(dr.GetInt32(11), conn);
}
//revision.DatosRevision = GetTDatosRevision(revision, conn);
revisiones.Add(revision);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(revisiones);
}
//static DataModelTestDataContext dm = new DataModelTestDataContext();
public static List <ConfiguracionB> ObtenerConfiguraciones()
{
// metodo agregado
#region SQL compact connection
SqlCeConnection conn = null;
SqlCeCommand cmd = null;
SqlCeDataReader rdr = null;
List <ConfiguracionB> result = new List <ConfiguracionB>();
try
{
conn = new SqlCeConnection("Data Source=" + System.IO.Path.Combine(Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location), "HRNPCIData.sdf"));
conn.Open();
cmd = new SqlCeCommand("SELECT * From Configuracion", conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ConfiguracionB f = new ConfiguracionB();
if (!DBNull.Value.Equals(rdr[0]))
{
f.iCodigoConfiguracion = rdr.GetInt32(0);
}
if (!DBNull.Value.Equals(rdr[1]))
{
f.vParametro = rdr.GetString(1);
}
if (!DBNull.Value.Equals(rdr[2]))
{
f.vRutaEstatica = rdr.GetString(2);
}
if (!DBNull.Value.Equals(rdr[3]))
{
f.dtFechaCreacion = rdr.GetDateTime(3);
}
if (!DBNull.Value.Equals(rdr[4]))
{
f.dtFechaActualizacion = rdr.GetDateTime(4);
}
result.Add(f);
}
rdr.Close();
cmd.Dispose();
}
catch (Exception)
{
return(null);
}
finally
{
conn.Close();
}
return(result);
#endregion
}
public static void SetTDispositivo(TDispositivo dispositivo, SqlCeDataReader dr, SqlCeConnection conn)
{
dispositivo.DispositivoId = dr.GetInt32(0);
dispositivo.Nombre = dr.GetString(1);
dispositivo.Empresa = dr.GetString(2);
dispositivo.Instalacion = GetTInstalacion(dr.GetInt32(3), conn);
dispositivo.Tipo = GetTTipoDispositivo(dr.GetInt32(4), conn);
dispositivo.Funcion = dr.GetString(5);
dispositivo.Estado = dr.GetString(6);
dispositivo.CodBarras = dr.GetString(7);
if (dr[14] != DBNull.Value)
{
dispositivo.Posicion = dr.GetString(14);
}
if (dr[8] != DBNull.Value)
{
dispositivo.FechaCaducidad = dr.GetDateTime(8);
}
dispositivo.Caducado = dr.GetBoolean(9);
if (dr[12] != DBNull.Value)
{
dispositivo.Operativo = dr.GetBoolean(12);
}
//if (!CntSciTerminal.FechaNula(dispositivo.FechaBaja))
// dispositivo.FechaBaja = dr.GetDateTime(10);
if (dr[10] != DBNull.Value)
{
dispositivo.FechaBaja = dr.GetDateTime(10);
}
if (dr[11] != DBNull.Value)
{
dispositivo.Modelo = GetTModeloDispositivo(dr.GetInt32(11), conn);
}
dispositivo.Abm = dr.GetByte(15);
// nuevos campos vrs 2018.0.1.0
if (dr[16] != DBNull.Value)
{
dispositivo.NIndustria = dr.GetString(16);
}
if (dr[17] != DBNull.Value)
{
dispositivo.CargaKg = dr.GetDouble(17);
}
if (dr[18] != DBNull.Value)
{
dispositivo.Fabricante = GetTFabricante(dr.GetInt32(18), conn);
}
if (dr[19] != DBNull.Value)
{
dispositivo.FechaFabricacion = dr.GetDateTime(19);
}
if (dr[20] != DBNull.Value)
{
dispositivo.AgenteExtintor = GetTAgenteExtintor(dr.GetInt32(20), conn);
}
}
public static TRevision GetTRevision(int id, SqlCeConnection conn)
{
TRevision revision = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM Revision WHERE revision_id = {0}",
id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
revision = new TRevision()
{
RevisionId = dr.GetInt32(0),
Usuario = GetTUsuario(dr.GetInt32(2), conn),
Dispositivo = GetTDispositivo(dr.GetInt32(1), conn),
Resultado = dr.GetString(6),
Comentario = dr.GetString(7),
TPrograma = GetTProgramaC(dr.GetInt32(8), conn),
Estado = dr.GetString(9),
Plantilla = dr.GetString(10),
Abm = dr.GetByte(12)
};
revision.NInstalacion = revision.Dispositivo.Instalacion.Nombre;
// control de nulos en fechas.
if (dr[3] != DBNull.Value)
{
revision.FechaPlanificada = dr.GetDateTime(3);
}
if (dr[4] != DBNull.Value)
{
revision.FechaProgramada = dr.GetDateTime(4);
}
if (dr[5] != DBNull.Value)
{
revision.FechaRevision = dr.GetDateTime(5);
}
if (dr.GetInt32(11) == 0)
{
revision.TTipoAnomalia = null;
}
else
{
revision.TTipoAnomalia = GetTTipoAnomalia(dr.GetInt32(11), conn);
}
revision.DatosRevision = GetTDatosRevision(revision, conn);
break;
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(revision);
}
public static TIncidencia GetTIncidencia(int id, SqlCeConnection conn)
{
TIncidencia incidencia = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM Incidencia WHERE incidencia_id = {0}",
id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
incidencia = new TIncidencia();
incidencia.IncidenciaId = dr.GetInt32(0);
incidencia.TDispositivo = GetTDispositivo(dr.GetInt32(1), conn);
incidencia.TUsuario = GetTUsuario(dr.GetInt32(2), conn);
incidencia.Comentarios = dr.GetString(3);
incidencia.Operativo = dr.GetBoolean(4);
// control de nulos en fechas.
if (dr[5] != DBNull.Value)
{
incidencia.FechaApertura = dr.GetDateTime(5);
}
if (dr[6] != DBNull.Value)
{
incidencia.FechaCierre = dr.GetDateTime(6);
}
// nuevos atributos
if (dr[7] != DBNull.Value)
{
incidencia.TEstado = GetTEstado(dr.GetInt32(7), conn);
}
if (dr[8] != DBNull.Value)
{
incidencia.TPrioridad = GetTPrioridad(dr.GetInt32(8), conn);
}
if (dr[9] != DBNull.Value)
{
incidencia.TResponsable = GetTResponsable(dr.GetInt32(9), conn);
}
incidencia.Abm = dr.GetByte(10);
if (dr[11] != DBNull.Value)
{
incidencia.FechaPrevista = dr.GetDateTime(11);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
}
// No profundizamos para evitar bucles.
return(incidencia);
}
public static TTerminal GetTerminalFromDr(SqlCeDataReader dr)
{
TTerminal t = new TTerminal();
t.terminalId = dr.GetInt32(0);
t.numero = dr.GetString(1);
t.nombre = dr.GetString(2);
if (dr[3] != DBNull.Value)
t.fechaAlta = dr.GetDateTime(3);
if (dr[4] != DBNull.Value)
t.fechaBaja = dr.GetDateTime(4);
return t;
}
public static TDispositivo GetTDispositivo(int id, SqlCeConnection conn)
{
TDispositivo dispositivo = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = String.Format("SELECT * FROM Dispositivo WHERE dispositivo_id = {0}", id);
using (SqlCeDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
dispositivo = new TDispositivo();
dispositivo.DispositivoId = dr.GetInt32(0);
dispositivo.Nombre = dr.GetString(1);
dispositivo.Instalacion = GetTInstalacion(dr.GetInt32(3), conn);
dispositivo.Tipo = GetTTipoDispositivo(dr.GetInt32(4), conn);
dispositivo.Funcion = dr.GetString(5);
dispositivo.Estado = dr.GetString(6);
dispositivo.CodBarras = dr.GetString(7);
if (dr[14] != DBNull.Value)
{
dispositivo.Posicion = dr.GetString(14);
}
if (dr[8] != DBNull.Value)
{
dispositivo.FechaCaducidad = dr.GetDateTime(8);
}
dispositivo.Caducado = dr.GetBoolean(9);
if (dr[10] != DBNull.Value)
{
dispositivo.FechaBaja = dr.GetDateTime(10);
}
if (dr[11] != DBNull.Value)
{
dispositivo.Modelo = GetTModeloDispositivo(dr.GetInt32(11), conn);
}
dispositivo.Operativo = dr.GetBoolean(12);
dispositivo.Abm = dr.GetByte(15);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
}
return(dispositivo);
}
public IEnumerable <Scan> GetAllScans()
{
Scan scan = null;
string selectCommand = @" SELECT * FROM scan ";
using (SqlCeConnection connect = new SqlCeConnection(Datasource))
{
connect.Open();
using (SqlCeCommand command = new SqlCeCommand(selectCommand, connect))
{
using (SqlCeDataReader reader = command.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
yield return(new Scan((int)reader.GetInt32(reader.GetOrdinal("artcode")),
(int)reader.GetInt32(reader.GetOrdinal("id_gamma")),
(int)reader.GetInt32(reader.GetOrdinal("qty")))
{
Dt = reader.GetDateTime(reader.GetOrdinal("dt")),
StartDt = reader.GetString(reader.GetOrdinal("StartDt")),
EndDt = reader.GetString(reader.GetOrdinal("EndDt")),
});
}
}
}
}
}
}
public static Employee GetEmployee(int id)
{
string commandText =
"select ID, SURNAME, NAME, PATRONYMIC" +
", INN, PASSPORT, BIRTHDAY, JOB_POST" +
" from Employee where ID = @ID";
using (SqlCeConnection connection = new SqlCeConnection(GetConnectionString()))
{
connection.Open();
using (SqlCeCommand command = new SqlCeCommand(commandText, connection))
{
command.Parameters.Add("ID", System.Data.SqlDbType.Int).Value = id;
using (SqlCeDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
return(new Employee()
{
Id = reader.GetInt32(0),
Surname = reader.GetString(1),
Name = reader.GetString(2),
Patronymic = reader.GetString(3),
INN = reader.GetString(4),
Passport = reader.GetString(5),
Birthday = reader.GetDateTime(6),
JobPost = reader.GetString(7)
});
}
}
}
}
return(null);
}
public static IEnumerable <Employee> GetEmployees()
{
string commandText =
"select ID, SURNAME, NAME, PATRONYMIC" +
", INN, PASSPORT, BIRTHDAY, JOB_POST from Employee";
using (SqlCeConnection connection = new SqlCeConnection(GetConnectionString()))
{
connection.Open();
using (SqlCeCommand command = new SqlCeCommand(commandText, connection))
{
using (SqlCeDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
yield return(new Employee()
{
Id = reader.GetInt32(0),
Surname = reader.GetString(1),
Name = reader.GetString(2),
Patronymic = reader.GetString(3),
INN = reader.GetString(4),
Passport = reader.GetString(5),
Birthday = reader.GetDateTime(6),
JobPost = reader.GetString(7)
});
}
}
}
}
}
public static IList <TIncidenciaEvolucion> GetTIncidenciaEvolucions(SqlCeConnection conn)
{
List <TIncidenciaEvolucion> incidenciaEvolucions = new List <TIncidenciaEvolucion>();
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM IncidenciaEvolucion";
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TIncidenciaEvolucion tincidenciaEvolucion = new TIncidenciaEvolucion()
{
IncidenciaEvolucionId = dr.GetInt32(0),
Incidencia = GetTIncidencia(dr.GetInt32(1), conn),
FechaEvolucion = dr.GetDateTime(2),
Comentarios = dr.GetString(3),
Usuario = GetTUsuario(dr.GetInt32(4), conn),
Operativo = dr.GetBoolean(5),
Abm = dr.GetByte(6)
};
if (tincidenciaEvolucion != null)
{
incidenciaEvolucions.Add(tincidenciaEvolucion);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(incidenciaEvolucions);
}
public static TIncidenciaEvolucion GetTIncidenciaEvolucion(int id, SqlCeConnection conn)
{
TIncidenciaEvolucion incidenciaEvolucion = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM IncidenciaEvolucion WHERE incidencia_evolucion_id = {0}",
id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
incidenciaEvolucion = new TIncidenciaEvolucion()
{
IncidenciaEvolucionId = dr.GetInt32(0),
Operativo = dr.GetBoolean(5),
Usuario = GetTUsuario(dr.GetInt32(4), conn),
Incidencia = GetTIncidencia(dr.GetInt32(1), conn),
Comentarios = dr.GetString(3)
};
// control de nulos en fechas.
if (dr[2] != DBNull.Value)
{
incidenciaEvolucion.FechaEvolucion = dr.GetDateTime(2);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
}
// No profundizamos para evitar bucles.
return(incidenciaEvolucion);
}
protected virtual DateTime? ReadDateTimeOrNull(SqlCeDataReader reader, string columnName)
{
if (reader.IsDBNull(reader.GetOrdinal(columnName)))
return null;
return reader.GetDateTime(reader.GetOrdinal(columnName));
}
private void PopulateList()
{
String query = "SELECT * FROM " + db.TableName + " ORDER BY date DESC";
using (SqlCeConnection c = new SqlCeConnection(DataSource))
{
c.Open();
using (SqlCeCommand cmd = new SqlCeCommand(query, c))
{
using (SqlCeDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
String id = "" + reader.GetInt32(0);
String rupee = "" + reader.GetValue(1);
String dateTime = "" + reader.GetDateTime(2);
ListAdd(id, rupee, dateTime);
}
reader.Close();
}
}
c.Close();
}
}
public void Load()
{
var command = DataStore.Connection.CreateCommand();
SqlCeDataReader reader = null;
command.CommandText = "SELECT * FROM [reminders] ORDER BY [time]";
reader = command.ExecuteReader();
while (reader.Read())
{
Reminder rem = new Reminder(this);
rem.Name = reader.GetString("name");
rem.Text = reader.GetString("text");
rem.Time = reader.GetDateTime("time");
rem.Frequency = reader.GetEnum <Frequency>("frequency");
reminders.Add(rem);
rem.Init();
}
reader.Dispose();
command.Dispose();
}
private void populateControlsWithData(SqlCeDataReader reader)
{
int customerID = reader.GetInt32(reader.GetOrdinal("CustomerID"));
customerNameCombo.SelectedValue = customerID;
paymentDatePicker.Value = reader.GetDateTime(reader.GetOrdinal("PaymentDate"));
decimal amount = reader.GetDecimal(reader.GetOrdinal("Amount"));
amountField.Text = amount.ToString("N2");
string paymentMode = reader.GetString(reader.GetOrdinal("PaymentMode"));
switch (paymentMode)
{
case "C":
cashButton.Checked = true;
break;
case "Q":
chequeButton.Checked = true;
break;
case "D":
demandDraftButton.Checked = true;
break;
}
object value = reader.GetValue(reader.GetOrdinal("InstrumentNumber"));
if (value != DBNull.Value)
{
instrumentNumberField.Text = (string)value;
}
value = reader.GetValue(reader.GetOrdinal("Notes"));
if (value != DBNull.Value)
{
notesField.Text = (string)value;
}
string errorText;
decimal?balanceAmount = GlobalMethods.GetCustomerBalance(customerID,
out errorText);
if (!balanceAmount.HasValue)
{
string message = "An error occurred in fetching the customer's balance from the database."
+ "\nThe error text is as follows:\n" + errorText;
Cursor.Current = Cursors.Default;
SystemSounds.Exclamation.Play();
MessageBox.Show(message, "Error in Fetching Account Balance", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
return;
}
balanceAmount = balanceAmount.Value - amount;
balanceField.Text = GlobalMethods.GetBalanceAsString(balanceAmount.Value);
}
public Tuple <LinkedList <int>, LinkedList <String>, LinkedList <DateTime>, LinkedList <double> > scanValueForPatient(int ScanID)
{
LinkedList <int> scanID = new LinkedList <int>();
LinkedList <String> pointCloudFileReference = new LinkedList <String>();
LinkedList <DateTime> timestamp = new LinkedList <DateTime>();
LinkedList <double> value = new LinkedList <double>();
SqlCeCommand selectQuery = this.con.CreateCommand();
selectQuery.CommandText = "Select Scans.scanID, pointCloudFileReference, timestamp, Records.value from Scans join Records on Scans.scanID = Records.scanID where Scans.scanID = @ScanID;";
selectQuery.Parameters.Clear();
selectQuery.Parameters.Add("@ScanID", ScanID);
SqlCeDataReader reader = selectQuery.ExecuteReader();
while (reader.Read())
{
scanID.AddLast(reader.GetInt32(0));
pointCloudFileReference.AddLast(reader.GetString(1));
timestamp.AddLast(Convert.ToDateTime(reader.GetDateTime(2).ToString()));
value.AddLast(reader.GetDouble(3));
}
reader.Close();
return(Tuple.Create(scanID, pointCloudFileReference, timestamp, value));
}
public static IList <TPrograma> GetTProgramasC(int gtId, SqlCeConnection conn)
{
IList <TPrograma> l = new List <TPrograma>();
string sql = String.Format("SELECT DISTINCT p.programa_id, p.fecha_programada, u.nombre, p.estado, p.comentarios, i.nombre, p.abm FROM programa p LEFT JOIN USUARIO u ON u.usuario_id = p.usuario_id LEFT JOIN Revision r ON p.programa_id = r.programa_id LEFT JOIN Dispositivo d ON r.dispositivo_id = d.dispositivo_id LEFT JOIN Instalacion i ON d.instalacion = i.instalacion_id WHERE u.grupo_trabajo_id = {0} ORDER BY fecha_programada ASC", gtId);
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TPrograma tp = new TPrograma()
{
ProgramaId = dr.GetInt32(0),
FechaProgramada = dr.GetDateTime(1),
NUsuario = dr.GetString(2),
Estado = dr.GetString(3),
Comentarios = dr.GetString(4),
NInstalacion = dr.GetString(5),
Abm = dr.GetByte(6)
};
if (tp != null)
{
l.Add(tp);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(l);
}
public static TPrograma GetTPrograma(int id, SqlCeConnection conn)
{
TPrograma programa = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM Programa WHERE programa_id = {0}", id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
programa = new TPrograma()
{
ProgramaId = dr.GetInt32(0),
FechaProgramada = dr.GetDateTime(1),
Usuario = GetTUsuario(dr.GetInt32(2), conn),
Estado = dr.GetString(3),
Comentarios = dr.GetString(4),
Abm = dr.GetByte(5)
};
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(programa);
}
//table type 1 queries
//patient information
public Tuple <LinkedList <int>, LinkedList <String>, LinkedList <DateTime>, LinkedList <String>, LinkedList <String>, LinkedList <String> > PatientInformation(String colName, String criterion)
{
LinkedList <int> patientID = new LinkedList <int>();
LinkedList <String> name = new LinkedList <String>();
LinkedList <DateTime> dob = new LinkedList <DateTime>();
LinkedList <String> nationality = new LinkedList <String>();
LinkedList <String> nhsNo = new LinkedList <String>();
LinkedList <String> address = new LinkedList <String>();
SqlCeCommand selectQuery = this.con.CreateCommand();
selectQuery.CommandText = "SELECT * FROM PatientInformation WHERE @ColName LIKE @Criterion";
selectQuery.Parameters.Clear();
selectQuery.Parameters.Add("@ColName", colName);
selectQuery.Parameters.Add("@Criterion", criterion);
SqlCeDataReader reader = selectQuery.ExecuteReader();
while (reader.Read())
{
patientID.AddLast(reader.GetInt32(0));
name.AddLast(reader.GetString(1));
dob.AddLast(Convert.ToDateTime(reader.GetDateTime(2).ToString()));
nationality.AddLast(reader.GetString(3));
nhsNo.AddLast(reader.GetString(4));
address.AddLast(reader.GetString(5));
}
reader.Close();
return(Tuple.Create(patientID, name, dob, nationality, nhsNo, address));
}
public static TIncidenciaEvolucion GetTIncidenciaEvolucion(int id, SqlCeConnection conn)
{
TIncidenciaEvolucion tIncidenciaEvolucion = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM IncidenciaEvolucion WHERE incidencia_evolucion_id = {0} AND abm <> 2", id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
tIncidenciaEvolucion = new TIncidenciaEvolucion()
{
IncidenciaEvolucionId = dr.GetInt32(0),
Comentarios = dr.GetString(3),
Operativo = dr.GetBoolean(5),
Abm = dr.GetByte(6)
};
if (dr[2] != DBNull.Value)
{
tIncidenciaEvolucion.FechaEvolucion = dr.GetDateTime(2);
}
if (dr[4] != DBNull.Value)
{
tIncidenciaEvolucion.TUsuario = GetTUsuario(dr.GetInt32(4), conn);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(tIncidenciaEvolucion);
}
public static PTDate GetDateForDateTime(DateTime datetime)
{
SqlCeConnection connection = null;
PTDate date = new PTDate(0, default(DateTime));
bool success = false;
try
{
connection = Connection();
connection.Open();
var command = connection.CreateCommand();
command.CommandText = "SELECT * FROM Dates WHERE Date=@date";
command.Parameters.Add("@date", SqlDbType.DateTime).Value = datetime.Date;
SqlCeDataReader reader = command.ExecuteReader();
if (reader.Read())
{
date.index = reader.GetInt32(0);
date.date = reader.GetDateTime(1);
success = true;
}
}
finally
{
connection.Close();
}
if (!success)
{
InsertDate(datetime);
date = GetDateForDateTime(datetime);
}
return(date);
}
private static BSP_Ticket DataReaderAObjeto(SqlCeDataReader rdrLector)
{
BSP_Ticket oBSP_Ticket = new BSP_Ticket();
oBSP_Ticket.ID = rdrLector.GetInt64(rdrLector.GetOrdinal("ID"));
oBSP_Ticket.Billete = rdrLector.GetInt64(rdrLector.GetOrdinal("Billete"));
oBSP_Ticket.Tipo = rdrLector.GetString(rdrLector.GetOrdinal("Tipo"));
if (!rdrLector.IsDBNull(rdrLector.GetOrdinal("FechaVenta")))
{
oBSP_Ticket.FechaVenta = rdrLector.GetDateTime(rdrLector.GetOrdinal("FechaVenta"));
}
oBSP_Ticket.TarContado = rdrLector.GetDecimal(rdrLector.GetOrdinal("TarContado"));
oBSP_Ticket.TarCredito = rdrLector.GetDecimal(rdrLector.GetOrdinal("TarCredito"));
oBSP_Ticket.IVA105 = rdrLector.GetDecimal(rdrLector.GetOrdinal("IVA105"));
oBSP_Ticket.ComPorcentaje = rdrLector.GetDecimal(rdrLector.GetOrdinal("ComPorcentaje"));
oBSP_Ticket.ComValor = rdrLector.GetDecimal(rdrLector.GetOrdinal("ComValor"));
oBSP_Ticket.ComOver = rdrLector.GetDecimal(rdrLector.GetOrdinal("ComOver"));
oBSP_Ticket.ComIVA = rdrLector.GetDecimal(rdrLector.GetOrdinal("ComIVA"));
oBSP_Ticket.Total = rdrLector.GetDecimal(rdrLector.GetOrdinal("Total"));
oBSP_Ticket.Rg = rdrLector.GetBoolean(rdrLector.GetOrdinal("Rg")) ? BSP_Rg.Internacional : BSP_Rg.Doméstico;
oBSP_Ticket.Moneda = rdrLector.GetBoolean(rdrLector.GetOrdinal("Moneda")) ? Moneda.Dolar : Moneda.Peso;
oBSP_Ticket.Concepto = new Concepto {
ID = rdrLector.GetInt64(rdrLector.GetOrdinal("IdConcepto"))
};
oBSP_Ticket.Compania = new Compania {
ID = rdrLector.GetInt64(rdrLector.GetOrdinal("IdCompania"))
};
oBSP_Ticket.SemanaID = rdrLector.GetInt64(rdrLector.GetOrdinal("SemanaID"));
return(oBSP_Ticket);
}
//scans
public Tuple <LinkedList <int>, LinkedList <int>, LinkedList <String>, LinkedList <String>, LinkedList <DateTime> > Scans(String colName, String criterion)
{
LinkedList <int> scanID = new LinkedList <int>();
LinkedList <int> scanTypeID = new LinkedList <int>();
LinkedList <String> pointCloudFileReference = new LinkedList <String>();
LinkedList <String> description = new LinkedList <String>();
LinkedList <DateTime> timestamp = new LinkedList <DateTime>();
SqlCeCommand selectQuery = this.con.CreateCommand();
selectQuery.CommandText = "SELECT * FROM Scans WHERE @ColName LIKE @Criterion";
selectQuery.Parameters.Clear();
selectQuery.Parameters.Add("@ColName", colName);
selectQuery.Parameters.Add("@Criterion", criterion);
SqlCeDataReader reader = selectQuery.ExecuteReader();
while (reader.Read())
{
scanID.AddLast(reader.GetInt32(0));
scanTypeID.AddLast(reader.GetInt32(1));
pointCloudFileReference.AddLast(reader.GetString(2));
description.AddLast(reader.GetString(3));
timestamp.AddLast(Convert.ToDateTime(reader.GetDateTime(4).ToString()));
}
reader.Close();
return(Tuple.Create(scanID, scanTypeID, pointCloudFileReference, description, timestamp));
}
public static TPrograma GetTProgramaC(int id, SqlCeConnection conn)
{
TPrograma programa = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT p.programa_id, p.fecha_programada, u.nombre, p.estado, p.comentarios, p.abm FROM Programa p LEFT JOIN usuario u on p.usuario_id = u.usuario_id WHERE programa_id = {0}", id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
programa = new TPrograma()
{
ProgramaId = dr.GetInt32(0),
NUsuario = dr.GetString(2),
Estado = dr.GetString(3),
Comentarios = dr.GetString(4),
Abm = dr.GetByte(5)
};
if (dr[1] != DBNull.Value)
{
programa.FechaProgramada = dr.GetDateTime(1);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
// Ahora NO buscamos las revisiones asociadas para evitar bucles.
// o reducir el tiempo de carga
}
return(programa);
}
public static TDescargaLinea GetDescargaLineaFromDr(SqlCeDataReader dr)
{
TDescargaLinea dl = new TDescargaLinea();
dl.descargaLineaId = dr.GetInt32(0);
dl.descargaId = dr.GetInt32(1);
dl.tag = dr.GetString(2);
dl.fechaHora = dr.GetDateTime(3);
dl.tipo = dr.GetString(4);
dl.tipoId = dr.GetInt32(5);
dl.nombre = dr.GetString(6);
dl.incidenciaId = dr.GetInt32(7);
dl.observaciones = dr.GetString(8);
return dl;
}
public static TRonda GetRondaFromDr(SqlCeDataReader dr)
{
TRonda r = new TRonda();
bool primero = true;
while (dr.Read())
{
if (primero)
{
r.rondaId = dr.GetInt32(0);
r.nombre = dr.GetString(1);
r.tag = dr.GetString(2);
r.tagf = dr.GetString(3);
r.RondasPuntos = new List<TRondaPunto>();
primero = false;
}
TRondaPunto rp = new TRondaPunto();
TPunto p = new TPunto();
TEdificio e = new TEdificio();
TGrupo g = new TGrupo();
rp.rondaPuntoId = dr.GetInt32(4);
rp.orden = dr.GetInt32(5);
p.puntoId = dr.GetInt32(6);
p.nombre = dr.GetString(7);
e.edificioId = dr.GetInt32(8);
p.tag = dr.GetString(9);
e.nombre = dr.GetString(10);
g.grupoId = dr.GetInt32(11);
g.nombre = dr.GetString(12);
p.cota = dr.GetString(13);
p.cubiculo = dr.GetString(14);
r.mintime = dr.GetInt32(15);
r.maxtime = dr.GetInt32(16);
p.csnmax = dr.GetInt32(17);
p.csnmargen = dr.GetInt32(18);
p.lastcontrol = dr.GetDateTime(19);
e.Grupo = g;
p.Edificio = e;
rp.Punto = p;
rp.Ronda = r;
r.RondasPuntos.Add(rp);
}
return r;
}
public static TPunto GetPuntoFromDr(SqlCeDataReader dr)
{
TGrupo g = new TGrupo();
TEdificio e = new TEdificio();
TPunto p = new TPunto();
p.puntoId = dr.GetInt32(0);
p.nombre = dr.GetString(1);
e.edificioId = dr.GetInt32(2);
p.tag = dr.GetString(3);
p.cota = dr.GetString(4);
p.cubiculo = dr.GetString(5);
p.observaciones = dr.GetString(6);
e.nombre = dr.GetString(7);
g.grupoId = dr.GetInt32(8);
g.nombre = dr.GetString(9);
p.csnmax = dr.GetInt32(10);
p.csnmargen = dr.GetInt32(11);
p.lastcontrol = dr.GetDateTime(12);
return p;
}
static FS2JournalItem ReadOneJournalItem(SqlCeDataReader reader)
{
var journalItem = new FS2JournalItem();
if (!reader.IsDBNull(reader.GetOrdinal("Id")))
journalItem.No = reader.GetInt32(reader.GetOrdinal("Id"));
if (!reader.IsDBNull(reader.GetOrdinal("SystemTime")))
journalItem.SystemTime = reader.GetDateTime(reader.GetOrdinal("SystemTime"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceTime")))
journalItem.DeviceTime = reader.GetDateTime(reader.GetOrdinal("DeviceTime"));
if (!reader.IsDBNull(reader.GetOrdinal("Description")))
journalItem.Description = reader.GetString(reader.GetOrdinal("Description"));
if (!reader.IsDBNull(reader.GetOrdinal("Detalization")))
journalItem.Detalization = reader.GetString(reader.GetOrdinal("Detalization"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceName")))
journalItem.DeviceName = reader.GetString(reader.GetOrdinal("DeviceName"));
if (!reader.IsDBNull(reader.GetOrdinal("PanelName")))
journalItem.PanelName = reader.GetString(reader.GetOrdinal("PanelName"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceUID")))
journalItem.DeviceUID = reader.GetGuid(reader.GetOrdinal("DeviceUID"));
if (!reader.IsDBNull(reader.GetOrdinal("PanelUID")))
journalItem.PanelUID = reader.GetGuid(reader.GetOrdinal("PanelUID"));
if (!reader.IsDBNull(reader.GetOrdinal("ZoneName")))
journalItem.ZoneName = reader.GetString(reader.GetOrdinal("ZoneName"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceCategory")))
journalItem.DeviceCategory = reader.GetInt32(reader.GetOrdinal("DeviceCategory"));
if (!reader.IsDBNull(reader.GetOrdinal("StateType")))
journalItem.StateType = (StateType)reader.GetInt32(reader.GetOrdinal("StateType"));
if (!reader.IsDBNull(reader.GetOrdinal("SubsystemType")))
journalItem.SubsystemType = (SubsystemType)reader.GetInt32(reader.GetOrdinal("SubsystemType"));
if (!reader.IsDBNull(reader.GetOrdinal("UserName")))
journalItem.UserName = reader.GetString(reader.GetOrdinal("UserName"));
return journalItem;
}
static JournalItem ReadOneJournalItem(SqlCeDataReader reader)
{
var journalItem = new JournalItem();
if (!reader.IsDBNull(reader.GetOrdinal("JournalItemType")))
journalItem.JournalItemType = (JournalItemType)reader.GetByte(reader.GetOrdinal("JournalItemType"));
if (!reader.IsDBNull(reader.GetOrdinal("SystemDateTime")))
journalItem.SystemDateTime = reader.GetDateTime(reader.GetOrdinal("SystemDateTime"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceDateTime")))
journalItem.DeviceDateTime = reader.GetDateTime(reader.GetOrdinal("DeviceDateTime"));
if (!reader.IsDBNull(reader.GetOrdinal("ObjectUID")))
journalItem.ObjectUID = reader.GetGuid(reader.GetOrdinal("ObjectUID"));
if (!reader.IsDBNull(reader.GetOrdinal("Name")))
journalItem.Name = reader.GetString(reader.GetOrdinal("Name"));
if (!reader.IsDBNull(reader.GetOrdinal("Description")))
journalItem.Description = reader.GetString(reader.GetOrdinal("Description"));
if (!reader.IsDBNull(reader.GetOrdinal("ObjectState")))
journalItem.ObjectState = reader.GetInt32(reader.GetOrdinal("ObjectState"));
if (!reader.IsDBNull(reader.GetOrdinal("GKObjectNo")))
journalItem.GKObjectNo = (ushort)reader.GetInt16(reader.GetOrdinal("GKObjectNo"));
if (!reader.IsDBNull(reader.GetOrdinal("GKIpAddress")))
journalItem.GKIpAddress = reader.GetString(reader.GetOrdinal("GKIpAddress"));
if (!reader.IsDBNull(reader.GetOrdinal("GKJournalRecordNo")))
journalItem.GKJournalRecordNo = reader.GetInt32(reader.GetOrdinal("GKJournalRecordNo"));
if (!reader.IsDBNull(reader.GetOrdinal("KAUNo")))
journalItem.ControllerAddress = (ushort)reader.GetInt32(reader.GetOrdinal("KAUNo"));
if (!reader.IsDBNull(reader.GetOrdinal("StateClass")))
journalItem.StateClass = (XStateClass)reader.GetByte(reader.GetOrdinal("StateClass"));
if (!reader.IsDBNull(reader.GetOrdinal("UserName")))
journalItem.UserName = reader.GetString(reader.GetOrdinal("UserName"));
if (!reader.IsDBNull(reader.GetOrdinal("ObjectStateClass")))
journalItem.ObjectStateClass = (XStateClass)reader.GetByte(reader.GetOrdinal("ObjectStateClass"));
if (!reader.IsDBNull(reader.GetOrdinal("ObjectName")))
journalItem.ObjectName = reader.GetString(reader.GetOrdinal("ObjectName"));
if (!reader.IsDBNull(reader.GetOrdinal("AdditionalDescription")))
journalItem.AdditionalDescription = reader.GetString(reader.GetOrdinal("AdditionalDescription"));
if (!reader.IsDBNull(reader.GetOrdinal("Subsystem")))
journalItem.SubsystemType = (XSubsystemType)reader.GetByte(reader.GetOrdinal("Subsystem"));
return journalItem;
}
private object DataReaderToObject(SqlCeDataReader reader, EntityType entity)
{
object entityObject = null;
switch (entity)
{
case EntityType.Processor:
entityObject = new EntProcessor();
break;
case EntityType.OS:
entityObject = new EntOS();
break;
case EntityType.Bios:
entityObject = new EntBios();
break;
case EntityType.MotherBoard:
entityObject = new EntMotherBoard();
break;
case EntityType.Disk:
entityObject = new EntDisk();
break;
case EntityType.Memory:
entityObject = new EntMemory();
break;
case EntityType.LogicalDrive:
entityObject = new EntLogicalDrive();
break;
case EntityType.CDRom:
entityObject = new EntCDRom();
break;
case EntityType.Video:
entityObject = new EntVideo();
break;
case EntityType.Multimedia:
entityObject = new EntMultimedia();
break;
case EntityType.Monitor:
entityObject = new EntMonitor();
break;
case EntityType.Share:
entityObject = new EntShare();
break;
case EntityType.StartUp:
entityObject = new EntStartUp();
break;
case EntityType.Hotfix:
entityObject = new EntHotfixes();
break;
case EntityType.Processes:
entityObject = new EntProcesses();
break;
case EntityType.Softwares:
entityObject = new EntSoftwares();
break;
case EntityType.Services:
entityObject = new EntServices();
break;
case EntityType.IPRoutes:
entityObject = new EntIPRoutes();
break;
case EntityType.EnvironmentVar:
entityObject = new EntEnvironmentVars();
break;
case EntityType.Computer:
entityObject = new EntComputer();
break;
case EntityType.Printer:
entityObject = new EntPrinter();
break;
case EntityType.UserGroup:
entityObject = new EntUserGroups();
break;
case EntityType.NetworkAdapter:
entityObject = new EntNetworkAdapter();
break;
}
Type t = entityObject.GetType();
PropertyInfo[] pi = t.GetProperties();
foreach (PropertyInfo prop in pi)
{
if (prop.Name == "ClassName" || prop.Name == "Icon" || prop.Name == "NodeName")
continue;
switch (prop.PropertyType.Name)
{
case "String":
string strValue = reader.GetString(reader.GetOrdinal(prop.Name));
prop.SetValue(entityObject, strValue, null);
break;
case "Int32":
int intValue = reader.GetInt32(reader.GetOrdinal(prop.Name));
prop.SetValue(entityObject, intValue, null);
break;
case "Double":
double dValue = reader.GetDouble(reader.GetOrdinal(prop.Name));
prop.SetValue(entityObject, dValue, null);
break;
case "DateTime":
DateTime dtValue = DateTime.MinValue;
if ( reader.GetValue(reader.GetOrdinal(prop.Name))== DBNull.Value)
{
dtValue = DateTime.MinValue;
}
else
{
dtValue = reader.GetDateTime(reader.GetOrdinal(prop.Name));
}
prop.SetValue(entityObject, dtValue, null);
break;
case "Boolean":
bool bValue = reader.GetBoolean(reader.GetOrdinal(prop.Name));
prop.SetValue(entityObject, bValue, null);
break;
}
}
return entityObject;
}
//
// GetUserFromReader
// A helper function that takes the current row from the SqlCeDataReader
// and hydrates a MembershipUser from the values. Called by the
// MembershipUser.GetUser implementation.
//
private MembershipUser GetUserFromReader(SqlCeDataReader reader)
{
if (string.IsNullOrWhiteSpace(reader.GetString(1))) return null;
object providerUserKey = null;
string strGooid = Guid.NewGuid().ToString();
if (reader.GetValue(0).ToString().Length > 0)
providerUserKey = new Guid(reader.GetValue(0).ToString());
else
providerUserKey = new Guid(strGooid);
string username = reader.GetString(1);
string email = reader.GetString(2);
string passwordQuestion = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
string comment = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
bool isApproved = reader.IsDBNull(5) ? false : reader.GetBoolean(5);
bool isLockedOut = reader.IsDBNull(6) ? false : reader.GetBoolean(6);
DateTime creationDate = reader.IsDBNull(7) ? DateTime.UtcNow : reader.GetDateTime(7);
DateTime lastLoginDate = reader.IsDBNull(8) ? DateTime.UtcNow : reader.GetDateTime(8);
DateTime lastActivityDate = reader.IsDBNull(9) ? DateTime.UtcNow : reader.GetDateTime(9);
DateTime lastPasswordChangedDate = reader.IsDBNull(10) ? DateTime.UtcNow : reader.GetDateTime(10);
DateTime lastLockedOutDate = reader.IsDBNull(11) ? DateTime.UtcNow : reader.GetDateTime(11);
MembershipUser u = new MembershipUser(this.Name,
username,
providerUserKey,
email,
passwordQuestion,
comment,
isApproved,
isLockedOut,
creationDate,
lastLoginDate,
lastActivityDate,
lastPasswordChangedDate,
lastLockedOutDate);
return u;
}
private DailyUsageBO ReadRecord(SqlCeDataReader reader)
{
DailyUsageBO result = new DailyUsageBO();
result.Day = reader.GetDateTime(0);
result.Month = reader.GetString(1);
result.Upload = reader.GetDouble(2);
result.Download = reader.GetDouble(3);
result.Total = reader.GetDouble(4);
if (!reader.IsDBNull(5))
result.Period = new Period(reader.GetString(5));
return result;
}
private EntScan DataReaderToObject(SqlCeDataReader reader)
{
EntScan scan = new EntScan();
scan.MachineID = reader.GetInt32(reader.GetOrdinal("MachineID"));
scan.ScanID = reader.GetInt32(reader.GetOrdinal("ScanID"));
scan.Date = reader.GetDateTime(reader.GetOrdinal("ScanDate"));
return scan;
}
private EntDiscover DataReaderToObject(SqlCeDataReader reader)
{
EntDiscover machine = new EntDiscover();
machine.MachineID = reader.GetInt32(reader.GetOrdinal("MachineID"));
machine.IPAddr = reader.GetString(reader.GetOrdinal("IPAddress"));
machine.LastChecked = reader.GetDateTime(reader.GetOrdinal("LastChecked"));
machine.Discovered = reader.GetBoolean(reader.GetOrdinal("Discovered"));
machine.StatusMessage = reader.GetString(reader.GetOrdinal("StatusMessage"));
machine.DomainName = reader.GetString(reader.GetOrdinal("DomainName"));
machine.MachineName = reader.GetString(reader.GetOrdinal("MachineName"));
machine.CredentialID = reader.GetInt32(reader.GetOrdinal("CredentialID"));
return machine;
}
// Loads member data
public void LoadMember(SqlCeDataReader reader)
{
//MemberID = Int32.Parse(reader["Id"].ToString());
MemberID = reader.GetInt32(0);
if (!reader.IsDBNull(1))
{
CardNumber = reader.GetInt32(1);
}
LName = reader["LastName"].ToString();
FName = reader["FirstName"].ToString();
Sex = reader["Sex"].ToString();
if (!reader.IsDBNull(4))
{
DateOfBirth = reader.GetDateTime(4);
}
Street = reader["Street"].ToString();
Suburb = reader["Suburb"].ToString();
City = reader["City"].ToString();
if (!reader.IsDBNull(9))
{
PostalCode = reader.GetInt32(9);
}
HomePhone = reader["HomePhone"].ToString();
CellPhone = reader["CellPhone"].ToString();
Email = reader["email"].ToString();
Occupation = reader["Occupation"].ToString();
if (!reader.IsDBNull(16))
{
PersonalTrainer = reader.GetInt32(16);
}
//PersonalTrainer = reader["PersonalTrainer"].ToString();
Notes = reader["Notes"].ToString();
if (!reader.IsDBNull(15))
{
Image = (byte[])reader["Image"];
}
}
static JournalRecord ReadOneJournalRecord(SqlCeDataReader reader)
{
var journalRecord = new JournalRecord();
if (!reader.IsDBNull(reader.GetOrdinal("Description")))
journalRecord.Description = reader.GetString(reader.GetOrdinal("Description"));
if (!reader.IsDBNull(reader.GetOrdinal("Detalization")))
journalRecord.Detalization = reader.GetString(reader.GetOrdinal("Detalization"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceCategory")))
journalRecord.DeviceCategory = reader.GetInt32(reader.GetOrdinal("DeviceCategory"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceDatabaseId")))
journalRecord.DeviceDatabaseId = reader.GetString(reader.GetOrdinal("DeviceDatabaseId"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceName")))
journalRecord.DeviceName = reader.GetString(reader.GetOrdinal("DeviceName"));
if (!reader.IsDBNull(reader.GetOrdinal("DeviceTime")))
journalRecord.DeviceTime = reader.GetDateTime(reader.GetOrdinal("DeviceTime"));
if (!reader.IsDBNull(reader.GetOrdinal("OldId")))
journalRecord.OldId = reader.GetInt32(reader.GetOrdinal("OldId"));
if (!reader.IsDBNull(reader.GetOrdinal("PanelDatabaseId")))
journalRecord.PanelDatabaseId = reader.GetString(reader.GetOrdinal("PanelDatabaseId"));
if (!reader.IsDBNull(reader.GetOrdinal("PanelName")))
journalRecord.PanelName = reader.GetString(reader.GetOrdinal("PanelName"));
if (!reader.IsDBNull(reader.GetOrdinal("StateType")))
journalRecord.StateType = (StateType)reader.GetInt32(reader.GetOrdinal("StateType"));
if (!reader.IsDBNull(reader.GetOrdinal("SubsystemType")))
journalRecord.SubsystemType = (SubsystemType)reader.GetInt32(reader.GetOrdinal("SubsystemType"));
if (!reader.IsDBNull(reader.GetOrdinal("SystemTime")))
journalRecord.SystemTime = reader.GetDateTime(reader.GetOrdinal("SystemTime"));
if (!reader.IsDBNull(reader.GetOrdinal("UserName")))
journalRecord.User = reader.GetString(reader.GetOrdinal("UserName"));
if (!reader.IsDBNull(reader.GetOrdinal("ZoneName")))
journalRecord.ZoneName = reader.GetString(reader.GetOrdinal("ZoneName"));
if (!reader.IsDBNull(reader.GetOrdinal("Id")))
journalRecord.No = reader.GetInt32(reader.GetOrdinal("Id"));
return journalRecord;
}
