public IActionResult PostAtendente([FromForm] AtendenteViewModel request)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Attendant (AttendantName, AttendantCpf, AttendantEmail, AttendantPass) VALUES(@AttendantName, @AttendantCpf, @AttendantEmail, @AttendantPass)", conn))
{
cmd.Parameters.AddWithValue("@AttendantName", request.AttendantName);
cmd.Parameters.AddWithValue("@AttendantCpf", request.AttendantCpf);
cmd.Parameters.AddWithValue("@AttendantEmail", request.AttendantEmail);
cmd.Parameters.AddWithValue("@AttendantPass", request.AttendantPass);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("CadastrarAtendente"));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
public IActionResult Login([FromForm] string AttendantEmail, string AttendantPass)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
AtendenteViewModel AtendenteViewModel = new AtendenteViewModel();
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("SELECT AttendantEmail, AttendantPass FROM Attendant WHERE AttendantEmail LIKE '%" + AttendantEmail + "%' AND AttendantPass LIKE '%" + AttendantPass + "%'", conn))
{
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
if (!dataReader.IsDBNull(0) && !dataReader.IsDBNull(1))
{
return(RedirectToAction("BuscarCpf"));
}
}
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
public async Task <IActionResult> Create(AtendenteViewModel atendenteViewModel)
{
if (!ModelState.IsValid)
{
return(View(atendenteViewModel));
}
await _atendenteRepository.Adicionar(_mapper.Map <Atendente>(atendenteViewModel));
return(RedirectToAction(nameof(Index)));
}
public async Task <IActionResult> Edit(Guid id, AtendenteViewModel atendenteViewModel)
{
if (id != atendenteViewModel.Id)
{
return(NotFound());
}
if (!ModelState.IsValid)
{
return(View(atendenteViewModel));
}
var atentende = _mapper.Map <Atendente>(atendenteViewModel);
await _atendenteRepository.Atualizar(atentende);
return(RedirectToAction(nameof(Index)));
}
public IActionResult CadastrarAtendente()
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
AtendenteViewModel AtendenteViewModel = new AtendenteViewModel();
try
{
conn.Open();
return(View(new AtendenteViewModel {
}));
}
catch (Exception ex)
{
return(View(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
