public static int AddLink(List <int> fileIDs)
        {
            // Create the link group (without setting up a memo)
            string insert = "Insert Into LinkMemos (dMemoCreated, dMemoUpdated) " +
                            "Values (GetDate(), GetDate()); " +
                            "Select Convert(int, Scope_Identity());";
            int newID = (int)Db.ExecuteScalar(insert);

            // Add list of files to the group
            foreach (int id in fileIDs)
            {
                FileLinkDAL.Join(newID, id);
            }
            return(newID);
        }
        public static int AddLink(List <int> fileIDs, string linkMemo)
        {
            // Create the link group
            List <SqlParameter> args = new List <SqlParameter>();

            args.Add(new SqlParameter("@Memo", linkMemo));
            string insert = "Insert Into LinkMemos (sLinkMemo, dMemoCreated, dMemoUpdated) " +
                            "Values (@Memo, GetDate(), GetDate()); " +
                            "Select Convert(int, Scope_Identity());";
            int newID = (int)Db.ExecuteScalar(insert, args.ToArray());

            // Add list of files to the group
            foreach (int id in fileIDs)
            {
                FileLinkDAL.Join(newID, id);
            }
            return(newID);
        }