public ActionResult Cadastrar(DependenteViewModel dep)
{
_unit.DependenteRepository.Cadastrar(dep.Dependente);
_unit.Salvar();
TempData["msg"] = "Dependente cadastrado!";
return(RedirectToAction("Cadastrar"));
}
public IActionResult Main()
{
if (_dataService.VerificarSecao())
{
UsuarioViewModel usuarioViewModel;
var usuario = _dataService.ObterUsuarioSessao();
if (_dataService.TipoCliente(usuario) != "Dependente")
{
usuarioViewModel = new ClienteViewModel((Cliente)usuario);
}
else
{
usuarioViewModel = new DependenteViewModel(_dataService.ObterDependente(usuario.Id));
}
if (!DefaultFactory._mensagemViewModel.SemMensagem())
{
ViewBag.TipoMensagem = DefaultFactory._mensagemViewModel.Tipo;
ViewBag.Mensagem = DefaultFactory._mensagemViewModel.Mensagem;
DefaultFactory._mensagemViewModel.Dispose();
}
ViewBag.ListaPendenciaViewModel = _dataService.ListarPendenciasUsuarioLogado();
ViewBag.DicionarioClassificacao = _dataService.PrepararClassificacaoViewModel();
ViewBag.ListaGenero = _dataService.PrepararGeneroViewModel();
return(View(usuarioViewModel));
}
else
{
return(RedirectToAction("Index"));
}
}
public IActionResult PostDependente([FromForm] DependenteViewModel request)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Dependent (DependentName, DependentBirth, DependentBlood, DependentAllergy, DependentSusNo, User_UserID) VALUES(@DependentName, @DependentBirth, @DependentBlood, @DependentAllergy, @DependentSusNo, @User_UserID)", conn))
{
cmd.Parameters.AddWithValue("@DependentName", request.DependentName);
cmd.Parameters.AddWithValue("@DependentBirth", request.DependentBirth);
cmd.Parameters.AddWithValue("@DependentBlood", request.DependentBlood);
cmd.Parameters.AddWithValue("@DependentAllergy", request.DependentAllergy);
cmd.Parameters.AddWithValue("@DependentSusNo", request.DependentSus);
cmd.Parameters.AddWithValue("@User_UserID", request.ResponsavelID);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("BuscarCpf"));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
public async Task <IActionResult> Edit(Guid id, DependenteViewModel dependenteViewModel)
{
if (id != dependenteViewModel.Id)
{
return(NotFound());
}
var dependeteAtualizacao = await ObterDependente(id);
dependenteViewModel.Funcionario = dependeteAtualizacao.Funcionario;
if (!ModelState.IsValid)
{
return(View(dependenteViewModel));
}
dependeteAtualizacao.Nome = dependenteViewModel.Nome;
dependeteAtualizacao.CPF = dependenteViewModel.CPF;
dependeteAtualizacao.Nascimento = dependenteViewModel.Nascimento;
dependeteAtualizacao.Sexo = dependenteViewModel.Sexo;
await _dependenteService.Atualizar(_mapper.Map <Dependente>(dependeteAtualizacao));
if (!OperacaoValida())
{
return(View(dependenteViewModel));
}
TempData["Sucesso"] = "Dependente editado com sucesso!";
return(RedirectToAction("Index"));
}
public ActionResult Incluir([DataSourceRequest] DataSourceRequest request, DependenteViewModel item)
{
if (ModelState.IsValid)
{
try
{
Dependente dados = Mapper.Map <Dependente>(item);
_repositorio.Inserir(dados);
_contexto.SaveChanges();
item.PessoaId = dados.PessoaId;
}
catch (Exception erro)
{
if (erro.InnerException.InnerException.Message.Contains("IdxNome"))
{
ModelState.AddModelError("", "O nome já foi incluído.");
}
_contexto.Rollback();
return(Json(ModelState.ToDataSourceResult()));
}
}
return(Json(new[] { item }.ToDataSourceResult(request)));
}
public ActionResult Cadastrar()
{
var viewModel = new DependenteViewModel();
var lista = _unit.ResponsavelRepository.Listar();
viewModel.Responsaveis =
new SelectList(lista, "ResponsavelId", "Nome");
return(View(viewModel));
}
public ActionResult Create(DependenteViewModel dependente, int PessoaId)
{
if (ModelState.IsValid)
{
var dependenteDomain = Mapper.Map <DependenteViewModel, Dependente>(dependente);
dependenteDomain.PessoaId = PessoaId;
_depApp.Add(dependenteDomain);
return(RedirectToAction("Index", "Dependente", new { id = PessoaId }));
}
ViewBag.SexoId = new SelectList(_sexoApp.GetAll(), "Id", "Descricao", dependente.SexoId);
ViewBag.GrauInstrucaoId = new SelectList(_grauInstrucaoApp.GetAll(), "Id", "Descricao", dependente.GrauInstrucaoId);
return(View(dependente));
}
public ActionResult Edit(DependenteViewModel dependente)
{
if (ModelState.IsValid)
{
var dependenteDomain = Mapper.Map <DependenteViewModel, Dependente>(dependente);
_depApp.Update(dependenteDomain);
return(RedirectToAction("Index"));
}
ViewBag.SexoId = new SelectList(_sexoApp.GetAll(), "Id", "Descricao", dependente.SexoId);
ViewBag.GrauInstrucaoId = new SelectList(_grauInstrucaoApp.GetAll(), "Id", "Descricao", dependente.GrauInstrucaoId);
return(View(dependente));
}
public ActionResult Excluir([DataSourceRequest] DataSourceRequest request, DependenteViewModel item)
{
try
{
_contexto.Dependentes.Remove(_contexto.Dependentes.Find(item.PessoaId));
_contexto.SaveChanges();
ModelState.IsValidField("true");
}
catch (Exception erro)
{
ModelState.IsValidField("false");
ModelState.AddModelError("", erro.Message);
_contexto.Rollback();
}
return(Json(ModelState.ToDataSourceResult()));
}
public ActionResult <FuncionarioViewModel> Post(int id, [FromBody] DependenteViewModel dependenteViewModel)
{
if (dependenteViewModel == null)
{
return(BadRequest(new { mensagem = "Informações inválidas." }));
}
if (dependenteViewModel.CPF.Length != 11)
{
return(BadRequest(new { mensagem = "CPF inválido." }));
}
var dependente = dependenteViewModel.SetDependente();
_funcionarioServico.InserirDependente(id, dependente);
return(CreatedAtAction(nameof(GetDependentes), new { id }, dependenteViewModel));
}
public ActionResult Atualizar([DataSourceRequest] DataSourceRequest request, DependenteViewModel item)
{
if (ModelState.IsValid)
{
try
{
Dependente dados = Mapper.Map <Dependente>(item);
dados = _repositorio.Atualizar(dados);
_contexto.Commit();
}
catch (Exception erro)
{
ModelState.AddModelError("", erro.Message);
_contexto.Rollback();
}
}
return(Json(ModelState.ToDataSourceResult()));
}
public async Task <IActionResult> Create(DependenteViewModel dependenteViewModel)
{
dependenteViewModel = await PopularFuncionarios(dependenteViewModel);
if (!ModelState.IsValid)
{
return(View(dependenteViewModel));
}
await _dependenteService.Adicionar(_mapper.Map <Dependente>(dependenteViewModel));
if (!OperacaoValida())
{
return(View(dependenteViewModel));
}
TempData["Sucesso"] = "Dependente adicionado com sucesso!";
return(RedirectToAction("Index"));
}
/// <summary>
/// Inserir um Dependente
/// </summary>
/// <param name="dependente">Dependente</param>
/// <returns></returns>
public ActionResult InsertDependente(DependenteViewModel dependente)
{
try
{
var dependenteDomain = Mapper.Map <DependenteViewModel, Dependente>(dependente);
if (dependente.DependenteId > 0)
{
_dependenteApp.Update(dependenteDomain);
}
else
{
_dependenteApp.Add(dependenteDomain);
}
return(Json(dependenteDomain, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { erro = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public IActionResult CadastrarDependente(int id)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
DependenteViewModel DependenteViewModel = new DependenteViewModel();
ResponsavelViewModel Responsavel = new ResponsavelViewModel();
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("SELECT UserID, UserName, UserCpf, UserEmail FROM User WHERE UserID =" + id, conn))
{
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
Responsavel.ResponsavelID = dataReader.GetInt32(0);
Responsavel.ResponsavelName = dataReader.GetString(1);
Responsavel.ResponsavelCpf = dataReader.GetString(2);
Responsavel.ResponsavelEmail = dataReader.GetString(3);
}
}
ViewData["ResponsavelID"] = Responsavel;
return(View(new DependenteViewModel {
}));
}
catch (Exception ex)
{
return(View(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
public async Task <ActionResult> Dependentes(DependenteViewModel dependente)
{
try
{
using (var c = new HttpClient())
{
string u = HttpContext.Request.Url.Host + ":" + HttpContext.Request.Url.Port;
c.BaseAddress = new Uri("http://" + u);
c.DefaultRequestHeaders.Accept.Clear();
c.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage res = await c.PostAsJsonAsync("/api/Dependentes", dependente);
ViewBag.Success = "Inserido com sucesso!";
return(View());
}
}
catch
{
ViewBag.Success = "Ocorreu um erro...";
return(View());
}
}
private async Task <DependenteViewModel> PopularFuncionarios(DependenteViewModel dependente)
{
dependente.Funcionarios = _mapper.Map <IEnumerable <FuncionarioViewModel> >(await _funcionarioRepository.ObterTodos());
return(dependente);
}
public override AssociadoViewModel MapToRepository(Associado entity)
{
App_Dominio.Security.EmpresaSecurity <App_Dominio.Entidades.SecurityContext> security = new App_Dominio.Security.EmpresaSecurity <App_Dominio.Entidades.SecurityContext>();
Sessao sessaoCorrente = security.getSessaoCorrente();
if (sessaoCorrente != null && sessaoCorrente.value1 != "0")
{
if (entity.associadoId != int.Parse(sessaoCorrente.value1))
{
return new AssociadoViewModel()
{
mensagem = new Validate()
{
Code = 202
}
}
}
;
}
AssociadoViewModel value = new AssociadoViewModel()
{
associadoId = entity.associadoId,
torreId = entity.torreId,
unidadeId = entity.unidadeId,
apto = entity.torreId + entity.unidadeId.ToString(),
nome = entity.nome,
ind_proprietario = entity.ind_proprietario,
ind_proprietario_confirmacao = entity.ind_proprietario_confirmacao,
dt_nascimento = entity.dt_nascimento,
cpf_cnpj = entity.cpf_cnpj,
rg = entity.rg,
orgaoEmissor = entity.orgaoEmissor,
sexo = entity.sexo,
ind_est_civil = entity.ind_est_civil,
empresa = entity.empresa,
enderecoCom = entity.enderecoCom,
complementoEndCom = entity.complementoEndCom,
cepCom = entity.cepCom,
cidadeComId = entity.cidadeComId,
nome_cidadeCom = entity.cidadeComId != null?db.Cidades.Find(entity.cidadeComId).nome : null,
ufCom = entity.ufCom,
bairroCom = entity.bairroCom,
telParticular1 = entity.telParticular1,
telParticular2 = entity.telParticular2,
telParticular3 = entity.telParticular3,
telParticular4 = entity.telParticular4,
areaAtuacaoId = entity.areaAtuacaoId,
descricao_areaAtuacao = entity.areaAtuacaoId != null?db.AreaAtuacaos.Find(entity.areaAtuacaoId).descricao : null,
email1 = entity.email1,
usuarioId = entity.usuarioId,
observacao = entity.observacao,
nome_contato = entity.nome_contato,
dt_inicio = entity.dt_inicio,
dt_fim = entity.dt_fim,
ind_animal = entity.ind_animal,
dt_cadastro = entity.dt_cadastro,
avatar = entity.avatar,
Veiculos = new List <VeiculoViewModel>(),
Dependentes = new List <DependenteViewModel>(),
Funcionarios = new List <FuncionarioViewModel>(),
mensagem = new Validate()
{
Code = 0, Message = "Registro incluído com sucesso !"
}
};
IList <VeiculoViewModel> Veiculos = new List <VeiculoViewModel>();
IList <DependenteViewModel> Dependentes = new List <DependenteViewModel>();
IList <FuncionarioViewModel> Funcionarios = new List <FuncionarioViewModel>();
foreach (Veiculo v in entity.Veiculos)
{
VeiculoViewModel v1 = new VeiculoViewModel()
{
associadoId = entity.associadoId,
placa = v.placa,
cor = v.cor,
descricao = v.descricao,
marca = v.marca,
condutor = v.condutor,
num_serie = v.num_serie
};
Veiculos.Add(v1);
}
;
foreach (Dependente d in entity.Dependentes)
{
DependenteViewModel d1 = new DependenteViewModel()
{
associadoId = entity.associadoId,
dependenteId = d.dependenteId,
nome = d.nome,
email = d.email,
tx_relacao_associado = d.tx_relacao_associado,
sexo = d.sexo
};
Dependentes.Add(d1);
}
;
foreach (Funcionario f in entity.Funcionarios)
{
FuncionarioViewModel f1 = new FuncionarioViewModel()
{
associadoId = entity.associadoId,
funcionarioId = f.funcionarioId,
nome = f.nome.ToUpper(),
funcao = f.funcao,
sexo = f.sexo.ToUpper(),
rg = f.rg,
dia_semana = f.dia_semana,
dom = f.dia_semana.Substring(0, 1),
seg = f.dia_semana.Substring(1, 1),
ter = f.dia_semana.Substring(2, 1),
qua = f.dia_semana.Substring(3, 1),
qui = f.dia_semana.Substring(4, 1),
sex = f.dia_semana.Substring(5, 1),
sab = f.dia_semana.Substring(6, 1),
horario_ini = f.horario_ini,
horario_fim = f.horario_fim
};
Funcionarios.Add(f1);
}
;
value.Veiculos = Veiculos;
value.Dependentes = Dependentes;
value.Funcionarios = Funcionarios;
return(value);
}
public IActionResult ImportaClienteDep(IFormFile importExcel)
{
ClienteViewModel cli = new ClienteViewModel();
if (importExcel == null || importExcel.Length == 0)
{
return(View());
}
MemoryStream memoryStream = new MemoryStream();
importExcel.CopyToAsync(memoryStream).ConfigureAwait(false);
ExcelPackage package = new ExcelPackage(memoryStream);
for (int i = 1; i <= package.Workbook.Worksheets.Count; i++)
{
var totalRows = package.Workbook.Worksheets[i].Dimension?.Rows;
var totalCollumns = package.Workbook.Worksheets[i].Dimension?.Columns;
for (int j = 1; j <= totalRows; j++)
{
for (int k = 1; k <= totalCollumns.Value; k++)
{
cli.CPF = package.Workbook.Worksheets[i].Cells[j, k].Value == null ? "x" : package.Workbook.Worksheets[i].Cells[j, k].Value.ToString();
cli.Nome = package.Workbook.Worksheets[i].Cells[j, 2].Value == null ? "x" : package.Workbook.Worksheets[i].Cells[j, 2].Value.ToString();
cli.DataNasc = Convert.ToDateTime(package.Workbook.Worksheets[i].Cells[j, 3].Value) == null ? DateTime.Now : Convert.ToDateTime(package.Workbook.Worksheets[i].Cells[j, 3].Value);
cli.Sexo = package.Workbook.Worksheets[i].Cells[j, 4].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 4].Value.ToString();
cli.EstadoCivil = package.Workbook.Worksheets[i].Cells[j, 5].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 5].Value.ToString();
cli.Endereco.Logradouro = package.Workbook.Worksheets[i].Cells[j, 6].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 6].Value.ToString();
cli.Endereco.Numero = package.Workbook.Worksheets[i].Cells[j, 7].Value == null ? "001" : package.Workbook.Worksheets[i].Cells[j, 7].Value.ToString();
cli.Endereco.Complemento = package.Workbook.Worksheets[i].Cells[j, 8].Value == null ? "Rua" : package.Workbook.Worksheets[i].Cells[j, 8].Value.ToString();
cli.Endereco.Bairro = package.Workbook.Worksheets[i].Cells[j, 9].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 9].Value.ToString();
cli.Endereco.Cidade = package.Workbook.Worksheets[i].Cells[j, 10].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 10].Value.ToString();
cli.Endereco.Estado = package.Workbook.Worksheets[i].Cells[j, 11].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 11].Value.ToString();
cli.Endereco.CEP = package.Workbook.Worksheets[i].Cells[j, 12].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 12].Value.ToString();
var ddd = package.Workbook.Worksheets[i].Cells[j, 13].Value == null ? "00" : package.Workbook.Worksheets[i].Cells[j, 13].Value.ToString();
cli.Fone = package.Workbook.Worksheets[i].Cells[j, 14].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 14].Value.ToString();
cli.RG = package.Workbook.Worksheets[i].Cells[j, 15].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 15].Value.ToString();
cli.OrgaoExpedidor = package.Workbook.Worksheets[i].Cells[j, 16].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 16].Value.ToString();
cli.Email = package.Workbook.Worksheets[i].Cells[j, 17].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 17].Value.ToString();
cli.CodigoProf = Convert.ToInt32(package.Workbook.Worksheets[i].Cells[j, 18].Value) == null ? 1 : Convert.ToInt32(package.Workbook.Worksheets[i].Cells[j, 18].Value);
cli.PPE = package.Workbook.Worksheets[i].Cells[j, 19].Value == null ? "nao" : package.Workbook.Worksheets[i].Cells[j, 19].Value.ToString();
if (cli.PPE == "Não")
{
cli.PPE = "nao";
}
cli.Ocupacao = package.Workbook.Worksheets[i].Cells[j, 20].Value == null ? "" : cli.Ocupacao = package.Workbook.Worksheets[i].Cells[j, 20].Value.ToString();
cli.FuncionarioId = FuncionarioId;
k = 99;
cli.Fone = ddd + cli.Fone;
cli.Celular = cli.Fone;
if (cli.Endereco.Complemento == " ")
{
cli.Endereco.Complemento = "Rua";
}
if (cli.CPF.Length == 10)
{
cli.CPF = 0 + cli.CPF;
}
if (cli.CPF.Length == 9)
{
cli.CPF = 00 + cli.CPF;
}
if (cli.CPF.Length == 8)
{
cli.CPF = 000 + cli.CPF;
}
if (cli.Endereco.CEP.Length == 7)
{
cli.Endereco.CEP = 0 + cli.Endereco.CEP;
}
if (cli.Endereco.CEP.Contains("-"))
{
var x = cli.Endereco.CEP.Split("-");
var cep = x[0] + x[1];
cli.Endereco.CEP = cep;
}
var cepSemEspaco = cli.Endereco.CEP.Replace(" ", "");
cli.Endereco.CEP = cepSemEspaco;
ClienteViewModel cliente = new ClienteViewModel();
cliente = _clienteAppService.ObterPorCpf(cli.CPF);
if (cliente != null)
{
//_clienteAppService.Atualizar(cliente);
cliente.Id = Guid.NewGuid();
}
else
{
cli.Id = Guid.NewGuid();
_clienteAppService.Registrar(cli);
DependenteViewModel dep1 = new DependenteViewModel();
DependenteViewModel dep2 = new DependenteViewModel();
DependenteViewModel dep3 = new DependenteViewModel();
DependenteViewModel dep4 = new DependenteViewModel();
dep1.Nome = package.Workbook.Worksheets[i].Cells[j, 21].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 21].Value.ToString();
dep1.Parentesco = package.Workbook.Worksheets[i].Cells[j, 22].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 22].Value.ToString();
dep1.Participacao = package.Workbook.Worksheets[i].Cells[j, 23].Value == null ? 0 : Convert.ToDecimal(package.Workbook.Worksheets[i].Cells[j, 23].Value);
dep2.Nome = package.Workbook.Worksheets[i].Cells[j, 24].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 24].Value.ToString();
dep2.Parentesco = package.Workbook.Worksheets[i].Cells[j, 25].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 25].Value.ToString();
dep2.Participacao = package.Workbook.Worksheets[i].Cells[j, 26].Value == null ? 0 : Convert.ToDecimal(package.Workbook.Worksheets[i].Cells[j, 26].Value);
dep3.Nome = package.Workbook.Worksheets[i].Cells[j, 27].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 27].Value.ToString();
dep3.Parentesco = package.Workbook.Worksheets[i].Cells[j, 28].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 28].Value.ToString();
dep3.Participacao = package.Workbook.Worksheets[i].Cells[j, 29].Value == null ? 0 : Convert.ToDecimal(package.Workbook.Worksheets[i].Cells[j, 29].Value);
dep4.Nome = package.Workbook.Worksheets[i].Cells[j, 30].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 30].Value.ToString();
dep4.Parentesco = package.Workbook.Worksheets[i].Cells[j, 31].Value == null ? "" : package.Workbook.Worksheets[i].Cells[j, 31].Value.ToString();
dep4.Participacao = package.Workbook.Worksheets[i].Cells[j, 32].Value == null ? 0 : Convert.ToDecimal(package.Workbook.Worksheets[i].Cells[j, 32].Value);
List <DependenteViewModel> deps = new List <DependenteViewModel>();
deps.Add(dep1);
deps.Add(dep2);
deps.Add(dep3);
deps.Add(dep4);
foreach (var item in deps)
{
if (item.Nome != "")
{
item.Id = Guid.NewGuid();
item.ClienteId = cliente == null ? cli.Id : cliente.Id;
_clienteAppService.AdicionarDependente(item);
item.Id = Guid.NewGuid();
}
}
}
cli.Id = Guid.NewGuid();
cli.Endereco.Id = Guid.NewGuid();
}
}
}
//IEnumerable<ProfissaoViewModel> cli = new List<ProfissaoViewModel>();
//cli = _clienteAppService.ObterProfissoes();
//ViewBag.ListClientes = cli;
//clienteViewModel.CPF = CPFX;
//if (!ModelState.IsValid) return View(clienteViewModel);
//var cpf = _clienteAppService.ObterPorCpf(clienteViewModel.CPF);
//if (cpf != null)
//{
// cli = _clienteAppService.ObterProfissoes();
// ViewBag.ListClientes = cli;
// return View(clienteViewModel);
//}
//var profissao = _clienteAppService.ObterProfissaoPorId(Convert.ToInt32(clienteViewModel.Ocupacao));
//clienteViewModel.Ocupacao = profissao.profdesc;
//clienteViewModel.CodigoProf = Convert.ToInt32(profissao.profcod);
//clienteViewModel.FuncionarioId = FuncionarioId;
//_clienteAppService.Registrar(clienteViewModel);
ViewBag.RetornoPost = OperacaoValida() ? "succes, Cliente Registrado com Sucesso!" : "error, Cliente não pode ser Registrado, verifique as mensagens";
if (OperacaoValida())
{
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public IActionResult ImportaDependentes(IFormFile importExcel)
{
DependenteViewModel cli = new DependenteViewModel();
if (importExcel == null || importExcel.Length == 0)
{
return(View());
}
using (var memoryStream = new MemoryStream())
{
importExcel.CopyToAsync(memoryStream).ConfigureAwait(false);
using (var package = new ExcelPackage(memoryStream))
{
for (int i = 1; i <= package.Workbook.Worksheets.Count; i++)
{
var totalRows = package.Workbook.Worksheets[i].Dimension?.Rows;
var totalCollumns = package.Workbook.Worksheets[i].Dimension?.Columns;
for (int j = 1; j <= totalRows; j++)
{
for (int k = 1; k <= totalCollumns.Value; k++)
{
var cpf = package.Workbook.Worksheets[i].Cells[j, k].Value == null ? "x" : package.Workbook.Worksheets[i].Cells[j, k].Value.ToString();
cli.Nome = package.Workbook.Worksheets[i].Cells[j, 2].Value == null ? "x" : package.Workbook.Worksheets[i].Cells[j, 2].Value.ToString();
cli.Parentesco = package.Workbook.Worksheets[i].Cells[j, 3].Value == null ? "x" : package.Workbook.Worksheets[i].Cells[j, 3].Value.ToString();
cli.Participacao = package.Workbook.Worksheets[i].Cells[j, 4].Value == null ? 0 : Convert.ToDecimal(package.Workbook.Worksheets[i].Cells[j, 4].Value);
if (cpf.Length == 10)
{
cpf = 0 + cpf;
}
k = 21;
ClienteViewModel cliente = new ClienteViewModel();
cliente = _clienteAppService.ObterPorCpf(cpf);
if (cliente != null)
{
cli.ClienteId = cliente.Id;
_clienteAppService.AdicionarDependente(cli);
}
cli.Id = Guid.NewGuid();
}
}
}
}
}
ViewBag.RetornoPost = OperacaoValida() ? "succes, Cliente Registrado com Sucesso!" : "error, Cliente não pode ser Registrado, verifique as mensagens";
if (OperacaoValida())
{
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public void AdicionarDependente(DependenteViewModel dependenteViewModel)
{
var dependenteCommand = _mapper.Map <IncluirDependenteClienteCommand>(dependenteViewModel);
_bus.SendCommand(dependenteCommand);
}
public void AtualizarDependente(DependenteViewModel dependenteViewModel)
{
throw new NotImplementedException();
}
