//ToDo: save exhibit info to the database
public void Update(Exhibit exhibit)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand(
" UPDATE Exhibit " +
" SET Title = @title, [Description] = @description, FeaturedImg = @featuredImg, ThumbnailImg = @thumbnailImg, " +
" ExhibitStartDate = @exhibitStartDate, ExhibitStartTime = @exhibitStartTime, ExhibitEndDate = @exhibitEndDate, ExhibitEndTime = @exhibitEndTime, " +
" RegistrationStartDate = @registrationStartDate, RegistrationStartTime = @registrationStartTime, RegistrationEndDate = @registrationEndDate, RegistrationEndTime = @registrationEndTime, " +
" ReceptionDate = @receptionDate, ReceptionStartTime = @receptionStartTime, ReceptionEndTime = @receptionEndTime, " +
" AdditionalComments = @additionalComments " +
" WHERE ExhibitID = @exhibitID",
connection);
cmd.Parameters.AddWithValue("@exhibitID", exhibit.getId());
cmd.Parameters.AddWithValue("@title", exhibit.getTitle());
cmd.Parameters.AddWithValue("@description", exhibit.getDescription());
cmd.Parameters.AddWithValue("@featuredImg", exhibit.getFeaturedImg());
cmd.Parameters.AddWithValue("@thumbnailImg", exhibit.getThumbnailImg());
cmd.Parameters.AddWithValue("@exhibitStartDate", exhibit.getExhibitStartDate());
cmd.Parameters.AddWithValue("@exhibitStartTime", exhibit.getExhibitStartTime());
cmd.Parameters.AddWithValue("@exhibitEndDate", exhibit.getExhibitEndDate());
cmd.Parameters.AddWithValue("@exhibitEndTime", exhibit.getExhibitEndTime());
cmd.Parameters.AddWithValue("@registrationStartDate", exhibit.getRegistrationStartDate());
cmd.Parameters.AddWithValue("@registrationStartTime", exhibit.getRegistrationStartTime());
cmd.Parameters.AddWithValue("@registrationEndDate", exhibit.getRegistrationEndDate());
cmd.Parameters.AddWithValue("@registrationEndTime", exhibit.getExhibitEndTime());
cmd.Parameters.AddWithValue("@receptionDate", exhibit.getReceptionDate());
cmd.Parameters.AddWithValue("@receptionStartTime", exhibit.getReceptionStartTime());
cmd.Parameters.AddWithValue("@receptionEndTime", exhibit.getReceptionEndTime());
cmd.Parameters.AddWithValue("@additionalComments", exhibit.getAdditionalComments());
cmd.ExecuteNonQuery();
connection.Close();
}
}
public void DeleteExhibit([FromBody] Exhibit exhibitData)
{
//create the exhibit manager
ExhibitDBManager exhibitDBManager = new ExhibitDBManager();
int exhibitID = exhibitData.getId();
//update exhibit and add it to the database
exhibitDBManager.Delete(exhibitID);
}
