private void button4_Click_1(object sender, EventArgs e) { String id = dataGridView1.Rows[x].Cells[0].Value.ToString(); String stock = dataGridView1.Rows[x].Cells[5].Value.ToString(); if (int.Parse(stock) == 0) { MessageBox.Show("Inventory is empty. Please select others."); } else { string name = DLname.getInstance().Str; string command = "select uReservation from userlogin where uName =" + name; DBTools db = new DBTools(".", "wkdl", true, "sa", "wdxg"); SqlDataReader b = db.getResult("select * from userlogin where uName ='" + name + "' and uReservation != ''"); if (b.Read()) { MessageBox.Show("Sorry! Each member can only reserve one vechicle.", "System", MessageBoxButtons.OK, MessageBoxIcon.Warning); db.Disconnect(); return; } db.Disconnect(); string update = "update ware set stocks = " + (int.Parse(stock) - 1) + " where [id]=" + id; string reserve = "; update userlogin set uReservation = 'Model: " + dataGridView1.Rows[x].Cells[1].Value + ", Price: $" + dataGridView1.Rows[x].Cells[2].Value + "/mouth, Zip: " + dataGridView1.Rows[x].Cells[3].Value + ", Reserve time: " + DateTime.Now.ToLocalTime() + "' where [uName] = '" + DLname.getInstance().Str + "'"; da.InsertCommand = con.CreateCommand(); da.InsertCommand.CommandText = update + reserve; con.Open(); da.InsertCommand.ExecuteNonQuery(); con.Close(); MessageBox.Show("Reserve successfully, please wait for agent response."); LoadDGV(); } }
private void button1_Click(object sender, EventArgs e) { string name = textBox1.Text.Trim().ToString(); string pwd = textBox2.Text.Trim().ToString(); if (textBox2.Text.Trim().Length == 0 || textBox3.Text.Trim() != textBox2.Text.Trim()) { MessageBox.Show("Failed, password and confirm password are not equal or empty!", "System", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { try { DBTools db = new DBTools(".", "wkdl", true, "sa", "wdxg"); SqlDataReader b = db.getResult("update userlogin set uPassword='******'where uName='" + name + "'"); db.Disconnect(); b.Close(); MessageBox.Show("Change password successfully!", "System", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Dispose(true); } catch (Exception x) { MessageBox.Show(x.Message, "System", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void button1_Click(object sender, EventArgs e) { DBTools db = new DBTools(".", "wkdl", true, "sa", "wdxg"); SqlDataReader b = db.getResult("Select * from userlogin where uname='" + textBox1.Text.Trim() + "'and uPassword='******'"); try { if (b.Read()) { db.Disconnect(); DBTools dc = new DBTools(".", "wkdl", true, "sa", "wdxg"); SqlDataReader bb = db.getResult("Select * from userlogin where uname='" + textBox1.Text.Trim() + "'and usa='admin'"); DLname c = DLname.getInstance(); c.Str = textBox1.Text; if (bb.Read()) { dc.Disconnect(); MessageBox.Show("Hello administrator.", "Hello", MessageBoxButtons.OK, MessageBoxIcon.Information); MainForm mfa = new MainForm(); mfa.Text = "Administrator System"; mfa.Show(); } else { dc.Disconnect(); MessageBox.Show("Hello VIP member", "Hello", MessageBoxButtons.OK, MessageBoxIcon.Information); MainForm mfb = new MainForm(); mfb.Text = "Member System"; mfb.Show(); } dc.Disconnect(); this.Hide(); } else { db.Disconnect(); MessageBox.Show("Login failed! Please check your input.", "Sorry", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Update_Load(object sender, EventArgs e) { db = new DBTools(".", "wkdl", true, "sa", "wdxg"); SqlDataReader b = db.getResult("Select * from ware where id=" + c.Num); while (b.Read()) { textBox1.Text = b["id"].ToString(); textBox2.Text = b["warename"].ToString(); textBox3.Text = b["price"].ToString(); textBox4.Text = b["zip"].ToString(); textBox5.Text = b["type"].ToString(); textBox6.Text = b["stocks"].ToString(); } db.Disconnect(); }