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