public void Save()
{
foreach (ModelStatement ms in Statements)
{
MDFeNetConfig.WriteStatementForModel(ms.ModelName, ms.Statement);
}
}
private void FillFromLocal()
{
DatasourceConfiguration conf = MDFeNetConfig.ReadFromLocal();
cbTipoBanco.SelectedValue = conf.DataProvider;
txServidor.Text = conf.Datasource;
txUsuario.Text = conf.UserId;
txSenha.Password = conf.Password;
txNomeBanco.Text = conf.InitialCatalog;
}
private void btExecutar_Click(object sender, RoutedEventArgs e)
{
try
{
DatasourceConfiguration conf = MDFeNetConfig.ReadFromLocal();
DataTable dt = conf.RetrieveDataFromSql(txSQL.Text);
dataGrid.ItemsSource = dt.DefaultView;
}
catch (Exception ex)
{
MsgBox.SimpleText(ex.Message);
}
}
private void FillListBox()
{
/*
* Emitente
* Motorista
* Veiculo
* Autorizado ( pode ser inserido na hora tbm)
* NFeVinculada ( chaves de acesso escolhidas de uma listagem de notas do banco)
* a classe IdeMDFe tem algumas propriedqades q vem do bd e outras nao
*
*/
Statements.Add(new ModelStatement("Emitente", MDFeNetConfig.ReadStatementForModel("Emitente")));
Statements.Add(new ModelStatement("Motorista", MDFeNetConfig.ReadStatementForModel("Motorista")));
Statements.Add(new ModelStatement("Veiculo", MDFeNetConfig.ReadStatementForModel("Veiculo")));
Statements.Add(new ModelStatement("Autorizado", MDFeNetConfig.ReadStatementForModel("Autorizado")));
Statements.Add(new ModelStatement("NFeVinculada", MDFeNetConfig.ReadStatementForModel("NFeVinculada")));
listBox.ItemsSource = Statements;
listBox.SelectedIndex = 0;
}
private void button1_Click(object sender, RoutedEventArgs e)
{
string sql = @"SELECT CNPJ, RAZAO_SOCIAL, NOME_FANTASIA, FROM LOJAS";
MDFeNetConfig.WriteStatementForModel("Emitente", sql);
}
public void Save()
{
MDFeNetConfig.SaveToLocal(GetConfig());
}