public override async Task <Command> GetAll(Command command) { Command cmd = new Command(command); try { var entities = await MyRepository.Get(null, null, "Endereco"); var list = entities.ToList(); if (list.Any()) { cmd.Cmd = ServerCommands.LogResultOk; var dtos = list.Select(t => t.ConvertDto()).ToList(); cmd.Json = await SerializerAsync.SerializeJsonList(dtos); } else { cmd.Cmd = ServerCommands.LogResultDeny; } } catch (Exception e) { ConsoleEx.WriteError(e); } return(cmd); }
public static async Task <Command> GetAllStates(Command command) { Command cmd = new Command(command); try { using (var context = new ZZContext()) { var rep = new Repository <Estado>(context); var entities = await rep.Get(); var list = entities.ToList(); if (list.Any()) { cmd.Cmd = ServerCommands.LogResultOk; var dtos = list.Select(t => t.ConvertDto()).ToList(); cmd.Json = await SerializerAsync.SerializeJsonList(dtos); } else { cmd.Cmd = ServerCommands.LogResultDeny; } } } catch (Exception e) { ConsoleEx.WriteError(e); } return(cmd); }
public static async Task <Command> GetAddress(Command command) { Command cmd = new Command(command); try { using (var context = new ZZContext()) { var dto = await SerializerAsync.DeserializeJson <EnderecoDto>(cmd.Json); var rep = new Repository <Endereco>(context); var enderecos = await rep.Get(e => e.Logradouro.Equals(dto.Logradouro) && e.Numero == dto.Numero); var endList = enderecos.ToList(); if (endList.Any()) { cmd.Cmd = ServerCommands.LogResultOk; var dtosEnd = endList.Select(e => e.ConvertDto()).ToList(); cmd.Json = await SerializerAsync.SerializeJsonList(dtosEnd); } else { var addressList = await SearchAddressAsync(dto.Estado, dto.Cidade, dto.Logradouro, CancellationToken.None); var viaCepResults = addressList.ToList(); if (viaCepResults.Any()) { cmd.Cmd = ServerCommands.LogResultOk; var dtos = viaCepResults.Select(d => new EnderecoDto { Cep = d.ZipCode, Bairro = d.Neighborhood, Cidade = d.City, Estado = d.StateInitials, Logradouro = d.Street, Complemento = d.Complement, Ibge = d.IBGECode, GIACode = d.GIACode, Numero = dto.Numero, Codigo = d.IBGECode.ToString() + d.GIACode.ToString() + d.ZipCode + dto.Numero.ToString() }); cmd.Json = await SerializerAsync.SerializeJsonList(dtos.ToList()); } else { cmd.Cmd = ServerCommands.LogResultDeny; } } } } catch (Exception e) { ConsoleEx.WriteError(e); } return(cmd); }
public static async Task <Command> UpdateEstados(Command command) { Command cmd = new Command(command); try { using (var context = new ZZContext()) { var rep = new Repository <Estado>(context); var entities = await rep.Get(); var list = entities.ToList(); var ibgeList = await SearchEstadoAsync(); if (list.Any() && ibgeList.Any()) { foreach (var estado in ibgeList) { if (list.Exists(e => e.Ibge == estado.Ibge)) { var est = list.Find(e => e.Ibge == estado.Ibge); est.Ibge = estado.Ibge; est.Descricao = estado.Descricao; est.Sigla = estado.Sigla; } } await rep.InsertList(list); await rep.Save(); cmd.Cmd = ServerCommands.LogResultOk; var dtos = list.Select(t => t.ConvertDto()).ToList(); cmd.Json = await SerializerAsync.SerializeJsonList(dtos); } else if (ibgeList.Any()) { await rep.InsertList(ibgeList); await rep.Save(); cmd.Cmd = ServerCommands.LogResultOk; var dtos = ibgeList.Select(t => t.ConvertDto()).ToList(); cmd.Json = await SerializerAsync.SerializeJsonList(dtos); } else { cmd.Cmd = ServerCommands.LogResultDeny; } } } catch (Exception e) { ConsoleEx.WriteError(e); } return(cmd); }
public static async Task <Command> GetCityByUf(Command command) { Command cmd = new Command(command); try { using (var context = new ZZContext()) { var dto = await SerializerAsync.DeserializeJson <TipoSiglaDto>(cmd.Json); var repEstado = new Repository <Estado>(context); var repCity = new Repository <Cidade>(context); var list = await repEstado.Get(e => e.Sigla.Equals(dto.Sigla)); var entity = list.FirstOrDefault(); var cidades = await repCity.Get(c => c.EstadoId == entity.Id); var cidadeList = cidades.ToList(); if (cidadeList.Any()) { cmd.Cmd = ServerCommands.LogResultOk; var dtos = cidadeList.Select(t => t.ConvertDto(dto.Sigla)).ToList(); cmd.Json = await SerializerAsync.SerializeJsonList(dtos); } else { cmd.Cmd = ServerCommands.LogResultDeny; } } } catch (Exception e) { ConsoleEx.WriteError(e); } return(cmd); }
public static async Task <Command> UpdateCidades(Command command) { Command cmd = new Command(command); try { using (var context = new ZZContext()) { var repEstado = new Repository <Estado>(context); var repCity = new Repository <Cidade>(context); var entities = await repEstado.Get(); var list = entities.ToList(); var cidades = await repCity.Get(); var cidadeList = cidades.ToList(); if (list.Any() && cidadeList.Any()) { foreach (var estado in list) { var ibgeCities = await SearchMunicipioAsync(estado.Ibge, estado.Id); foreach (var city in ibgeCities) { if (cidadeList.Exists(c => c.Ibge == city.Ibge)) { var cidade = list.Find(c => c.Ibge == city.Ibge); cidade.Ibge = city.Ibge; cidade.Descricao = city.Descricao; } } } await repCity.InsertList(cidadeList); await repCity.Save(); cmd.Cmd = ServerCommands.LogResultOk; var dtos = cidadeList.Select(t => t.ConvertDto()).ToList(); cmd.Json = await SerializerAsync.SerializeJsonList(dtos); } else if (list.Any()) { foreach (var estado in list) { var ibgeCities = await SearchMunicipioAsync(estado.Ibge, estado.Id); cidadeList.AddRange(ibgeCities); } await repCity.InsertList(cidadeList); await repCity.Save(); cmd.Cmd = ServerCommands.LogResultOk; var dtos = cidadeList.Select(t => t.ConvertDto()).ToList(); cmd.Json = await SerializerAsync.SerializeJsonList(dtos); } else { cmd.Cmd = ServerCommands.LogResultDeny; } } } catch (Exception e) { ConsoleEx.WriteError(e); } return(cmd); }