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(); } } } }