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 void TestQuery()
{
var snippet = new BigQueryQuery();
snippet.Query(_projectId);
var outputLines = _stringOut.ToString().Trim().Split(Environment.NewLine);
Assert.Equal(100, outputLines.Count());
}
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));
}
