public IActionResult Update([FromBasicAuth] string auth, [FromBody] ScoreItem item, string id)
{
if (item == null)
{
return(BadRequest());
}
var score = ScoreItems.Find(id);
if (score == null)
{
return(NotFound());
}
if (!Auth.IsAllowed(auth, score.Game, UserPermission.UpdateScores))
{
return(Auth.Result);
}
item.Key = score.Key;
if (GameItems.Find(item.Game) == null)
{
return(BadRequest("Game not found"));
}
ScoreItems.Update(item);
return(new NoContentResult());
}
private async Task ExecuteGetLeaderboardCommand()
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
var items = await azureService.GetScores(CurrentGameType);
ScoreItems.Clear();
int i = 1;
foreach (var item in items)
{
item.Number = i;
ScoreItems.Add(item);
i++;
}
}
finally
{
IsBusy = false;
}
}
public string CalculateScore()
{
int total = GetTotalOfMeasurementTool();
int sum = ScoreItems.OrderBy(y => y.Key).Select(y => y.Value).Sum();
return $"{sum} / {total}";
}
public IEnumerable <ScoreItem> GetHistory([FromBasicAuth] string auth, [FromQuery] string game = null, [FromQuery] string param = null, [FromQuery] string version = null, [FromQuery] string user = null)
{
if (!Auth.IsAllowed(auth, UserPermission.ReadScores))
{
Response.StatusCode = Auth.StatusCode;
return(null);
}
return(ScoreItems.GetHistory(game, param, version, user));
}
public IEnumerable <ScoreItem> GetTop([FromBasicAuth] string auth, string game, [FromQuery] int max = int.MaxValue, [FromQuery] string param = null, [FromQuery] string version = null)
{
if (!Auth.IsAllowed(auth, game, UserPermission.ReadScores))
{
Response.StatusCode = Auth.StatusCode;
return(null);
}
return(ScoreItems.GetTop(max, game, param, version));
}
public double CalculateBurdenOfCare()
{
if (MeasurementTool.Name == "Beta")
{
double sum = ScoreItems.OrderBy(y => y.Key).Select(y => (double)y.Value).Sum();
double value = (GetTotalOfMeasurementTool() - sum) * 3.38 / 60;
return Math.Floor(value * 10) / 10;
}
else
{
return 0;
}
}
public IActionResult Delete([FromBasicAuth] string auth, string id)
{
var score = ScoreItems.Find(id);
if (score == null)
{
return(NotFound());
}
if (!Auth.IsAllowed(auth, score.Game, UserPermission.UpdateScores))
{
return(Auth.Result);
}
ScoreItems.Remove(id);
return(new NoContentResult());
}
public IActionResult GetById([FromBasicAuth] string auth, string id)
{
var item = ScoreItems.Find(id);
if (item != null)
{
if (!Auth.IsAllowed(auth, item.Game, UserPermission.ReadScores))
{
return(Auth.Result);
}
}
else
{
return(NotFound());
}
return(new ObjectResult(item));
}
public IActionResult Create([FromBasicAuth] string auth, [FromBody] ScoreItem item)
{
if (item == null)
{
return(BadRequest());
}
if (!Auth.IsAllowed(auth, item.Game, UserPermission.PostScores))
{
return(Auth.Result);
}
if (GameItems.Find(item.Game) == null)
{
return(BadRequest("Game not found"));
}
item.Date = DateTime.Now;
ScoreItems.Add(item);
return(CreatedAtRoute("GetScore", new { id = item.Key }, item));
}
private void Score(Label label, ScoreItems scoreItems)
{
label.Text = scoreSheet.possibleScores[(int)scoreItems].ToString();
}
public void Export()
{
var name = string.Empty;
var workBook = new XLWorkbook();
var worksheet = workBook.Worksheets.Add("Resultaat");
switch (LogType)
{
case LogTypes.Score:
name = "Score";
worksheet.Row(1).Cell(1).Value = "FotoNaam";
worksheet.Row(1).Cell(2).Value = "Lid";
worksheet.Row(1).Cell(3).Value = "Jury1";
worksheet.Row(1).Cell(4).Value = "Jury2";
worksheet.Row(1).Cell(5).Value = "Jury3";
worksheet.Row(1).Cell(6).Value = "Jury4";
worksheet.Row(1).Cell(7).Value = "Jury5";
worksheet.Row(1).Cell(8).Value = "Totaal";
worksheet.Row(1).Cell(9).Value = "Afwijking";
worksheet.Row(1).Cell(10).Value = "Totaal (%)";
worksheet.Row(1).Cell(11).Value = "GelijkeScores";
if (ScoreItems != null)
{
worksheet.Cells("A2").Value = ScoreItems.Select(s => new ScoreItem
{
FotoNaam = s.FotoNaam,
Lid = s.Lid,
Jury1 = s.Jury1,
Jury2 = s.Jury2,
Jury3 = s.Jury3,
Jury4 = s.Jury4,
Jury5 = s.Jury5,
Afwijking = string.IsNullOrEmpty(s.Afwijking) ? string.Empty : (s.Afwijking.Equals(Variables.DefaultScore) ? string.Empty : s.Afwijking),
GelijkeScores =
string.IsNullOrEmpty(s.GelijkeScores) ? string.Empty : s.GelijkeScores.Equals(Variables.DefaultScore) ? string.Empty : s.GelijkeScores,
MaxPoints = s.MaxPoints,
NumberOfJuryMembers = s.NumberOfJuryMembers
}).AsEnumerable();
}
//format decimals
worksheet.Column(10).Style.NumberFormat.Format = "#,##0.00";
var indx = 11;
if (ScoreItems != null && ScoreItems.All(w => string.IsNullOrEmpty(w.GelijkeScores)))
{
worksheet.Columns(indx, indx).Delete();
indx--;
}
if (ScoreItems != null && ScoreItems.All(w => string.IsNullOrEmpty(w.Afwijking)))
{
worksheet.Columns(9, 9).Delete();
indx--;
}
if (ScoreItems != null && (!MemberModuleActive || ScoreItems.All(w => string.IsNullOrEmpty(w.Lid))))
{
worksheet.Columns(2, 2).Delete();
indx--;
}
worksheet.Range(1, 1, 1, indx).AddToNamed("Titles");
worksheet.Columns(12, 17).Delete();
worksheet.Columns().AdjustToContents();
break;
case LogTypes.Activity:
name = "Activity";
worksheet.Row(1).Cell(1).Value = "Club";
worksheet.Row(1).Cell(2).Value = "Datum";
worksheet.Row(1).Cell(3).Value = "Ip";
worksheet.Row(1).Cell(4).Value = "Source";
worksheet.Row(1).Cell(5).Value = "Type";
worksheet.Row(1).Cell(6).Value = "Lokatie";
worksheet.Row(1).Cell(7).Value = "Omschrijving";
worksheet.Range(1, 1, 1, 7).AddToNamed("Titles");
if (ActivityItems != null)
{
worksheet.Cells("A2").Value = ActivityItems.Select(s => new ActivityItem
{
Club = s.Club,
Datum = s.Datum,
Ip = s.Ip,
Source = s.Source,
Type = s.Type,
Lokatie = s.Lokatie,
Omschrijving = s.Omschrijving
}).AsEnumerable();
}
worksheet.Columns().AdjustToContents();
break;
}
//format titles
var titlesStyle = workBook.Style;
titlesStyle.Font.Bold = true;
titlesStyle.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
titlesStyle.Fill.BackgroundColor = XLColor.LightBlue;
workBook.NamedRanges.NamedRange("Titles").Ranges.Style = titlesStyle;
var memoryStream = new MemoryStream();
workBook.SaveAs(memoryStream);
memoryStream.Position = 0;
var folderDialog = new SaveFileDialog
{
FileName = $"{name}_{DateTime.Now:yyyymmddhhmmss}.xlsx",
DefaultExt = ".xlsx",
Filter = @"Microsoft Excel Worksheet (.xlsx)|*.xlsx"
};
var result = folderDialog.ShowDialog();
if (result == DialogResult.OK)
{
using (var fileStream = File.OpenWrite(folderDialog.FileName))
{
memoryStream.WriteTo(fileStream);
}
}
}
