public static Package GetPackageWithDetails(string packageId, PackageContext context, IConfiguration configuration)
{
var package = context.Package.FirstOrDefault(t => t.SfdcId == packageId);
if (package == null)
{
return(null);
}
var lastUpdatedInHours = package.UpdatedAt != null ?
((TimeSpan)(DateTime.Now - package.UpdatedAt)).TotalHours :
0;
if (package.Details == null || package.UpdatedAt == null || lastUpdatedInHours > 24)
{
var packageJObject = KtapiService.GetPackageDetailsFromKTAPI(
packageId,
configuration["KTAPI:Key"],
configuration["KTAPI:Secret"],
configuration["KTAPI:Endpoint"]).Result;
package.Details = packageJObject.ToString();
package.UpdatedAt = DateTime.Now;
context.SaveChanges();
}
return(package);
}
public static IEnumerable <Package> GetPackages(int?page, int?size, PackageContext context, ILogger logger, MyAppData appState, IConfiguration configuration)
{
/* SYNC PACKAGES FROM KTAPI EVERY 24 hours */
var hours = appState.PackageRetrievedAt != null ?
((TimeSpan)(DateTime.Now - appState.PackageRetrievedAt)).TotalHours :
0;
if (!appState.PackageRetrieved || hours > 24)
{
appState.PackageRetrieved = true;
appState.PackageRetrievedAt = DateTime.Now;
context.Database.ExecuteSqlCommand("TRUNCATE TABLE Package");
var packagesJArray = KtapiService.GetPackagesFromKTAPI(
configuration["KTAPI:Key"],
configuration["KTAPI:Secret"],
configuration["KTAPI:Endpoint"]).Result;
foreach (Newtonsoft.Json.Linq.JObject pObject in packagesJArray)
{
var package = context.Package.FirstOrDefault(t => t.SfdcId == (String)pObject["id"]);
if (package == null)
{
package = new Package();
package.SfdcId = (String)pObject["id"];
context.Package.Add(package);
}
package.Name = (String)pObject["name"];
package.Data = pObject.ToString();
}
context.SaveChanges();
}
/* END OF SYNC LOGIC */
if (size != null && page != null)
{
return(context.Package
.OrderByDescending(x => x.Id)
.Skip((int)page * (int)size)
.Take((int)size)
.Select(item => new Package
{
Id = item.Id,
SfdcId = item.SfdcId,
Name = item.Name,
Data = item.Data,
})
.ToList());
}
else
{
return(context.Package.ToList());
}
}
public static object GetPackagePricesWithAlternatives(string packageId, object data, PackageContext context, IConfiguration configuration)
{
var packageJObject = KtapiService.GetPackagePricesWithAlternativesFromKTAPI(
packageId,
data,
configuration["KTAPI:Key"],
configuration["KTAPI:Secret"],
configuration["KTAPI:Endpoint"]).Result;
return(packageJObject);
}
