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