public void SingleLine(string password)
{
Hash h = new Hash();
h.Password = password;
h.Md5Hash = HashMethods.GetMd5Hash(password);
h.Sha1Hash = HashMethods.GetSHA1Hash(password);
h.Sha2Hash = HashMethods.GetSHA2Hash(password);
db.Hashes.Add(h);
db.SaveChanges();
}
public void InsertData(string password)
{
string query = "INSERT INTO dbo.Hash (Password,Md5Hash,Sha1Hash,Sha2Hash) "
+ "VALUES (@password, @md5hash, @sha1hash, @sha2hash) ";
using (SqlConnection cn = new SqlConnection(connectionString))
using (SqlCommand cmd = new SqlCommand(query, cn))
{
cmd.CommandTimeout = 900;
cmd.Parameters.Add("@password", SqlDbType.NVarChar, 50).Value = password;
cmd.Parameters.Add("@md5hash", SqlDbType.NVarChar, 32).Value = HashMethods.GetMd5Hash(password);
cmd.Parameters.Add("@sha1hash", SqlDbType.NVarChar, 40).Value = HashMethods.GetSHA1Hash(password);
cmd.Parameters.Add("@sha2hash", SqlDbType.NVarChar, 64).Value = HashMethods.GetSHA2Hash(password);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
public void insertBulk(List <string> passwords, int startIndex, int endIndex)
{
try
{
using (SqlConnection cn = new SqlConnection(connectionString))
{
cn.Open();
DataTable dt = new DataTable("passwords");
dt.Columns.Add("Password");
dt.Columns.Add("Md5Hash");
dt.Columns.Add("Sha2Hash");
dt.Columns.Add("Sha1Hash");
for (int i = startIndex; i < endIndex; i++)
{
DataRow dr = dt.NewRow();
dr["Password"] = passwords[i];
dr["Md5Hash"] = HashMethods.GetMd5Hash(passwords[i]);
dr["Sha1Hash"] = HashMethods.GetSHA1Hash(passwords[i]);
dr["Sha2Hash"] = HashMethods.GetSHA2Hash(passwords[i]);
dt.Rows.Add(dr);
}
SqlBulkCopy sbc = new SqlBulkCopy(cn);
SqlBulkCopyColumnMapping mapPass = new SqlBulkCopyColumnMapping("Password", "Password");
sbc.ColumnMappings.Add(mapPass);
SqlBulkCopyColumnMapping mapMd5Hash = new SqlBulkCopyColumnMapping("Md5Hash", "Md5Hash");
sbc.ColumnMappings.Add(mapMd5Hash);
SqlBulkCopyColumnMapping mapSha1Hash = new SqlBulkCopyColumnMapping("Sha1Hash", "Sha1Hash");
sbc.ColumnMappings.Add(mapSha1Hash);
SqlBulkCopyColumnMapping mapSha2Hash = new SqlBulkCopyColumnMapping("Sha2Hash", "Sha2Hash");
sbc.ColumnMappings.Add(mapSha2Hash);
sbc.DestinationTableName = "dbo.Hash";
sbc.BatchSize = 10000;
sbc.WriteToServer(dt);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public void insertLines(List <string> passwords, int startIndex, int endIndex)
{
string query = "INSERT INTO dbo.Hash (Password,Md5Hash,Sha1Hash,Sha2Hash) "
+ "VALUES (@password, @md5hash, @sha1hash, @sha2hash) ";
using (SqlConnection cn = new SqlConnection(connectionString))
using (SqlCommand cmd = new SqlCommand(query, cn))
{
cmd.CommandTimeout = 900;
cn.Open();
SqlTransaction transaction;
transaction = cn.BeginTransaction("transaction");
cmd.Transaction = transaction;
try
{
for (int i = startIndex; i < endIndex; i++)
{
cmd.Parameters.Add("@password", SqlDbType.NVarChar, 50).Value = passwords[i];
cmd.Parameters.Add("@md5hash", SqlDbType.NVarChar, 32).Value = HashMethods.GetMd5Hash(passwords[i]);
cmd.Parameters.Add("@sha1hash", SqlDbType.NVarChar, 40).Value = HashMethods.GetSHA1Hash(passwords[i]);
cmd.Parameters.Add("@sha2hash", SqlDbType.NVarChar, 64).Value = HashMethods.GetSHA2Hash(passwords[i]);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
transaction.Commit();
Console.WriteLine("Multiple rows are written.");
}
catch (Exception ex)
{
Console.WriteLine("Commit Exception Type: {0}", ex.GetType());
Console.WriteLine(" Message: {0}", ex.Message);
try
{
transaction.Rollback();
}
catch (Exception ex2)
{
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
}
}
}
