public async Task <ActionResult <StaffOperator> > GetOperatorFromPhone(GetPersonByPhone phone) { var staffOperator = await _context.Operators.FromSqlInterpolated( $"SELECT * FROM \"Operators\" AS O WHERE EXISTS(SELECT * FROM \"OperatorPhones\" AS OP WHERE O.\"OperatorId\" = OP.\"OperatorId\" AND OP.\"PhoneNumber\" = {phone.Phone})").FirstOrDefaultAsync(); if (staffOperator == null) { return(NotFound()); } return(staffOperator); }
public async Task <ActionResult <Client> > GetClientByPhone(GetPersonByPhone phone) { var client = await _context.Clients.FirstOrDefaultAsync(x => x.PhoneNumber == phone.Phone); // var client = await _context.Clients.FromSqlInterpolated( // $"SELECT * FROM \"Clients\" WHERE PhoneNumber = {phone.Phone}").FirstOrDefaultAsync(); if (client == null) { return(NotFound()); } return(client); }