public static bool BlockMembershipID(int numberOfNonMemberID, int numberOfMemberID, string strBranchCode) { ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider(); TblCompany sqlCompany = new TblCompany(); TblBranch sqlBranch = new TblBranch(); try { sqlCompany.MainConnectionProvider = connProvider; sqlBranch.MainConnectionProvider = connProvider; connProvider.OpenConnection(); connProvider.BeginTransaction("BlockMembershipID"); if (numberOfNonMemberID > 0) sqlCompany.UpdateBlockNonMembershipID(numberOfNonMemberID); if (numberOfMemberID > 0) sqlBranch.UpdateBlockMembershipID(strBranchCode, numberOfMemberID); connProvider.CommitTransaction(); return true; } catch (Exception) { connProvider.RollbackTransaction("BlockMembershipID"); throw; } finally { if (connProvider.CurrentTransaction != null) connProvider.CurrentTransaction.Dispose(); if (connProvider.DBConnection != null) { if (connProvider.DBConnection.State == ConnectionState.Open) connProvider.DBConnection.Close(); connProvider.DBConnection.Dispose(); } sqlCompany.Dispose(); sqlBranch.Dispose(); } }