public static void deleteProjectShortcomings(ProjectShortcomings projectShortcomings)
{
try
{
DBConnection.updateDB("delete from project_shortcomings where staff_id = '" + projectShortcomings.StaffId + "' and proj_id = '" + projectShortcomings.ProjectId + "' and event_id = '" + projectShortcomings.EventId + "'");
}
catch (Exception ex)
{
MessageBox.Show("Something went wrong! '" + ex + "'", "Update client", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void addProjectShortcomings(ProjectShortcomings projectShortcomings)
{
try
{
DBConnection.updateDB("insert into project_shortcomings(staff_id,proj_id,event_id,description)values('" + projectShortcomings.StaffId + "','" + projectShortcomings.ProjectId + "','" + projectShortcomings.EventId + "','" + projectShortcomings.Description + "')");
}
catch (Exception)
{
MessageBox.Show("Something went wrong!", "Update client", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}