public static async Task <NotenDLModel> GetByIdNoteAsync(int id, string sql) { try { using (NpgsqlConnection connection = new NpgsqlConnection(sql)) { NpgsqlCommand command; //Edit Schueler props [notenschema] connection.Open(); command = new NpgsqlCommand ($"select * from notenschema where nid = {id};", connection); var dr = await command.ExecuteReaderAsync(); NotenDLModel editnote = null; while (dr.Read()) { editnote = new NotenDLModel( int.Parse(dr[0].ToString()), int.Parse(dr[1].ToString()), int.Parse(dr[2].ToString()) ); } connection.Close(); return(editnote); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public static async Task <bool> SaveNoteAsync(int id, NotenDLModel changednote, string sql) { try { using (NpgsqlConnection connection = new NpgsqlConnection(sql)) { NpgsqlCommand command; //Edit Note props [notenschema] connection.Open(); command = new NpgsqlCommand ($"update notenschema set bez = {changednote.Bezeichnung}, mindestanforderung = {changednote.Mindestanforderung} where nid = {id};", connection); int i = await command.ExecuteNonQueryAsync(); connection.Close(); if (i == 1) { return(true); } return(false); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <bool> PutNoteAsync(int id, NotenDLModel note) { try { var d = await NotenProcessor.SaveNoteAsync(id, note, ConnectionString); return(d); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> Edit(int id, NotenDLModel changednote) { try { await NotenProcessor.SaveNoteAsync(id, changednote, ConnectionString); return(RedirectToAction("Index")); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <NotenModel> GetNoteAsync(int id) { try { NotenDLModel resultnote = await NotenProcessor.GetByIdNoteAsync(id, ConnectionString); NotenModel note = new NotenModel { NId = resultnote.NId, Bezeichnung = resultnote.Bezeichnung, Mindestanforderung = resultnote.Mindestanforderung }; return(note); } catch (Exception ex) { throw new Exception(ex.Message); } }