public long addaccount(Account account) { SqlConnection conn = null; SqlTransaction trans = null; AccountDao accountDao = new AccountDao(); long AccountID = 0; ConnectionDao ConnectionDao = new ConnectionDao(); try { conn = ConnectionDao.getConnection(); trans = conn.BeginTransaction(); AccountID = accountDao.addAccountBasicInfo(conn, trans, account); if (!AccountID.Equals(0)) { trans.Commit(); } else { trans.Rollback(); } } catch (Exception exception) { trans.Rollback(); System.Diagnostics.Trace.WriteLine("[EmployeeServices:addEmployee] Exception " + exception.StackTrace); } finally { ConnectionDao.closeConnection(conn); } return AccountID; }
public string customeradd(customer customer1, Account account) { string str = ""; SqlConnection conn = null; SqlTransaction trans = null; string returnString = IdProConstants.SUCCESS; CustomerDAO customerdao = new CustomerDAO(); AccountDao accountdao = new AccountDao(); ConnectionDao ConnectionDao = new ConnectionDao(); Customer_Account_O2M customerAccountO2M = new Customer_Account_O2M(); Customer_Account_O2MDAO customerAccountO2Mservice = new Customer_Account_O2MDAO(); try { conn = ConnectionDao.getConnection(); trans = conn.BeginTransaction(); customerAccountO2M.CustomerID = customerdao.addCustomerBasicInfo(conn, trans, customer1); if (!customerAccountO2M.CustomerID.Equals(0)) { customerAccountO2M.AccountID = accountdao.addAccountBasicInfo(conn, trans, account); if (!customerAccountO2M.AccountID.Equals(0)) { returnString = customerAccountO2Mservice.addCustomerAccountO2MInfo(conn, trans,customerAccountO2M); } str = customer1.cofirstname; if (str != "") { customerAccountO2M.CustomerID = customerdao.addCustomerCoinfo(conn, trans, customer1); if (!customerAccountO2M.CustomerID.Equals(0)) { customerAccountO2M.AccountID = accountdao.addAccountBasicInfo(conn, trans, account); if (!customerAccountO2M.AccountID.Equals(0)) { returnString = customerAccountO2Mservice.addCustomerAccountO2MInfo(conn, trans, customerAccountO2M); } } } } if (returnString.Equals(IdProConstants.SUCCESS)) { trans.Commit(); } else { trans.Rollback(); } } catch (Exception exception) { trans.Rollback(); System.Diagnostics.Trace.WriteLine("[EmployeeServices:addEmployee] Exception " + exception.StackTrace); } finally { ConnectionDao.closeConnection(conn); } string finalreturnvalue=""; if (returnString == "Success") { finalreturnvalue = "Thanks record saved successfully"; } else { finalreturnvalue = "Sorry, Your request could not be processed. Please try after some time"; } return finalreturnvalue; }