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));
}
