private void CancleBtn(object sender, RoutedEventArgs e)
{
RecepieWindow window = new RecepieWindow();
window.Show();
Close();
}
private void btnQuit_Click(object sender, RoutedEventArgs e)
{
RecepieWindow recepieWindowWindow = new RecepieWindow();
recepieWindowWindow.Show();
Close();
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
receptDetails.DeleteRecepie();
RecepieWindow recepie = new RecepieWindow();
recepie.Show();
Close();
}
private void Buy(object sender, RoutedEventArgs e)
{
scvm.WriteToTheFile();
MessageBox.Show("You have successfully purchased components.");
RecepieWindow window = new RecepieWindow();
window.Show();
Close();
}
private void BtnLogin(object sender, RoutedEventArgs e)
{
CurrentUser = null;
//Inserted value in password field is being converted into enrypted verson for latter matching with database version.
byte[] data = System.Text.Encoding.ASCII.GetBytes(txtPassword.Password);
data = new System.Security.Cryptography.SHA256Managed().ComputeHash(data);
String hash = System.Text.Encoding.ASCII.GetString(data);
SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
//User is extracted from the database matching inserted paramaters Username and Password.
SqlCommand query = new SqlCommand("SELECT * FROM tblUser WHERE Username=@Username AND Password=@Password", sqlCon);
query.CommandType = CommandType.Text;
query.Parameters.AddWithValue("@Username", txtUsername.Text);
query.Parameters.AddWithValue("@Password", hash);
sqlCon.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
CurrentUser = new User
{
UserId = int.Parse(row[0].ToString()),
FullName = row[1].ToString(),
Username = row[2].ToString(),
Password = row[3].ToString()
};
}
sqlCon.Close();
if (CurrentUser != null)
{
RecepieWindow window = new RecepieWindow();
window.Show();
Close();
return;
}
else
{
if (!UserValidation.Validate(txtUsername.Text, txtPassword.Password))
{
return;
}
data = System.Text.Encoding.ASCII.GetBytes(txtPassword.Password);
data = new System.Security.Cryptography.SHA256Managed().ComputeHash(data);
hash = System.Text.Encoding.ASCII.GetString(data);
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
var cmd = new SqlCommand(@"insert into tblUser values (@FullName, @Username, @Password);", conn);
cmd.Parameters.AddWithValue("@FullName", txtUsername.Text);
cmd.Parameters.AddWithValue("@Username", txtUsername.Text);
cmd.Parameters.AddWithValue("@Password", hash);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBoxResult messageBoxResult1 = System.Windows.MessageBox.Show("New user successfully created.", "Notification");
}
sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
//User is extracted from the database matching inserted paramaters Username and Password.
query = new SqlCommand("SELECT * FROM tblUser WHERE Username=@Username AND Password=@Password", sqlCon);
query.CommandType = CommandType.Text;
query.Parameters.AddWithValue("@Username", txtUsername.Text);
query.Parameters.AddWithValue("@Password", hash);
sqlCon.Open();
sqlDataAdapter = new SqlDataAdapter(query);
dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
CurrentUser = new User
{
UserId = int.Parse(row[0].ToString()),
FullName = row[1].ToString(),
Username = row[2].ToString(),
Password = row[3].ToString()
};
}
sqlCon.Close();
if (CurrentUser != null)
{
RecepieWindow window = new RecepieWindow();
window.Show();
Close();
return;
}
}
}
