public IActionResult Sil(DirekSatisIlaclari item)
{
try
{
using (var dbConnection = DatabaseBaglanti.Connection())
{
dbConnection.Open();
dbConnection.Execute("delete from public.direksatisilaclari where Id = @Id ", item);
}
return(Json(new { basarili = true }));
}
catch (System.Exception)
{
return(Json(new { basarisiz = true }));
}
}
public IActionResult Kaydet(DirekSatisIlaclari item)
{
try
{
using (var dbConnection = DatabaseBaglanti.Connection())
{
dbConnection.Open();
if (item.Id == 0)
{
dbConnection.Execute("insert into public.direksatisilaclari (id, ilacid,adet ) values(@id, @ilacid,@adet)", item);
}
else
{
dbConnection.Execute("update public.direksatisilaclari set id = @id, ilacid= @ilacid, adet=@adet where Id = @Id", item);
}
}
return(Json(new { basarili = true }));
}
catch (System.Exception ex)
{
return(Json(new { basarisiz = true }));
}
}