/// <summary> /// Muestra todas las entidades. /// </summary> /// <param name="sender">The event sender.</param> /// <param name="e">The event arguments.</param> private void ShowEntities_Click(object sender, EventArgs e) { using (TutorialObjectContext entities = new TutorialObjectContext(ConnectionManager.ConnectionString)) { dgvMain.DataSource = entities.Pallets.Select(p => new { p.Id, p.Lote, Codigo = p.Articulo.Id, Bloqueado = p.Bloqueado.Equals("Y"), p.FechaEntrada, Articulo = p.Articulo.Descripcion }); } }
/// <summary> /// Muestra los automoviles. /// </summary> /// <param name="sender">The event sender.</param> /// <param name="e">The event arguments.</param> private void ShowAutomoviles_Click(object sender, EventArgs e) { using (TutorialObjectContext entities = new TutorialObjectContext(ConnectionManager.ConnectionString)) { dgvMain.DataSource = entities.Vehiculos.OfType <Automovil>(); } }
/// <summary> /// Muestra los gerentes. /// </summary> /// <param name="sender">The event sender.</param> /// <param name="e">The event arguments.</param> private void ShowGerentes_Click(object sender, EventArgs e) { using (TutorialObjectContext entities = new TutorialObjectContext(ConnectionManager.ConnectionString)) { dgvMain.DataSource = entities.Personas.OfType <Gerente>(); } }
/// <summary> /// Agrega un articulo al sistema mediante un Store Procedure. /// </summary> /// <param name="sender">The event sender.</param> /// <param name="e">The event arguments.</param> private void AgregarArticulo_Click(object sender, EventArgs e) { using (TutorialObjectContext entities = new TutorialObjectContext(ConnectionManager.ConnectionString)) { Random random = new Random(); entities.AgregarArticulo(random.Next(9999).ToString(), "Dummy", 12); } }
/// <summary> /// Actualiza solo un campo de un desarrollador impactando en una sola tabla. /// </summary> /// <param name="sender">The event sender.</param> /// <param name="e">The event arguments.</param> private void UpdateDesarrollador_Click(object sender, EventArgs e) { using (TutorialObjectContext entities = new TutorialObjectContext(ConnectionManager.ConnectionString)) { Desarrollador desarrollador = entities.Personas.OfType <Desarrollador>().Where(d => d.Id == 4).First(); desarrollador.Nivel = "Senior"; entities.SaveChanges(); } }
/// <summary> /// Actualiza todos los campos de un gerente, impactando en dos tablas. /// </summary> /// <param name="sender">The event sender.</param> /// <param name="e">The event arguments.</param> private void UpdateGerente_Click(object sender, EventArgs e) { using (TutorialObjectContext entities = new TutorialObjectContext(ConnectionManager.ConnectionString)) { Gerente gerente = entities.Personas.OfType <Gerente>().Where(d => d.Id == 1).First(); gerente.Nombre = "Jorge"; gerente.Apellido = "Bourdette"; gerente.Cargo = "Gerente Sistemas Gestion Calidad"; entities.SaveChanges(); } }
/// <summary> /// Ingresa un lider tecnico sin realizar commit. /// </summary> /// <param name="sender">The event sender.</param> /// <param name="e">The event arguments.</param> private void InsertLiderTecnico_Click(object sender, EventArgs e) { using (TransactionScope ts = new TransactionScope()) { using (TutorialObjectContext entities = new TutorialObjectContext(ConnectionManager.ConnectionString)) { LiderTecnico liderTecnico = new LiderTecnico { Id = DateTime.Now.Ticks % 1000000, Nombre = "Dummy", Apellido = "Boy", Nivel = "Junior", Projecto = "My ePlant" }; entities.AddToPersonas(liderTecnico); entities.SaveChanges(); } ts.Dispose(); } }