public bool AtualizarProfissional(Profissionals profissionalObj)
{
Connection();
int i;
using (SqlCommand command = new SqlCommand("AtualizarProfissional", _con))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ProfissionalId", profissionalObj.ProfissionalId);
command.Parameters.AddWithValue("@Profissional", profissionalObj.Profissional);
command.Parameters.AddWithValue("@CPF", profissionalObj.CPF);
command.Parameters.AddWithValue("@DataAdmissao", profissionalObj.DataAdmissao);
command.Parameters.AddWithValue("@DataNascimento", profissionalObj.DataNascimento);
command.Parameters.AddWithValue("@Salario", profissionalObj.Salario);
command.Parameters.AddWithValue("@Status", "ATIVO");
_con.Open();
i = command.ExecuteNonQuery();
}
_con.Close();
return(i >= 1);
}
public List <Profissionals> ObterProfissional()
{
Connection();
List <Profissionals> profissionalsList = new List <Profissionals>();
using (SqlCommand command = new SqlCommand("ObterProfissional", _con))
{
command.CommandType = CommandType.StoredProcedure;
_con.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Profissionals profissional = new Profissionals()
{
ProfissionalId = Convert.ToInt32(reader["ProfissionalId"]),
Profissional = Convert.ToString(reader["Profissional"]),
CPF = Convert.ToString(reader["CPF"]),
DataAdmissao = Convert.ToString(reader["DataAdmissao"]),
DataNascimento = Convert.ToString(reader["DataNascimento"]),
Salario = Convert.ToString(reader["Salario"])
};
profissionalsList.Add(profissional);
}
_con.Close();
return(profissionalsList);
}
}
public ActionResult AtualizarProfissional(int id, Profissionals profissionalObj)
{
try
{
_repositorio = new ProfissionalRepositorio();
_repositorio.AtualizarProfissional(profissionalObj);
return(RedirectToAction("ObterProfissional"));
}
catch (Exception e)
{
var ja = e.Message;
return(View("ObterProfissional"));
}
}
public ActionResult IncluirProfissional(Profissionals profissionalObj)
{
try
{
if (ModelState.IsValid)
{
_repositorio = new ProfissionalRepositorio();
if (_repositorio.AdicionarProfissional(profissionalObj))
{
ViewBag.Mensagem = "O profissional foi cadastrado com sucesso!";
}
}
return(RedirectToAction("ObterProfissional"));
}
catch (Exception)
{
return(View("ObterProfissional"));
}
}
