private void btnAddSale_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are You Sure", "Warning", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
try
{
string vin = this.inventoryGrid.CurrentRow.Cells[0].Value.ToString();
Int64 telephone = Int64.Parse(this.customerGrid.CurrentRow.Cells[2].Value.ToString());
price = decimal.Parse(tbxPrice.Text);
string query = "select inventoryID " +
"from inventory " +
$"where vin = '{vin}';";
DataTable idtbl = Filler.DataTableFiller(query);
foreach (DataRow row in idtbl.Rows)
{
inventoryID = int.Parse(row["inventoryID"].ToString().Trim());
}
string query2 = "select customerID " +
"from customer " +
$"where telephone = {telephone};";
DataTable cdtbl = Filler.DataTableFiller(query2);
foreach (DataRow row in cdtbl.Rows)
{
customerID = int.Parse(row["customerID"].ToString().Trim());
}
string salesquery = $"insert into sales values({inventoryID},{customerID},{price}); " +
$"update inventory set sold = 1 where inventoryID = {inventoryID};";
Filler.InserterDeleter(salesquery);
DataViewControl dvc = new DataViewControl();
this.Hide();
dvc.tabControl1.SelectedTab = dvc.salesPage;
dvc.ShowDialog();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (dialogResult == DialogResult.No)
{
}
}
private void btnCreateAccount_Click(object sender, EventArgs e)
{
string username = tbxUsername.Text;
string password = tbxPassword.Text;
string queryUsername = $"select username from account " +
$"where username = '******';";
DataTable Usernamedtbl = Filler.DataTableFiller(queryUsername);
if (Usernamedtbl.Rows.Count != 0)
{
MessageBox.Show("Username Already Exists", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
if (lblPasswordQuality.ForeColor != Color.Green)
{
MessageBox.Show("Create Stronger Password", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else if (tbxPassword.Text != tbxConfirmPassword.Text)
{
MessageBox.Show("Passwords Do Not Match", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
Account g = new Account(username, password);
string queryCreateAccount = $"insert into account values('{g.GetUsername()}','{Encryption.sha256(g.GetPassword())}');";
Filler.InserterDeleter(queryCreateAccount);
MessageBox.Show("Account Created", "New", MessageBoxButtons.OK,
MessageBoxIcon.Information);
LogIn li = new LogIn();
this.Hide();
li.ShowDialog();
li.Dispose();
this.Close();
}
}
}
private void fillCustomerDataTable()
{
string query = "select firstname, lastname, telephone, email " +
"from customer;";
DataTable Customerdtbl = Filler.DataTableFiller(query);
foreach (DataRow row in Customerdtbl.Rows)
{
string[] rowarray = { row["firstname"].ToString().Trim(),
row["lastname"].ToString().Trim(),
row["telephone"].ToString().Trim(),
row["email"].ToString().Trim() };
customerGrid.Rows.Add(rowarray);
}
}
private void fillSalesDataTable()
{
string query = "select firstname, lastname, modelyear, make, model, modeltrim, price " +
"from customer, inventory, sales " +
"where sales.customerID = customer.customerID " +
"and sales.inventoryID = inventory.inventoryID;";
DataTable Salesdtbl = Filler.DataTableFiller(query);
foreach (DataRow row in Salesdtbl.Rows)
{
string[] rowarray = { row["firstname"].ToString().Trim() + " " + row["lastname"].ToString().Trim(),
row["modelyear"].ToString().Trim() + " " + row["make"].ToString().Trim() + " " + row["model"].ToString().Trim() + " " + row["modeltrim"].ToString().Trim(),
row["price"].ToString().Trim() };
salesGrid.Rows.Add(rowarray);
}
}
private void fillInventoryDataTable()
{
string query = "select vin, color, make, model, modeltrim, modelyear, mileage " +
"from inventory " +
"where sold = 0;";
DataTable Inventorydtbl = Filler.DataTableFiller(query);
foreach (DataRow row in Inventorydtbl.Rows)
{
string[] rowarray = { row["vin"].ToString().Trim(),
row["color"].ToString().Trim(),
row["modelyear"].ToString().Trim(),
row["make"].ToString().Trim(),
row["model"].ToString().Trim(),
row["modeltrim"].ToString().Trim(),
row["mileage"].ToString().Trim() };
inventoryGrid.Rows.Add(rowarray);
}
}
private void btnLogIn_Click(object sender, EventArgs e)
{
string username = tbxUsername.Text;
string password = tbxPassword.Text;
string queryUsername = $"select username, password from account " +
$"where username = '******';";
DataTable Usernamedtbl = Filler.DataTableFiller(queryUsername);
if (Usernamedtbl.Rows.Count == 0)
{
MessageBox.Show("User Not Found", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
foreach (DataRow row in Usernamedtbl.Rows)
{
if (row["password"].ToString().Trim() != Encryption.sha256(password))
{
MessageBox.Show("Incorrect Password", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
DataViewControl dvc = new DataViewControl();
this.Hide();
dvc.ShowDialog();
dvc.Dispose();
this.Close();
}
}
}
}
