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); } }
protected void gvGoogleDocs_RowUpdating(object sender, GridViewUpdateEventArgs e) { bool updateRecord = true; GoogleDoc doc = new GoogleDoc(); if (e.NewValues.Contains("Set") && e.OldValues.Contains("Set")) { doc.Set = e.NewValues["Set"] != null ? e.NewValues["Set"].ToString() : string.Empty; } else { updateRecord = false; DAL.ExceptionManager.LogException(new Exception("Google Doc Update Failed"), "Could not find the SET column in the grid view control"); } if (e.NewValues.Contains("Season") && e.OldValues.Contains("Season")) { doc.Season = e.NewValues["Season"] != null ? e.NewValues["Season"].ToString() : string.Empty; } else { updateRecord = false; DAL.ExceptionManager.LogException(new Exception("Google Doc Update Failed"), "Could not find the SEASON column in the grid view control"); } if (e.NewValues.Contains("GoogleDocsUrl") && e.OldValues.Contains("GoogleDocsUrl")) { doc.Url = e.NewValues["GoogleDocsUrl"] != null ? e.NewValues["GoogleDocsUrl"].ToString() : string.Empty; } else { updateRecord = false; DAL.ExceptionManager.LogException(new Exception("Google Doc Update Failed"), "Could not find the \"GoogleDocsUrl\" column in the grid view control"); } //if (!doc.isValidDbRow()) //{ // updateRecord = false; // // Display error message to user //} if (!updateRecord) { e.Cancel = true; gvGoogleDocs.EditIndex = -1; BindData(); } else { } }
protected void btnInsert_Click(object sender, EventArgs e) { if (Page.IsValid) { GoogleDoc newDoc = new GoogleDoc(); newDoc.Season = ddlSeasons.SelectedItem.Value; newDoc.Set = tbCardSet.Text; newDoc.Url = tbGoogleDocUrl.Text; bool success = newDoc.InsertIntoDB(); if (success) { BindData(); } else { lbInsertError.Visible = true; } } }