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