public object FindAll()
{
string query = "SELECT id FROM venta ORDER BY id DESC LIMIT 1";
int ventaId = 0;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
ventaId = Convert.ToInt32(reader["id"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(ventaId);
}
public object UltimoPago(int id)
{
var pagar = new UltimoPagoViewModels();
string query = "SELECT A.saldo_anterior, A.saldo_actual, A.monto, A.fecha_pagar, A.fecha_cancelada, A.venta_id, B.cuota FROM pagos A"
+ " INNER JOIN finan_venta B ON A.venta_id = B.venta_id WHERE A.venta_id = @id ORDER BY A.id DESC LIMIT 1";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
pagar.Saldo_Anterior = Convert.ToDouble(reader["saldo_anterior"]);
pagar.Saldo_Actual = Convert.ToDouble(reader["saldo_actual"]);
pagar.Monto = Convert.ToDouble(reader["monto"]);
pagar.Fecha_Pagar = Convert.ToDateTime(reader["fecha_pagar"]);
pagar.Fecha_Cancelada = Convert.ToDateTime(reader["fecha_cancelada"]);
pagar.Venta_id = Convert.ToInt16(reader["venta_id"]);
pagar.Cuota = Convert.ToDouble(reader["cuota"]);
}
}
}
}
return(pagar);
}
public object FindForId(int id)
{
var lotestado = new EstadoLoteViewModels();
string query = " SELECT id, estado FROM estado_lote WHERE id= " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try {
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lotestado.id = Convert.ToInt32(reader["id"]);
lotestado.estado = Convert.ToString(reader["estado"]);
}
}
} catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lotestado);
//asdf
}
public object FindForId(int id)
{
var listaMoras = new List <MoraViewModels>();
string query = "SELECT monto, fecha, estado FROM moras WHERE venta_id = @id";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
listaMoras.Add(new MoraViewModels()
{
Monto = Convert.ToDouble(reader["monto"]),
Fecha = Convert.ToDateTime(reader["fecha"]),
Estado = Convert.ToInt16(reader["estado"])
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(listaMoras);
}
public object FindForId(int id)
{
var gastos = new GastosViewModels();
string query = "SELECT id, fecha, cantidad, descripcion, id_lotifi, id_empleado FROM gastos WHERE id = @id";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Parameters.AddWithValue("@id", id);
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
gastos.id = Convert.ToInt16(reader["id"]);
gastos.fecha = Convert.ToDateTime(reader["fecha"]);
gastos.cantidad = Convert.ToDouble(reader["cantidad"]);
gastos.descripcion = reader["descripcion"].ToString();
gastos.lotificadora_id = Convert.ToInt16(reader["id_lotifi"]);
gastos.empleado_id = Convert.ToInt16(reader["id_empleado"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(gastos);
}
private DateTime FechaUltimaMora(int id)
{
DateTime fechaUltimaMora = new DateTime();
string query = "SELECT fecha FROM moras WHERE venta_id = @venta_id" +
" ORDER BY fecha DESC LIMIT 1";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Parameters.AddWithValue("@venta_id", id);
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
fechaUltimaMora = Convert.ToDateTime(reader["fecha"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
}
return(fechaUltimaMora);
}
public object FindForId(int id)
{
var pagar = new List <ClientesPagarViewModels>();
string query = "SELECT a.nombre, a.apellido, b.id FROM Cliente a, Venta b WHERE a.id = b.cliente_id AND a.id = @id";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
pagar.Add(new ClientesPagarViewModels()
{
nombre = Convert.ToString(reader["nombre"]),
apellido = Convert.ToString(reader["apellido"]),
idventa = Convert.ToInt32(reader["id"])
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(pagar);
}
public object FindForId(int id)
{
var estado = new EstadoEmpViewModels();
string query = "SELECT id, estadoemp FROM estadoemp WHERE id = " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
estado.id = Convert.ToInt16(reader["id"]);
estado.nestado = reader["estadoemp"].ToString();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(estado);
}
public object FindForId(int id)
{
string query = "SELECT cuota FROM finan_venta WHERE venta_id = @id";
double cuota = 0;
using (var connection = PostConnection.Connection())
{
using (var command = _database.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
using (var reader = command.ExecuteReader())
{
cuota = Convert.ToDouble(reader["cuota"]);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(cuota);
}
public object FindForId(int id)
{
var lotificadora = new LotificadoraViewModels();
string query = "SELECT id, nombre, direccion, telefono, tasa_interes, tasa_mora FROM lotificadora WHERE id = " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lotificadora.id = Convert.ToInt16(reader["id"]);
lotificadora.nombre = reader["nombre"].ToString();
lotificadora.direccion = reader["direccion"].ToString();
lotificadora.telefono = Convert.ToInt32(reader["telefono"]);
lotificadora.tasa_interes = Convert.ToDouble(reader["tasa_interes"]);
lotificadora.tasa_mora = Convert.ToDouble(reader["tasa_mora"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lotificadora);
}
public object FindAll()
{
var lista = new List <ManzanaLoteViewModels>();
string query = "SELECT id, manzana FROM manzana";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new ManzanaLoteViewModels()
{
id = Convert.ToInt32(reader["id"]),
manzana = reader["manzana"].ToString(),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}
// public int Delete(int id)
public object FindAll()
{
var lista = new List <CargoEmpViewModels>();
string query = "SELECT id, nombrecargo, sueldo FROM cargo";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new CargoEmpViewModels()
{
id = Convert.ToInt16(reader["id"]),
nombrecargo = reader["nombrecargo"].ToString(),
sueldo = Convert.ToDouble(reader["sueldo"]),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}
public object FindForId(int id)
{
var cargo = new CargoEmpViewModels();
string query = "SELECT id, nombrecargo, sueldo FROM cargo WHERE id = " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
cargo.id = Convert.ToInt16(reader["id"]);
cargo.nombrecargo = reader["nombrecargo"].ToString();
cargo.sueldo = Convert.ToDouble(reader["sueldo"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(cargo);
}
public object FindForId(int id)
{
var lotemanzana = new ManzanaLoteViewModels();
string query = " SELECT id, manzana FROM manzana WHERE id = " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lotemanzana.id = Convert.ToInt32(reader["id"]);
lotemanzana.manzana = reader["manzana"].ToString();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lotemanzana);
}
public object FindAll()
{
string query = "SELECT id, descripcion FROM tipo_venta";
var tipo_venta = new List <TipoVentaViewModels>();
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
tipo_venta.Add(new TipoVentaViewModels()
{
Id = Convert.ToInt16(reader["id"]),
Descripcion = reader["descripcion"].ToString(),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(tipo_venta);
}
public object FindAll()
{
var lista = new List <EstadoCliViewModels>();
string query = "SELECT id, estado FROM estado_cliente";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new EstadoCliViewModels()
{
id = Convert.ToInt16(reader["id"]),
estado = reader["estado"].ToString(),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}
public object FindForId(int id)
{
var referenciaemp = new ReferenciaEmpViewModels();
string query = "SELECT id, nombre, apellido, telefono, direccion, id_emp FROM referenciaemp WHERE id = " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
referenciaemp.id = Convert.ToInt16(reader["id"]);
referenciaemp.nombre = reader["nombre"].ToString();
referenciaemp.apellido = reader["apellido"].ToString();
referenciaemp.tel = Convert.ToInt32(reader["telefono"]);
referenciaemp.direccion = reader["direccion"].ToString();
referenciaemp.id_emp = Convert.ToInt16(reader["id_emp"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(referenciaemp);
}
public object FindAll()
{
var lista = new List <LoteViewModels>();
string query = "select id, numero, largo, ancho, mts_cuadrados, precio, manzana, lotificadora, estado from viewlote";
// string query = "SELECT no_lote, largo, ancho, mts_cuadrados, precio_lote, manzana_id, lotificadora_id, estado_id from lote ";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new LoteViewModels()
{
id = Convert.ToInt32(reader["id"]),
numero = Convert.ToInt32(reader["numero"]),
largo = Convert.ToDouble(reader["largo"]),
ancho = Convert.ToDouble(reader["ancho"]),
mts_cuadrados = Convert.ToDouble(reader["mts_cuadrados"]),
precio = Convert.ToDouble(reader["precio"]),
manzana = Convert.ToString(reader["manzana"]),
lotificadora = Convert.ToString(reader["lotificadora"]),
estado = Convert.ToString(reader["estado"]),
// @no_lote,@largo,@ancho,@mts_cuadrados,@precio_lote,@manzana_id,@interes_id,@estado_id
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}
public object FindAll()
{
var lista = new List <EmpleadosIngresoViewModels>();
string query = "SELECT id, nombre, apellido, dpi, telefono, sexo, fecha_nac, direccion, id_cargo, id_estadoemp FROM empleados";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new EmpleadosIngresoViewModels()
{
id = Convert.ToInt16(reader["id"]),
nombre_e = reader["nombre"].ToString(),
apellido_e = reader["apellido"].ToString(),
dpi_e = Convert.ToInt64(reader["dpi"]),
tel_e = Convert.ToInt32(reader["telefono"]),
sexo_e = Convert.ToInt16(reader["sexo"]),
fecha_nac_e = Convert.ToDateTime(reader["fecha_nac"]),
dire_e = reader["direccion"].ToString(),
cargo_e = Convert.ToInt16(reader["id_cargo"]),
estado_e = Convert.ToInt16(reader["id_estadoemp"]),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}
public object FindAll()
{
var lista = new List <ClienteInsertViewModels>();
string query = "SELECT id, nombre, apellido, dpi, telefono, fecha,sexo, direccion, estado_id FROM Cliente";
using (var conection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
conection.Open();
command.Connection = conection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new ClienteInsertViewModels()
{
id = Convert.ToInt32(reader["id"]),
nombre = Convert.ToString(reader["nombre"]),
apellido = Convert.ToString(reader["apellido"]),
dpi = Convert.ToString(reader["dpi"]),
telefono = Convert.ToString(reader["telefono"]),
fecha = Convert.ToDateTime(reader["fecha"]),
sexo = Convert.ToString(reader["sexo"]),
direccion = Convert.ToString(reader["direccion"]),
estado = Convert.ToInt32(reader["estado_id"]),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}
public object FindAll()
{
var lista = new List <BeneficiarioViewModels>();
string query = " select id, nombre, apellido, dpi, telefono, direccion, sexo, id_cliente from beneficiario ";
using (var conection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
conection.Open();
command.Connection = conection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new BeneficiarioViewModels()
{
Id = Convert.ToInt32(reader["id"]),
Nombre = reader["nombre"].ToString(),
Apellido = reader["apellido"].ToString(),
Dpi = reader["dpi"].ToString(),
Telefono = Convert.ToInt32(reader["telefono"]),
Direccion = reader["direccion"].ToString(),
Sexo = reader["sexo"].ToString(),
ClienteId = Convert.ToInt32(reader["id_cliente"]),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}
public object FindForId(int id)
{
var lotify = new LoteIngresoViewModels();
string query = "SELECT id, no_lote, largo, ancho, mts_cuadrados, precio_lote, manzana_id, lotificadora_id, estado_id FROM lote WHERE id = @id";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lotify.id = Convert.ToInt32(reader["id"]);
lotify.numero = Convert.ToInt32(reader["no_lote"]);
lotify.largo = Convert.ToDouble(reader["largo"]);
lotify.ancho = Convert.ToDouble(reader["ancho"]);
lotify.mts_cuadrados = Convert.ToDouble(reader["mts_cuadrados"]);
lotify.precio_lote = Convert.ToDouble(reader["precio_lote"]);
lotify.manzana_id = Convert.ToInt32(reader["manzana_id"]);
lotify.lotificadora_id = Convert.ToInt32(reader["lotificadora_id"]);
lotify.estado_id = Convert.ToInt32(reader["estado_id"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lotify);
}
public object FindAll()
{
var promociones = new List <PromocionViewModels>();
string query = "SELECT id, cantidad, descripcion, fecha_inicio, fecha_fin, loti_id " +
"FROM promociones WHERE now() <= fecha_fin+1";
//select* from promociones WHERE loti_id = 1 AND(now() BETWEEN fecha_inicio AND fecha_fin + 1
using (var connection = PostConnection.Connection())
{
using (var command = _database.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
promociones.Add(new PromocionViewModels()
{
Id = Convert.ToInt16(reader["id"]),
Cantidad = Convert.ToDouble(reader["cantidad"]),
Descripcion = reader["descripcion"].ToString(),
FechaInicio = Convert.ToDateTime(reader["fecha_inicio"]),
FechaFin = Convert.ToDateTime(reader["fecha_fin"]),
LotificadoraId = Convert.ToInt16(reader["loti_id"])
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(promociones);
}
public object FindAll()
{
var lista = new List <VistaGastoViewModels>();
string query = "SELECT id, fecha, cantidad, descripcion, lotificadora, nombre, apellido FROM viewgastos";
//string query = "SELECT id, fecha, cantidad, descripcion, id_lotifi, id_empleado FROM gastos";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new VistaGastoViewModels()
{
id = Convert.ToInt16(reader["id"]),
Fecha = Convert.ToDateTime(reader["fecha"]),
cantidad = Convert.ToDouble(reader["cantidad"]),
descripcion = reader["descripcion"].ToString(),
lotificadora = reader["lotificadora"].ToString(),
nombre = reader["nombre"].ToString(),
apellido = reader["apellido"].ToString(),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}
public object FindForId(int id)
{
var empleado = new EmpleadosIngresoViewModels();
string query = "SELECT id, nombre, apellido, dpi, telefono, sexo, fecha_nac, direccion, id_cargo, id_estadoemp FROM empleados WHERE id = " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@idemp", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
empleado.id = Convert.ToInt16(reader["id"]);
empleado.nombre_e = reader["nombre"].ToString();
empleado.apellido_e = reader["apellido"].ToString();
empleado.dpi_e = Convert.ToInt64(reader["dpi"]);
empleado.tel_e = Convert.ToInt32(reader["telefono"]);
empleado.sexo_e = Convert.ToInt16(reader["sexo"]);
empleado.fecha_nac_e = Convert.ToDateTime(reader["fecha_nac"]);
empleado.dire_e = reader["direccion"].ToString();
empleado.cargo_e = Convert.ToInt16(reader["id_cargo"]);
empleado.estado_e = Convert.ToInt16(reader["id_estadoemp"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(empleado);
}
public object FindForId(int id)
{
var listaMoras = new List <PagosSelectViewModels>();
string query = "SELECT saldo_anterior, saldo_actual, monto, fecha_a_pagar, fecha_cancelada " +
"FROM pagos WHERE venta_id = @id";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
listaMoras.Add(new PagosSelectViewModels()
{
SaldoAnterior = Convert.ToDouble(reader["saldo_anterior"]),
SaldoActual = Convert.ToDouble(reader["saldo_actual"]),
Monto = Convert.ToDouble(reader["monto"]),
FechaPagar = Convert.ToDateTime(reader["fecha_a_pagar"]),
FechaCancelada = Convert.ToDateTime(reader["fecha_cancelada"])
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(listaMoras);
}
public object FindForId(int id)
{
var cliente = new ClienteInsertViewModels();
string query = "SELECT id, nombre, apellido, dpi, telefono, fecha,sexo, direccion, estado_id FROM cliente WHERE id= " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
cliente.id = Convert.ToInt32(reader["id"]);
cliente.nombre = Convert.ToString(reader["nombre"]);
cliente.apellido = Convert.ToString(reader["apellido"]);
cliente.dpi = Convert.ToString(reader["dpi"]);
cliente.telefono = Convert.ToString(reader["telefono"]);
cliente.fecha = Convert.ToDateTime(reader["fecha"]);
cliente.sexo = Convert.ToString(reader["sexo"]);
cliente.direccion = Convert.ToString(reader["direccion"]);
cliente.estado = Convert.ToInt32(reader["estado_id"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(cliente);
}
public object FindForId(int id)
{
var promo = new PromocionViewModels();
string query = "SELECT id, cantidad, descripcion, fecha_inicio, fecha_fin, loti_id" +
" FROM promociones WHERE id = @id";
using (var connection = PostConnection.Connection())
{
using (var command = _database.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
promo.Id = Convert.ToInt16(reader["id"]);
promo.Cantidad = Convert.ToDouble(reader["cantidad"]);
promo.Descripcion = reader["descripcion"].ToString();
promo.FechaInicio = Convert.ToDateTime(reader["fecha_inicio"]);
promo.FechaFin = Convert.ToDateTime(reader["fecha_fin"]);
promo.LotificadoraId = Convert.ToInt16(reader["loti_id"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(promo);
}
public object FindForId(int id)
{
var paramsMora = new CalcularMoraViewModels();
string query = "SELECT saldo, fecha, cuota, mora FROM calc_demorados WHERE venta_id = @venta_id"
+ " ORDER BY fecha DESC LIMIT 1";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Parameters.AddWithValue("@venta_id", id);
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
paramsMora.Saldo = Convert.ToDouble(reader["saldo"]);
paramsMora.Fecha = Convert.ToDateTime(reader["fecha"]);
paramsMora.Cuota = Convert.ToDouble(reader["cuota"]);
paramsMora.TasaMora = Convert.ToDouble(reader["mora"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
DateTime fechaUltimaMora = FechaUltimaMora(id);
paramsMora.Fecha = paramsMora.Fecha < fechaUltimaMora ? fechaUltimaMora : paramsMora.Fecha;
return(paramsMora);
}
public object FindAll()
{
var lista = new List <ReferenciaEmpViewModels>();
string query = "SELECT id, nombre, apellido, telefono, direccion, id_emp FROM referenciaemp";
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lista.Add(new ReferenciaEmpViewModels()
{
id = Convert.ToInt16(reader["id"]),
nombre = reader["nombre"].ToString(),
apellido = reader["apellido"].ToString(),
tel = Convert.ToInt32(reader["telefono"]),
direccion = reader["direccion"].ToString(),
id_emp = Convert.ToInt16(reader["id_emp"]),
});
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(lista);
}