2 // Mainsoft.Web.Security.DerbyApplicationsHelper
\r
5 // Vladimir Krasnov (vladimirk@mainsoft.com)
\r
9 // Permission is hereby granted, free of charge, to any person obtaining
\r
10 // a copy of this software and associated documentation files (the
\r
11 // "Software"), to deal in the Software without restriction, including
\r
12 // without limitation the rights to use, copy, modify, merge, publish,
\r
13 // distribute, sublicense, and/or sell copies of the Software, and to
\r
14 // permit persons to whom the Software is furnished to do so, subject to
\r
15 // the following conditions:
\r
17 // The above copyright notice and this permission notice shall be
\r
18 // included in all copies or substantial portions of the Software.
\r
20 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
\r
21 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
\r
22 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
\r
23 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
\r
24 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
\r
25 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
\r
26 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
\r
32 using System.Web.Security;
\r
34 using System.Data.OleDb;
\r
35 using System.Data.Common;
\r
36 using System.Collections.Generic;
\r
39 namespace Mainsoft.Web.Security
\r
41 static class DerbyApplicationsHelper
\r
43 private static OleDbParameter AddParameter (OleDbCommand command, string paramName, object paramValue)
\r
45 OleDbParameter prm = new OleDbParameter (paramName, paramValue);
\r
46 command.Parameters.Add (prm);
\r
50 public static object Applications_CreateApplication (DbConnection connection, string applicationName)
\r
52 string selectQuery = "SELECT ApplicationId FROM aspnet_Applications WHERE LoweredApplicationName = ?";
\r
53 string insertQuery = "INSERT INTO aspnet_Applications (ApplicationId, ApplicationName, LoweredApplicationName) VALUES (?, ?, ?)";
\r
55 OleDbCommand selectCmd = new OleDbCommand (selectQuery, (OleDbConnection) connection);
\r
56 AddParameter (selectCmd, "LoweredApplicationName", applicationName.ToLowerInvariant ());
\r
58 using (OleDbDataReader reader = selectCmd.ExecuteReader ()) {
\r
60 return reader.GetString (0);
\r
63 string applicationId = Guid.NewGuid ().ToString ();
\r
64 OleDbCommand insertCmd = new OleDbCommand (insertQuery, (OleDbConnection) connection);
\r
65 AddParameter (insertCmd, "ApplicationId", applicationId);
\r
66 AddParameter (insertCmd, "ApplicationName", applicationName);
\r
67 AddParameter (insertCmd, "LoweredApplicationName", applicationName.ToLowerInvariant ());
\r
68 insertCmd.ExecuteNonQuery ();
\r
70 return applicationId;
\r
73 public static string GetApplicationId (DbConnection connection, string applicationName)
\r
75 string selectQuery = "SELECT ApplicationId FROM aspnet_Applications WHERE LoweredApplicationName = ?";
\r
77 OleDbCommand selectCmd = new OleDbCommand (selectQuery, (OleDbConnection) connection);
\r
78 AddParameter (selectCmd, "LoweredApplicationName", applicationName.ToLowerInvariant ());
\r
79 using (OleDbDataReader reader = selectCmd.ExecuteReader ()) {
\r
81 return reader.GetString (0);
\r