本文整理汇总了C#中Credentials.getPassword方法的典型用法代码示例。如果您正苦于以下问题：C# Credentials.getPassword方法的具体用法？C# Credentials.getPassword怎么用？C# Credentials.getPassword使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Credentials的用法示例。
在下文中一共展示了Credentials.getPassword方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: changePassword
public static bool changePassword(Credentials user)
{
String database = System.Configuration.ConfigurationManager.ConnectionStrings["programaholics_anonymous_databaseConnectionString"].ConnectionString;
using (OleDbConnection sqlConn = new OleDbConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + database))
{
try
{
sqlConn.Open();
OleDbCommand cmd = sqlConn.CreateCommand();
OleDbTransaction transact = sqlConn.BeginTransaction(); //using a transaction incase something goes wrong...
cmd.Transaction = transact;
String update = "UPDATE [password] INNER JOIN [users] ON [users].password = [password].ID SET [password].[password] = @password, [password].[salt] = @salt WHERE [users].username = @username";
cmd.CommandText = update;
cmd.Parameters.Add("password", OleDbType.VarChar, 255).Value = user.getPassword();
cmd.Parameters.Add("salt", OleDbType.VarChar, 255).Value = user.getSalt();
cmd.Parameters.Add("username", OleDbType.VarChar, 255).Value = user.getUsername();
int rows = cmd.ExecuteNonQuery();
if (rows == 1)
{
transact.Commit();
return true;
}
else
{
return false;
}
}
catch (OleDbException ex)
{
return false;
}
finally
{
sqlConn.Close();
}
}
}示例2: createAccount
//This method adds a new username password combination to the database
public static bool createAccount(Credentials newUser)
{
Boolean created;
String database = System.Configuration.ConfigurationManager.ConnectionStrings["programaholics_anonymous_databaseConnectionString"].ConnectionString;
using (OleDbConnection sqlConn = new OleDbConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + database))
{
try
{
sqlConn.Open();
OleDbCommand cmd = sqlConn.CreateCommand();
OleDbTransaction transact = sqlConn.BeginTransaction(); //useing a transaction because we need to update 2 tables in db
cmd.Transaction = transact;
String insert2 = "INSERT INTO [password]([password], [salt]) VALUES (@password, @salt)";
cmd.Parameters.Clear();
cmd.CommandText = insert2;
cmd.Parameters.Add("password", OleDbType.VarChar, 255).Value = newUser.getPassword();
cmd.Parameters.Add("salt", OleDbType.VarChar, 255).Value = newUser.getSalt();
cmd.Prepare();
int rows1 = cmd.ExecuteNonQuery();
String select = "SELECT LAST(ID) FROM [password]";
cmd.Parameters.Clear();
cmd.CommandText = select;
cmd.Prepare();
int ID = 0;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ID = Convert.ToInt32(reader[ID]);
}
reader.Close();
String insert = "INSERT INTO [users]([username], [accessLevel], [password], [createdOnDate]) VALUES (@username, 2, @password, @date)";
cmd.CommandText = insert;
cmd.Parameters.Add("username", OleDbType.VarChar, 255).Value = newUser.getUsername();
cmd.Parameters.Add("password", OleDbType.Integer, 32).Value = ID;
cmd.Parameters.Add("date", OleDbType.Date).Value = System.DateTime.Now;
cmd.Prepare();
int rows2 = cmd.ExecuteNonQuery();
//check if all parts of transaction were successful
if (rows1 == 1 && rows2 == 1)
{
transact.Commit();
created = true;
}
else
{
transact.Rollback(); //cancel transaction if unsuccessful
created = false;
}
}
catch (OleDbException ex)
{
return false;
}
finally
{
sqlConn.Close();
}
return created;
}
}