public string deletePegawai(string id)
{
Koneksi kon = new Koneksi();
SqlConnection sqlcon = kon.getConnection();
string msg = string.Empty;
using (sqlcon)
{
sqlcon.Open();
string sql = "delete from pegawai where idpegawai = @id";
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
using (sqlcom)
{
sqlcom.Parameters.AddWithValue("@id", id);
int res = sqlcom.ExecuteNonQuery();
msg = (res != 0 ? "Data has been deleted." : "Oops, something went wrong.");
}
sqlcon.Close();
}
return(msg);
}
