public static bool InsertGoogleDoc(GoogleDoc newDoc)
 {
     GeoTradingCards.DAL.GoogleDocsPage newPage = new GoogleDocsPage();
     newPage.Season        = newDoc.Season;
     newPage.Set           = newDoc.Set;
     newPage.GoogleDocsUrl = newDoc.Url;
     try
     {
         Databases.GoogleDocs.GoogleDocsPages.InsertOnSubmit(newPage);
         Databases.GoogleDocs.SubmitChanges(System.Data.Linq.ConflictMode.FailOnFirstConflict);
         return(true);
     }
     catch (ChangeConflictException)
     {
         foreach (ObjectChangeConflict conflict in Databases.GoogleDocs.ChangeConflicts)
         {
             conflict.Resolve(RefreshMode.OverwriteCurrentValues);
         }
         return(true);
     }
     catch (System.Exception ex)
     {
         ExceptionManager.LogException(ex);
         return(false);
     }
 }
        /// <summary>
        /// Retrieves a specific Google Doc from a specified season and set
        /// </summary>
        /// <param name="season"></param>
        /// <param name="set"></param>
        /// <returns>A Google document</returns>
        public static GoogleDocsPage GetDocBySet(string season, string set)
        {
            GoogleDocsPage gDoc = (from gDocs in Databases.GoogleDocs.GoogleDocsPages
                                   where gDocs.Season == season
                                   where gDocs.Set == set
                                   select gDocs).FirstOrDefault();

            return(gDoc);
        }
 partial void DeleteGoogleDocsPage(GoogleDocsPage instance);
 partial void UpdateGoogleDocsPage(GoogleDocsPage instance);
 partial void InsertGoogleDocsPage(GoogleDocsPage instance);