Beispiel #1
0
        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;
            }
        }
Beispiel #2
0
        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;
            }
        }
Beispiel #3
0
        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;
            }
        }
Beispiel #4
0
        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;
            }
        }
Beispiel #5
0
        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);
            }
        }
Beispiel #6
0
        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;
            }
        }
Beispiel #7
0
        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;
            }
        }
Beispiel #8
0
        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;
            }
        }
Beispiel #9
0
        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;
            }
        }
Beispiel #10
0
        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;
            }
        }
Beispiel #11
0
        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;
            }
        }
Beispiel #12
0
        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;
            }
        }
Beispiel #13
0
        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);
            }
        }
Beispiel #14
0
        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;
            }
        }
Beispiel #15
0
        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);
            }
        }
Beispiel #16
0
        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;
            }
        }
Beispiel #17
0
        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;
            }
        }
Beispiel #18
0
        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;
            }
        }
Beispiel #19
0
        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;
            }
        }
Beispiel #20
0
        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;
            }
        }
Beispiel #21
0
        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;
            }
        }
Beispiel #22
0
        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);
            }
        }
Beispiel #23
0
        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;
            }
        }
Beispiel #24
0
        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;
            }
        }
Beispiel #25
0
        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;
            }
        }
Beispiel #26
0
        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;
            }
        }
Beispiel #27
0
        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;
            }
        }
Beispiel #28
0
        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);
            }
        }
Beispiel #29
0
        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;
            }
        }
Beispiel #30
0
        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;
            }
        }