public void MemberRingDelete()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_MEMBERRINGDELETE);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@BandID", BandID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@UserID", UserID);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet VerifyRFID(BIZ.Entry bizData)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_VerifyRFID", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", bizData.ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@SerialRFIDNo", bizData.RFIDSerialNo);
dbconn.sqlComm.Parameters.AddWithValue("@ReleasePointID", bizData.ReleasepointID);
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", bizData.MemberID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public void RaceScheduleDelete()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_ScheduleDELETE);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleID", ScheduleID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@UserID", UserID);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet RaceResultGetByKeys()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_RACERESULTGETBYKEYS);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@ReleaseDate", DateRelease.Date);
dbconn.sqlComm.Parameters.AddWithValue("@RaceCategory", RaceCategoryName);
dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroup", RaceCategoryGroupName);
dbconn.sqlComm.Parameters.AddWithValue("@Name", Name);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetRegisteredMobileList(String mobileNumber)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("GetMobileNumberRegisteredList");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.AddWithValue("@mobilenumber", mobileNumber);
dbconn.sqlComm.Parameters.AddWithValue("@RequestFrom", "pilipinaskalapati");
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbconn.sqlConn.Close();
dbconn.sqlConn.Dispose();
SqlConnection.ClearPool(dbconn.sqlConn);
}
}
public Boolean Delete(BIZ.RegisterRFID bizData)
{
try
{
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_MemberRFIDRegisrationDelete", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@MemberRegistrationID", bizData.MemberRFIDRegistrationID);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet ViewClubRace()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("ViewClubRace");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Date", DateRelease);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet RegisterMobileNumber()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("RegisterMobileNumber");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@UserID", UserID);
dbconn.sqlComm.Parameters.AddWithValue("@MemberIDNo", PinNumber);
dbconn.sqlComm.Parameters.AddWithValue("@MobileNumber", MobileNumber);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet TransactionGetByBillingNo()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("TransactionGetByBillingNo");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@BillingNo", BillingNo);
dbconn.sqlComm.Parameters.AddWithValue("@IsTranDetails", IsTranDetails);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet PaymentsHistory()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("GetPaymentSummary");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubName", ClubName);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetParticularList()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("GetParticularList");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@TransactionType", TransactionType);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public void Save()
{
try
{
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("TransactionSave");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@TransactionID", TransactionID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubName", ClubName);
dbconn.sqlComm.Parameters.AddWithValue("@UserID", UserID);
dbconn.sqlComm.Parameters.AddWithValue("@Particular", Particular);
dbconn.sqlComm.Parameters.AddWithValue("@Quantity", Quantity);
dbconn.sqlComm.Parameters.AddWithValue("@UnitPrice", UnitPrice);
dbconn.sqlComm.Parameters.AddWithValue("@BillingNo", BillingNo);
dbconn.sqlComm.Parameters.AddWithValue("@TransactionType", TransactionType);
dbconn.sqlComm.Parameters.AddWithValue("@PaymentAmount", PaymentAmount);
dbconn.sqlComm.Parameters.AddWithValue("@PaymentDate", PaymentDate);
dbconn.sqlComm.Parameters.AddWithValue("@OrderStatus", OrderStatus);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
//return dataResult;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet LoadBalance(String userID)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("GetCheckLoadBalance");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.AddWithValue("@MobileNumber", userID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbconn.sqlConn.Close();
dbconn.sqlConn.Dispose();
SqlConnection.ClearPool(dbconn.sqlConn);
}
}
public DataSet GetMembetDistancePerReleasePoint()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("GetMemberDistanceByReleasePoint");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@LocationID", LocationID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetAdvertisement()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("GetAdvertisement");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbconn.sqlConn.Close();
dbconn.sqlConn.Dispose();
SqlConnection.ClearPool(dbconn.sqlConn);
}
}
public DataSet GetClubList()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("ClubSelectAll");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Save(BIZ.RegisterRFID bizData)
{
try
{
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_MemberRFIDRegisrationSave", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@MemberRegistrationID", bizData.MemberRFIDRegistrationID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", bizData.ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@MemberIDNo", bizData.MemberIDNo);
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", bizData.MemberID);
dbconn.sqlComm.Parameters.AddWithValue("@ScheduleName", bizData.Season);
dbconn.sqlComm.Parameters.AddWithValue("@RingType", bizData.Type);
dbconn.sqlComm.Parameters.AddWithValue("@BandNumber", bizData.BandNumber);
dbconn.sqlComm.Parameters.AddWithValue("@BandID", bizData.BandID);
dbconn.sqlComm.Parameters.AddWithValue("@RFIDSerialNo", bizData.RFID);
dbconn.sqlComm.Parameters.AddWithValue("@Picture", "");
dbconn.sqlComm.Parameters.AddWithValue("@BirdCategory", bizData.BirdCategory);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet LocationSearchByKey()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_LOCATIONSEARCHBYKEYS);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ScheduleCategoryID", RaceScheduleCategoryID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@LocationName", LocationName);
dbconn.sqlComm.Parameters.AddWithValue("@ReleaseDate", ReleaseDate);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetMemberRFIDRegisterGetByID(BIZ.RegisterRFID bizData)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_MemberRFIDRegisrationGeyByID", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", bizData.MemberID);
dbconn.sqlComm.Parameters.AddWithValue("@ScheduleName", bizData.Season);
dbconn.sqlComm.Parameters.AddWithValue("@Clubid", bizData.ClubID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet RaceReleasePointGetbyRaceScheduleCategory()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_RACERELEASEPOINTGEYBYSCHEDULECATEGORY);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
//dbconn.sqlComm.Parameters.AddWithValue("@ID", ID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleCategoryName", RaceScheduleCategoryName);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet RaceResultDelete()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("RaceResultDelete");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@StickerCode", StickerCode);
dbconn.sqlComm.Parameters.AddWithValue("@PigeonID", PigeonID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet ChargeText(string mobilenumber)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("ChargeText");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@MobileNumber", mobilenumber);
dbconn.sqlComm.Parameters.AddWithValue("@Multiplier", 0);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", 0);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbconn.sqlConn.Close();
dbconn.sqlConn.Dispose();
SqlConnection.ClearPool(dbconn.sqlConn);
}
}
public DataSet RaceResultAddFromBackup(string source)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("RaceResultSave");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Content", "");
dbconn.sqlComm.Parameters.AddWithValue("@Sender", Sender);
dbconn.sqlComm.Parameters.AddWithValue("@StickerNumber", StickerCode);
dbconn.sqlComm.Parameters.AddWithValue("@Arrival", Arrival);
dbconn.sqlComm.Parameters.AddWithValue("@RaceReleaseDate", DateRelease);
dbconn.sqlComm.Parameters.AddWithValue("@Source", source);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetRegisterBandNumberWithRFID(BIZ.ImportData importData)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_GetRegisterBandNumberWithRFID", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", importData.ClubID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Save(BIZ.Entry bizData)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_EclockEntrySave", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@EclockEntryID", bizData.EclockEntryID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", bizData.ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@ReleasePointID", bizData.ReleasepointID);
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", bizData.MemberID);
dbconn.sqlComm.Parameters.AddWithValue("@BandID", bizData.BandID);
dbconn.sqlComm.Parameters.AddWithValue("@BandNumber", bizData.BandNumber);
dbconn.sqlComm.Parameters.AddWithValue("@MemberRegisterRFID", bizData.MemberRFIDRegisterID);
dbconn.sqlComm.Parameters.AddWithValue("@SerialRFIDNo", bizData.RFIDSerialNo);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet ClubSearchByKey()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_ClubSEARCHBYKEYS);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@UserID", UserID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public void Save()
{
try
{
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_ScheduleSAVE);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@UserID", UserID);
dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleID", ScheduleID);
dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleName", ScheduleName);
dbconn.sqlComm.Parameters.AddWithValue("@RegionName", RegionName);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
//return dataResult;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet ValidateLogin(LoginData mLoginData)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("RaceResultLogins");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.AddWithValue("@UserName", mLoginData.UserName);
dbconn.sqlComm.Parameters.AddWithValue("@Password", mLoginData.Password);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbconn.sqlConn.Close();
dbconn.sqlConn.Dispose();
SqlConnection.ClearPool(dbconn.sqlConn);
}
}
public DataSet RaceScheduleSelectAll()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_ScheduleLIST);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet MemberRingSearchByKey()
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(SP_MEMBERRINGBYKEYS);
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@UserID", UserID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", MemberID);
dbconn.sqlComm.Parameters.AddWithValue("@ScheduleName", RaceScheduleName);
dbconn.sqlComm.Parameters.AddWithValue("@ScheduleCategoryName", RaceScheduleCategoryName);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}