public IActionResult Put(int id, [FromBody] ProfessorRequest professorRequest)
{
try
{
var professor = contexto.Professor.Where(x => x.IdPessoa == id)
.FirstOrDefault();
if (professor != null)
{
professor.RegistroAtivo = professorRequest.RegistroAtivo;
}
contexto.Entry(professor).State =
Microsoft.EntityFrameworkCore.EntityState.Modified;
contexto.SaveChanges();
}
catch (Exception ex)
{
return(StatusCode(400, ex.InnerException.Message.FirstOrDefault()));
}
var professorRetorno = contexto.Professor.FirstOrDefault(
x => x.IdPessoa == id
);
ProfessorResponse retorno = new ProfessorResponse()
{
IdPessoa = professorRetorno.IdPessoa,
RegistroAtivo = professorRetorno.RegistroAtivo
};
return(StatusCode(200, retorno));
}
public IActionResult Post([FromBody]
ProfessorRequest professorRequest)
{
var professor = new Professor
{
Id = professorRequest.IdProfessor,
RegistroAtivo = professorRequest.RegistroAtivo
};
contexto.Professor.Add(professor);
contexto.SaveChanges();
var professorRetorno = contexto.Professor.Where
(x => x.Id == professor.Id)
.FirstOrDefault();
ProfessorResponse response = new ProfessorResponse();
if (professorRetorno != null)
{
response.IdProfessor = professorRetorno.Id;
response.RegistroAtivo = professorRetorno.RegistroAtivo;
}
return(StatusCode(200, response));
}
public IEnumerable <ProfessorResponse> GetAllProfessors()
{
List <ProfessorResponse> professors = new List <ProfessorResponse>();
Create();
using (connection)
{
var command = new SqlCommand("SELECT * FROM [dbo].[User] INNER JOIN [dbo].[Professor] ON ProfessorId = [dbo].[Professor].Id; ", connection);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
ProfessorResponse professor = new ProfessorResponse();
professor.Id = Guid.Parse(reader["Id"].ToString());
professor.ProfessorId = Guid.Parse(reader["ProfessorId"].ToString());
professor.FirstName = reader["FirstName"].ToString();
professor.LastName = reader["LastName"].ToString();
professor.Username = reader["Username"].ToString();
professor.Email = reader["Email"].ToString();
professor.University = reader["University"].ToString();
professor.Vocation = reader["Vocation"].ToString();
professor.Department = reader["Department"].ToString();
professors.Add(professor);
}
}
Close();
}
return(professors);
}
public ProfessorResponse GetById(Guid Id)
{
ProfessorResponse professor = new ProfessorResponse();
Create();
using (connection)
{
var command = new SqlCommand("SELECT * FROM [dbo].[User] INNER JOIN [dbo].[Professor] ON ProfessorId = [dbo].[Professor].Id where [dbo].[User].Id=@Id", connection);
command.Parameters.Add("@Id", SqlDbType.UniqueIdentifier);
command.Parameters["@Id"].Value = Id;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
professor.Id = Guid.Parse(reader["Id"].ToString());
professor.ProfessorId = Guid.Parse(reader["ProfessorId"].ToString());
professor.FirstName = reader["FirstName"].ToString();
professor.LastName = reader["LastName"].ToString();
professor.Username = reader["Username"].ToString();
professor.Email = reader["Email"].ToString();
professor.University = reader["University"].ToString();
professor.Vocation = reader["Vocation"].ToString();
professor.Department = reader["Department"].ToString();
}
}
Close();
}
return(professor);
}
public void CarregarCampos(ProfessorResponse professor)
{
nudPrimeiroEmprego.Value = professor.NrAnoPrimeiroEmprego;
dtpFaculdadeInicio.Value = professor.DtFaculdadeInicio;
dtpFaculdadeFim.Value = professor.DtFaculdadeFim;
lblId.Text = professor.IdProfessor.ToString();
dtpNascimento.Value = professor.DtNascimento;
cboContrato.Text = professor.TpContratacao;
txtFaculdade.Text = professor.DsFaculdade;
txtRGEmissao.Text = professor.DsRgEmissor;
txtCvLattes.Text = professor.DsCvLattes;
txtEstadoNasc.Text = professor.DsEstado;
txtTelefone.Text = professor.DsTelefone;
txtCelular.Text = professor.DsCelular;
txtRGOrgao.Text = professor.DsRgOrgao;
txtNome.Text = professor.NmProfessor;
chkAtivo.Checked = professor.BtAtivo;
txtCurso.Text = professor.DsCurso;
txtEmail.Text = professor.DsEmail;
txtLogin.Text = professor.DsLogin;
txtPai.Text = professor.NmPai;
txtMae.Text = professor.NmMae;
txtCpf.Text = professor.DsCpf;
txtRG.Text = professor.DsRg;
panelId.Visible = true;
this.professor = professor;
}
public ProfessorResponse Create(ProfessorCreateRequest request)
{
Guid ID = _professorDao.InsertProfessor(request);
var response = new ProfessorResponse(_userService.Create(request, ID), ID, request.University, request.Department, request.Vocation);
return(response);
}
private void Alterar()
{
ProfessorResponse professor = dgvProfessores.CurrentRow.DataBoundItem as ProfessorResponse;
frmProfessorCadastrar tela = new frmProfessorCadastrar();
frmInicial.Current.OpenScreen(tela);
tela.CarregarCampos(professor);
this.Hide();
}
private void Deletar()
{
ProfessorResponse professor = dgvProfessores.CurrentRow.DataBoundItem as ProfessorResponse;
DialogResult r = MessageBox.Show(@"Tem certeza que deseja remover?", "Remover", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (r == DialogResult.Yes)
{
ProfessorAPI api = new ProfessorAPI();
api.Remover(professor.IdProfessor, professor.IdLogin);
MessageBox.Show(@"Professor Removido com sucesso!", "NSF", MessageBoxButtons.OK, MessageBoxIcon.Information);;
this.ListarTodos();
}
}
//Id=User
public ProfessorResponse Update(Guid Id, ProfessorUpdateRequest request)
{
ProfessorResponse professor = _professorDao.GetById(Id);
if (!string.IsNullOrWhiteSpace(request.Department))
{
professor.Department = request.Department;
}
if (!string.IsNullOrWhiteSpace(request.University))
{
professor.University = request.University;
}
if (!string.IsNullOrWhiteSpace(request.Vocation))
{
professor.Vocation = request.Vocation;
}
Guid ID = _professorDao.UpdateProfessor(Id, _mapper.Map <ProfessorUpdateRequest>(professor));
var response = new ProfessorResponse(_userService.UpdateUser(Id, request), ID, professor.University, professor.Department, professor.Vocation);
return(response);
}
