//[Authorize(Roles = Role.OfficeAdmin + "," + Role.SuperAdmin)]
public async Task <ActionResult <int> > InsertClinician(InsertClinician clinician)
{
try
{
return(await _clinicianRepo.InsertClinician(clinician));
}
catch (Exception)
{
return(StatusCode(500, "Internal Server Error"));
}
}
public async Task <int> InsertClinician(InsertClinician clinician)
{
using (var con = mainConn)
{
string query = @"INSERT INTO [dbo].[Clinicians]
([UserID]
,[FirstName]
,[LastName]
,[PhoneNum]
,[EmailAddress]
,[Title]
,[Address]
,[Practice]
,[FaxNum])
VALUES
(@UserID, @FirstName, @LastName, @PhoneNum, @EmailAddress,
@Title, @Address, @Practice, @FaxNum);
SELECT SCOPE_IDENTITY()";
var id = await con.QueryFirstOrDefaultAsync <int>(query, clinician);
return(id);
}
}
