public void Initialize(string applicationName, SqlConnectionHolder holder, SqlMembershipProvider sqlMembershipProvider, int commandTimeout)
{
CommandTimeout = commandTimeout;
Holder = holder;
Provider = sqlMembershipProvider;
ApplicationName = applicationName;
}
public override MembershipProvider GetProvider()
{
DatabaseUtil.CreateTestDatabase(FixtureConstants.SqlMembershipProviderDatabaseName);
var result = new SqlMembershipProvider();
return result;
}
/// <summary>
/// Initializes a new <see cref="SqlMembershipProviderPasswordService"/> using the provided password format.
/// </summary>
/// <param name="passwordFormat">The password encryption method.</param>
public SqlMembershipProviderPasswordService(MembershipPasswordFormat passwordFormat)
{
this.passwordFormat = passwordFormat;
this.provider = new SqlMembershipProvider();
var config = new NameValueCollection {
{ "minRequiredPasswordLength", "1" },
{ "minRequiredNonalphanumericCharacters", "0" },
{ "passwordFormat", passwordFormat.ToString() },
{ "passwordCompatMode", "Framework40" },
{ "connectionString" , "__foo__" }
};
this.provider.Initialize(null, config);
}
public override MembershipProvider GetProvider()
{
string tempPath = Properties.Settings.Default.AccessibleTempPath;
string databaseMdfPath = Path.Combine(tempPath, @"RavenDBMembershipTestSqlDatabase\DatabaseFile.mdf");
if (!Directory.Exists(tempPath))
Directory.CreateDirectory(tempPath);
DatabaseInitialization.DetachDatabase(FixtureConstants.DatabaseName);
DatabaseInitialization.RecreateDatabase(FixtureConstants.DatabaseName, databaseMdfPath);
DatabaseInitialization.RunSqlMembershipCreationScript(FixtureConstants.DatabaseName);
var result = new SqlMembershipProvider();
return result;
}
public DataSet GetData()
{
_connetionStringBuilder = new SqlConnectionStringBuilder();
_connetionStringBuilder["Data Source"] = "localhost\\SQLExpress";
_connetionStringBuilder["integrated Security"] = true;
_connetionStringBuilder["Initial Catalog"] = "STMEMBERSHIP";
_connetionStringBuilder["Asynchronous Processing"] = true;
DataSet dataSet = new DataSet();
using (SqlConnection connection = new SqlConnection( _connetionStringBuilder.ConnectionString ))
{
connection.Open();
using (SqlCommand command = new SqlCommand("SELECT * FROM dbo.aspnet_Users", connection))
{
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dataSet);
}
}
SqlMembershipProvider test = new SqlMembershipProvider();
//System.Collections.Specialized.NameValueCollection nc = new System.Collections.Specialized.NameValueCollection();
//nc.Add("connectionStringName", "StudyMateConnectionString");
//nc.Add("applicationName", "/STMate");
//nc.Add("requiresQuestionAndAnswer", "false");
//test.Initialize("StudyMateMembershipProvider", nc);
//System.Collections.Specialized.NameValueCollection nameColl = new System.Collections.Specialized.NameValueCollection();
//nameColl.Add("connectionStringName", "StudyMateConnectionString");
//nameColl.Add("applicationName", "/STMate");
//nameColl.Add("requiresQuestionAndAnswer", "false");
//defaultMembership.Initialize("StudyMateMembershipProvider", nameColl);
//int Total= 0;
//MembershipUserCollection col = defaultMembership.GetAllUsers(0, 10, out Total);
//System.Collections.IEnumerator en = col.GetEnumerator();
//en.Reset();
//while (en.MoveNext())
//{
// MembershipUser firest = (MembershipUser)en.Current;
// Console.WriteLine(firest.Email);
//}
//int Total = 0;
//MembershipUserCollection col = test.GetAllUsers(0, 10, out Total);
//System.Collections.IEnumerator en = col.GetEnumerator();
//en.Reset();
//while (en.MoveNext())
//{
// MembershipUser firest = (MembershipUser)en.Current;
// Console.WriteLine(firest.Email);
//}
//MembershipUser user = (MembershipUser)test.GetUser (userName, false);
//public ActionResult ExpireSession()
//{
// string sessionId = Session.SessionID;
// Session.Abandon();
// return new ContentResult()
// {
// Content = "Session '" + sessionId + "' abandoned at " + DateTime.Now
// };
//}
//this.Context.Application.Lock();
//this.Context.Application.UnLock();
//this.Context.Response.Redirect("http://www.google.co.kr");
return dataSet;
}
protected void SaveButton_Click(object sender, EventArgs e)
{
Errors.Items.Clear();
string serverType = ServerTypeDrop.SelectedValue;
DbServer serverTypeParsed;
if (!Enum.TryParse<DbServer>(serverType, out serverTypeParsed))
{
Errors.Items.Add("Please, choose the type of database engine you wish to use.");
return;
}
// initial testing of the database connection before we attempt to create the main schema
IBaseDriver drv = null;
switch (serverTypeParsed)
{
case DbServer.MySql:
drv = new BaseDriverMySql(SystemConnstringTextBox.Text);
break;
case DbServer.MsSql:
drv = new BaseDriverMsSql(SystemConnstringTextBox.Text);
break;
}
try
{
drv.TestConnection();
drv.TestDatabaseIsEmpty();
}
catch (Exception ex)
{
Errors.Items.Add(ex.Message);
return;
}
if (UsernameTextBox.Text == "")
{
Errors.Items.Add("Please, insert the initial user's name");
return;
}
if (PasswordTextBox.Text.Length < 7)
{
Errors.Items.Add("The password must be at least 7 characters long.");
return;
}
if (PasswordTextBox.Text != RetypePasswordTextBox.Text)
{
Errors.Items.Add("The passwords do not match.");
return;
}
try
{
System.Net.Mail.MailAddress address = new System.Net.Mail.MailAddress(MailTextBox.Text);
}
catch (FormatException fe)
{
Errors.Items.Add(fe.Message);
return;
}
// run the schema dump script
switch (serverTypeParsed)
{
case DbServer.MySql:
MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(SystemConnstringTextBox.Text);
try
{
MySql.Data.MySqlClient.MySqlScript script = new MySql.Data.MySqlClient.MySqlScript(connection);
string scriptText = File.ReadAllText(HttpContext.Current.Server.MapPath(CC.MYSQL_SCHEMA_FILE_PATH));
script.Query = scriptText;
script.Query = scriptText;
connection.Open();
script.Execute();
connection.Clone();
}
catch (Exception esql1)
{
Errors.Items.Add(esql1.Message);
connection.Close();
return;
}
break;
case DbServer.MsSql:
SqlConnection conn = new SqlConnection(SystemConnstringTextBox.Text);
try
{
string query = File.ReadAllText(HttpContext.Current.Server.MapPath(CC.MSSQL_SCHEMA_FILE_PATH));
Microsoft.SqlServer.Management.Smo.Server sqlServer = new Server(new ServerConnection(conn));
conn.Open();
sqlServer.ConnectionContext.ExecuteNonQuery(query);
conn.Close();
SqlMembershipProvider mssqlProvider = new SqlMembershipProvider();
}
catch (Exception esql2)
{
Errors.Items.Add(esql2.Message);
conn.Close();
return;
}
break;
}
var configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~");
var section = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
System.Web.Security.MembershipProvider membership = null;
string username = UsernameTextBox.Text;
string password = PasswordTextBox.Text;
string mail = MailTextBox.Text;
MembershipCreateStatus status;
// rewrite the connection in the database and reload the connstring section, also set the defaultProvidder for the membership tag
switch (serverTypeParsed)
{
case DbServer.MySql:
section.ConnectionStrings["MySqlServer"].ConnectionString = SystemConnstringTextBox.Text;
configuration.AppSettings.Settings["ServerType"].Value = "MySql";
configuration.Save();
SetDefaultMembershipProvider("MySqlMembershipProvider");
// remove the readonly attribute of the connection string variable of the connfiguration
var settingsMy = ConfigurationManager.ConnectionStrings["MsSqlServer"];
var fiMy = typeof( ConfigurationElement ).GetField( "_bReadOnly", BindingFlags.Instance | BindingFlags.NonPublic );
fiMy.SetValue(settingsMy, false);
settingsMy.ConnectionString = SystemConnstringTextBox.Text;
membership = Membership.Providers["MySqlMembershipProvider"];
membership.CreateUser(username, password, mail, "Dummy question", "Dummy answer", true, 1, out status);
break;
case DbServer.MsSql:
section.ConnectionStrings["MsSqlServer"].ConnectionString = SystemConnstringTextBox.Text;
configuration.AppSettings.Settings["ServerType"].Value = "MsSql";
configuration.Save();
SetDefaultMembershipProvider("MsSqlMembershipProvider");
// remove the readonly attribute of the connection string variable of the connfiguration
var settings = ConfigurationManager.ConnectionStrings["MsSqlServer"];
var fi = typeof( ConfigurationElement ).GetField( "_bReadOnly", BindingFlags.Instance | BindingFlags.NonPublic );
fi.SetValue(settings, false);
settings.ConnectionString = SystemConnstringTextBox.Text;
membership = Membership.Providers["MsSqlMembershipProvider"];
// generate a ProviderUserKey
Random rand = new Random();
Guid key = new Guid(rand.Next(), 2, 3, new byte[] { 10, 20, 30, 40, 50, 60, 70, 80 });
((SqlMembershipProvider)membership).CreateUser(username, password, mail, "Dummy question", "Dummy answer", true, key, out status);
break;
}
int totalUsers;
MembershipUser user = membership.FindUsersByName(username, 0, 1, out totalUsers)[username];
SystemDriver sysDriver = new SystemDriver(drv);
sysDriver.SetUserRights((user.ProviderUserKey), null, 11110);
// Set FirstRun to false. This cannot be done by the first configuration object - it wil
// not like the configuration file since it has been modified by SetDefaultMembershipProvider
// in the meantime.
var config2 = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~");
config2.AppSettings.Settings["FirstRun"].Value = "False";
System.Web.Configuration.WebConfigurationManager.AppSettings["FirstRun"] = "False";
config2.Save();
Errors.Items.Add("Done.");
Response.RedirectToRoute("DefaultRoute");
}
private void InitSqlProvider()
{
MembershipSection membershipSection = GetConfigMembershipSection();
string sqlProviderName = membershipSection.Providers[this.Name].Parameters["sqlProviderName"];
_SqlProvider = (SqlMembershipProvider)Membership.Providers[sqlProviderName];
}