public async Task <IHttpActionResult> GettXrefUserSourceServiceDevice(int id)
{
tXrefUserSourceServiceDevice tXrefUserSourceServiceDevice = await db.tXrefUserSourceServiceDevices.FindAsync(id);
if (tXrefUserSourceServiceDevice == null)
{
return(NotFound());
}
return(Ok(tXrefUserSourceServiceDevice));
}
public async Task <IHttpActionResult> PosttXrefUserSourceServiceDevice(tXrefUserSourceServiceDevice tXrefUserSourceServiceDevice)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tXrefUserSourceServiceDevices.Add(tXrefUserSourceServiceDevice);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = tXrefUserSourceServiceDevice.ID }, tXrefUserSourceServiceDevice));
}
public async Task <IHttpActionResult> DeletetXrefUserSourceServiceDevice(int id)
{
tXrefUserSourceServiceDevice tXrefUserSourceServiceDevice = await db.tXrefUserSourceServiceDevices.FindAsync(id);
if (tXrefUserSourceServiceDevice == null)
{
return(NotFound());
}
db.tXrefUserSourceServiceDevices.Remove(tXrefUserSourceServiceDevice);
await db.SaveChangesAsync();
return(Ok(tXrefUserSourceServiceDevice));
}
public IHttpActionResult Post(Sources value)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (value.source == null || value.access_token == null)
{
return(BadRequest());
}
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
tSourceService sourceServiceObj = db.tSourceServices
.SingleOrDefault(x => x.ServiceName == value.source && x.SourceID == 5);
if (sourceServiceObj == null)
{
sourceServiceObj = new tSourceService();
sourceServiceObj.ServiceName = value.source;
if (value.organization == null)
{
sourceServiceObj.TypeID = 2; //Wellness
}
else
{
sourceServiceObj.TypeID = 1; //Medical
}
sourceServiceObj.SourceID = 5; //HumanAPI
db.tSourceServices.Add(sourceServiceObj);
}
//get user source service status
tUserSourceServiceStatus statusObj = null;
string strStatus = "";
if (value.syncStatus != null) //for wellness
{
strStatus = value.syncStatus.status;
}
else if (value.historySync != null) //for medical
{
strStatus = value.historySync.status;
}
statusObj = db.tUserSourceServiceStatuses.SingleOrDefault(x => x.Status == strStatus);
if (statusObj == null)
{
statusObj = new tUserSourceServiceStatus();
statusObj.Status = strStatus;
db.tUserSourceServiceStatuses.Add(statusObj);
}
//Get credentials
tUserSourceService userSourceServiceObj = null;
tCredential credentialObj =
db.tCredentials.SingleOrDefault(x => x.SourceID == 5 &&
x.AccessToken == value.access_token &&
x.SystemStatusID == 1);
if (credentialObj == null)
{
throw new NoUserCredentialsException("Unable to find any matching HAPI user credentials");
}
else
{
userSourceServiceObj = db.tUserSourceServices.SingleOrDefault(
x => x.SourceServiceID == sourceServiceObj.ID &&
x.CredentialID == credentialObj.ID &&
x.SystemStatusID == 1);
if (userSourceServiceObj == null)
{
userSourceServiceObj = new tUserSourceService();
userSourceServiceObj.SourceServiceID = sourceServiceObj.ID;
userSourceServiceObj.UserID = credentialObj.UserID;
userSourceServiceObj.CredentialID = credentialObj.ID;
userSourceServiceObj.ConnectedOnDateTime = value.connectedSince;
userSourceServiceObj.LastSyncDateTime = DateTime.Now.AddDays(-30d);
userSourceServiceObj.LatestDateTime = DateTime.Now;
userSourceServiceObj.StatusID = statusObj.ID;
userSourceServiceObj.SystemStatusID = 1; //valid
userSourceServiceObj.tCredential = credentialObj;
db.tUserSourceServices.Add(userSourceServiceObj);
}
}
foreach (string device in value.devices)
{
tSourceServiceDevice sourceServiceDevices = db.tSourceServiceDevices.SingleOrDefault(
x => x.Name == device);
if (sourceServiceDevices == null)
{
sourceServiceDevices = new tSourceServiceDevice();
sourceServiceDevices.Name = device;
db.tSourceServiceDevices.Add(sourceServiceDevices);
}
tXrefUserSourceServiceDevice userdevices = db.tXrefUserSourceServiceDevices.SingleOrDefault(
x => x.UserSourceServiceID == userSourceServiceObj.ID &&
x.SourceServiceDeviceID == sourceServiceDevices.ID);
if (userdevices == null)
{
userdevices = new tXrefUserSourceServiceDevice();
userdevices.UserSourceServiceID = userSourceServiceObj.ID;
userdevices.SourceServiceDeviceID = sourceServiceDevices.ID;
userdevices.tSourceServiceDevice = sourceServiceDevices;
userdevices.tUserSourceService = userSourceServiceObj;
db.tXrefUserSourceServiceDevices.Add(userdevices);
}
}
tSourceOrganization userSourceOrganization = null;
if (value.organization != null)
{
//Get source org
userSourceOrganization = db.tSourceOrganizations
.Include("tOrganization")
.SingleOrDefault(x => x.SourceObjectID == value.organization.id);
if (userSourceOrganization == null)
{
//create org
tOrganization userOrganization = new tOrganization();
userOrganization.Name = value.organization.name;
//create new source org entry
userSourceOrganization = new tSourceOrganization();
userSourceOrganization.SourceObjectID = value.organization.id;
userSourceOrganization.tOrganization = userOrganization;
userSourceOrganization.OrganizationID = userOrganization.ID;
userSourceOrganization.SourceServiceID = sourceServiceObj.ID;
db.tSourceOrganizations.Add(userSourceOrganization);
}
}
db.SaveChanges();
dbContextTransaction.Commit();
return(Ok(userSourceServiceObj));
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
//Insert Error Log
tUserDataErrLog userErrorLog = new tUserDataErrLog();
userErrorLog.ErrTypeID = (int)ErrorLogging.enumErrorType.Application;
userErrorLog.ErrSourceID = (int)AuditLogging.enumApplication.SFCBAL;
userErrorLog.Code = ex.HResult.ToString();
userErrorLog.Description = ex.Message;
userErrorLog.Trace = ex.StackTrace;
dbErr.tUserDataErrLogs.Add(userErrorLog);
dbErr.SaveChanges();
string ErrMsg = "An error occured and we have logged the error. Please try again later.";
Exception Err = new Exception(ErrMsg, ex);
return(InternalServerError(Err));
}
}
}
public async Task <IHttpActionResult> PuttXrefUserSourceServiceDevice(int id, tXrefUserSourceServiceDevice tXrefUserSourceServiceDevice)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tXrefUserSourceServiceDevice.ID)
{
return(BadRequest());
}
db.Entry(tXrefUserSourceServiceDevice).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tXrefUserSourceServiceDeviceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
