예제 #1
0
        public void ImportIPO_NewApplication_MoneyTransactionRequest()
        {
            Web2014DataImportBAL bal = new Web2014DataImportBAL();
            DataTable            dt  = new DataTable();

            try
            {
                bal.Connect_SMS();
                bal.Connect_Web();

                dt = bal.GetDataWeb_IPOApplicationMoneyTransRequest_UITransApplied();
                bal.InsertData_WebReceiveAll_UITransApplied(dt);
                bal.UpdateWebSyncFlagWeb_IPOApplicationMoneyTransRequest_UITransApplied(dt);

                bal.Commit_Web();
                bal.Commit_SMS();
            }
            catch (Exception ex)
            {
                bal.Rollback_Web();
                bal.Rollback_SMS();
                throw new Exception(ex.Message);
            }
            finally
            {
                bal.CloseConnection_Web();
                bal.CloseConnection_SMS();
            }
        }
예제 #2
0
        private void button5_Click(object sender, EventArgs e)
        {
            Web2014DataImportBAL bal = new Web2014DataImportBAL();
            DataTable            dt  = new DataTable();

            try
            {
                bal.Connect_SMS();
                bal.Connect_Web();

                dt = bal.GetDataWeb_IPOApplicationMoneyTransRequest_UITransApplied();
                bal.InsertData_WebReceiveAll_UITransApplied(dt);
                bal.UpdateWebSyncFlagWeb_IPOApplicationMoneyTransRequest_UITransApplied(dt);

                bal.Commit_Web();
                bal.Commit_SMS();
                MessageBox.Show("Upload Successfully");
            }
            catch (Exception ex)
            {
                bal.Rollback_Web();
                bal.Rollback_SMS();
                MessageBox.Show(ex.Message);
            }
            finally
            {
                bal.CloseConnection_Web();
                bal.CloseConnection_SMS();
            }
        }
예제 #3
0
        public void DataProcessIPO_Create_Application_Transaction_Request_FromWeb()
        {
            Web2014DataImportBAL bal = new Web2014DataImportBAL();
            DataTable            dt  = new DataTable();

            try
            {
                bal.Connect_SMS();
                bal.InsertData_WebRequest_UITransApplied();
                bal.Commit_SMS();
            }
            catch (Exception ex)
            {
                bal.Rollback_SMS();
                throw new Exception(ex.Message);
            }
            finally
            {
                bal.CloseConnection_SMS();
            }
        }
예제 #4
0
        private void button6_Click(object sender, EventArgs e)
        {
            Web2014DataImportBAL bal = new Web2014DataImportBAL();
            DataTable            dt  = new DataTable();

            try
            {
                bal.Connect_SMS();
                bal.InsertData_WebRequest_UITransApplied();
                bal.Commit_SMS();
                MessageBox.Show("Upload Successfully");
            }
            catch (Exception ex)
            {
                bal.Rollback_SMS();
                MessageBox.Show(ex.Message);
            }
            finally
            {
                bal.CloseConnection_SMS();
            }
        }