public SingleFactura()
{
ReadBC objRead = new ReadBC();
Proveedores = objRead.ReadProvedor();
/*txtIdProvedor.ItemsSource = Proveedores;
txtIdProvedor.SelectedValue = "IdProvedor";
*/
factura.Fecha = DateTime.Now;
InitializeComponent();
Binding binding = new Binding();
binding.Source = Proveedores;
txtIdProvedor.DisplayMemberPath = "Nombre";
txtIdProvedor.SelectedValuePath = "IdProvedor";
txtIdProvedor.SetBinding(ComboBox.ItemsSourceProperty, binding);
this.DataContext = factura;
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadFactura(@"
select IdFactura,(select Nombre
from Provedor
where Provedor.IdProvedor = Factura.IdProvedor ) as Provedor, NoFactura, Fecha
from Factura");
}
public ListEntrada()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Entradas = obj.ReadEntrada();
this.DataContext = Entradas;
}
public ListSalida()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Salidas = obj.ReadSalida();
this.DataContext = Salidas;
}
public ListFacturaArticulo()
{
InitializeComponent();
ReadBC obj = new ReadBC();
FacturaArticulos = obj.ReadFacturaArticulo();
this.DataContext = FacturaArticulos;
}
public ListUsuario()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Usuarios = obj.ReadUsuario();
this.DataContext = Usuarios;
}
public ListPendiente()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Pendientes = obj.ReadPendiente();
this.DataContext = Pendientes;
}
public ListRectificacion()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Rectificacions = obj.ReadRectificacion();
this.DataContext = Rectificacions;
}
public ListEmpleado()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Empleados = obj.ReadEmpleado();
this.DataContext = Empleados;
}
public ListProvedor()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Provedors = obj.ReadProvedor();
this.DataContext = Provedors;
}
public ListDevolucion()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Devolucions = obj.ReadDevolucion();
this.DataContext = Devolucions;
}
public SingleSalida()
{
InitializeComponent();
ReadBC read = new ReadBC();
Empleados = read.ReadEmpleado();
this.DataContext = Empleados;
salida.Fecha = DateTime.Now.Date;
}
public ListArticulo()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Articulos = obj.ReadArticulo();
this.DataContext = Articulos;
}
public SingleFactura(Factura reg)
{
InitializeComponent();
txtIdProvedor.ItemsSource = Proveedores;
factura = reg;
ReadBC objRead = new ReadBC();
btnActualizar.Visibility = Visibility.Visible;
btnGuardar.Visibility = Visibility.Collapsed;
}
public ListSalidaArticulo()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Articulos = obj.ReadArticulo();
SalidaArticulos = obj.ReadSalidaArticulos(salida.IdSalida);
listArticulo.DataContext = Articulos;
listSalidaArticulos.DataContext = SalidaArticulos;
}
public ListFactura()
{
InitializeComponent();
ReadBC obj = new ReadBC();
Facturas = obj.ReadFactura(@"
select IdFactura,(select Nombre
from Provedor
where Provedor.IdProvedor = Factura.IdProvedor ) as Provedor, NoFactura, Fecha
from Factura");
this.DataContext = Facturas;
}
private void Update()
{
ReadBC objReader = new ReadBC();
EntradaArticulos = objReader.ReadEntradaArticulo(factura.IdFactura);
this.DataContext = EntradaArticulos;
ReadBC objReaderPendiente = new ReadBC();
PendienteArticulos = objReaderPendiente.ReadPendienteArticulo(factura.IdFactura);
listPendienteArticulo.DataContext = PendienteArticulos;
double total = 0;
foreach (EntradaArticulo art in EntradaArticulos)
{
total += art.Precio * art.Cantidad;
}
txtTotal.Text = total.ToString("$ 0.00");
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadDevolucion();
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadEntrada();
}
private void btnAgregarEntrada_Click(object sender, RoutedEventArgs e)
{
Pages.AgregarEntrada dialog = new Pages.AgregarEntrada();
dialog.Title = "Agregar";
dialog.Content = new Pages.AgregarArticulo();
dialog.ResizeMode = ResizeMode.CanResize;
dialog.UpdateLayout();
dialog.ShowDialog();
if (agregar)
{
Entrada nuevaEntrada = new Entrada();
nuevaEntrada = ArticuloNuevo;
CreateBC objCreate = new CreateBC();
objCreate.Create(nuevaEntrada);
ReadBC objReader = new ReadBC();
EntradaArticulos = objReader.ReadEntradaArticulo();
this.DataContext = EntradaArticulos;
agregar = false;
}
else
{
}
}
private void btnEliminarEntrada_Click(object sender, RoutedEventArgs e)
{
EntradaArticulo reg = listEntradaArticulo.SelectedValue as EntradaArticulo;
DeleteBC objDelete = new DeleteBC();
objDelete.DeleteEntrada(reg.IdEntrada);
ReadBC objReader = new ReadBC();
EntradaArticulos = objReader.ReadEntradaArticulo(factura.IdFactura);
this.DataContext = EntradaArticulos;
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadFacturaArticulo();
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadProvedor();
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadEmpleado();
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadRectificacion();
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadPendiente();
}
private void btnReport_Click(object sender, RoutedEventArgs e)
{
ReadOneBC objRead = new ReadOneBC();
ReadBC obj = new ReadBC();
Empleado emp = objRead.ReadOneEmpleado(salida.IdEmpleado);
List<List<SalidaArticulos>> splitArticulos = new List<List<SalidaArticulos>>();
List<UserControl> reportes = new List<UserControl>();
splitArticulos = Split( obj.ReadSalidaArticulos(salida.IdSalida), 45);
foreach (List<SalidaArticulos> articulos in splitArticulos)
{
reportes.Add(new Reports.Salida(articulos, emp.Nombre +" "+ emp.ApellidoPaterno));
}
Report objRep = new Report();
objRep.Generar("", reportes);
}
public void Update()
{
ReadBC obj = new ReadBC();
Articulos = obj.ReadArticulo();
this.DataContext = Articulos;
}
public void Update()
{
ReadBC obj = new ReadBC();
listSalidaArticulos.DataContext = obj.ReadSalidaArticulos(salida.IdSalida);
listArticulo.DataContext = obj.ReadArticulo();
}
public void Update()
{
ReadBC obj = new ReadBC();
this.DataContext = obj.ReadUsuario();
}