public DataTable SaveIntroduceFriend(string strMembershipID, string strIntroducerID, string Freebie, string strBranchCode, int employeeID) { ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider(); TblMember sqlMember = new TblMember(); try { sqlMember.MainConnectionProvider = connProvider; connProvider.OpenConnection(); connProvider.BeginTransaction("SaveIntroduceFriend"); sqlMember.UpdateIntroducerMembershipID(strMembershipID, strIntroducerID); DataTable IntroFriendFreebieTable = sqlMember.AddIntroFriendFreebie(strMembershipID, strIntroducerID, Freebie, strBranchCode, employeeID); connProvider.CommitTransaction(); return(IntroFriendFreebieTable); } catch (Exception ex) { 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(); } //sqlRewardsTransaction.Dispose(); sqlMember.Dispose(); } }