private void CacheDbs()
{
try
{
IsLoading = true;
/* this.toolStripStatusLabel1.Text = "Cargando Articulo en cache";
* CacheArticulo = await Task.Run(() => db.articuloes.ToList());
* this.toolStripStatusLabel1.Text = "Listo";
*
* this.toolStripStatusLabel1.Text = "Cargando Caracteristica en cache";
* CacheCaracteristicas = await Task.Run(() => db.caracteristicas.ToList());
* this.toolStripStatusLabel1.Text = "Listo";
*
* this.toolStripStatusLabel1.Text = "Cargando Color en cache";
* CacheCaracteristicas = await Task.Run(() => db.caracteristicas.ToList());
* this.toolStripStatusLabel1.Text = "Listo";*/
this.toolStripStatusLabel1.Text = "Cargando la base de datos";
Task.WaitAll(
Task.Run(() => { using (var c = new pikitikosdbEntities()) { CacheArticulo = new pikitikosdbEntities().articuloes.ToList(); } }),
Task.Run(() => { using (var c = new pikitikosdbEntities()) { CacheCaracteristicas = new pikitikosdbEntities().caracteristicas.ToList(); } }),
Task.Run(() => { using (var c = new pikitikosdbEntities()) { CacheColor = new pikitikosdbEntities().colors.ToList(); } }),
Task.Run(() => { using (var c = new pikitikosdbEntities()) { Cachetalla = new pikitikosdbEntities().tallas.ToList(); } }),
Task.Run(() => { using (var c = new pikitikosdbEntities()) { CacheTipoArticulo = new pikitikosdbEntities().tipoarticuloes.ToList(); } }),
Task.Run(() => { using (var c = new pikitikosdbEntities()) { CacheTipoTela = new pikitikosdbEntities().tipotelas.ToList(); } }),
Task.Run(() => { using (var c = new pikitikosdbEntities()) { CacheInventario = new pikitikosdbEntities().inventarios.ToList(); } })
);
this.toolStripStatusLabel1.Text = "Listo";
BuildDdisplay();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
IsLoading = false;
db.Database.Connection.Close();
}
}
private async void frmInventario_Load(object sender, EventArgs e)
{
db = new pikitikosdbEntities();
CacheDbs();
// rbArticulo_CheckedChanged(this, new EventArgs());
dgInventario.AutoGenerateColumns = true;
dgInventario.DataSource = DisplayInventario;
dgInventario.Columns[0].ReadOnly = true;
dgInventario.Columns[0].Visible = false;
dgInventario.Columns[1].ReadOnly = true;
dgInventario.Columns[11].Visible = false;
dgInventario.Columns[12].Visible = false;
dgInventario.Columns[13].Visible = false;
dgInventario.Columns[14].Visible = false;
dgInventario.Columns[15].Visible = false;
dgInventario.Columns[16].Visible = false;
await InsertNullDummies();
}