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));
}
