public static string getFilteredEvents(string city, string team, string startDate, string endDate) { if (team == "0") { team = "NULL"; } string queryStr = "EXEC procViewEvents " + team + ", "; queryStr += (startDate == "Click to Select") ? "NULL, " : "'" + startDate + "', "; queryStr += (endDate == "Click to Select") ? "NULL, " : "'" + endDate + "', "; queryStr += (city == "0") ? "NULL" : "'" + city + "'"; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); if (dic.Count != 0) { for (int curIn = 0; curIn < dic["eventId"].Count; curIn++) { dic["eventId"][curIn] = UseKardoEncryption.getEncryptedString(dic["eventId"][curIn].ToString(), 100); } } return(KardoStaticMethods.getJSONFromDic(dic)); }
public static string getUserTickets(int userId) { string queryStr = "EXEC procGetUserTickets " + userId; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(KardoStaticMethods.getJSONFromDic(dic)); }
public static Dictionary <string, List <Object> > getEventsTeams() { string queryStr = "SELECT * FROM viewEventsTeams"; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(dic); }
public static Dictionary <string, List <Object> > getAuthentications(int userId) { string queryStr = "EXEC procGetAuthenticationsLast30Min " + userId; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(dic); }
public static Dictionary <string, List <Object> > getUserFromUUID(string UUID) { string queryStr = "EXEC procGetUserFromUUID '" + UUID + "'"; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(dic); }
public static Dictionary <string, List <Object> > getSecCategories() { string queryStr = "SELECT * FROM sSectionCategories ORDER BY priceRatio"; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(dic); }
public static Dictionary <string, List <Object> > getSSections(int stadiumId) { string queryStr = "EXEC procViewTheStadiumSections " + stadiumId; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(dic); }
public static Dictionary <string, List <Object> > getSportTypes() { string queryStr = "SELECT * FROM sportType WHERE deletedFlag = 0 ORDER BY sportType"; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(dic); }
public static string getEventsDateGroups() { string queryStr = "SELECT * FROM viewEventsDateGroups"; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(KardoStaticMethods.getJSONFromDic(dic)); }
public static Dictionary <string, List <Object> > getEventTicketInfo(int eventId) { string queryStr = "EXEC procEventTicketInfo " + eventId; SqlCommand sc = new SqlCommand(queryStr, con); SqlDataReader sdr; con.Open(); sdr = sc.ExecuteReader(); Dictionary <string, List <Object> > dic = KardoGeneralModel.getDicFromSDR(sdr); con.Close(); return(dic); }