/// <summary>
/// Constuctor sin parametros
/// </summary>
public Especial()
{
Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter Adapter1 = new Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter();
this.FacturasCount = (int) Adapter1.CountFacturas();
Data.dsClienteTableAdapters.ClienteTableAdapter Adapter2 =
new Data.dsClienteTableAdapters.ClienteTableAdapter();
this.ClientesCount = (int)Adapter2.CountClientes();
Data.dsEmpleadoTableAdapters.EmpleadoTableAdapter Adapter3 =
new Data.dsEmpleadoTableAdapters.EmpleadoTableAdapter();
this.EmpleadosSuma = (int) Adapter3.SumEmpleados();
Data.dsProductoTableAdapters.ProductosTableAdapter Adapter4 = new Data.dsProductoTableAdapters.ProductosTableAdapter();
this.ProductosSum = (int) Adapter4.SumProductosInv();
}
public int InsertUpdateFactura()
{
Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter Adapter = new Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter();
return (int)Adapter.InsertUpdateFacturaHeader(this.idFacturaHeader, this.idCliente, this.idTipoPago, this.idEmpleado, this.dtFechaPago, this.mTotal);
}
public static void DeleteFactura(int idFacturaHeader)
{
Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter Adapter = new Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter();
Adapter.DeleteFacturaHeader(idFacturaHeader);
}
public static List<FacturaHeader> GetListaFacturas()
{
List<FacturaHeader> listaFacturas = new List<FacturaHeader>();
Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter Adapter = new Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter();
Data.dsFactura.FacturasHeaderDataTable dt = Adapter.SelectListaFacturasHeader(null);
foreach(var dr in dt)
{
FacturaHeader temp = new FacturaHeader();
temp.idFacturaHeader = dr.idFacturaHeader;
temp.idCliente = dr.idCliente;
temp.idTipoPago = dr.idTipoPago;
if (!dr.IsidEmpleadoNull())
temp.idEmpleado = dr.idEmpleado;
if (!dr.IsdtFechaPagoNull())
temp.dtFechaPago = dr.dtFechaPago;
if (!dr.IsmTotalNull())
temp.mTotal = dr.mTotal;
if (!dr.IscEmpresaNull())
temp.cEmpresa = dr.cEmpresa.Trim();
listaFacturas.Add(temp);
}
return listaFacturas;
}
public FacturaHeader(int idFacturaHeader)
{
Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter Adapter = new Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter();
Data.dsFactura.FacturasHeaderDataTable dt = Adapter.SelectListaFacturasHeader(idFacturaHeader);
if (dt.Rows.Count > 0)
{
Data.dsFactura.FacturasHeaderRow dr = dt[0];
this.idFacturaHeader = dr.idFacturaHeader;
this.idCliente = dr.idCliente;
this.idTipoPago = dr.idTipoPago;
if (!dr.IsidEmpleadoNull())
this.idEmpleado = dr.idEmpleado;
if (!dr.IsdtFechaPagoNull())
this.dtFechaPago = dr.dtFechaPago;
if (!dr.IsmTotalNull())
this.mTotal = dr.mTotal;
if (!dr.IscEmpresaNull())
this.cEmpresa = dr.cEmpresa.Trim();
this.clienteActual = new Cliente(this.idCliente);
this.listaDetalle = FacturaDetalle.GetListaFacturasDetalle(this.idFacturaHeader);
this.GetSelectLists();
}
}
