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