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();
}
