public void Delete(AnnouncementTable announcement)
{
string command = "DELETE FROM NET_ANNOUNCEMENTS WHERE announce_id = :id";
int rows;
conn.Open();
cmd = new OracleCommand(command, conn);
cmd.Parameters.Add(new OracleParameter("id", announcement.announce_id));
rows = cmd.ExecuteNonQuery();
conn.Close();
Message = rows.ToString() + " row(s) have been deleted.";
}
public void Update(AnnouncementTable announcement)
{
string command = "UPDATE NET_ANNOUNCEMENTS SET announce_id = :id, announce_text = :a_text, announce_date = SYSDATE, emp_id = :e_id WHERE announce_id = :id";
int rows;
conn.Open();
cmd = new OracleCommand(command, conn);
cmd.Parameters.Add(new OracleParameter("id", announcement.announce_id));
cmd.Parameters.Add(new OracleParameter("a_text", announcement.announce_text));
cmd.Parameters.Add(new OracleParameter("e_id", announcement.emp_id));
rows = cmd.ExecuteNonQuery();
conn.Close();
Message = rows.ToString() + " row(s) have been updated.";
}
public void Add(AnnouncementTable announcement)
{
string command = "INSERT INTO NET_ANNOUNCEMENTS (announce_id, announce_text, emp_id) VALUES (:id, :a_text, :e_id)";
int rows;
conn.Open();
cmd = new OracleCommand(command, conn);
cmd.Parameters.Add(new OracleParameter("id", announcement.announce_id));
cmd.Parameters.Add(new OracleParameter("a_text", announcement.announce_text));
cmd.Parameters.Add(new OracleParameter("e_id", announcement.emp_id));
rows = cmd.ExecuteNonQuery();
conn.Close();
Message = rows.ToString() + " row(s) have been added.";
}