public Dictionary<string, string> GetAgendaSessionAsset(string queryString)
{
MobileAppsAgendaData_1Entities entities = new MobileAppsAgendaData_1Entities();
NameValueCollection parameters = HttpUtility.ParseQueryString(queryString);
IEnumerable<viewWebAgendaSessionAsset> webAgendaSessionAssets = entities.ExecuteStoreQuery<viewWebAgendaSessionAsset>("spr_WebAgendaSessionAsset_Select", "");
int limit = 0;
int offset = 0;
bool sendResultsOnly = false;
foreach (string key in parameters)
{
string value = parameters[key];
if (key == "limit")
{
limit = Convert.ToInt32(value);
}
else if (key == "offset")
{
offset = Convert.ToInt32(value);
}
if (key == "conferenceID")
{
if (!value.Contains("["))
{
int conferenceID = Convert.ToInt32(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.conferenceID == conferenceID);
}
else
{
List<Object> conferenceIDs = APITools.createList(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => conferenceIDs.Contains(p.conferenceID));
}
}
else if (key == "sessionAssetAuthor")
{
if (!value.Contains("["))
{
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.sessionAssetAuthor == value);
}
else
{
List<Object> sessionAssetAuthors = APITools.createList(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => sessionAssetAuthors.Contains(p.sessionAssetAuthor));
}
}
else if (key == "sessionAssetAuthorBio")
{
if (!value.Contains("["))
{
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.sessionAssetAuthorBio.Contains(value));
}
else
{
List<Object> sessionAssetAuthorBios = APITools.createList(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => sessionAssetAuthorBios.Contains(p.sessionAssetAuthorBio));
}
}
else if (key == "sessionAssetAuthorJobTitle")
{
if (!value.Contains("["))
{
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.sessionAssetAuthorJobTitle == value);
}
else
{
List<Object> sessionAssetAuthorJobTitles = APITools.createList(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => sessionAssetAuthorJobTitles.Contains(p.sessionAssetAuthorJobTitle));
}
}
else if (key == "sessionAssetAuthorOrganizationName")
{
if (!value.Contains("["))
{
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.sessionAssetAuthorOrganizationName == value);
}
else
{
List<Object> sessionAssetAuthorOrganizationNames = APITools.createList(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => sessionAssetAuthorOrganizationNames.Contains(p.sessionAssetAuthorOrganizationName));
}
}
else if (key == "sessionAssetDescription")
{
if (!value.Contains("["))
{
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.sessionAssetDescription.Contains(value));
}
else
{
List<Object> sessionAssetDescriptions = APITools.createList(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => sessionAssetDescriptions.Contains(p.sessionAssetDescription));
}
}
//else if (key == "sessionAssetID")
//{
// webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p..ToString() == intValue);
//}
else if (key == "sessionAssetTitle")
{
if (!value.Contains("["))
{
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.sessionAssetTitle == value);
}
else
{
List<Object> sessionAssetTitles = APITools.createList(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => sessionAssetTitles.Contains(p.sessionAssetTitle));
}
}
else if (key == "sessionID")
{
if (!value.Contains("["))
{
int sessionID = Convert.ToInt32(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.sessionID == sessionID);
}
else
{
List<Object> sessionIDs = APITools.createList(value);
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => sessionIDs.Contains(p.sessionID));
}
}
else if (key == "totalResults")
{
if (value.ToLower() == "true")
sendResultsOnly = true;
}
}
if (sendResultsOnly)
{
string count = webAgendaSessionAssets.Count().ToString();
Dictionary<string, string> dTotalResults = new Dictionary<string, string>();
dTotalResults.Add("totalResults", count);
dTotalResults.Add("resultType", "SessionAsset");
return dTotalResults;
}
if (offset != 0)
webAgendaSessionAssets = webAgendaSessionAssets.Where(p => p.RowIdentity > offset);
if (limit != 0)
webAgendaSessionAssets = webAgendaSessionAssets.Take(limit);
JavaScriptSerializer serializer = new JavaScriptSerializer();
serializer.MaxJsonLength = Int32.MaxValue;
string json = serializer.Serialize(webAgendaSessionAssets);
string rowcount = APITools.countJSONRecords(json);
Dictionary<string, string> ret = new Dictionary<string, string>();
ret.Add("totalResults", rowcount);
ret.Add("resultType", "SessionAsset");
ret.Add("results", json);
return ret;
}
public Dictionary<string, string> GetBoothsforWebAgenda(string queryString)
{
MobileAppsAgendaData_1Entities entities = new MobileAppsAgendaData_1Entities();
NameValueCollection parameters = HttpUtility.ParseQueryString(queryString);
IEnumerable<viewAllBoothsforWebAgenda> booths = entities.ExecuteStoreQuery<viewAllBoothsforWebAgenda>("spr_AllBoothsforWebAgenda_Select", "");
int limit = 0;
int offset = 0;
bool sendResultsOnly = false;
foreach (string key in parameters)
{
string value = parameters[key];
if (key == "limit")
{
limit = Convert.ToInt32(value);
}
else if (key == "offset")
{
offset = Convert.ToInt32(value);
}
else if (key == "totalResults")
{
if (value.ToLower() == "true")
sendResultsOnly = true;
}
}
if (sendResultsOnly)
{
string count = booths.Count().ToString();
Dictionary<string, string> dTotalResults = new Dictionary<string, string>();
dTotalResults.Add("totalResults", count);
dTotalResults.Add("resultType", "Exhibitor");
return dTotalResults;
}
if (offset != 0)
booths = booths.Where(p => p.RowIdentity > offset);
if (limit != 0)
booths = booths.Take(limit);
JavaScriptSerializer serializer = new JavaScriptSerializer();
serializer.MaxJsonLength = Int32.MaxValue;
string json = serializer.Serialize(booths);
string rowcount = APITools.countJSONRecords(json);
Dictionary<string, string> ret = new Dictionary<string, string>();
ret.Add("totalResults", rowcount);
ret.Add("resultType", "Exhibitor");
ret.Add("results", json);
return ret;
}
public Dictionary<string, string> GetWebExhibitor(string queryString)
{
MobileAppsAgendaData_1Entities entities = new MobileAppsAgendaData_1Entities();
NameValueCollection parameters = HttpUtility.ParseQueryString(queryString);
IEnumerable<viewWebExhibitor> webExhibitor = entities.ExecuteStoreQuery<viewWebExhibitor>("spr_WebExhibitor_Select", "");
int limit = 0;
int offset = 0;
bool sendResultsOnly = false;
foreach (string key in parameters)
{
string value = parameters[key];
if (key == "limit")
{
limit = Convert.ToInt32(value);
}
else if (key == "offset")
{
offset = Convert.ToInt32(value);
}
if (key == "conferenceID")
{
if (!value.Contains("["))
{
int conferenceID = Convert.ToInt32(value);
webExhibitor = webExhibitor.Where(p => p.conferenceID == conferenceID);
}
else
{
List<Object> ids = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => ids.Contains(p.conferenceID));
}
}
else if (key == "exhibitorName")
{
if (!value.Contains("["))
webExhibitor = webExhibitor.Where(p => p.exhibitorName == value);
else
{
List<Object> exhibitorNames = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => exhibitorNames.Contains(p.exhibitorName));
}
}
else if (key == "exhibitorDescription")
{
if (!value.Contains("["))
webExhibitor = webExhibitor.Where(p => p.exhibitorDescription.Contains(value));
else
{
List<Object> exhibitorDescriptions = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => exhibitorDescriptions.Contains(p.exhibitorDescription));
}
}
else if (key == "exhibitorUrl")
{
if (!value.Contains("["))
webExhibitor = webExhibitor.Where(p => p.exhibitorURL == value);
else
{
List<Object> exhibitorUrls = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => exhibitorUrls.Contains(p.exhibitorURL));
}
}
else if (key == "sponsorLogo")
{
if (!value.Contains("["))
webExhibitor = webExhibitor.Where(p => p.sponsorLogo == value);
else
{
List<Object> sponsorLogos = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => sponsorLogos.Contains(p.sponsorLogo));
}
}
else if (key == "sponsorTypeID")
{
if (!value.Contains("["))
{
int sponsorTypeID = Convert.ToInt32(value);
webExhibitor = webExhibitor.Where(p => p.sponsorTypeID == sponsorTypeID);
}
else
{
List<Object> sponsorTypeIDs = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => sponsorTypeIDs.Contains(p.sponsorTypeID));
}
}
else if (key == "sponsorTypeDescription")
{
if (!value.Contains("["))
webExhibitor = webExhibitor.Where(p => p.sponsorTypeName == value);
else
{
List<Object> sponsorTypeDescription = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => sponsorTypeDescription.Contains(p.sponsorTypeName));
}
}
else if (key == "exhibitorBooth")
{
if (!value.Contains("["))
webExhibitor = webExhibitor.Where(p => p.exhibitorBooth == value);
else
{
List<Object> exhibitorBooths = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => exhibitorBooths.Contains(p.exhibitorBooth));
}
}
else if (key == "pointx")
{
if (!value.Contains("["))
{
double? xp = Convert.ToDouble(value);
webExhibitor = webExhibitor.Where(p => p.xPoint == xp);
}
else
{
List<Object> pointxs = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => pointxs.Contains(p.xPoint));
}
}
else if (key == "pointy")
{
if (!value.Contains("["))
{
double? yp = Convert.ToDouble(value);
webExhibitor = webExhibitor.Where(p => p.yPoint == yp);
}
else
{
List<Object> pointys = APITools.createList(value);
webExhibitor = webExhibitor.Where(p => pointys.Contains(p.yPoint));
}
}
else if (key == "totalResults")
{
if (value.ToLower() == "true")
sendResultsOnly = true;
}
}
if (sendResultsOnly)
{
string count = webExhibitor.Count().ToString();
Dictionary<string, string> dTotalResults = new Dictionary<string, string>();
dTotalResults.Add("totalResults", count);
dTotalResults.Add("resultType", "Exhibitor");
return dTotalResults;
}
if (offset != 0)
webExhibitor = webExhibitor.Where(p => p.RowIdentity > offset);
if (limit != 0 )
webExhibitor = webExhibitor.Take(limit);
JavaScriptSerializer serializer = new JavaScriptSerializer();
serializer.MaxJsonLength = Int32.MaxValue;
string json = serializer.Serialize(webExhibitor);
string rowcount = APITools.countJSONRecords(json);
Dictionary<string, string> ret = new Dictionary<string, string>();
ret.Add("totalResults", rowcount);
ret.Add("resultType", "Exhibitor");
ret.Add("results", json);
return ret;
}
public Dictionary<string, string> GetAgendaSession(string queryString)
{
MobileAppsAgendaData_1Entities entities = new MobileAppsAgendaData_1Entities();
NameValueCollection parameters = HttpUtility.ParseQueryString(queryString);
IEnumerable<viewWebAgendaSession> webAgendaSession = entities.ExecuteStoreQuery<viewWebAgendaSession>("spr_WebAgendaSession_Select", "");
int limit = 0;
int offset = 0;
bool sendResultsOnly = false;
foreach (string key in parameters)
{
string value = parameters[key];
if (key == "limit")
{
limit = Convert.ToInt32(value);
}
else if (key == "offset")
{
offset = Convert.ToInt32(value);
}
if (key == "conferenceID")
{
if (!value.Contains("["))
{
int conferenceID = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.conferenceID == conferenceID);
}
else
{
List<Object> conferenceIDs = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => conferenceIDs.Contains(p.conferenceID));
}
}
//else if (key == "endTimeStamp")
//{
// DateTime endTimeStamp = Convert.ToDateTime(value);
// webAgendaSession = webAgendaSession.Where(p => p.endTimeStamp == endTimeStamp);
//}
else if (key == "endDay")
{
if (!value.Contains("["))
{
int endDay = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.endDay == endDay);
}
else
{
List<Object> endDays = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => endDays.Contains(p.endDay));
}
}
else if (key == "endHour")
{
if (!value.Contains("["))
{
int endHour = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.endHour == endHour);
}
else
{
List<Object> endHours = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => endHours.Contains(p.endHour));
}
}
else if (key == "endMinute")
{
if (!value.Contains("["))
{
int endMinute = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.endMinute == endMinute);
}
else
{
List<Object> endMinutes = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => endMinutes.Contains(p.endMinute));
}
}
else if (key == "endMonth")
{
if (!value.Contains("["))
{
int endMonth = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.endMonth == endMonth);
}
else
{
List<Object> endMonths = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => endMonths.Contains(p.endMonth));
}
}
else if (key == "endYear")
{
if (!value.Contains("["))
{
int endYear = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.endYear == endYear);
}
else
{
List<Object> endYears = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => endYears.Contains(p.endYear));
}
}
else if (key == "eventTypeDescription")
{
if (!value.Contains("["))
{
webAgendaSession = webAgendaSession.Where(p => p.eventTypeDescription == value);
}
else
{
List<Object> eventTypeDescriptions = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => eventTypeDescriptions.Contains(p.eventTypeDescription));
}
}
else if (key == "eventTypeID")
{
if (!value.Contains("["))
{
int eventTypeID = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.eventTypeID == eventTypeID);
}
else
{
List<Object> eventTypeIDs = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => eventTypeIDs.Contains(p.eventTypeID));
}
}
else if (key == "floor")
{
if (!value.Contains("["))
{
int floor = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.floor == floor);
}
else
{
List<Object> floors = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => floors.Contains(p.floor));
}
}
else if (key == "room")
{
if (!value.Contains("["))
{
webAgendaSession = webAgendaSession.Where(p => p.room == value);
}
else
{
List<Object> rooms = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => rooms.Contains(p.room));
}
}
else if (key == "sessionID")
{
if (!value.Contains("["))
{
int sessionID = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.sessionID == sessionID);
}
else
{
List<Object> sessionIDs = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => sessionIDs.Contains(p.sessionID));
}
}
else if (key == "sessionTitle")
{
if (!value.Contains("["))
{
webAgendaSession = webAgendaSession.Where(p => p.sessionTitle == value);
}
else
{
List<Object> sessionTitles = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => sessionTitles.Contains(p.sessionTitle));
}
}
//else if (key == "startTimeStamp")
//{
// DateTime startTimeStamp = Convert.ToDateTime(value);
// webAgendaSession = webAgendaSession.Where(p => p.startTimeStamp == startTimeStamp);
//}
else if (key == "startDay")
{
if (!value.Contains("["))
{
int startDay = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.startDay == startDay);
}
else
{
List<Object> startDays = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => startDays.Contains(p.startDay));
}
}
else if (key == "startHour")
{
if (!value.Contains("["))
{
int startHour = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.startHour == startHour);
}
else
{
List<Object> startHours = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => startHours.Contains(p.startHour));
}
}
else if (key == "startMinute")
{
if (!value.Contains("["))
{
int startMinute = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.startMinute == startMinute);
}
else
{
List<Object> startMinutes = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => startMinutes.Contains(p.startMinute));
}
}
else if (key == "startMonth")
{
if (!value.Contains("["))
{
int startMonth = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.startMonth == startMonth);
}
else
{
List<Object> startMonths = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => startMonths.Contains(p.startMonth));
}
}
else if (key == "startYear")
{
if (!value.Contains("["))
{
int startYear = Convert.ToInt32(value);
webAgendaSession = webAgendaSession.Where(p => p.startYear == startYear);
}
else
{
List<Object> startYears = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => startYears.Contains(p.startYear));
}
}
else if (key == "sessionLevelDescription")
{
if (!value.Contains("["))
{
webAgendaSession = webAgendaSession.Where(p => p.sessionDescription.Contains(value));
}
else
{
List<Object> sessionLevelDescriptions = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => sessionLevelDescriptions.Contains(p.sessionDescription));
}
}
//else if (key == "sessionKeyWords")
// webAgendaSession = webAgendaSession.Where(p => p.sessionKeyWords.Contains(value));
else if (key == "superTrackTitle")
{
if (!value.Contains("["))
{
webAgendaSession = webAgendaSession.Where(p => p.supertracks.Contains(value));
}
else
{
List<Object> superTrackTitles = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => superTrackTitles.Contains(p.supertracks));
}
}
else if (key == "trackTitle")
{
if (!value.Contains("["))
{
webAgendaSession = webAgendaSession.Where(p => p.tracks.Contains(value));
}
else
{
List<Object> trackTitles = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => trackTitles.Contains(p.tracks));
}
}
else if (key == "pointx")
{
if (!value.Contains("["))
{
double? xp = Convert.ToDouble(value);
webAgendaSession = webAgendaSession.Where(p => p.xPoint == xp);
}
else
{
List<Object> pointxs = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => pointxs.Contains(p.xPoint));
}
}
else if (key == "pointy")
{
if (!value.Contains("["))
{
double? yp = Convert.ToDouble(value);
webAgendaSession = webAgendaSession.Where(p => p.yPoint == yp);
}
else
{
List<Object> pointys = APITools.createList(value);
webAgendaSession = webAgendaSession.Where(p => pointys.Contains(p.yPoint));
}
}
else if (key == "totalResults")
{
if (value.ToLower() == "true")
sendResultsOnly = true;
}
}
if (sendResultsOnly)
{
string count = webAgendaSession.Count().ToString();
Dictionary<string, string> dTotalResults = new Dictionary<string, string>();
dTotalResults.Add("totalResults", count);
dTotalResults.Add("resultType", "Session");
return dTotalResults;
}
if (offset != 0)
webAgendaSession = webAgendaSession.Where(p => p.RowIdentity > offset);
if (limit != 0)
webAgendaSession = webAgendaSession.Take(limit);
JavaScriptSerializer serializer = new JavaScriptSerializer();
serializer.MaxJsonLength = Int32.MaxValue;
string json = serializer.Serialize(webAgendaSession);
string rowcount = APITools.countJSONRecords(json);
Dictionary<string, string> ret = new Dictionary<string, string>();
ret.Add("totalResults", rowcount);
ret.Add("resultType", "Session");
ret.Add("results", json);
return ret;
}
