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));
}
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));
}
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);
}
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);
}
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);
}
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);
}
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));
}
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());
}
}