protected void DeleteAnnoucement_Click(object sender, EventArgs e) { AnnouncementTable announcement = new AnnouncementTable() { announce_id = Convert.ToInt32(deleteAnnouncementIdUser.Text) }; ConnString db = new ConnString(); try { db.Delete(announcement); adminChangeMessage.Text = db.Message; } catch (OracleException ex) { if (ex.Message.Contains("ORA-00000")) { adminChangeMessage.Text = "We've got a situation"; } adminChangeMessage.Text = ex.Message; } Show(); }
protected void UpdateAnnouncement_Click(object sender, EventArgs e) { AnnouncementTable announcement = new AnnouncementTable() { announce_id = Convert.ToInt32(updateAnnouncementIdUser.Text), announce_text = updateAnnouncementTextUser.Text, emp_id = Convert.ToInt32(empNum.Text) }; ConnString db = new ConnString(); try { db.Update(announcement); adminChangeMessage.Text = db.Message; } catch (OracleException ex) { if (ex.Message.Contains("ORA-01407")) { adminChangeMessage.Text = "Announcement Text cannot be left Blank."; } else if (ex.Message.Contains("ORA-12899")) { adminChangeMessage.Text = "Announcement text must be under 200 Characters."; } else { adminChangeMessage.Text = ex.Message; } } Show(); }
protected void CreateAnnouncement_Click(object sender, EventArgs e) { AnnouncementTable announcement = new AnnouncementTable() { announce_id = Convert.ToInt32(createAnnouncementIdUser.Text), announce_text = createAnnouncementTextUser.Text, emp_id = Convert.ToInt32(empNum.Text) //Convert.ToInt32(createAnnouncementEmployeeUser.Text) //needs to equal emp_id for user logged in }; ConnString db = new ConnString(); try { db.Add(announcement); adminChangeMessage.Text = db.Message; } catch (OracleException ex) { if (ex.Message.Contains("ORA-00001")) { adminChangeMessage.Text = "Announcement ID already exists. Please Select New ID."; } else if (ex.Message.Contains("ORA-01400")) { adminChangeMessage.Text = "All Fields must be filled in."; } else if (ex.Message.Contains("ORA-12899")) { adminChangeMessage.Text = "Announcement text must be under 200 Characters."; } else if (ex.Message.Contains("ORA-01407")) { adminChangeMessage.Text = "Announcement Text cannot be left Blank."; } else { adminChangeMessage.Text = ex.Message; } } Show(); }