public async Task <IActionResult> SelectLogin([FromBody] LoginDTO requestBody)
{
try {
using (SGCContext db = new SGCContext())
{
tbl_0001_user Cliente = await db.tbl_0001_user.Where(i => i.email_user == requestBody.email_user && i.senha_user == requestBody.senha_user).FirstOrDefaultAsync();
return(Ok(Cliente.cd_user));
}
}
catch (Exception ex)
{
return(StatusCode(500, ex));
}
}
public async Task <IActionResult> GetById([FromBody] int requestBody)
{
try
{
using (SGCContext db = new SGCContext())
{
tbl_0002_filme Filme = await db.tbl_0002_filme.Where(i => i.cd_filme == requestBody).FirstOrDefaultAsync();
return(Ok(Filme));
}
}
catch (Exception ex)
{
return(StatusCode(500, ex));
}
}
public async Task <IActionResult> InsertCad([FromBody] tbl_0001_user requestBody)
{
try
{
using (SGCContext db = new SGCContext())
{
db.tbl_0001_user.Add(requestBody);
db.SaveChanges();
tbl_0001_user Cliente = await db.tbl_0001_user.Where(i => i.email_user == requestBody.email_user).FirstOrDefaultAsync();
return(Ok(Cliente.cd_user));
}
}
catch (Exception ex)
{
return(StatusCode(500, ex));
}
}
