public ActivityTypeService(string type = null, int?id = null) { string query = @"SELECT MovementTypeId activityTypeId, MovementType activityType FROM Data_Layer_Test.MovementTypes WHERE IsActive = true"; string queryType = " and MovementType = " + type; string queryId = " and MovementTypeId = " + id.ToString(); if (type != null && id != null) { query = query + queryType + queryId; } else if (type != null) { query = query + queryType; } else if (id != null) { query = query + queryId; } var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }
//@"SELECT TO_JSON_STRING(t, true) FROM(SELECT ClubId clubid, ClubName clubname, Location location, isActive FROM Data_Layer.Clubs WHERE DivisionId = 2) t"; public StudiosService() { var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }
public PersonnelService(int clubid, PersonnelFilters pf) { string query = BuildQuery(clubid, pf); var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }
public EventService(int clubid, EventsFilters eventsFilters, int?eventid = null) { string query = BuildQuery(clubid, eventsFilters, eventid); var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }
public ScheduleService(int clubid, ScheduleFilters classFilters) { string query = BuildQuery(clubid, classFilters); var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }
//@"SELECT TO_JSON_STRING(t, true) FROM(SELECT ClubId clubid, ClubName clubname, Location location, isActive FROM Data_Layer.Clubs WHERE DivisionId = 2) t"; public ConceptService(int?clubid = null, int?conceptid = null, int?language = 0) { string query = ""; if (language == 0 || language == 2) { query = @"SELECT ConceptId conceptid, IFNULL(Concept, '') conceptname, ClubId clubid, isActive from Data_Layer_Test.Concepts"; if (clubid != null) { query = query + " WHERE ClubId = " + clubid.ToString(); } else if (clubid != null && conceptid != null) { query = query + " WHERE ClubId = " + clubid.ToString() + " and ConceptId = " + conceptid.ToString(); } else if (conceptid != null) { query = query + " WHERE ConceptId = " + conceptid.ToString(); } } else { query = @"SELECT ConceptId conceptid, IFNULL(FrenchConcept, '') conceptname, ClubId clubid, isActive from Data_Layer_Test.Concepts"; if (clubid != null) { query = query + " WHERE ClubId = " + clubid.ToString(); } else if (clubid != null && conceptid != null) { query = query + " WHERE ClubId = " + clubid.ToString() + " and ConceptId = " + conceptid.ToString(); } else if (conceptid != null) { query = query + " WHERE ConceptId = " + conceptid.ToString(); } } var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }
public ClassTypesService(int clubid, int?conceptid, int?language) { string query = ""; if (language == 0 || language == 2) { query = @"select DISTINCT ClassTypes.ClassTypeId id, IFNULL(ClassTypes.ClassType, '') name, ClassTypes.ConceptId conceptId, ClassCategories.CategoryName className, IFNULL(ClassCategories.Description, '') description from Data_Layer_Test.ClassTypes inner join Data_Layer_Test.ClassCategories on ClassCategories.ClassTypeId = ClassTypes.ClassTypeId and ClassCategories.ClassCategoryId = ClassTypes.CSIServiceId where ClassCategories.EventFlag = false and ClassCategories.ClubId = " + clubid.ToString(); } else { query = @"select DISTINCT ClassTypes.ClassTypeId id, IFNULL(ClassTypes.FrenchClassType, '') name, ClassTypes.ConceptId conceptId, IFNULL(ClassCategories.FrenchCategoryName, '') className, IFNULL(ClassCategories.FrenchDescription, '') description from Data_Layer_Test.ClassTypes inner join Data_Layer_Test.ClassCategories on ClassCategories.ClassTypeId = ClassTypes.ClassTypeId and ClassCategories.ClassCategoryId = ClassTypes.CSIServiceId where ClassCategories.EventFlag = false and ClassCategories.ClubId = " + clubid.ToString(); } if (conceptid != null) { query = query + " and ClassTypes.ConceptId = " + conceptid.ToString(); } var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }
public ResourceService(int clubid, int?resourceid = null) { string query = @"SELECT ResourceId, ResourceName, ClubId, true as isActive FROM Data_Layer_Test.Resources WHERE ClubId =" + clubid.ToString(); if (resourceid != null) { query = query + " and ResourceId = " + resourceid.ToString(); } var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }
public ClubService(int?siteid = null, int?clubid = null) { string query = @"SELECT ClubId clubid, ClubName clubname, CSIId csiid, GPId gpid, Location location, zip, RitaID, MerchantId, ExtraLanguage, TimeZone, isActive FROM Data_Layer_Test.Clubs WHERE DivisionId = 2"; if (siteid != null && clubid == null) { query = query + " and CSIId = " + siteid.ToString(); } else if (siteid == null && clubid != null) { query = query + " and ClubId = " + clubid.ToString(); } else { query = query + ""; } var bqq = new BigQueryQuery(); var client = bqq.CreateClient(); var job = bqq.CreateQueryJob(client, query); Results.Add(bqq.GetBigQueryResults(client, job)); }