private void btnBack_Click(object sender, EventArgs e) { Form adminForm = new adminForm(); adminForm.Show(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { string name = "faisal"; string pass = "******"; string email = userNameTxt.Text; string Pass = PasswordTxt.Text; con.Open(); SqlCommand comm = new SqlCommand("SELECT count(*) FROM UserTable where Email='" + email + "' and Password='******'", con); Int32 count = (Int32)comm.ExecuteScalar(); if (email == name && Pass == pass) { //MessageBox.Show("valid user!"); Form adminForm = new adminForm(); adminForm.Show(); // this.Hide(); } else if (count > 0) { //MessageBox.Show("valid user!"); Form userForm = new userForm(); userForm.Show(); // this.Hide(); //this.Close(); } else { MessageBox.Show("Invalid User!"); } con.Close(); }
private void btnSearch_Click(object sender, EventArgs e) { DialogResult res = MessageBox.Show("Are you sure you want to Delete", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (res == DialogResult.OK) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Delete from BookTable where Title='" + txtTitle.Text + "'"; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Book Removed!"); this.Close(); } if (res == DialogResult.Cancel) { Form adminForm = new adminForm(); adminForm.Show(); } }
private void button1_Click(object sender, EventArgs e) { string Title, Author; int AvailableCopy; double Price; Title = txtTitle.Text; Author = txtAuthor.Text; Price = Convert.ToDouble(txtPrice.Text); AvailableCopy = Int32.Parse(txtAvailableCopy.Text); con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Insert into BookTable values('" + Title + "','" + Author + "','" + Price + "','" + AvailableCopy + "')"; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Book Added!"); Form adminForm = new adminForm(); adminForm.Show(); this.Close(); }
private void btnRemove_Click(object sender, EventArgs e) { string UserName = txtUserName.Text; string Email = txtEmail.Text; try { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "delete from UserTable where Name='" + UserName + "' and Email='" + Email + "'"; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("User Deleted!"); Form adminForm = new adminForm(); adminForm.Show(); this.Close(); } catch (Exception ex) { throw new ApplicationException(string.Format("Invalid User"), ex); } }
private void button2_Click(object sender, EventArgs e) { Form adminForm = new adminForm(); adminForm.Show(); }