public void Alterar(ExperienciaViewModel experiencia) { string sql = "update Experiencias set nome_empresa = @nome_empresa, " + "inicio_EXP = @inicio_EXP, " + "fim_EXP = @fim_EXP, " + "cargo_EXP = @cargo_EXP where id_experiencia = @id_experiencia"; HelperDAO.ExecutaSQL(sql, CriaParametros(experiencia)); }
public void Inserir(ExperienciaViewModel experiencia) { string sql = "insert into Experiencias(id_experiencia, id_curriculo_EXP, nome_empresa, inicio_EXP, fim_EXP, cargo_EXP)" + "values (@id_experiencia, @id_curriculo_EXP, @nome_empresa, @inicio_EXP, @fim_EXP, @cargo_EXP)"; HelperDAO.ExecutaSQL(sql, CriaParametros(experiencia)); }
public ActionResult Edit([Bind(Include = "ExperienciaId,NomeEmpresa,Cargo,Anos,CurriculoId")] ExperienciaViewModel experienciaViewModel) { if (ModelState.IsValid) { _experienciaAppServicos.Atualizar(experienciaViewModel); return(RedirectToAction("Index")); } ViewBag.CurriculoId = new SelectList(_curriculoAppServicos.ObterTodos(), "CurriculoId", "Nome", experienciaViewModel.CurriculoId); return(View(experienciaViewModel)); }
private SqlParameter[] CriaParametros(ExperienciaViewModel experiencia) { SqlParameter[] parametros = new SqlParameter[6]; parametros[0] = new SqlParameter("id_experiencia", experiencia.Id); parametros[1] = new SqlParameter("id_curriculo_EXP", experiencia.IdCurriculo); parametros[2] = new SqlParameter("nome_empresa", experiencia.NomeDaEmpresa); parametros[3] = new SqlParameter("inicio_EXP", experiencia.Inicio); parametros[4] = new SqlParameter("fim_EXP", experiencia.Fim); parametros[5] = new SqlParameter("cargo_EXP", experiencia.Cargo); return(parametros); }
public ExperienciaViewModel Atualizar(ExperienciaViewModel experienciaViewModel) { var experiencia = Mapper.Map <ExperienciaViewModel, Experiencia>(experienciaViewModel); var experienciaReturn = _experienciaServico.Atualizar(experiencia); if (experienciaReturn.IsValid()) { Commit(); } return(experienciaViewModel); }
// GET: Experiencias/Details/5 public ActionResult Details(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ExperienciaViewModel experienciaViewModel = _experienciaAppServicos.ObterPorId(id.Value); if (experienciaViewModel == null) { return(HttpNotFound()); } return(View(experienciaViewModel)); }
// GET: Experiencias/Edit/5 public ActionResult Edit(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ExperienciaViewModel experienciaViewModel = _experienciaAppServicos.ObterPorId(id.Value); if (experienciaViewModel == null) { return(HttpNotFound()); } ViewBag.CurriculoId = new SelectList(_curriculoAppServicos.ObterTodos(), "CurriculoId", "Nome", experienciaViewModel.CurriculoId); return(View(experienciaViewModel)); }