protected override void RunActualProcess() { var db = Services.SqlConnectionPreparer.GetDatabaseConnection(Stage.Raw, Constants.PresentSlice); db.RecreateTable <Jahrgang>(); db.BeginTransaction(); string fn = CombineForRaw("Jahrgänge.csv"); using (var sr = new StreamReader(fn)) { while (!sr.EndOfStream) { var l = sr.ReadLine(); if (!string.IsNullOrWhiteSpace(l)) { var arr = l.Split(';'); var year = Convert.ToInt32(arr[0]); var count = Convert.ToInt32(arr[1]); var jg = new Jahrgang { Jahr = year, Count = count }; db.Save(jg); } } } db.CompleteTransaction(); }
public async Task <IActionResult> PutJahrgang([FromRoute] int id, [FromBody] Jahrgang jahrgang) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != jahrgang.JahrgangID) { return(BadRequest()); } _context.Entry(jahrgang).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!JahrgangExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
protected override void RunActualProcess() { SqlConnection.RecreateTable <Jahrgang>(Stage.Raw, Constants.PresentSlice); var db = SqlConnection.GetDatabaseConnection(Stage.Raw, Constants.PresentSlice).Database; db.BeginTransaction(); using (var sr = new StreamReader(@"U:\SimZukunft\RawDataForMerging\Jahrgänge.csv")) { while (!sr.EndOfStream) { var l = sr.ReadLine(); if (!string.IsNullOrWhiteSpace(l)) { var arr = l.Split(';'); var year = Convert.ToInt32(arr[0]); var count = Convert.ToInt32(arr[1]); var jg = new Jahrgang { Jahr = year, Count = count }; db.Save(jg); } } } db.CompleteTransaction(); }
public async Task <IActionResult> PostJahrgang([FromBody] Jahrgang jahrgang) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.Jahrgang.Add(jahrgang); await _context.SaveChangesAsync(); return(CreatedAtAction("GetJahrgang", new { id = jahrgang.JahrgangID }, jahrgang)); }