private void login() { Database_Class database = new Database_Class(); string password = database.getLogins(UsernameField.Text); String entered_name = UsernameField.Text; String entered_pass = PasswordField.Text; if ((entered_name == "") || (entered_pass == "")) { IncorrectCredentials.Show(); } else if (password.Equals(entered_pass)) { //You may login //Hide the incorrect credentials message box IncorrectCredentials.Hide(); //Create and show the main menu when login is successful Main_Menu _mainMenu = new Main_Menu(); Hide(); _mainMenu.Show(); } else { //You may not login. Incorrect Credentials IncorrectCredentials.Show(); } }
//********************************************************************************************************************************************** private void ElectronicToolsGrid_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Enter) { Database_Class database = new Database_Class(); database.editItems(dataGridView()); } }
//**************************************************************************************************************** private void btnDelete_Click(object sender, EventArgs e) { if (thisGridView().SelectedCells.Count > 0) { Display_Manager _display_manager = new Display_Manager(); string _verification_message = _display_manager.Delete_Verification_Message(thisGridView()); int Item_ID = _display_manager.get_Item_ID(thisGridView()); Database_Class database_access = new Database_Class(); database_access.deleteItem(Item_ID, _verification_message); refresh_dataGridView(); } }
//**************************************************************************************************************** private void AddNewButton_Click(object sender, EventArgs e) { Display_Manager _display_manager = new Display_Manager(); string[] _items = { txtName.Text, txtDescription.Text, txtManufacturer.Text, CATEGORY, txtNumber.Text, CB_Available.Text, txtCondition.Text, txtLocation.Text }; string[] _entries = _display_manager.Validate_Entries(_items); if (_entries != null) { //Load entries into the database Database_Class database_access = new Database_Class(); database_access.addItem(_items); refresh_dataGridView(); // Refresh the viewed data after you finish adding an item } }
//******************************************************************************************************************************************************************************* public void Refresh(DataGridView grid, string category, string filter_string) { Database_Class database_access = new Database_Class(); DataSet dataset = new DataSet(); database_access.SelectItems(ref dataset, category, filter_string); //Chosing the data to be displayed in the Grid View on the Screen grid.DataSource = dataset.Tables[0]; //Making sure that the data grid view uses up all the space avaibale on the screen grid.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; grid.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; grid.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; grid.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; grid.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; grid.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; grid.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; grid.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; grid.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; //Hide the Item_ID and the Category from the grid view grid.Columns["Item_ID"].Visible = false; grid.Columns["Category"].Visible = false; // Control The Edit Previlleges // Columns 6 and 9 are: Item Availability and Borrower // These columns need to ne editable grid.ReadOnly = false; grid.Columns[1].ReadOnly = true; grid.Columns[2].ReadOnly = true; grid.Columns[3].ReadOnly = true; grid.Columns[4].ReadOnly = true; grid.Columns[5].ReadOnly = true; grid.Columns[7].ReadOnly = true; grid.Columns[8].ReadOnly = true; grid.EditMode = DataGridViewEditMode.EditOnEnter; }
//********************************************************************************************************************************************** private void btnBorrowed_Click(object sender, EventArgs e) { Database_Class database = new Database_Class(); database.editItems(dataGridView()); }