public IActionResult Edit(Renungan ren)
{
try{
_renung.Update(ren);
return(RedirectToAction("Index"));
}catch (Exception ex) {
return(Content($"Error: {ex.Message}"));
}
}
public void Update(Renungan ren)
{
using (SqlConnection conn = new SqlConnection(GetConnStr())){
var strSql = @"update Renungan set judul=@judul, isi=@isi where id_bacaan=@id_bacaan";
try{
var param = new { judul = ren.judul, isi = ren.isi,
id_bacaan = ren.id_bacaan };
conn.Execute(strSql, param);
}catch (SqlException sqlEx) {
throw new Exception($"Error: {sqlEx.Message}");
}
}
}
public object Create(Renungan ren)
{
try{
_renung.Create(ren);
return(RedirectToAction("Index"));
}
catch (Exception ex) {
ViewData["pesan"] =
$"<span class='alert alert-danger'>Data Gagal Ditambah, {ex.Message}</span>";
return(View("Index"));
}
}
public void Create(Renungan ren)
{
using (SqlConnection conn = new SqlConnection(GetConnStr())){
var strSql = @"insert into Renungan(judul,isi) values(@judul,@isi)";
try{
var param = new { judul = ren.judul, isi = ren.isi };
conn.Execute(strSql, param);
}
catch (SqlException sqlEx) {
throw new Exception($"Error : {sqlEx.Message}");
}
}
}
