public JsonResult ClienteList(int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
        {
            try
            {
                var qtd       = 0;
                var campo     = string.Empty;
                var crescente = string.Empty;
                var array     = jtSorting.Split(' ');

                if (array.Length > 0)
                {
                    campo = array[0];
                }

                if (array.Length > 1)
                {
                    crescente = array[1];
                }

                var clientes = _bo.Pesquisa(jtStartIndex, jtPageSize, campo,
                                            crescente.Equals("ASC", StringComparison.InvariantCultureIgnoreCase), out qtd);
                return(Json(new { Result = "OK", Records = clientes, TotalRecordCount = qtd }));
            }
            catch (Exception ex)
            {
                return(Json(new { Result = "ERROR", ex.Message }));
            }
        }
예제 #2
0
        public JsonResult Alterar(ClienteModel model)
        {
            if (!this.ModelState.IsValid)
            {
                List <string> erros = (from item in ModelState.Values
                                       from error in item.Errors
                                       select error.ErrorMessage).ToList();

                Response.StatusCode = 400;
                return(Json(string.Join(Environment.NewLine, erros)));
            }
            else
            {
                CPFValidateReturn cpfValid = CpfValidate.ValidateCpf(model.CPF);

                if (!cpfValid.IsValid)
                {
                    Response.StatusCode = 400;
                    return(Json(string.Join(Environment.NewLine, cpfValid.Message)));
                }

                BoCliente bo       = new BoCliente();
                int       qtd      = 0;
                var       clientes = bo.Pesquisa(0, 5, "Nome", "ASC".Equals("ASC", StringComparison.InvariantCultureIgnoreCase), out qtd);
                if (clientes.Where(c => c.Id != model.Id && c.CPF == model.CPF).Count() >= 1)
                {
                    Response.StatusCode = 400;
                    return(Json(string.Join(Environment.NewLine, "Esse CPF já existe em outro cliente!")));
                }

                bo.Alterar(new Cliente()
                {
                    Id            = model.Id,
                    CEP           = model.CEP,
                    Cidade        = model.Cidade,
                    Email         = model.Email,
                    Estado        = model.Estado,
                    Logradouro    = model.Logradouro,
                    Nacionalidade = model.Nacionalidade,
                    Nome          = model.Nome,
                    Sobrenome     = model.Sobrenome,
                    Telefone      = model.Telefone,
                    CPF           = model.CPF
                });

                return(Json("Cadastro alterado com sucesso"));
            }
        }