/// <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();
}
}
