samples/ServiceProvider/Default.aspx

   1 <%@ Page Title="DotNetOpenAuth Service Provider Sample" Language="C#" MasterPageFile="~/MasterPage.master" %>
   2
   3 <%@ Import Namespace="System.IO" %>
   4 <%@ Import Namespace="System.Data.SqlClient" %>
   5
   6 <script runat="server">
   7
   8         protected void createDatabaseButton_Click(object sender, EventArgs e) {
   9                 string dbPath = Path.Combine(Server.MapPath(Request.ApplicationPath), "App_Data");
  10                 if (!Directory.Exists(dbPath)) {
  11                         Directory.CreateDirectory(dbPath);
  12                 }
  13                 string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString.Replace("|DataDirectory|", dbPath);
  14                 var dc = new DataClassesDataContext(connectionString);
  15                 if (dc.DatabaseExists()) {
  16                         dc.DeleteDatabase();
  17                 }
  18                 try {
  19                         dc.CreateDatabase();
  20                         // Fill with sample data.
  21                         dc.OAuthConsumers.InsertOnSubmit(new OAuthConsumer {
  22                                 ConsumerKey = "sampleconsumer",
  23                                 ConsumerSecret = "samplesecret",
  24                         });
  25                         dc.Users.InsertOnSubmit(new User {
  26                                 OpenIDFriendlyIdentifier = "=arnott",
  27                                 OpenIDClaimedIdentifier = "=!9B72.7DD1.50A9.5CCD",
  28                                 Age = 27,
  29                                 FullName = "Andrew Arnott",
  30                                 FavoriteSites = new System.Data.Linq.EntitySet<FavoriteSite> {
  31                                         new FavoriteSite { SiteUrl = "http://www.microsoft.com" },
  32                                         new FavoriteSite { SiteUrl = "http://www.google.com" },
  33                                 },
  34                         });
  35
  36                         dc.SubmitChanges();
  37                         databaseStatus.Visible = true;
  38                 } catch (System.Data.SqlClient.SqlException ex) {
  39                         foreach (System.Data.SqlClient.SqlError error in ex.Errors) {
  40                                 Response.Write(error.Message);
  41                         }
  42                 }
  43         }
  44 </script>
  45
  46 <asp:Content ID="Content2" ContentPlaceHolderID="Body" runat="Server">
  47         <asp:Button ID="createDatabaseButton" runat="server" Text="(Re)create Database" OnClick="createDatabaseButton_Click" />
  48         <asp:Label runat="server" ID="databaseStatus" EnableViewState="false" Text="Database recreated!"
  49                 Visible="false" />
  50 </asp:Content>