public async Task <IHttpActionResult> PutJudoka(int id, Judoka judoka)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != judoka.Id)
{
return(BadRequest());
}
db.Entry(judoka).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!JudokaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IHttpActionResult> GetJudoka(int id)
{
Judoka judoka = await db.Judoka.FindAsync(id);
if (judoka == null)
{
return(NotFound());
}
return(Ok(judoka));
}
public async Task <IHttpActionResult> PostJudoka(Judoka judoka)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Judoka.Add(judoka);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = judoka.Id }, judoka));
}
public async Task <IHttpActionResult> DeleteJudoka(int id)
{
Judoka judoka = await db.Judoka.FindAsync(id);
if (judoka == null)
{
return(NotFound());
}
db.Judoka.Remove(judoka);
await db.SaveChangesAsync();
return(Ok(judoka));
}
/// <summary>
/// Erzeugt die Listen mit den Objekten aus der Anmeldung.
/// </summary>
public void Generate()
{
// Variablen initialisieren
judoka = new List<Judoka>();
verein = new Verein();
// Ko-Kriterien
if (!System.IO.File.Exists(fileName)) return;
Excel.Application excel = null;
Excel.Workbook workbook = null;
Excel.Worksheet worksheet = null;
try
{
// Worksheet Initialisieren
excel = new Excel.Application();
workbook = excel.Workbooks.Open(fileName, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, null, false, false, false);
worksheet = (Excel.Worksheet)workbook.Sheets.get_Item(1);
// Verein auslesen
verein.Name = GetSheetValue(worksheet, "B2");
verein.Kurzname = GetSheetValue(worksheet, "B2");
verein.Email = GetSheetValue(worksheet, "B7");
System.Text.StringBuilder sb = new StringBuilder();
sb.AppendLine(GetSheetValue(worksheet, "B3"));
sb.AppendLine(GetSheetValue(worksheet, "B4"));
sb.AppendLine(GetSheetValue(worksheet, "B5"));
sb.AppendLine(GetSheetValue(worksheet, "B6"));
verein.Adresse = sb.ToString();
// Kämpfer auslesen
int counter = 1;
while (HasSheetJudoka(counter, worksheet))
{
Judoka j = new Judoka();
j.Vorname = GetSheetValue(worksheet, GetJudokaCell(counter, "C"));
j.Nachname = GetSheetValue(worksheet, GetJudokaCell(counter, "B"));
try
{
j.Geburtsdatum = DateTime.FromOADate(double.Parse(GetSheetValue(worksheet, GetJudokaCell(counter, "F"))));
}
catch (Exception)
{
j.Geburtsdatum = new DateTime(1900, 1, 1);
}
j.Gürtel = new Gürtel(GetSheetValue(worksheet, GetJudokaCell(counter, "D")), "9");
j.Geschlecht = new Geschlecht(GetSheetValue(worksheet, GetJudokaCell(counter, "E")));
j.Verein = verein;
judoka.Add(j);
counter++;
}
}
catch (Exception)
{
throw;
}
finally
{
// Excel beenden
workbook.Close(false, null, 0);
workbook = null;
excel.Quit();
excel = null;
System.GC.WaitForPendingFinalizers();
}
}
