protected override void OnStartup(StartupEventArgs e)
{
Properties.Settings App = new Properties.Settings();
// провереям подключение к WebService
var client = new EDIWebServiceSoapClient("EDIWebServiceSoap");
string result = client.Relationships(App.LoginWebService, App.PasswordWebService, 1000).Res;
client.Close();
if (!String.IsNullOrEmpty(SoapRequest.ResultWebRequest(result)))
{
MessageBox.Show(SoapRequest.ResultWebRequest(result), "Подключения к WebService", MessageBoxButton.OK, MessageBoxImage.Error);
SettingWebSerice settingForm = new SettingWebSerice();
settingForm.ShowDialog();
// перезагружаем приложение
System.Diagnostics.Process.Start(Application.ResourceAssembly.Location);
Application.Current.Shutdown();
}
// проверяем подключения к бд
if (!StatusApp.CheckConnection())
{
MessageBox.Show("Нет соединение с базой данных , проверьте параметры подключения или обратитесь к системному администратору ", "Cоединение с базой данных", MessageBoxButton.OK, MessageBoxImage.Hand);
ConnectionDataBase.ChangeConnect();
}
}
public static int ProximoID(string tabela)
{
DataTable dataTable = new DataTable();
string sql = $"select (id + 1) as proximo_id from {tabela} order by id desc limit 1";
try
{
using (var connect = ConnectionDataBase.ConnectionDataBases())
{
NpgsqlCommand cmd = new NpgsqlCommand(sql);
cmd.Connection = connect;
using (NpgsqlDataAdapter Adpt = new NpgsqlDataAdapter(cmd))
{
Adpt.Fill(dataTable);
}
}
}
catch (NpgsqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
if (dataTable.Rows.Count != 0)
{
return(Convert.ToInt32(dataTable.Rows[0]["proximo_id"]));
}
else
{
return(1);
}
}
public string RetornaQuery()
{
_ConnectionDataBase = new ConnectionDataBase("scan", "1521", "lgpd", "app", "123456");
string selectCodCampanha = _ConnectionDataBase.ExecutaSelect(string.Format(SelectCodCampanha));
return(selectCodCampanha);
}
public static DataTable ExecutaSelect(string sql)
{
DataTable dataTable = new DataTable();
try
{
using (var connect = ConnectionDataBase.ConnectionDataBases())
{
NpgsqlCommand cmd = new NpgsqlCommand(sql);
cmd.Connection = connect;
using (NpgsqlDataAdapter Adpt = new NpgsqlDataAdapter(cmd))
{
Adpt.Fill(dataTable);
}
}
}
catch (NpgsqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
if (dataTable.Rows.Count != 0)
{
return(dataTable);
}
else
{
return(null);
}
}
public MainWindow()
{
InitializeComponent();
#region StatusBarElements
lblStatus.Content = "WebService OK";
EllipseStatus.Fill = Brushes.GreenYellow;
lblConnectionString.Content = ConnectionDataBase.Read();
#endregion
// выводим список направлений
cbxDirection.ItemsSource = StoredProcedureItems.getDirection();
// выводим список партнеров в EDI
cbxPartnerILN.ItemsSource = SoapRequest.Relationships("DESADV");
}
private void previewButton_Click(object sender, EventArgs e)
{
double diferenceDateTime = endDateTimePicker.Value.Subtract(startDateTimePicker.Value).TotalDays;
if (diferenceDateTime > 0)
{
ConnectionDataBase.GetItDetaMoveToDatagridview(mainDataGridView, startDateTimePicker.Value, endDateTimePicker.Value);
//totalRowsLabel.Text = "" + mainDataGridView.RowCount;
}
else
{
MessageBox.Show("The start date can not be greater than the end date.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
static void ValidaConexaoBD()
{
try
{
using (var connect = ConnectionDataBase.ConnectionDataBases()) { }
}
catch (NpgsqlException erro)
{
MessageBox.Show(erro.Message);
Process.GetCurrentProcess().Kill();
}
catch (Exception erro)
{
MessageBox.Show(erro.Message);
Process.GetCurrentProcess().Kill();
}
}
public GeneratorOrdersVM()
{
AddOrders = new RelayAsyncCommand(async() => await addOrdersToDb());
IsEnabledButton = true;
IsEnabledSlider = true;
MinimumValue = 0;
CurrentProgress = 0;
CountOrders = 1000;
CountOrdersStatus = $"Count Orders: {CountOrders}";
ConnectionDataBase connectionDataBase = new ConnectionDataBase();
ConnectionDataBaseVM connectionDataBaseVM = (ConnectionDataBaseVM)connectionDataBase.DataContext;
connectionDataBase.ShowDialog();
if (connectionDataBaseVM.IsSuccessConnect == false)
{
DialogResult = false;
return;
}
contextDb = new ContextDb($"Server={connectionDataBaseVM.ServerDatabase};Database={connectionDataBaseVM.NameDatabase};Trusted_Connection=False;MultipleActiveResultSets=true;");
}
public static void ExecutaSQL(List <string> list_sql)
{
try
{
using (var connect = ConnectionDataBase.ConnectionDataBases())
{
NpgsqlCommand cmd = new NpgsqlCommand("begin");
cmd.Connection = connect;
cmd.ExecuteNonQuery();
foreach (string sql in list_sql)
{
try
{
cmd = new NpgsqlCommand(sql);
cmd.Connection = connect;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
cmd = new NpgsqlCommand("rollback");
cmd.Connection = connect;
cmd.ExecuteNonQuery();
throw ex;
}
}
cmd = new NpgsqlCommand("commit");
cmd.Connection = connect;
cmd.ExecuteNonQuery();
}
}
catch (NpgsqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public GenericDAO()
{
this.conexao = new ConnectionDataBase();
}
public void UI01_Validacao_Alteracao_Rotina_Cancelamento_Contrato_PJ_Campinas()
{
SDK.Init(new SdkConfiguration());
Reporter.Init(new ReportConfiguration());
IBrowser browser = BrowserFactory.Launch(BrowserType.InternetExplorer);
// CLASSES A SEREM UTILIZADAS
var basePage = new BasePage(browser);
var loginPage = new LoginPage(browser);
var menuPage = new MenuPage(browser);
var atendimentoContratoPage = new AtendimentoContratoPage(browser);
var processaFaturamentoPage = new ProcessaFaturamentoPage(browser);
var gerarArquivoRpsPage = new GerarArquivoRpsPage(browser);
var cadastroFilialFiscalPage = new CadastroFilialFiscalPage(browser);
var dados = new US57839();
var dadosQueryBD = new DadosQuerysBD();
var executaOperacoesBD = new ExecutaOperacoesBD();
var connectionDataBase = new ConnectionDataBase(dadosQueryBD.HostStringConnectionQA4, dadosQueryBD.PortStringConnection,
dadosQueryBD.ServiceQA8StringConnectionQA4, dadosQueryBD.UserStringConnectionHumberto, dadosQueryBD.PasswordStringConnectionHumberto);
string DataFatura;
string valueInputUltimoNumero;
//INICIO DO FLUXO DO CASO DE TESTE
browser.Navigate(dados.UrlQA4);
basePage.gerarEvidencias("UI002");
loginPage.loginSisAmil(dados.Username, dados.Senha);
// ACESSAR SUBMENU FILIAL FISCAL - ESTRUTURA ORGANIZACIONAL / CADASTRO FILIAL FISCAL
menuPage.acessarCadastroFilialFiscal();
//PREENCHER SELECTS TELA CADASTRO FILIAL FISCAL
cadastroFilialFiscalPage.preencherSelectsOperadoraFilialFiscal(dados.OperadoraAmil, dados.FilialFiscalCampinas);
//MUDA CAMPOS "TIPO LAYOUT DE ARQUIVO NFE" -> "PREFEITURA" // "TIPO DE CONTRATO NFE" -> "PESSOA JURÍDICA" // "TIPO NUMERAÇÃO RPS(PF / PJ)" -> "PROPRIA" // PEGA O TEXT DO IMPUT "ÚLTIMO NÚMERO"
cadastroFilialFiscalPage.selecionaRadioCampoTipoLayoutArquivoNFE("Prefeitura");
cadastroFilialFiscalPage.selecionaRadioTipoContratoNFEPJ();
cadastroFilialFiscalPage.selecionaRadioNumeracaoRPSCNPJPFPropria();
valueInputUltimoNumero = cadastroFilialFiscalPage.getTextInputUltimoNumero();
// FLUXO MENU ATENDIMENTO CONTRATO/ATENDIMENTO PARA PEGAR OS DADOS DE MES/ANO
menuPage.acessarAtendimentoContrato();
menuPage.subMenuAtendimento2();
atendimentoContratoPage.preencherNumeroContrato(dados.Contrato7);
atendimentoContratoPage.clicarIconeContinuar();
atendimentoContratoPage.acessarSubMenuCadeiaPgEso();
DataFatura = atendimentoContratoPage.getTextPrimeiroLinkMens();
//FLUXO MENU FATURAMENTO/ITENS DE COBRANÇA/PROCESSAR
menuPage.acessarMenuProcessarFaturamento();
processaFaturamentoPage.preencheContratoParaProcessar(dados.Contrato7);
processaFaturamentoPage.preencheCamposAdicionais(DataFatura);
processaFaturamentoPage.verificaFaturamentoSucesso();
//FLUXO MENU FATURAMENTO/NOTA FISCAL ELETRONICA/GERAR ARQUIVO RPS
menuPage.acessarSubMenuGerarArquivoRPS();
gerarArquivoRpsPage.preencheContratoParaProcessar(dados.Contrato7);
gerarArquivoRpsPage.clicaBotaoExecutar();
gerarArquivoRpsPage.verificaFaturamentoSucesso();
//FLUXO MENU FATURAMENTO/NOTA FISCAL ELETRONICA/CONSULTA LOTE RPS
menuPage.acessarSubMenuConsultaLotaRPS();
gerarArquivoRpsPage.preencherSelectsTelaConsultaLoteRPS();
gerarArquivoRpsPage.verificaUltimaLinhaInserida();
gerarArquivoRpsPage.getUltimoCodLoteRPSInserido();
//REPRESA O LOTE / EXECUTA SCRIPT PASSANDO O LOTE GERADO
executaOperacoesBD.represaLote(gerarArquivoRpsPage.CodRPS);
//CONTINUAR
//FIM DO FLUXO DO CASO DE TESTE
browser.Close();
Reporter.GenerateReport();
SDK.Cleanup();
}
public DataBaseContext() : base(ConnectionDataBase.Read())
{
}
private void menuChangeConnection_Click(object sender, RoutedEventArgs e)
{
ConnectionDataBase.ChangeConnect();
RestartApp();
}
