private void btnAtuCubo_Click(object sender, EventArgs e)
{
try
{
string linha = "";
lblTexto.Visible = true;
prgrsBrCarrega.Value = 0;
prgrsBrCarrega.Visible = true;
tmrTempo.Enabled = true;
//Abrir o arquivo
linha += "<Batch xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\"> " +
"<Parallel> " +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ddl2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2\" xmlns:ddl2_2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2/2\" xmlns:ddl100_100=\"http://schemas.microsoft.com/analysisservices/2008/engine/100/100\"> " +
"<Object> " +
"<DatabaseID>Comercial_Mart</DatabaseID> " +
"<DimensionID>Regiao</DimensionID> " +
"</Object> " +
"<Type>ProcessUpdate</Type> " +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation> " +
"</Process> " +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ddl2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2\" xmlns:ddl2_2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2/2\" xmlns:ddl100_100=\"http://schemas.microsoft.com/analysisservices/2008/engine/100/100\"> " +
"<Object> " +
"<DatabaseID>Comercial_Mart</DatabaseID> " +
"<CubeID>Vendas_Regiao_Produto</CubeID> " +
"</Object> " +
"<Type>ProcessFull</Type> " +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation> " +
"</Process> " +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ddl2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2\" xmlns:ddl2_2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2/2\" xmlns:ddl100_100=\"http://schemas.microsoft.com/analysisservices/2008/engine/100/100\"> " +
"<Object> " +
"<DatabaseID>Comercial_Mart</DatabaseID> " +
"<DimensionID>Produto</DimensionID> " +
"</Object> " +
"<Type>ProcessUpdate</Type> " +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation> " +
"</Process> " +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ddl2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2\" xmlns:ddl2_2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2/2\" xmlns:ddl100_100=\"http://schemas.microsoft.com/analysisservices/2008/engine/100/100\"> " +
"<Object> " +
"<DatabaseID>Comercial_Mart</DatabaseID> " +
"<DimensionID>Data</DimensionID> " +
"</Object> " +
"<Type>ProcessUpdate</Type> " +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation> " +
"</Process> " +
"</Parallel> " +
"</Batch>";
//FileInfo x = new FileInfo(@"E:\Faculdade\Tcc_google\Prototipo\atucubo.txt");
// StreamReader valor = x.OpenText();
//while (valor.ReadLine() != null)
// {
// linha += valor.ReadLine();
//}
string c = ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString_analysis"].ConnectionString;
AdomdConnection conn = new AdomdConnection(c);
conn.Open();
AdomdCommand cmd = new AdomdCommand(linha, conn);
cmd.Execute();
conn.Close();
COMERCIALDataSetTableAdapters.ATUCUBOTableAdapter atu = new Comercial.COMERCIALDataSetTableAdapters.ATUCUBOTableAdapter();
DateTime data = Convert.ToDateTime(DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day);
atu.Insert(_princ.usuarioLogado, data);
preencheGrid();
prgrsBrCarrega.Value = 100;
tmrTempo.Enabled = false;
lblTexto.Visible = false;
MessageBox.Show("Processo executado com sucesso", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information);
pictureBox1.Visible = true;
pictureBox2.Visible = true;
}
catch (Exception ex)
{
tmrTempo.Enabled = false;
lblTexto.Visible = false;
prgrsBrCarrega.Visible = false;
MessageBox.Show("Houve um problema na execução da atualização!\nConsulte o DBA.", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Error);
pictureBox1.Visible = false;
pictureBox1.Visible = false;
}
}
private void btnAtuCubo_Click(object sender, EventArgs e)
{
try
{
string linha = "";
lblTexto.Visible = true;
prgrsBrCarrega.Value = 0;
prgrsBrCarrega.Visible = true;
tmrTempo.Enabled = true;
//Abrir o arquivo
linha += "<Batch xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\"> " +
"<Parallel> " +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ddl2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2\" xmlns:ddl2_2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2/2\" xmlns:ddl100_100=\"http://schemas.microsoft.com/analysisservices/2008/engine/100/100\"> " +
"<Object> " +
"<DatabaseID>Comercial_Mart</DatabaseID> " +
"<DimensionID>Regiao</DimensionID> " +
"</Object> " +
"<Type>ProcessUpdate</Type> " +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation> " +
"</Process> " +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ddl2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2\" xmlns:ddl2_2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2/2\" xmlns:ddl100_100=\"http://schemas.microsoft.com/analysisservices/2008/engine/100/100\"> " +
"<Object> " +
"<DatabaseID>Comercial_Mart</DatabaseID> " +
"<CubeID>Vendas_Regiao_Produto</CubeID> " +
"</Object> " +
"<Type>ProcessFull</Type> " +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation> " +
"</Process> " +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ddl2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2\" xmlns:ddl2_2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2/2\" xmlns:ddl100_100=\"http://schemas.microsoft.com/analysisservices/2008/engine/100/100\"> " +
"<Object> " +
"<DatabaseID>Comercial_Mart</DatabaseID> " +
"<DimensionID>Produto</DimensionID> " +
"</Object> " +
"<Type>ProcessUpdate</Type> " +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation> " +
"</Process> " +
"<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:ddl2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2\" xmlns:ddl2_2=\"http://schemas.microsoft.com/analysisservices/2003/engine/2/2\" xmlns:ddl100_100=\"http://schemas.microsoft.com/analysisservices/2008/engine/100/100\"> " +
"<Object> " +
"<DatabaseID>Comercial_Mart</DatabaseID> " +
"<DimensionID>Data</DimensionID> " +
"</Object> " +
"<Type>ProcessUpdate</Type> " +
"<WriteBackTableCreation>UseExisting</WriteBackTableCreation> " +
"</Process> " +
"</Parallel> " +
"</Batch>";
//FileInfo x = new FileInfo(@"E:\Faculdade\Tcc_google\Prototipo\atucubo.txt");
// StreamReader valor = x.OpenText();
//while (valor.ReadLine() != null)
// {
// linha += valor.ReadLine();
//}
string c = ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString_analysis"].ConnectionString;
AdomdConnection conn = new AdomdConnection(c);
conn.Open();
AdomdCommand cmd = new AdomdCommand(linha, conn);
cmd.Execute();
conn.Close();
COMERCIALDataSetTableAdapters.ATUCUBOTableAdapter atu = new Comercial.COMERCIALDataSetTableAdapters.ATUCUBOTableAdapter();
DateTime data = Convert.ToDateTime(DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day);
atu.Insert(_princ.usuarioLogado, data);
preencheGrid();
prgrsBrCarrega.Value = 100;
tmrTempo.Enabled = false;
lblTexto.Visible = false;
MessageBox.Show("Processo executado com sucesso", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information);
pictureBox1.Visible = true;
pictureBox2.Visible = true;
}
catch(Exception ex)
{
tmrTempo.Enabled = false;
lblTexto.Visible = false;
prgrsBrCarrega.Visible = false;
MessageBox.Show("Houve um problema na execução da atualização!\nConsulte o DBA.", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Error);
pictureBox1.Visible = false;
pictureBox1.Visible = false;
}
}
