// Token: 0x06000061 RID: 97 RVA: 0x00008ED4 File Offset: 0x000070D4
private bool GetHash(ref string file, ref string hash)
{
bool result;
try
{
OpenFileDialog openFileDialog = new OpenFileDialog();
if (DialogResult.OK == openFileDialog.ShowDialog())
{
file = openFileDialog.FileName;
byte[] ba = File.ReadAllBytes(openFileDialog.FileName);
hash = CryptoExpress.Sha256Hash(ba);
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
MessageBox.Show("File not valid.\r\n\r\n" + ex.ToString());
result = false;
}
return(result);
}
private bool GetHash(ref string file, ref string hash)
{
try
{
var f = new OpenFileDialog();
if (DialogResult.OK == f.ShowDialog())
{
file = f.FileName;
var ba = File.ReadAllBytes(f.FileName);
hash = CryptoExpress.Sha256Hash(ba);
return(true);
}
return(false);
}
catch (Exception ex)
{
MessageBox.Show("File not valid.\r\n\r\n" + ex);
return(false);
}
}
void bw_DoWork(object sender, DoWorkEventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO `");
sb.AppendFormat(tableName);
sb.AppendFormat("` (`varchar`,`text`,`datetime`,`date`,`time`,`decimal`,`tinyint`,`timestamp`,`char36`,`binary16`,`float`,`double`,`blob`,`bool`) VALUES");
StringBuilder sb2 = new StringBuilder();
sb2.AppendFormat("('");
sb2.AppendFormat(CryptoExpress.RandomString(45)); // varchar
sb2.AppendFormat("','");
sb2.AppendFormat(CryptoExpress.RandomString(45)); // text
sb2.AppendFormat("','");
sb2.AppendFormat(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); // datetime
sb2.AppendFormat("','");
sb2.AppendFormat(DateTime.Now.ToString("yyyy-MM-dd")); // date
sb2.AppendFormat("','");
sb2.AppendFormat(DateTime.Now.ToString("HH:mm:ss")); // time
sb2.AppendFormat("',3487.2398,1,CURRENT_TIMESTAMP,'00000000000000000000000000000000',"); // decimal, tinyint, timestamp
sb2.AppendFormat(CryptoExpress.ConvertByteArrayToHexString(new byte[16]));
sb2.AppendFormat(",243.234,456.456,");
sb2.AppendFormat(CryptoExpress.ConvertByteArrayToHexString(new byte[16]));
sb2.AppendFormat(",1)");
string head = sb.ToString();
string values = sb2.ToString();
int maxlength = 1024 * 1024;
using (MySqlConnection conn = new MySqlConnection(Program.ConnectionString))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
conn.Open();
cmd.CommandText = "start transaction;";
cmd.ExecuteNonQuery();
StringBuilder sb3 = new StringBuilder();
for (long i = 0; i < totalRows; i++)
{
if (stop)
{
break;
}
currentRow = i + 1;
if (sb3.Length == 0)
{
sb3.AppendFormat(head);
sb3.AppendFormat(values);
}
else if (sb3.Length + values.Length < maxlength)
{
sb3.AppendFormat(",");
sb3.AppendFormat(values);
}
else
{
sb3.AppendFormat(";");
cmd.CommandText = sb3.ToString();
cmd.ExecuteNonQuery();
sb3 = new StringBuilder();
sb3.AppendFormat(head);
sb3.AppendFormat(values);
}
}
if (sb3.Length > 0)
{
sb3.AppendFormat(";");
cmd.CommandText = sb3.ToString();
cmd.ExecuteNonQuery();
}
cmd.CommandText = "commit;";
cmd.ExecuteNonQuery();
conn.Close();
}
}
System.Threading.Thread.Sleep(700);
}
public static string ConvertToSqlFormat(object ob, bool wrapStringWithSingleQuote, bool escapeStringSequence, MySqlColumn col, BlobDataExportMode blobExportMode)
{
StringBuilder sb = new StringBuilder();
if (ob == null || ob is System.DBNull)
{
sb.AppendFormat("NULL");
}
else if (ob is System.String)
{
string str = (string)ob;
if (escapeStringSequence)
{
str = QueryExpress.EscapeStringSequence(str);
}
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
sb.Append(str);
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
}
else if (ob is System.Boolean)
{
sb.AppendFormat(Convert.ToInt32(ob).ToString());
}
else if (ob is System.Byte[])
{
if (((byte[])ob).Length == 0)
{
if (wrapStringWithSingleQuote)
{
return("''");
}
else
{
return("");
}
}
else
{
if (blobExportMode == BlobDataExportMode.HexString)
{
sb.AppendFormat(CryptoExpress.ConvertByteArrayToHexString((byte[])ob));
}
else if (blobExportMode == BlobDataExportMode.BinaryChar)
{
if (wrapStringWithSingleQuote)
{
sb.Append("'");
}
foreach (byte b in ((byte[])ob))
{
char ch = (char)b;
escape_string(sb, ch);
}
if (wrapStringWithSingleQuote)
{
sb.Append("'");
}
}
}
}
else if (ob is short)
{
sb.AppendFormat(((short)ob).ToString(_numberFormatInfo));
}
else if (ob is int)
{
sb.AppendFormat(((int)ob).ToString(_numberFormatInfo));
}
else if (ob is long)
{
sb.AppendFormat(((long)ob).ToString(_numberFormatInfo));
}
else if (ob is ushort)
{
sb.AppendFormat(((ushort)ob).ToString(_numberFormatInfo));
}
else if (ob is uint)
{
sb.AppendFormat(((uint)ob).ToString(_numberFormatInfo));
}
else if (ob is ulong)
{
sb.AppendFormat(((ulong)ob).ToString(_numberFormatInfo));
}
else if (ob is double)
{
sb.AppendFormat(((double)ob).ToString(_numberFormatInfo));
}
else if (ob is decimal)
{
sb.AppendFormat(((decimal)ob).ToString(_numberFormatInfo));
}
else if (ob is float)
{
sb.AppendFormat(((float)ob).ToString(_numberFormatInfo));
}
else if (ob is byte)
{
sb.AppendFormat(((byte)ob).ToString(_numberFormatInfo));
}
else if (ob is sbyte)
{
sb.AppendFormat(((sbyte)ob).ToString(_numberFormatInfo));
}
else if (ob is TimeSpan)
{
TimeSpan ts = (TimeSpan)ob;
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
sb.AppendFormat(ts.Hours.ToString().PadLeft(2, '0'));
sb.AppendFormat(":");
sb.AppendFormat(ts.Minutes.ToString().PadLeft(2, '0'));
sb.AppendFormat(":");
sb.AppendFormat(ts.Seconds.ToString().PadLeft(2, '0'));
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
}
else if (ob is System.DateTime)
{
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
sb.AppendFormat(((DateTime)ob).ToString("yyyy-MM-dd HH:mm:ss", _dateFormatInfo));
if (col.TimeFractionLength > 0)
{
sb.Append(".");
string _microsecond = ((DateTime)ob).ToString("".PadLeft(col.TimeFractionLength, 'f'));
sb.Append(_microsecond);
}
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
}
//else if (ob is MySql.Data.Types.MySqlDateTime)
//{
// MySql.Data.Types.MySqlDateTime mdt = (MySql.Data.Types.MySqlDateTime)ob;
// if (mdt.IsNull)
// {
// sb.AppendFormat("NULL");
// }
// else
// {
// if (mdt.IsValidDateTime)
// {
// DateTime dtime = mdt.Value;
// if (wrapStringWithSingleQuote)
// sb.AppendFormat("'");
// if (col.MySqlDataType == "datetime")
// sb.AppendFormat(dtime.ToString("yyyy-MM-dd HH:mm:ss", _dateFormatInfo));
// else if (col.MySqlDataType == "date")
// sb.AppendFormat(dtime.ToString("yyyy-MM-dd", _dateFormatInfo));
// else if (col.MySqlDataType == "time")
// sb.AppendFormat(dtime.ToString("HH:mm:ss", _dateFormatInfo));
// else
// sb.AppendFormat(dtime.ToString("yyyy-MM-dd HH:mm:ss", _dateFormatInfo));
// if (col.TimeFractionLength > 0)
// {
// sb.Append(".");
// sb.Append(((MySql.Data.Types.MySqlDateTime)ob).Microsecond.ToString().PadLeft(col.TimeFractionLength, '0'));
// }
// if (wrapStringWithSingleQuote)
// sb.AppendFormat("'");
// }
// else
// {
// if (wrapStringWithSingleQuote)
// sb.AppendFormat("'");
// if (col.MySqlDataType == "datetime")
// sb.AppendFormat("0000-00-00 00:00:00");
// else if (col.MySqlDataType == "date")
// sb.AppendFormat("0000-00-00");
// else if (col.MySqlDataType == "time")
// sb.AppendFormat("00:00:00");
// else
// sb.AppendFormat("0000-00-00 00:00:00");
// if (col.TimeFractionLength > 0)
// {
// sb.Append(".".PadRight(col.TimeFractionLength, '0'));
// }
// if (wrapStringWithSingleQuote)
// sb.AppendFormat("'");
// }
// }
//}
else if (ob is System.Guid)
{
if (col.MySqlDataType == "binary(16)")
{
sb.Append(CryptoExpress.ConvertByteArrayToHexString(((Guid)ob).ToByteArray()));
}
else if (col.MySqlDataType == "char(36)")
{
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
sb.Append(ob);
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
}
else
{
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
sb.Append(ob);
if (wrapStringWithSingleQuote)
{
sb.AppendFormat("'");
}
}
}
else
{
throw new Exception("Unhandled data type. Current processing data type: " + ob.GetType().ToString() + ". Please report this bug with this message to the development team.");
}
return(sb.ToString());
}
string Decrypt(string text)
{
return(CryptoExpress.AES_Decrypt(text, sha512HashedPassword));
}
void GetSHA512HashFromPassword(string password)
{
sha512HashedPassword = CryptoExpress.Sha512Hash(password);
}
