public IActionResult OnGet(int Subscriber_ID)
{
billingloginS = _BillingData.GetSubscriber_IDlogin(User.Identity.Name);
if (billingloginS == null)
{
return(RedirectToPage("/account/login", new { area = "identity" }));
}
Subscriber_ID = billingloginS.Subscriber_ID;
AlldeviceInfo = _DeviceData.GetAllDevices(StartDate, EndDate, Subscriber_ID);
AllSubscribers = _SubscriberData.GetAllSubscribers(StartDate, EndDate, Subscriber_ID);
//billingsRealData = _BillingData.GetAllBillings(StartDate, EndDate);
if (Subscriber_ID > 0)
{
billingsRealData = _BillingData.GetAllBillings_First3Month(Subscriber_ID);
}
var model = _BillingData.GetAllBillings_First3Month((int)Subscriber_ID)
.Select(s => new { s.EnergyConsumedFor30Days, s.BillingMonth }).ToList();
//return Ok(model);
return(Page());
}
public Task <IEnumerable <Subscriber> > Get()
{
try
{
return(_subscriberRepository.GetAllSubscribers());
}
catch (Exception ex)
{
_log.LogError(ex.ToString());
return(null);
}
}
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 ActionResult <IEnumerable <Subscriber> > GetAllSubscribers()
{
var subscribers = _repository.GetAllSubscribers();
return(Ok(subscribers));
}