コード例 #1
0
ファイル: FormCliente.cs プロジェクト: nevesvox/SlimDesktop
        public void carregaClientesPorNome()
        {
            ltvClientes.Items.Clear();
            try
            {
                ApiService           apiserv  = new ApiService();
                var                  json     = apiserv.fazRequisicaoPOST("https://slimws.tk/desktop/todosClientesPorNome", "nome=" + txtNomeCliente.Text);
                JavaScriptSerializer js       = new JavaScriptSerializer();
                Clientes[]           clientes = js.Deserialize <Clientes[]>(json);

                for (int i = 0; i < clientes.Length; i++)
                {
                    string[] subitems = new string[] {
                        clientes[i].id.ToString(),
                        clientes[i].nome,
                        clientes[i].email,
                        FormatCnpjCpf.FormatCPF(clientes[i].cpf),
                        FormatCnpjCpf.formatTelefone(clientes[i].telefone)
                    };
                    ListViewItem item = new ListViewItem(subitems);
                    ltvClientes.Items.Add(item);
                }
            }
            catch (Exception err)
            {
                MessageBox.Show("Houve um erro ao tentar se conectar com o servidor. " + err);
            }
        }
コード例 #2
0
        public override void UpdateCompany()
        {
            string cnpjFormatted = FormatCnpjCpf.FormatCnpj(_company.GetDataCompany().Cnpj);

            _sql = "update cliente set " +
                   $"tipo = '{_company.GetDataCompany().Cnpj}', " +
                   $"abertura = '{_company.GetDataCompany().Opening}', " +
                   $"nome = '{_company.GetDataCompany().Name}', " +
                   $"fantasia = '{_company.GetDataCompany().FantasyName}', " +
                   $"natureza_juridica = '{_company.GetDataCompany().JudicialNature}', " +
                   $"logradouro = '{_company.GetDataCompany().Street}', " +
                   $"numero = '{_company.GetDataCompany().Number}', " +
                   $"complemento = '{_company.GetDataCompany().Complement}', " +
                   $"cep = '{_company.GetDataCompany().ZipCode}', " +
                   $"bairro = '{_company.GetDataCompany().Neighborhood}', " +
                   $"municipio = '{_company.GetDataCompany().City}', " +
                   $"porte = '{_company.GetDataCompany().Size}', " +
                   $"uf = '{_company.GetDataCompany().State}', " +
                   $"email = '{_company.GetDataCompany().Email}', " +
                   $"telefone = '{_company.GetDataCompany().Telephone}', " +
                   $"efr = '{_company.GetDataCompany().ResponsibleFederativeEntity}', " +
                   $"situacao = '{_company.GetDataCompany().Situation}', " +
                   $"data_stuacao = '{_company.GetDataCompany().DateSituation}', " +
                   $"motivo_situacao = '{_company.GetDataCompany().ReasonSituation}', " +
                   $"situacao_especial = '{_company.GetDataCompany().SpecialSituation}', " +
                   $"data_situacao_especial = '{_company.GetDataCompany().DateSpecialSituation}', " +
                   $"capital_social = '{_company.GetDataCompany().SocialCapital}' " +
                   $"where cnpj = '{cnpjFormatted}'";
            _dal.ExecuteSqlCommand(_sql);
        }
コード例 #3
0
        public override ICompany ConsultCompany(string cnpj)
        {
            string cnpjFormatted = FormatCnpjCpf.FormatCnpj(cnpj);

            _sql = $"select * from empresas where cnpj = '{cnpjFormatted}'";
            DataTable data = _dal.ReturnDataTable(_sql);

            _company.SetDataCompany
                (data.Rows[0]["cnpj"].ToString(),
                data.Rows[0]["type"].ToString(),
                data.Rows[0]["size"].ToString(),
                data.Rows[0]["opening"].ToString(),
                data.Rows[0]["name"].ToString(),
                data.Rows[0]["fantasyName"].ToString(),
                data.Rows[0]["judicialNature"].ToString(),
                data.Rows[0]["street"].ToString(),
                data.Rows[0][" number"].ToString(),
                data.Rows[0]["complement"].ToString(),
                data.Rows[0]["zipCode"].ToString(),
                data.Rows[0]["neighborhood"].ToString(),
                data.Rows[0]["city"].ToString(),
                data.Rows[0]["state"].ToString(),
                data.Rows[0]["email"].ToString(),
                data.Rows[0]["telephone"].ToString(),
                data.Rows[0]["responsibleFederativeEntity"].ToString(),
                data.Rows[0]["situation"].ToString(),
                data.Rows[0]["dateSituation"].ToString(),
                data.Rows[0]["reasonSituation"].ToString(),
                data.Rows[0]["specialSituation"].ToString(),
                data.Rows[0]["dateSpecialSituation"].ToString(),
                data.Rows[0]["socialCapital"].ToString(),
                data.Rows[0]["lastUpdate"].ToString()
                );
            return(_company);
        }
コード例 #4
0
        public IActionResult RegisterCompany()
        {
            string cnpj            = FormatCnpjCpf.WithoutFormat(TempData["CompanyModel"] as string);
            var    objCompany      = new ConnectionReceitaws(new CompanyModel());
            var    registerCompany = new MySqlQueries(new CompanyModel());

            registerCompany.RegisterCompany(objCompany.GetCompanyData(cnpj));

            return(View());
        }
コード例 #5
0
        public Boolean logar(String Login, String Senha)
        {
            if (VerificarSeCpfOuCnpj.verificar(Login))
            {                                               //Se for cpf ou cnpj preparar dado para pesquisar no banco
                Login = FormatCnpjCpf.SemFormatacao(Login); //tirando pontos
                if (Login.Length == 11)                     //formatando de acordo com o tipo
                {
                    Login = FormatCnpjCpf.FormatCPF(Login);
                }
                else
                {
                    Login = FormatCnpjCpf.FormatCNPJ(Login);
                }
            }

            String[] info = new LoginBD().Logar(Login, Senha).ToArray(); //fazendo pesquisa no banco
            if (info.Length < 2)
            {                                                            //se retornar apenas um dado
                ControlViews.tipoDeAcesso = info[0];
                return(false);
            }
            else
            {//se retornar os dados corretamente
                ControlViews.tipoDeAcesso = info[0];
                if (ControlViews.tipoDeAcesso.Equals("funcionario"))
                {
                    ControlViews.idFunc = info[1];
                    ControlViews.cpf    = info[2];
                    ControlViews.adm    = Convert.ToBoolean(info[3]);
                    ControlViews.cnpj   = info[4];
                }
                else if (ControlViews.tipoDeAcesso.Equals("instituicao"))
                {
                    ControlViews.cnpj = info[1];
                }
                return(true);
            }
        }