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