private void gastosToolStripMenuItem_Click(object sender, EventArgs e)
{
DataTable dtReturned;
MovPorUsuariosEntities dbTest = new MovPorUsuariosEntities();
dbTest.MOVIMIENTOS.Load();
dbTest.ARTICULOS.Load();
var movFinded = dbTest.MOVIMIENTOS
.Where((MOVIMIENTOS item) => item.ID_Usuario == this.IDUser)
.Join(dbTest.ARTICULOS.Select((ARTICULOS item) => item),
item => item.ID_Articulo,
itemArt => itemArt.ID,
(itemMov, itemAr) => new { cantidad = itemMov.Cantidad.Value, precioUnit = itemMov.Precio_Unitario.Value, concept = itemAr.Concepto, fech = itemMov.Fecha.Value })
.OrderByDescending(item => item.fech);
dtReturned = LINQToData(movFinded);
this.labelMaestro.Text = "Datos Gastos";
HandleVisiblePeriodo(true);
this.buttonOKPeriodo.Visible = true;
HandleVisibleTable(true);
HandleVisibleIngresarMov(false);
HandleVisibleIngresarArticulo(false);
this.dataGridView1.DataSource = dtReturned;
this.bindingSource1.DataSource = dtReturned;
this.bindingNavigator1.BindingSource = this.bindingSource1;
}
private void articulosToolStripMenuItem_Click(object sender, EventArgs e)
{
DataTable dtReturned;
MovPorUsuariosEntities dbTest = new MovPorUsuariosEntities();
dbTest.ARTICULOS.Load();
var articuloFind = dbTest.ARTICULOS
.Select((ARTICULOS userItem) => userItem);
dtReturned = LINQToData(articuloFind, typeof(System.Collections.Generic.ICollection <MOVIMIENTOS>));
this.labelMaestro.Text = "Articulos";
HandleVisiblePeriodo(false);
this.buttonOKPeriodo.Visible = true;
HandleVisibleIngresarMov(false);
HandleVisibleIngresarArticulo(false);
HandleVisibleTable(true);
this.dataGridView1.DataSource = dtReturned;
this.bindingSource1.DataSource = dtReturned;
this.bindingNavigator1.BindingSource = this.bindingSource1;
}
