public static Dictionary <string, Object> getUserFromUserId(int userId)
{
string queryStr = "EXEC procGetUserFromUserId " + userId;
SqlCommand sc = new SqlCommand(queryStr, con);
SqlDataReader sdr;
con.Open();
sdr = sc.ExecuteReader();
Dictionary <string, Object> dic = KardoGeneralModel.getDicFromSDROneRow(sdr);
con.Close();
return(dic);
}
public static string getStadiumFromId(int stadiumId)
{
string queryStr = "SELECT s.*, ts.sportTypeId FROM stadiums s INNER JOIN theStadiumIsSuitableFor ts ON ts.stadiumId = s.stadiumId WHERE s.stadiumId=" + stadiumId;
SqlCommand sc = new SqlCommand(queryStr, con);
SqlDataReader sdr;
con.Open();
sdr = sc.ExecuteReader();
Dictionary <string, Object> dic = KardoGeneralModel.getDicFromSDROneRow(sdr);
con.Close();
return(KardoStaticMethods.getJSONFromDic(dic));
}
public static string getSectionFromId(int sectionId)
{
string queryStr = "SELECT ss.*, ssc.categoryName, ssc.priceRatio FROM stadiumSections ss INNER JOIN sSectionCategories ssc ON ss.categoryId = ssc.categoryId WHERE ss.sectionId=" + sectionId;
SqlCommand sc = new SqlCommand(queryStr, con);
SqlDataReader sdr;
con.Open();
sdr = sc.ExecuteReader();
Dictionary <string, Object> dic = KardoGeneralModel.getDicFromSDROneRow(sdr);
con.Close();
return(KardoStaticMethods.getJSONFromDic(dic));
}
public static string getUserFromId(int userId)
{
string queryStr = "SELECT * FROM users WHERE userId=" + userId;
SqlCommand sc = new SqlCommand(queryStr, con);
SqlDataReader sdr;
con.Open();
sdr = sc.ExecuteReader();
Dictionary <string, Object> dic = KardoGeneralModel.getDicFromSDROneRow(sdr);
con.Close();
return(KardoStaticMethods.getJSONFromDic(dic));
}
public static int countNewKps()
{
string queryStr = "SELECT COUNT(kardoPassoId) AS newKps FROM kardoPassos WHERE saleDate > DATEADD(YEAR, -1, GETUTCDATE())";
SqlCommand sc = new SqlCommand(queryStr, con);
SqlDataReader sdr;
con.Open();
sdr = sc.ExecuteReader();
Dictionary <string, Object> dic = KardoGeneralModel.getDicFromSDROneRow(sdr);
con.Close();
return((int)dic["newKps"]);
}
public static int countNewUsers()
{
string queryStr = "SELECT COUNT(userId) AS newUsers FROM users WHERE createdDate > DATEADD(YEAR, -1, GETUTCDATE()) AND deletedFlag = 0";
SqlCommand sc = new SqlCommand(queryStr, con);
SqlDataReader sdr;
con.Open();
sdr = sc.ExecuteReader();
Dictionary <string, Object> dic = KardoGeneralModel.getDicFromSDROneRow(sdr);
con.Close();
return((int)dic["newUsers"]);
}
public static string getSectionInfo(int eventId, int ssId)
{
string queryStr = "EXEC procEventTicketInfoOneSec " + eventId + ", " + ssId;
SqlCommand sc = new SqlCommand(queryStr, con);
SqlDataReader sdr;
con.Open();
sdr = sc.ExecuteReader();
Dictionary <string, Object> dic = KardoGeneralModel.getDicFromSDROneRow(sdr);
con.Close();
return(KardoStaticMethods.getJSONFromDic(dic));
}
public static Dictionary <string, Object> getEventInfo(int eventId)
{
string queryStr = "EXEC procViewTheEvent " + eventId;
SqlCommand sc = new SqlCommand(queryStr, con);
SqlDataReader sdr;
con.Open();
sdr = sc.ExecuteReader();
Dictionary <string, Object> dic = KardoGeneralModel.getDicFromSDROneRow(sdr);
con.Close();
return(dic);
}