private void ConfirmNewManager_Click(object sender, EventArgs e) { connection CN2 = new connection(); CN2.thisConnection.Open(); OracleDataAdapter thisAdapter = new OracleDataAdapter("SELECT * FROM userinfo", CN2.thisConnection); OracleCommandBuilder thisBuilder = new OracleCommandBuilder(thisAdapter); DataSet thisDataSet = new DataSet(); thisAdapter.Fill(thisDataSet, "userinfo"); DataRow thisRow = thisDataSet.Tables["userinfo"].NewRow(); try { thisRow["id"] = NewManagerUsername.Text; thisRow["password"] = NewManagerPass.Text; thisDataSet.Tables["userinfo"].Rows.Add(thisRow); thisAdapter.Update(thisDataSet, "userinfo"); MessageBox.Show("New Manager Added"); } catch (Exception ex) { MessageBox.Show(ex.Message); } CN2.thisConnection.Close(); AdminDashboard nxtform = new AdminDashboard(); nxtform.Show(); this.Hide(); }
private void ConfirmNewBook_Click(object sender, EventArgs e) { connection CN2 = new connection(); CN2.thisConnection.Open(); OracleDataAdapter thisAdapter = new OracleDataAdapter("SELECT * FROM bookinfo", CN2.thisConnection); OracleCommandBuilder thisBuilder = new OracleCommandBuilder(thisAdapter); DataSet thisDataSet = new DataSet(); thisAdapter.Fill(thisDataSet, "bookinfo"); DataRow thisRow = thisDataSet.Tables["bookinfo"].NewRow(); try { thisRow["isbn"] = IsbnOfTheBook.Text; thisRow["book_name"] = NameOfTheBook.Text; thisRow["writer_name"] = NameOfTheWriter.Text; thisRow["book_category"] = CategoryOfTheBook.Text; thisRow["entry_date"] = DateOfEntry.Text; thisRow["year_published"] = YearOfPublication.Text; thisRow["book_qty"] = NumberOfBook.Text; thisDataSet.Tables["bookinfo"].Rows.Add(thisRow); thisAdapter.Update(thisDataSet, "bookinfo"); MessageBox.Show("A New Book Added"); } catch (Exception ex) { MessageBox.Show(ex.Message); } CN2.thisConnection.Close(); ManagerDashboard nxtForm = new ManagerDashboard(); nxtForm.Show(); this.Hide(); }
private void ManagerVerification() { try { connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand = new OracleCommand(); thisCommand.Connection = CN.thisConnection; thisCommand.CommandText = "SELECT * From userinfo WHERE id='" + mngrUsername.Text + "' AND password='******'"; OracleDataReader thisReader = thisCommand.ExecuteReader(); if (thisReader.Read()) { ManagerDashboard nxtform = new ManagerDashboard(); nxtform.Show(); this.Hide(); } else { MessageBox.Show("incorect password or username"); } CN.thisConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button2_Click(object sender, EventArgs e) { connection sv = new connection(); sv.thisConnection.Open(); OracleCommand thisCommand = sv.thisConnection.CreateCommand(); thisCommand.CommandText = "update bookinfo set book_qty = '" + NewQty.Text + "'where book_name= '" + BookNameToUpdate.Text + "'"; thisCommand.Connection = sv.thisConnection; thisCommand.CommandType = CommandType.Text; try { thisCommand.ExecuteNonQuery(); MessageBox.Show("Quantity Updated"); //this.Hide(); } catch (Exception ex) { Console.WriteLine(ex.Message); } sv.thisConnection.Close(); ManagerDashboard nxtForm = new ManagerDashboard(); nxtForm.Show(); this.Hide(); }
private void GetSearchResultButton_Click(object sender, EventArgs e) { //lsvItem.Items.Clear(); connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand = CN.thisConnection.CreateCommand(); thisCommand.CommandText = "SELECT * FROM bookinfo where book_name= '" + SearchText.Text + "'"; OracleDataReader thisReader = thisCommand.ExecuteReader(); while (thisReader.Read()) { ListViewItem lsvItem = new ListViewItem(); //lsvItem.Clear(); listView1.Items.Clear(); // lsvItem.SubItems.Clear(); lsvItem.Text = thisReader["book_name"].ToString(); lsvItem.SubItems.Add(thisReader["writer_name"].ToString()); lsvItem.SubItems.Add(thisReader["book_qty"].ToString()); lsvItem.SubItems.Add(thisReader["book_category"].ToString()); listView1.Items.Add(lsvItem); } CN.thisConnection.Close(); }
/*public string GetSearchText() * { * return SearchText.Text; * }*/ private void ViewBookList_Load(object sender, EventArgs e) { connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand = CN.thisConnection.CreateCommand(); thisCommand.CommandText = "SELECT * FROM bookinfo order by book_name"; OracleDataReader thisReader = thisCommand.ExecuteReader(); while (thisReader.Read()) { ListViewItem lsvItem = new ListViewItem(); lsvItem.Text = thisReader["book_name"].ToString(); lsvItem.SubItems.Add(thisReader["writer_name"].ToString()); lsvItem.SubItems.Add(thisReader["book_qty"].ToString()); lsvItem.SubItems.Add(thisReader["book_category"].ToString()); listView1.Items.Add(lsvItem); } CN.thisConnection.Close(); }
private void ConfirmRemovingBook_Click(object sender, EventArgs e) { connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand1 = CN.thisConnection.CreateCommand(); thisCommand1.CommandText = "delete bookinfo where book_name= '" + BookNameToRemove.Text + "'"; thisCommand1.Connection = CN.thisConnection; thisCommand1.CommandType = CommandType.Text; try { thisCommand1.ExecuteNonQuery(); MessageBox.Show("Book Removed"); ManagerDashboard nxtform = new ManagerDashboard(); nxtform.Show(); this.Hide(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }