public string EncryptSHA512(string message)
{
using (SHA512 sha512 = SHA512.Create())
{
DataBaseData dataBase = new DataBaseData();
byte[] sourcecBytes = Encoding.UTF8.GetBytes(message + pepper + dataBase.Salt);
Console.WriteLine(dataBase.Salt);
byte[] hashBytes = sha512.ComputeHash(sourcecBytes);
string hash = BitConverter.ToString(hashBytes).Replace("-", String.Empty);
return(hash);
}
}
public bool GetDataBaseFile(String filePath)
{
bool getDatabase = false;
try
{
// string filePath = OpenDataBaseFile();
SQLiteConnection connection = new SQLiteConnection(@"DataSource=" + filePath);
connection.Open();
string[] result = new string[7];
string[] result2 = new string[7];
string sql = "select * from user";
SQLiteCommand command = new SQLiteCommand(sql, connection);
SQLiteDataReader reader = command.ExecuteReader();
List <DataBaseData> active = new List <DataBaseData>();
if (reader.HasRows)
{
while (reader.Read())
{
DataBaseData dataBaseData = new DataBaseData();
dataBaseData.UserName = reader[1].ToString();
dataBaseData.Password = reader[2].ToString();
dataBaseData.Salt = reader[3].ToString();
active.Add(dataBaseData);
Console.WriteLine($"{reader[1].ToString()} and {reader[2].ToString()} and {reader[3].ToString()}");
getDatabase = true;
}
}
else
{
Console.WriteLine("No rows found");
}
reader.Close();
connection.Close();
}
catch (Exception e)
{
Console.WriteLine("Exception " + e.Message);
getDatabase = false;
}
return(getDatabase);
}
public bool GetUserData(String filePath)
{
try
{
SQLiteConnection connection = new SQLiteConnection(@"DataSource=" + filePath);
connection.Open();
string[] result = new string[7];
string[] result2 = new string[7];
string sql = "select * from passwords where ownner='" + DataBase.loginCurrentUser + "'";
SQLiteCommand command = new SQLiteCommand(sql, connection);
SQLiteDataReader reader = command.ExecuteReader();
List <DataBaseData> active = new List <DataBaseData>();
if (reader.HasRows)
{
while (reader.Read())
{
DataBaseData dataBaseData = new DataBaseData();
dataBaseData.UserName = reader[1].ToString();
dataBaseData.Password = reader[2].ToString();
dataBaseData.Salt = reader[3].ToString();
active.Add(dataBaseData);
Console.WriteLine($"{reader[1].ToString()} and {reader[2].ToString()} and {reader[3].ToString()}");
}
reader.Close();
return(true);
}
else
{
Console.WriteLine("No rows found");
return(false);
}
connection.Close();
}
catch (Exception e)
{
Console.WriteLine("Exception " + e.Message);
return(false);
}
}
