public static void UpdateCalendarSettings(string FilterE, string MonthE, string PosterE, string ListE, string Default, string sGlobalHeader)
{
int month = 0;
if (MonthE == "on")
{
month = 1;
}
int poster = 0;
if (PosterE == "on")
{
poster = 1;
}
int list = 0;
if (ListE == "on")
{
list = 1;
}
int filter = 0;
if (FilterE == "Enabled")
{
filter = 1;
}
string sQuery = "UPDATE calendarsettings SET bFilterEnabled = " + filter + ", bMonthEnabled = " + month + ", bPosterEnabled = " + poster + ", bListEnabled = " + list + ", sDefault = '" + Default + "', sGlobalHeader = '" + sGlobalHeader + "'";
int iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
}
public static int AddPropertyToEvent(int iEventId, int iPropertyId)
{
int iRowsAffected = 0;
string sQuery = "INSERT INTO eventproperties(iEventId, iPropertyId) VALUES(" + iEventId + "," + iPropertyId + ")";
iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
return(iRowsAffected);
}
public static int CreateNewProperty(int iPropertyTypeId, string sPropertyName)
{
int iRowsAffected = 0;
string sQuery = "INSERT INTO property(iPropertyTypeId, vProperty) VALUES(" + iPropertyTypeId + ",'" + sPropertyName + "')";
iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
return(iRowsAffected);
}
public static int CreateNewPropertyType(string sPropertyTypeName)
{
int iRowsAffected = 0;
string sQuery = "INSERT INTO propertytype(vPropertyType) VALUES('" + sPropertyTypeName + "')";
iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
return(iRowsAffected);
}
/// <summary>
/// Deactives an event by Event Id
/// </summary>
/// <param name="iEventId"></param>
/// <returns>Number of rows affected, ideally 1</returns>
public static int DeactivateEvent(int iEventId)
{
int iRowsAffected = 0;
string sQuery = "UPDATE calendarevent SET bActive = 0 WHERE iEventId = " + iEventId;
iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
return(iRowsAffected);
}
/// <summary>
/// Publishes an existing submitted event in DB
/// </summary>
/// <param name="iEventId">id# of event to publish</param>
/// <returns>Number of rows affected, signifying if the creation was successful.</returns>
public static int PublishEvent(int iEventId)
{
int iRowsAffected = 0;
String sQuery = "UPDATE calendarevent SET bPublished = 1, dtPublishDate = NOW() WHERE iEventId = " + iEventId;
iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
var tempEvent = EventManager.SubmittedEvents[iEventId];
EventManager.SubmittedEvents.Remove(iEventId);
EventManager.PublishedEvents.Add(tempEvent.EventId, tempEvent);
return(iRowsAffected);
}
public static void UpdatePreselectedFilters(List <int> li)
{
string sQuery = "DELETE FROM preselectedcalendarfilters";
int iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
sQuery = "INSERT INTO preselectedcalendarfilters(iPropertyId) VALUES(";
foreach (int i in li)
{
sQuery = sQuery + i + "),(";
}
sQuery = sQuery.Remove(sQuery.Length - 2);
iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
}
/// <summary>
/// Creates a new submitted event in DB
/// </summary>
/// <param name="sEventTitle">Event Title</param>
/// <param name="dEventDate">Date of Event</param>
/// <param name="sStartTime">Event Start Time(optional)</param>
/// <param name="sEndTime">Event End Time(optional)</param>
/// <param name="bAllDay">All Day Event(optional)</param>
/// <param name="sVenueName">Venue Name</param>
/// <param name="sAddress">Address</param>
/// <param name="sDescription">Description</param>
/// <param name="sOrganizerName">Organizer's Name</param>
/// <param name="sOrganizerEmail">Organizer's Email</param>
/// <param name="sOrganizerPhoneNumber">Organizer's Phone Number</param>
/// <param name="sOrganizerURL">Organizer's URL(optional)</param>
/// <param name="sCost">Cost(optional)</param>
/// <param name="sRegistrationURL">Registration URL(optional)</param>
/// <param name="sSubmitterName">Submitter's Name(optional)</param>
/// <param name="sSubmitterEmail">Submitter's Email(optional)</param>
/// <returns></returns>
public static int InsertSubmittedEvent(string sEventTitle, string dEventDate, string dEndDate, string sStartTime, string sEndTime, bool bAllDay, string sVenueName, string sAddress, string sDescription, string sOrganizerName,
string sOrganizerEmail, string sOrganizerPhoneNumber, string sOrganizerURL, string sCost, string sRegistrationURL, string sSubmitterName, string sSubmitterEmail)
{
int iRowsAffected = 0;
string sQuery = "INSERT INTO calendarevent(vEventTitle, dEventDate, dEndDate, vStartTime, vEndTime, bAllDay, vVenueName, vAddress, vDescription, vOrganizerName, vOrganizerEmail, vOrganizerPhoneNumber," +
"vOrganizerURL, vCost, vRegistrationURL, vSubmitterName, vSubmitterEmail)" +
"VALUES('" + sEventTitle + "','" + dEventDate + "','" + dEndDate + "','" + sStartTime + "','" + sEndTime + "'," + Convert.ToInt32(bAllDay) + ",'" + sVenueName + "','" + sAddress + "','" +
sDescription + "','" + sOrganizerName + "','" + sOrganizerEmail + "','" + sOrganizerPhoneNumber + "','" + sOrganizerURL + "','" + sCost + "','" + sRegistrationURL + "','" + sSubmitterName + "','" + sSubmitterEmail + "')";
iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
int eventId = SQLDataAdapter.LastInsertedId;
var submittedEvent = new Event.Event(sEventTitle, sOrganizerName, sOrganizerEmail, sOrganizerPhoneNumber, sVenueName, sAddress, sDescription, sRegistrationURL, sSubmitterName, sSubmitterEmail, dEventDate, dEndDate, sStartTime, sEndTime, bAllDay);
submittedEvent.EventId = eventId;
EventManager.SubmittedEvents.Add(eventId, submittedEvent);
return(eventId);
}
public static void UpdateEvent(Event.Event ev)
{
string sQuery = "UPDATE calendarevent SET vEventTitle = '" + ev.Title + "', vOrganizerName = '" + ev.HostName + "', vOrganizerEmail = '" + ev.HostEmail + "', vOrganizerPhoneNumber = '" + ev.HostPhoneNumber + "', vVenueName = '" + ev.VenueName + "', vAddress = '" + ev.Address + "', vDescription = '" + ev.Description + "', vRegistrationURL = '" + ev.RegistrationURL + "', vSubmitterName = '" + ev.SubmitterName + "', vSubmitterEmail = '" + ev.SubmitterEmail + "', dEventDate = '" + ev.Date + "', dEndDate = '" + ev.EndDate + "', vStartTime = '" + ev.StartTime + "', vEndTime = '" + ev.EndTime + "', bAllDay = " + ev.AllDay + " WHERE iEventId = " + ev.EventId + " ";
int iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
}
//Example Usage of SQLDataAdapter to run Queries
public static void ExampleQuery2()
{
string sQuery = "INSERT INTO categories(vCategory) VALUES('Whatever')";
SQLDataAdapter.QueryExecute(sQuery);
}
