示例#1
0
        public static DataSet ListAllEntries(int contestId, int contestEntryId)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@ContestID", contestId);
            sql.AddParameter("@ContestEntryID", contestEntryId);
            return(sql.Execute("sp_ContestEntry_List", CommandType.StoredProcedure));
        }
示例#2
0
        public static DataSet EmailExists(string email, int contestId)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@Email", email);
            sql.AddParameter("@ContestID", contestId);

            return(sql.Execute("sp_ContestEntry_EmailExists", CommandType.StoredProcedure));
        }
        public static DataSet ScreenNameExists(string screenname, int contestId)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@ScreenName", screenname);
            sql.AddParameter("@ContestID", contestId);

            return(sql.Execute("sp_ContestJudge_ScreenNameExists", CommandType.StoredProcedure));
        }
        public static void SaveContestComment(string comment, int contestEntryId, int contestJudgeId)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@Comment", comment);
            sql.AddParameter("@ContestEntryID", contestEntryId);
            sql.AddParameter("@ContestJudgeID", contestJudgeId);

            sql.ExecuteNonQuery("sp_ContestComment_Insert", CommandType.StoredProcedure);
        }
        public static DataSet EmailUnsubscribe(string email, int contestJudgeId, int optIn)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@Email", email);
            sql.AddParameter("@ContestJudgeID", contestJudgeId);
            sql.AddParameter("@OptIn", optIn);

            return(sql.Execute("sp_ContestJudge_EmailUnsubscribe", CommandType.StoredProcedure));
        }
示例#6
0
        public static DataSet GetByOrderNumber(int orderNumber)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorseExpoConnectionString"].ConnectionString);

            sql.AddParameter("@OrderNumber", orderNumber);
            sql.AddParameter("@PubNumber", ConfigurationManager.AppSettings["HorseExpoPubNumber"]);

            DataSet dsResult = sql.Execute("sp_ht_GetShowdateByPub", CommandType.StoredProcedure);

            return(dsResult);
        }
示例#7
0
        public static void SaveContestEntry(int contestId, int?customerId, string title, string description, string firstName,
                                            string lastName, string email, string videoUrl, string embedVideoUrl, string zipcode)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@ContestID", contestId);
            sql.AddParameter("@CustomerID", customerId);
            sql.AddParameter("@Title", title);
            sql.AddParameter("@Description", description);
            sql.AddParameter("@FirstName", firstName);
            sql.AddParameter("@LastName", lastName);
            sql.AddParameter("@Email", email);
            sql.AddParameter("@VideoUrl", videoUrl);
            sql.AddParameter("@EmbedVideoUrl", embedVideoUrl);
            sql.AddParameter("@Zipcode", zipcode);

            sql.ExecuteNonQuery("sp_ContestEntry_Insert", CommandType.StoredProcedure);
        }
示例#8
0
        public static DataSet GetByContestEntryID(int?contestEntryId)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@ContestEntryID", contestEntryId);

            DataSet dsResult = sql.Execute("sp_ContestEntry_GetContestEntryByID", CommandType.StoredProcedure);

            return(dsResult);
        }
        public static void UpdateContestJudge(int contestJudgeId, int contestId, string firstName, string lastName,
                                              string email, string zipcode, int?voteContestEntryId, string screenname, string password)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@ContestJudgeID", contestJudgeId);
            sql.AddParameter("@ContestID", contestId);
            sql.AddParameter("@FirstName", firstName);
            sql.AddParameter("@LastName", lastName);
            sql.AddParameter("@Email", email);
            sql.AddParameter("@Zipcode", zipcode);
            sql.AddParameter("@VoteContestEntryID", voteContestEntryId);
            sql.AddParameter("@ScreenName", screenname);
            sql.AddParameter("@Password", password);

            sql.ExecuteNonQuery("sp_contest_UpdateContestJudge", CommandType.StoredProcedure);
        }
示例#10
0
        public static DataSet ListExpoVendorID(string expoVendorIdList)
        {
            DataSet dsResult = new DataSet();

            if (!string.IsNullOrEmpty(expoVendorIdList))
            {
                SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorseExpoConnectionString"].ConnectionString);
                sql.AddParameter("@ExpoVendorIDList", expoVendorIdList);

                dsResult = sql.Execute("sp_ht_ListExpoVendorsByID", CommandType.StoredProcedure);
            }

            return(dsResult);
        }
示例#11
0
        public static DataSet ListByOrderNumber(string orderNumberList)
        {
            DataSet dsResult = new DataSet();

            if (!string.IsNullOrEmpty(orderNumberList))
            {
                SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorseExpoConnectionString"].ConnectionString);
                sql.AddParameter("@OrderNumberList", orderNumberList);

                dsResult = sql.Execute("sp_ht_ListShowdatesByOrderNumber", CommandType.StoredProcedure);
            }

            return(dsResult);
        }
        public static DataSet SaveContestJudge(int contestId, int?customerId, string firstName, string lastName,
                                               string email, string zipcode, string screenname, string password)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["HorsetraderConnectionString"].ConnectionString);

            sql.AddParameter("@ContestID", contestId);
            sql.AddParameter("@CustomerID", customerId);
            sql.AddParameter("@FirstName", firstName);
            sql.AddParameter("@LastName", lastName);
            sql.AddParameter("@Email", email);
            sql.AddParameter("@Zipcode", zipcode);
            sql.AddParameter("@ScreenName", screenname);
            sql.AddParameter("@Password", password);

            return(sql.Execute("sp_contest_InsertContestJudge", CommandType.StoredProcedure));
        }
示例#13
0
        public static DataTable GetAllianceEventType(int eventTypeID)
        {
            SQLHelper sql = new SQLHelper(ConfigurationManager.ConnectionStrings["MainConnectionString"].ConnectionString);

            sql.AddParameter("@EventTypeID", eventTypeID);
            DataSet dsShowdateSections = sql.Execute("Usp_GetAllianceEventType", CommandType.StoredProcedure);

            if (dsShowdateSections.Tables.Count > 0)
            {
                return(dsShowdateSections.Tables[0]);
            }
            else
            {
                return(new DataTable());
            }
        }