public frmArticles() { InitializeComponent(); ArticleLoader(); DGVRefList.DataSource = TabelConnector.DataTableLoader("Select * from TblReference"); cmbRefrenceType.SelectedIndex = 0; }
//Article DataGridView Cell click event. private void DGVArticlesList_CellClick(object sender, DataGridViewCellEventArgs e) { try { articleId = Convert.ToInt32(DGVArticlesList.Rows[e.RowIndex].Cells[0].Value); DataTable dt = TabelConnector.DataTableLoader($"Select * from tblText where id= {articleId}");//Gets a data table from the datbase and initialize data to the textbox. txtWordEditor.Text = dt.Rows[0][1].ToString(); txtRefrence.Text = dt.Rows[0][3].ToString(); } catch { } }
//Admin's record delete from database. private void DeleteData(object sender, EventArgs e) { DataTable userCheckDT = TabelConnector.DataTableLoader($"Select * from Users Where UserId ='{txtUserId.Text}' or email = '{txtEmail.Text}'"); if (Convert.ToInt32(userCheckDT.Rows[0][0]) == UserInfo.id)//Admin cannot delete his/her own record. { MsgBox.Show($"You Cannot delete yourself", "Restriction", "OK", "Cancel"); } else { DatabaseNonQuery.InsertUpdateDelete($"Delete from Users where id = '{id}'"); ShowTableData(); MessageBox.Show("User removed from the storage", "Update Done", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); MangingFormAndControls.PanelClear(panelUserInfo); //After operation all the text boxes are cleared. } }
//DataGridView's cell click will load row data to the Panel's controlls. private void DGVCellClick(object sender, DataGridViewCellEventArgs e) { try { id = dgvUsersData.Rows[e.RowIndex].Cells[0].Value.ToString(); DataTable dt = TabelConnector.DataTableLoader($"Select * from Users where id = '{id}'"); txtFirstName.Text = dt.Rows[0][1].ToString(); txtLastName.Text = dt.Rows[0][2].ToString(); txtUserId.Text = dt.Rows[0][3].ToString(); txtContact.Text = dt.Rows[0][4].ToString(); txtEmail.Text = dt.Rows[0][5].ToString(); txtAddress.Text = dt.Rows[0][6].ToString(); txtPassword.Text = dt.Rows[0][7].ToString(); cmbUserType.Text = dt.Rows[0][8].ToString(); } catch { } }
/// <summary> /// This will initialize Database data fields to the class data fields. /// </summary> /// <param name="Command"> Database query command needs to be passed to get a datatable</param> void FieldInitializer(string Command) { DataTable dt = TabelConnector.DataTableLoader(Command); Id = Convert.ToInt32(dt.Rows[0][0]); title = dt.Rows[0][1].ToString(); Author = dt.Rows[0][2].ToString(); DocumentType = dt.Rows[0][3].ToString(); Year = dt.Rows[0][4].ToString(); Publisher = dt.Rows[0][5].ToString(); Abstract = dt.Rows[0][6].ToString(); NameOfDocument = dt.Rows[0][7].ToString(); Issue = dt.Rows[0][8].ToString(); Volume = dt.Rows[0][9].ToString(); PageNumbers = dt.Rows[0][10].ToString(); Notes = dt.Rows[0][11].ToString(); AuthorLastName(); }
//Update database data with additional admin feature. private void AdminUpdateData(object sender, EventArgs e) { if (txtFirstName.Text == "" || txtUserId.Text == "" || txtEmail.Text == "" || txtPassword.Text == "") { MessageBox.Show("User First Name, UserID, Email, Password cannot be empty", "Field Empty", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DataTable userCheckDT = TabelConnector.DataTableLoader($"Select * from Users Where UserId ='{txtUserId.Text}'"); if (userCheckDT.Rows.Count > 1) { MsgBox.Show($"User Already Registered", "Sign up Error", "OK", "Cancel"); } else { DatabaseNonQuery.InsertUpdateDelete($"Update Users set FirstName ='{txtFirstName.Text}',LastName='{txtLastName.Text}',UserId = '{txtUserId.Text}', Contact = '{txtContact.Text}', Email = '{txtEmail.Text}', Address = '{txtAddress.Text}', Password = '******', UserType = '{cmbUserType.Text}' where id='{id}'"); ShowTableData(); MessageBox.Show("User Information Updated", "Update Done", MessageBoxButtons.OK, MessageBoxIcon.Information); MangingFormAndControls.PanelClear(panelUserInfo); //After operation all the text boxes are cleared. } } }
//Database data insert for data record. private void SaveData(object sender, EventArgs e) { if (txtFirstName.Text == "" || txtUserId.Text == "" || txtEmail.Text == "" || txtPassword.Text == "") { MessageBox.Show("User First Name, UserID, Email, Password cannot be empty", "Field Empty", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DataTable userCheckDT = TabelConnector.DataTableLoader($"Select * from Users Where UserId ='{txtUserId.Text}'"); if (userCheckDT.Rows.Count > 1) { MsgBox.Show($"User Already Registered", "Sign up Error", "OK", "Cancel"); } else //If finds no previous record user's information is inserted to database. { DatabaseNonQuery.InsertUpdateDelete($"Insert into Users(FirstName, LastName, UserId, Contact, Email, Address, Password, UserType) values('{txtFirstName.Text}','{txtLastName.Text}','{txtUserId.Text}','{txtContact.Text}','{txtEmail.Text}','{txtAddress.Text}','{txtPassword.Text}','{cmbUserType.Text}')"); ShowTableData(); MessageBox.Show("User Registration Complete. User Can login now", "Data Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); MangingFormAndControls.PanelClear(panelUserInfo); //After operation all the text boxes are cleared. } } }
/// <summary> /// Stors user datafield's data to the textboxs. By getting data table from TabelConnector class. /// </summary> /// <param name="Command"> Select query for retriving data form the data field to initialze to the datafield.</param> void UserInformation(string Command) { DataTable dt = TabelConnector.DataTableLoader(Command); try { txtTitle.Text = dt.Rows[0][1].ToString(); txtAuthorsList.Text = dt.Rows[0][2].ToString(); cmbDocType.Text = dt.Rows[0][3].ToString(); txtYear.Text = dt.Rows[0][4].ToString(); txtPublisher.Text = dt.Rows[0][5].ToString(); txtAbstract.Text = dt.Rows[0][6].ToString(); txtNameOfSource.Text = dt.Rows[0][7].ToString(); txtIssue.Text = dt.Rows[0][8].ToString(); txtVolume.Text = dt.Rows[0][9].ToString(); txtPageNumber.Text = dt.Rows[0][10].ToString(); txtNotes.Text = dt.Rows[0][11].ToString(); userId = Convert.ToInt32(dt.Rows[0][12]); } catch { MessageBox.Show("Invalid Selection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//Loades user datatable data to the UsersDataGridView. void ShowTableData() { dgvUsersData.DataSource = TabelConnector.DataTableLoader("Select * from Users"); }
//Admin search for particular user using userid private void SearchData(object sender, EventArgs e) { dgvUsersData.DataSource = TabelConnector.DataTableLoader($"Select * from Users where id='{txtSearch.Text}'"); }
private void btnSearch_Click(object sender, EventArgs e) { DGVArticlesList.DataSource = TabelConnector.DataTableLoader($"select * from tbltext where text like '%{txtSearch.Text}%' and UserId='{UserInfo.id}'"); }
//Article DataGridView loads all the documents of the logged in user. void ArticleLoader() { DGVArticlesList.DataSource = TabelConnector.DataTableLoader($"Select * from TblText where userID = '{UserInfo.id}'"); }
//Searches all the matching titles of the refrences of from the refrences. private void btnSearch_Click(object sender, EventArgs e) { DGVRefrenceList.DataSource = TabelConnector.DataTableLoader($"select * from TblReference where Title like '%{txtSearch.Text}%'"); }
//Loads data table's data to the DataGridView. void ShowTableData() { DGVRefrenceList.DataSource = TabelConnector.DataTableLoader("Select * from TblReference"); }