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