public SubscriberDTO Find(int subscriptionId)
{
try
{
var subscriber = _subscriberRepository.GetById(subscriptionId);
Mapper.Initialize(
cfg => cfg.CreateMap <Subscriber, SubscriberDTO> ());
var subscriberDto = Mapper.Map <Subscriber, SubscriberDTO> (subscriber);
_logger.Info("Get Subscriber: id = " + subscriptionId);
return(subscriberDto);
}
catch (RepositoryException rep)
{
_logger.Error("Method: Find Subscriber ( int subscriptionId )");
_logger.Error(rep.Message);
throw new ServiceException("Service exception: from repository ", rep);
}
catch (Exception ex)
{
_logger.Error("Method: Find Subscriber ( int subscriptionId )", ex);
throw new ServiceException("Method: Find Subscriber ( int subscriptionId )", ex);
}
}
public ActionResult <QBSyncResponse> Client(int id)
{
//If the id is 0, return all subscribers otherwise return the requested subscriber
string bRtn;
bool updateAccessTableResult;
subscriberId = id;
IEnumerable <Subscriber> subscriber;
currentMethodName = this.ControllerContext.RouteData.Values["action"].ToString();
if (subscriberId == 0)
{
subscriber = _subscriberRepo.GetAllSubscribers();
}
else
{
subscriber = _subscriberRepo.GetById(subscriberId);
if (subscriber == null)
{
_logger.LogError("subscriber not found");
return(new QBSyncResponse()
{
ResponseStatus = false,
ResponseMessage = "Subscriber not found."
});
}
}
foreach (Subscriber subs in subscriber)
{
subscriberId = subs.Id;
_logger.LogInfo("Begin Subscriber " + subscriberId + " Authorization");
QBOAccess qboAccess = _qboaccessRepo.GetById(subscriberId);
if (qboAccess == null)
{
_logger.LogError("You must authorize with QuickBooks before syncing your data.");
return(new QBSyncResponse()
{
ResponseStatus = false,
ResponseMessage = "You must authorize with QuickBooks before syncing your data."
});
}
// save Access Id
int qboAccessId = qboAccess.Id;
// Refresh QBO connection
bRtn = RefreshQBO(qboAccess);
if (bRtn != SuccessMessage)
{
_qboaccessRepo.DeleteQBOAccess(subscriberId);
return(new QBSyncResponse()
{
ResponseStatus = false,
ResponseMessage = bRtn
});
}
// Update Access table with new refresh token
try
{
AESCryptography cryptography = new AESCryptography(_configuration);
appOauthRefreshToken = cryptography.Encrypt(appOauthRefreshToken);
if (IsAllDigits(qboAccess.Company))
{
companyId = cryptography.Encrypt(qboAccess.Company);
}
else
{
companyId = qboAccess.Company;
}
updateAccessTableResult = _qboaccessRepo.UpdateQBOAccess(qboAccessId, companyId, appOauthAccessToken, appOauthRefreshToken, qboAccess);
if (updateAccessTableResult == false)
{
_logger.LogError("You will need to re-authorize your QuickBooks account and try to sync again.");
return(new QBSyncResponse()
{
ResponseStatus = false,
ResponseMessage = "You will need to re-authorize your QuickBooks account and try to sync again."
});
}
}
catch (Exception ex)
{
_logger.LogError("error occurred" + ex.Message);
_errorLogRepo.InsertErrorLog(new ErrorLog
{
SubscriberId = subscriberId,
ErrorMessage = ex.Message,
ServiceName = serviceName,
MethodName = currentMethodName,
ErrorDateTime = DateTime.Now
});
return(new QBSyncResponse()
{
ResponseStatus = false,
ResponseMessage = "Error occurred " + ex.Message
});
}
_logger.LogInfo("End Subscriber " + subscriberId + " Authorization");
//Time to get some data from QBO
_logger.LogInfo("Begin QBO Data Access for Subscriber " + subscriberId);
// Get and Update Customers & Invoices
bRtn = GetQBOCustomers(qboAccess);
if (bRtn != SuccessMessage)
{
_logger.LogError(bRtn);
return(new QBSyncResponse()
{
ResponseStatus = false,
ResponseMessage = bRtn
});
}
_logger.LogInfo("End QBO Data Access for Subscriber " + subscriberId);
//Update the last sync date in the subscriber table
var updateSyncDateResult = _subscriberRepo.UpdateSubscriber(subscriberId, DateTime.Now, subs);
if (updateSyncDateResult == false)
{
_logger.LogError("Not able to update last sync date for subscriber");
return(new QBSyncResponse()
{
ResponseStatus = false,
ResponseMessage = "Not able to update last sync date for subscriber"
});
}
}
return(new QBSyncResponse()
{
ResponseStatus = true,
ResponseMessage = SuccessMessage
});
}
public CardModel GetById(int cardId)
{
var card = _subscriberRepository.GetById(cardId);
return(card);
}