示例#1
0
        public DataSet GetDetails(string clubID)
        {
            try
            {
                DataSet dtResult = new DataSet();
                dbconn = new MAVC_IntegrationV2.DatabaseConnection("web");
                dbconn.DatabaseConn("ClubSearchByKey");

                if (dbconn.sqlConn.State == ConnectionState.Open)
                {
                    dbconn.sqlConn.Close();
                }
                dbconn.sqlConn.Open();
                dbconn.sqlComm.CommandTimeout = 0;
                dbconn.sqlComm.Parameters.Clear();
                dbconn.sqlComm.Parameters.AddWithValue("@UserID", -1);
                dbconn.sqlComm.Parameters.AddWithValue("@ClubID", clubID);

                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = dbconn.sqlComm;
                da.Fill(dtResult);
                dbconn.sqlConn.Close();

                return(dtResult);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#2
0
        public void SaveDetails(DataTable dt, string action)
        {
            try
            {
                DataSet dtResult = new DataSet();
                dbconn = new MAVC_IntegrationV2.DatabaseConnection("local");
                dbconn.DatabaseConn("Integrate_BandNumber");

                if (dbconn.sqlConn.State == ConnectionState.Open)
                {
                    dbconn.sqlConn.Close();
                }
                dbconn.sqlConn.Open();
                dbconn.sqlComm.CommandTimeout = 0;
                dbconn.sqlComm.Parameters.Clear();
                dbconn.sqlComm.Parameters.AddWithValue("@BandID", dt.Rows[0]["BandID"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@ClubID", dt.Rows[0]["ClubID"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@MemberID", dt.Rows[0]["MemberID"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@BandNumber", dt.Rows[0]["BandNumber"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@Action", action);
                dbconn.sqlComm.ExecuteNonQuery();
                dbconn.sqlConn.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#3
0
        public DataSet GetFileNote()
        {
            try
            {
                DataSet dtResult = new DataSet();
                dbconn = new DatabaseConnection("local");
                dbconn.DatabaseConn("FileNotesGetAll");

                if (dbconn.sqlConn.State == ConnectionState.Open)
                {
                    dbconn.sqlConn.Close();
                }
                dbconn.sqlConn.Open();
                dbconn.sqlComm.CommandTimeout = 0;
                dbconn.sqlComm.Parameters.Clear();

                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = dbconn.sqlComm;
                da.Fill(dtResult);
                dbconn.sqlConn.Close();

                return(dtResult);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#4
0
        public void SaveDetails(DataTable dt, string action)
        {
            try
            {
                DataSet dtResult = new DataSet();
                dbconn = new MAVC_IntegrationV2.DatabaseConnection("local");
                dbconn.DatabaseConn("Integrate_Club");

                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", dt.Rows[0]["ClubID"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@ClubAbbreviation", dt.Rows[0]["ClubAbbreviation"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@ClubName", dt.Rows[0]["ClubName"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DateFounded", dt.Rows[0]["DateFounded"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatDegree", dt.Rows[0]["DistanceLatDegree"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatMinutes", dt.Rows[0]["DistanceLatMinutes"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSecond", dt.Rows[0]["DistanceLatSecond"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSign", dt.Rows[0]["DistanceLatSign"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongDegree", dt.Rows[0]["DistanceLongDegree"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongMinutes", dt.Rows[0]["DistanceLongMinutes"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSecond", dt.Rows[0]["DistanceLongSecond"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSign", dt.Rows[0]["DistanceLongSign"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@IsActive", dt.Rows[0]["IsActive"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@Version", dt.Rows[0]["Version"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@DateTimeSource", dt.Rows[0]["DateTimeSource"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@IsBackup", dt.Rows[0]["IsBackup"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@IsMAVCStickerUsed", dt.Rows[0]["IsMAVCStickerUsed"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@LastSubcription", dt.Rows[0]["LastSubcription"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@SubcriptionDate", dt.Rows[0]["SubcriptionDate"].ToString());
                dbconn.sqlComm.Parameters.AddWithValue("@Action", action);
                dbconn.sqlComm.ExecuteNonQuery();
                dbconn.sqlConn.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#5
0
        public void DeleteAccount(string accountid)
        {
            try
            {
                DataSet dtResult = new DataSet();
                dbconn = new MAVC_IntegrationV2.DatabaseConnection("local");
                dbconn.DatabaseConn("Integrate_ClubDelete");

                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", accountid);
                dbconn.sqlComm.ExecuteNonQuery();
                dbconn.sqlConn.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#6
0
        public void UpdateFileNotes(string fileNoteID)
        {
            try
            {
                DataSet dtResult = new DataSet();
                dbconn = new MAVC_IntegrationV2.DatabaseConnection("web");
                dbconn.DatabaseConn("UpdateFileNotes");

                if (dbconn.sqlConn.State == ConnectionState.Open)
                {
                    dbconn.sqlConn.Close();
                }
                dbconn.sqlConn.Open();
                dbconn.sqlComm.CommandTimeout = 0;
                dbconn.sqlComm.Parameters.Clear();
                dbconn.sqlComm.Parameters.AddWithValue("@FileNoteID", fileNoteID);
                dbconn.sqlComm.ExecuteNonQuery();
                dbconn.sqlConn.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }