private void Refresh() { using (Models.MaestroDetalleEntities db = new Models.MaestroDetalleEntities()) { dataGridView1.DataSource = db.venta.Select(d => new { d.id, d.fecha, d.total }).ToList(); } }
private void button2_Click(object sender, EventArgs e) { using (Models.MaestroDetalleEntities db = new Models.MaestroDetalleEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { Models.venta oVenta = new Models.venta(); oVenta.fecha = DateTime.Now; oVenta.total = decimal.Parse(lblTotal.Text.ToString()); db.venta.Add(oVenta); db.SaveChanges(); foreach (DataGridViewRow dr in dgvVentas.Rows) { Models.concepto oConcepto = new Models.concepto(); oConcepto.cantidad = int.Parse(dr.Cells[2].Value.ToString()); oConcepto.descripcion = dr.Cells[0].Value.ToString(); oConcepto.precioUnitario = decimal.Parse(dr.Cells[1].Value.ToString()); oConcepto.importe = decimal.Parse(dr.Cells[3].Value.ToString()); oConcepto.id_venta = oVenta.id; db.concepto.Add(oConcepto); } db.SaveChanges(); dbContextTransaction.Commit(); dbContextTransaction.Dispose(); this.Close(); }catch (Exception ex) { dbContextTransaction.Rollback(); } } } }