public static Prestamo ObtenerID()
{
Prestamo prestamo = new Prestamo();
SqlCommand cmd = null;
SqlDataReader dr = null;
string query = @"SELECT max(idPrestamo) as IdPrestamo FROM Prestamo";
try
{
cmd = OperacionesSQL.CreateBasicCommand(query);
dr = OperacionesSQL.ExecuteDataReaderCommand(cmd);
while (dr.Read())
{
prestamo = new Prestamo()
{
IdPrestamo = dr.GetInt32(0)
};
}
}
catch (Exception ex)
{
//Operaciones.WriteLogsRelease("LibroDal", "Obtenet(Get)", string.Format("{0} {1} Error: {2}", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), ex.Message));
throw ex;
}
finally
{
cmd.Connection.Close();
}
return(prestamo);
}
/// <summary>
/// Metodo para obtener un empleado
/// </summary>
/// <param name="id">Identificado del empleado </param>
/// <returns>Empleado</returns>
public static Prestamo Obtener(int id)
{
Prestamo prestamo = new Prestamo();
SqlCommand cmd = null;
SqlDataReader dr = null;
string query = @"select * from Prestamo
where idPrestamo= @id";
try
{
cmd = OperacionesSQL.CreateBasicCommand(query);
cmd.Parameters.AddWithValue("@id", id);
dr = OperacionesSQL.ExecuteDataReaderCommand(cmd);
while (dr.Read())
{
prestamo = new Prestamo()
{
IdPrestamo = dr.GetInt32(0),
FechaPrestamo = dr.GetDateTime(2),
FechaDevolucion = dr.GetDateTime(5),
Reserva = dr.GetInt32(4),
//Fecha_hora_reserva = dr.GetDateTime(4),
//Multas = dr.GetInt32(5),
//Monto_multas = dr.GetInt32(6),
IdUsuario = dr.GetInt16(1),
IdLibro = dr.GetInt32(3)
};
}
}
catch (Exception ex)
{
//Operaciones.WriteLogsRelease("PersonaDal", "Obtenet(Get)", string.Format("{0} {1} Error: {2}", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), ex.Message));
throw ex;
}
finally
{
cmd.Connection.Close();
}
return(prestamo);
}