private void SearchByKeyword()
{
var storedGetLibraryType = BuildingStoredProcHelper.BuildStoredStrSearchByKeyword(txtSearchByKeyword.Text);
HandlingDataHelper.LoadDataToGrid(dgvSearchByKeyword, DataGridViewHeader.listOfColumnsTypeByKeyword, storedGetLibraryType);
lblSearchByKeywordCount.Text = $"Total: {dgvSearchByKeyword.RowCount} record(s)";
}
private void LoadSearchTab(string title)
{
tcNationalLibrary.SelectedIndex = 0;
txtSearchByTitle.Text = title;
var storedGetLibraryType = BuildingStoredProcHelper.BuildStoredStrSearchByTitle(title);
HandlingDataHelper.LoadDataToGrid(dgvSearchByTitle, DataGridViewHeader.listOfColumnsType, storedGetLibraryType);
lblSearchByTitleCount.Text = $"Total: {dgvSearchByTitle.RowCount} record(s)";
}
private void tcAddData_SelectedIndexChanged(object sender, EventArgs e)
{
switch (tcAddData.SelectedTab.Name)
{
case TabControlConstants.TabAddDataPublisher:
HandlingDataHelper.LoadDataToGrid(dgvPublisher, DataGridViewHeader.listOfColumnsPublisher, TableConstants.LibraryTypePublisher);
break;
case TabControlConstants.TabAddDataEdition:
HandlingDataHelper.LoadDataToGrid(dgvEdition, DataGridViewHeader.listOfColumnsEdition, TableConstants.LibraryTypeEdition);
break;
case TabControlConstants.TabAddDataEditor:
HandlingDataHelper.LoadDataToGrid(dgvEditor, DataGridViewHeader.listOfColumnsEditor, TableConstants.LibraryTypeEditor);
break;
case TabControlConstants.TabAddDataFormat:
HandlingDataHelper.LoadDataToGrid(dgvFormat, DataGridViewHeader.listOfColumnsFormat, TableConstants.LibraryTypeFormat);
break;
case TabControlConstants.TabAddDataLanguage:
HandlingDataHelper.LoadDataToGrid(dgvLanguage, DataGridViewHeader.listOfColumnsLanguage, TableConstants.LibraryTypeLanguage);
break;
case TabControlConstants.TabAddDataCategory:
HandlingDataHelper.LoadDataToGrid(dgvCategory, DataGridViewHeader.listOfColumnsCategory, TableConstants.LibraryTypeCategory);
break;
case TabControlConstants.TabAddDataCopyright:
HandlingDataHelper.LoadDataToGrid(dgvCopyright, DataGridViewHeader.listOfColumnsCopyright, TableConstants.LibraryTypeCopyright);
break;
case TabControlConstants.TabAddDataAuthor:
HandlingDataHelper.LoadDataToGrid(dgvAuthor, DataGridViewHeader.listOfColumnsAuthor, TableConstants.LibraryTypeAuthor);
break;
default:
break;
}
}