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; }