public Result <StandardRecord> QueryAndTransform()
{
Logger.LogInformation($"Running Query and transform.");
Query.TargetDate = TargetDate;
var result = Query.DoQuery();
var records = new List <StandardRecord>();
var relevent = result.Data.FirstOrDefault(d => d.Date == TargetDate.AddDays(-1).Date);
records.Add(new StandardRecord()
{
Name = NameConstants.LookbackQuery_LfdTests
,
Date = TargetDate.AddDays(-1).Date
,
Daily = relevent?.LfdTests_Daily
,
Cumulative = relevent?.LfdTests_Cumulative
});
return(new Result <StandardRecord>()
{
Records = records,
QueryRecords = new List <QueryRecord>()
{
new QueryRecord()
{
Name = NameConstants.LookbackQuery_Lfd_Name, Url = result.Url
}
}
});
}
public override string ToString()
{
string ss;
ss = Id.ToString() + "|";
ss += TargetDate.ToString() + "|";
ss += Link + "|";
ss += GetStatusString() + "|";
return(ss);
}
public override string ToString()
{
string ss;
ss = Id.ToString() + "|";
ss += TargetDate.ToString() + "|";
ss += "ftp://" + Username + @"@" + Hostname + "|";
ss += RemoteName + "|";
ss += GetStatusString() + "|";
return(ss);
}
private List <DateTime> GetWindow()
{
var list = new List <DateTime>();
var date = TargetDate.AddDays(-10).Date;
while (date <= TargetDate.Date)
{
list.Add(date);
date = date.AddDays(1);
}
return(list);
}
public static void test1()
{
testing(TargetDate.DateNbDays(4281, 5087, 2), "2024-07-03");
testing(TargetDate.DateNbDays(4620, 5188, 2), "2021-09-19");
testing(TargetDate.DateNbDays(9999, 11427, 6), "2018-03-13");
testing(TargetDate.DateNbDays(3525, 4822, 3), "2026-04-18");
testing(TargetDate.DateNbDays(5923, 6465, 6), "2017-06-10");
testing(TargetDate.DateNbDays(4254, 4761, 8), "2017-05-22");
testing(TargetDate.DateNbDays(1244, 2566, 4), "2033-11-04");
testing(TargetDate.DateNbDays(6328, 7517, 5), "2019-05-25");
testing(TargetDate.DateNbDays(2920, 3834, 2), "2029-06-03");
testing(TargetDate.DateNbDays(7792, 8987, 4), "2019-07-09");
}
public QueryResponce <RegionVaccineProgressQueryModel> DoQuery()
{
var targetDate = TargetDate.AddDays(-1).Date;
Query.Options = new QueryOptions()
{
Filter = new Filter()
{
AreaType = new AreaType(AreaTypeMetrics.nation),
Date = new DateFilter(targetDate)
},
};
return(Query.DoQuery());
}
public QueryResponce <RegionBreakdownQueryModel> DoQuery()
{
var targetDate = TargetDate.AddDays(-1).Date;
Query.Options = new QueryOptions()
{
Filter = new Filter()
{
AreaType = new AreaType(AreaTypeMetrics.overview),
Date = new DateFilter(targetDate)
},
};
return(Query.DoQuery());
}
public Result <TitleResult> QueryAndTransform()
{
Logger.LogInformation($"Running Query and transform.");
Query.TargetDate = TargetDate;
var result = Query.DoQuery();
LookbackJustVaccineQuery.TargetDate = TargetDate;
var yesterdayResult = LookbackJustVaccineQuery.DoQuery();
var relevent = result.Data.Where(d => d.Date == TargetDate).FirstOrDefault();
var yesterdayRelevent = yesterdayResult.Data.Where(d => d.Date == TargetDate.AddDays(-1).Date).FirstOrDefault();
var titleResult = new TitleResult()
{
TotalCases = new SimpleRecord()
{
Date = TargetDate,
Value = relevent?.Cases_Cumulative
},
TotalDeaths = new SimpleRecord()
{
Date = TargetDate,
Value = relevent?.Deaths_Cumulative
},
TotalVaccines = new SimpleRecord()
{
Date = TargetDate,
Value = yesterdayRelevent?.FirstDose_Cumulative
},
Date = TargetDate
};
var list = new List <TitleResult>()
{
titleResult
};
return(new Result <TitleResult>()
{
Records = list,
QueryRecords = new List <QueryRecord>()
{
new QueryRecord()
{
Name = NameConstants.DailyQuery_Name, Url = result.Url
}
}
});
}
public QueryResponce <LookbackJustVaccineModel> DoQuery()
{
var trueTargetDate = TargetDate.AddDays(0);
var targetDate = TargetDate.AddDays(-1);
Query.Options = new QueryOptions()
{
Filter = new Filter()
{
AreaType = new AreaType(AreaTypeMetrics.overview),
Date = new DateFilter(targetDate)
},
};
return(Query.DoQuery());
}
public QueryResponce <LookbackEnglandQueryModel> DoQuery()
{
var trueTargetDate = TargetDate.AddDays(0);
var targetDate = TargetDate.AddDays(-1);
Query.Options = new QueryOptions()
{
Filter = new Filter()
{
AreaType = new AreaType(AreaTypeMetrics.nation),
AreaName = new AreaName("England"),
Date = new DateFilter(targetDate)
},
};
return(Query.DoQuery());
}
public Result <RegionRateRecord> Transform(List <Area> regions, QueryResponce <RegionBreakdownQueryModel> resultToday, QueryResponce <RegionBreakdownQueryModel> resultYesterday)
{
var records = new List <RegionRateRecord>();
var todayRecords = resultToday.Data.Where(d => d.Date == TargetDate.Date).ToList();
var yesterdayRecords = resultYesterday.Data.Where(d => d.Date == TargetDate.AddDays(-1).Date).ToList();
foreach (var region in regions)
{
var today = todayRecords.FirstOrDefault(r => r.Code == region.Code);
var yesterday = yesterdayRecords.FirstOrDefault(r => r.Code == region.Code);
var record = new RegionRateRecord()
{
Name = region.DisplayName(),
Date = TargetDate.Date,
Daily = today?.DailyCases,
Delta = today?.DailyCases - yesterday?.DailyCases
};
SetRatio(region, record);
records.Add(record);
}
records = records.OrderByDescending(r => r.Rate).ToList();
return(new Result <RegionRateRecord>()
{
Records = records,
QueryRecords = new List <QueryRecord>()
{
new QueryRecord()
{
Name = QueryNameToday, Url = resultToday.Url
},
new QueryRecord()
{
Name = QueryNameYesterday, Url = resultYesterday.Url
}
}
});
}
private IrregularRecord GetRecord(string name, NonDailyQueryModel record, long?value)
{
if (record != null)
{
return(new IrregularRecord()
{
Date = record.Date,
LastReportedTotal = value,
Name = name,
IsNew = (record.Date == TargetDate || record.Date == TargetDate.AddDays(-1))
});
}
else
{
return(null);
//return new IrregularRecord()
//{
// Date = DateTime.MinValue,
// LastReportedTotal = null,
// Name = name
//};
}
}
protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext)
{
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite sitecollection = new SPSite(Url))
{
using (SPWeb web = sitecollection.OpenWeb())
{
SPList list = web.Lists["Aufgaben"];
SPListItem listitem = list.Items.Add();
SPContentType ConType = list.ContentTypes[ContentType.ToString()];
if (ConType != null)
{
listitem["ContentTypeId"] = ConType.Id;
}
if (!String.IsNullOrEmpty(Title) & listitem.Fields.ContainsField("Title"))
{
listitem["Title"] = Title.ToString();
}
if (!String.IsNullOrEmpty(Descript) & (listitem.Fields.ContainsField("Beschreibung") | listitem.Fields.ContainsField("Body")))
{
listitem["Beschreibung"] = Descript.ToString();
}
if (!String.IsNullOrEmpty(Link) & listitem.Fields.ContainsField("Link"))
{
LinkFieldValue lfValue = new LinkFieldValue();
lfValue.NavigateUrl = Link.ToString();
lfValue.Text = "Link zu Dokument";
lfValue.UseDefaultIcon = false;
listitem["Link"] = lfValue;
}
if (!String.IsNullOrEmpty(AccountName) & listitem.Fields.ContainsField("AssignedTo"))
{
SPUserCollection users = web.Users;
SPUser user = UserExists(users, AccountName.ToString());
if (user != null)
{
listitem["AssignedTo"] = user;
}
else
{
SPGroupCollection groups = web.Groups;
if (GroupExists(groups, AccountName.ToString()))
{
listitem["AssignedTo"] = web.Groups[AccountName.ToString()];
}
}
}
if (!String.IsNullOrEmpty(Quelle) & listitem.Fields.ContainsField("Aufgabenquelle"))
{
listitem["Aufgabenquelle"] = Quelle.ToString();
}
if ((TargetDate.ToString() != string.Empty) & (listitem.Fields.ContainsField("DueDate")))
{
listitem["DueDate"] = TargetDate;
}
if (listitem.Fields.ContainsField("WorkflowID"))
{
listitem["WorkflowID"] = WorkflowID;
}
listitem.Update();
TaskID = listitem.ID;
}
}
});
return(base.Execute(executionContext));
}
public Result <RegionProgressRecord> Transform(List <Area> regions, QueryResponce <RegionVaccineProgressQueryModel> resultToday, QueryResponce <RegionVaccineProgressQueryModel> resultYesterday)
{
var records = new List <RegionProgressRecord>();
var todayRecords = resultToday.Data.Where(d => d.Date == TargetDate.Date.AddDays(-1).Date).ToList();
var yesterdayRecords = resultYesterday.Data.Where(d => d.Date == TargetDate.AddDays(-2).Date).ToList();
foreach (var region in regions)
{
var today = todayRecords.FirstOrDefault(r => r.Code == region.Code);
var yesterday = yesterdayRecords.FirstOrDefault(r => r.Code == region.Code);
var regionStats = region;
long? firstDoseTotal = null;
long? firstDoseNew = null;
double?firstDosePercentageProgress = null;
double?firstDoseIncrease = null;
if (today?.FirstDoseNew != null && today?.FirstDoseCum != null)
{
firstDoseTotal = today?.FirstDoseCum;
firstDoseNew = today?.FirstDoseNew;
firstDosePercentageProgress = ((double)today.FirstDoseCum / (double)regionStats.TwelveOrMorePopulation()) * (double)100;
if (yesterday?.FirstDoseCum != null)
{
var percentageYesterday = ((double)yesterday.FirstDoseCum / (double)regionStats.TwelveOrMorePopulation()) * (double)100;
firstDoseIncrease = firstDosePercentageProgress - percentageYesterday;
}
}
long? secondDoseTotal = null;
long? secondDoseNew = null;
double?secondDosePercentageProgress = null;
double?secondDoseIncrease = null;
if (today?.SecondDoseNew != null && today?.SecondDoseCum != null)
{
secondDoseTotal = today?.SecondDoseCum;
secondDoseNew = today?.SecondDoseNew;
secondDosePercentageProgress = ((double)today.SecondDoseCum / (double)regionStats.TwelveOrMorePopulation()) * (double)100;
if (yesterday?.SecondDoseCum != null)
{
var percentageYesterday = ((double)yesterday.SecondDoseCum / (double)regionStats.TwelveOrMorePopulation()) * (double)100;
secondDoseIncrease = secondDosePercentageProgress - percentageYesterday;
}
}
long? thirdDoseTotal = null;
long? thirdDoseNew = null;
double?thirdDosePercentageProgress = null;
double?thirdDoseIncrease = null;
if (today?.ThirdDoseNew != null && today?.ThirdDoseCum != null)
{
thirdDoseTotal = today?.ThirdDoseCum;
thirdDoseNew = today?.ThirdDoseNew;
thirdDosePercentageProgress = ((double)today.ThirdDoseCum / (double)regionStats.TwelveOrMorePopulation()) * (double)100;
if (yesterday?.ThirdDoseCum != null)
{
var percentageYesterday = ((double)yesterday.ThirdDoseCum / (double)regionStats.TwelveOrMorePopulation()) * (double)100;
thirdDoseIncrease = thirdDosePercentageProgress - percentageYesterday;
}
}
var record = new RegionProgressRecord()
{
Name = region.DisplayName(),
Date = TargetDate.Date,
FirstDoseTotal = firstDoseTotal,
FirstDoseDailyIncrease = firstDoseNew,
FirstDosePercentageProgress = firstDosePercentageProgress,
FirstDoseIncrease = firstDoseIncrease,
SecondDoseTotal = secondDoseTotal,
SecondDoseDailyIncrease = secondDoseNew,
SecondDosePercentageProgress = secondDosePercentageProgress,
SecondDoseIncrease = secondDoseIncrease,
ThirdDoseTotal = thirdDoseTotal,
ThirdDoseDailyIncrease = thirdDoseNew,
ThirdDosePercentageProgress = thirdDosePercentageProgress,
ThirdDoseIncrease = thirdDoseIncrease
};
records.Add(record);
}
records = records.OrderByDescending(r => r.FirstDosePercentageProgress).ToList();
return(new Result <RegionProgressRecord>()
{
Records = records,
QueryRecords = new List <QueryRecord>()
{
new QueryRecord()
{
Name = QueryNameToday, Url = resultToday.Url
},
new QueryRecord()
{
Name = QueryNameYesterday, Url = resultYesterday.Url
}
}
});
}
public Result <StandardRecord> QueryAndTransform()
{
Logger.LogInformation($"Running Query and transform.");
Query.TargetDate = TargetDate;
var result = Query.DoQuery();
var records = new List <StandardRecord>();
var relevent = result.Data.FirstOrDefault(d => d.Date == TargetDate.AddDays(-1).Date);
//records.Add(new StandardRecord()
//{
// Name = NameConstants.LookbackQuery_FirstDose
// ,
// Date = TargetDate.AddDays(-1).Date
// ,
// Daily = relevent?.FirstDose?.Daily
// ,
// Cumulative = relevent?.FirstDose?.Cumulative
//});
//records.Add(new StandardRecord()
//{
// Name = NameConstants.LookbackQuery_SecondDose
// ,
// Date = TargetDate.AddDays(-1).Date
// ,
// Daily = relevent?.SecondDose?.Daily
// ,
// Cumulative = relevent?.SecondDose?.Cumulative
//});
records.Add(new StandardRecord()
{
Name = NameConstants.LookbackQuery_Pillar1
,
Date = TargetDate.AddDays(-1).Date
,
Daily = relevent?.Pillar1_Daily
,
Cumulative = relevent?.Pillar1_Cumulative
});
records.Add(new StandardRecord()
{
Name = NameConstants.LookbackQuery_Pillar2
,
Date = TargetDate.AddDays(-1).Date
,
Daily = relevent?.Pillar2_Daily
,
Cumulative = relevent?.Pillar2_Cumulative
});
records.Add(new StandardRecord()
{
Name = NameConstants.LookbackQuery_Pillar3
,
Date = TargetDate.AddDays(-1).Date
,
Daily = relevent?.Pillar3_Daily
,
Cumulative = relevent?.Pillar3_Cumulative
});
records.Add(new StandardRecord()
{
Name = NameConstants.LookbackQuery_Pillar4
,
Date = TargetDate.AddDays(-1).Date
,
Daily = relevent?.Pillar4_Daily
,
Cumulative = relevent?.Pillar4_Cumulative
});
records.Add(new StandardRecord()
{
Name = NameConstants.LookbackQuery_PillarAll
,
Date = TargetDate.AddDays(-1).Date
,
Daily = relevent?.PillarAll_Daily
,
Cumulative = relevent?.PillarAll_Cumulative
});
records.Add(new StandardRecord()
{
Name = NameConstants.LookbackQuery_PcrTests
,
Date = TargetDate.AddDays(-1).Date
,
Daily = relevent?.PcrTests_Daily
,
Cumulative = relevent?.PcrTests_Cumulative
});
return(new Result <StandardRecord>()
{
Records = records,
QueryRecords = new List <QueryRecord>()
{
new QueryRecord()
{
Name = NameConstants.LookbackQuery_Name, Url = result.Url
}
}
});
}
private void LayoutRoot_OnTap(object sender, GestureEventArgs e)
{
App.Current.RootFrame.Navigate(new Uri("/View/Page/CalendarDayPage.xaml?uid=" + AccountID.ToString() + "&startDate=" + TargetDate.ToShortDateString(),
UriKind.Relative));
}
public override string ToString()
{
return(IsEnabled + " " + AlertType + " " + TargetDate?.ToString("dd/MM/yyyy HH:mm"));
}
public override BLL_Deal ToBLLModel()
{
BLL_Deal bLL_Deal = new BLL_Deal()
{
Dealnum = DealNumber,
Dealname = DealName,
Status = StatusCode,
StatusName = Status,
Contractnum = ContractNumber,
Inceptdate = InceptionDate.ToDate(),
Targetdt = TargetDate.ToUniversalDate(),
ModelPriority = Priority,
Submissiondate = SubmittedDate.ToDate(),
Uw1 = PrimaryUnderwriterCode,
Uw1Name = PrimaryUnderwriterName,
Uw2 = SecondaryUnderwriterCode,
Uw2Name = SecondaryUnderwriterName,
Ta = TechnicalAssistantCode,
TaName = TechnicalAssistantName,
Modeller = ModellerCode,
ModellerName = ModellerName,
Act1 = ActuaryCode,
Act1Name = ActuaryName,
Expirydate = ExpiryDate.ToDate(),
Broker = BrokerCode,
BrokerName = BrokerName,
BrokerContact = BrokerContactCode,
BrokerContactName = BrokerContactName,
Cedant = CedantCode,
CedantName = CedantName,
Continuous = Continuous,
Renewal = Renewal,
Dealtype = Dealtype,
DealtypeName = DealtypeName,
Coveragetype = Coveragetype,
CoveragetypeName = CoveragetypeName,
Policybasis = Policybasis,
PolicybasisName = PolicybasisName,
Currency = Currency,
CurrencyName = CurrencyName,
Domicile = Domicile,
DomicileName = DomicileName,
Region = Region,
RegionName = RegionName,
CedentLocation = CedentLocation,
CedentLocationname = CedentLocationname,
BrokerLocation = BrokerLocation,
BrokerLocationname = BrokerLocationname,
PaperName = PaperName,
ExpiryEod = ExpiryEod,
Exposuretype = Exposuretype,
CedantGroupCode = CedantGroupCode,
CedantGroupName = CedantGroupName,
BrokerGroupCode = BrokerGroupCode,
BrokerGroupName = BrokerGroupName,
RenewalName = RenewalName,
ChkPreBindProcessing = ChkPreBindProcessing,
ChkUWCompliance = ChkUWCompliance,
ChkModelling = ChkModelling,
decreason = decreason
};
return(bLL_Deal);
}
