//SQL_ACCESS /// <summary> /// Recherche d'un coureur ou d'une course à partir du nom de la course /// </summary> /// <param name="searchValue"></param> /// <param name="dgv"></param> /// <param name="dgvGoal"></param> /// <param name="btnSearch"></param> /// <param name="btnReinit"></param> /// <param name="btnDelete"></param> /// <param name="isConnected"></param> internal void Search(string searchValue, DataGridView dgv, DataGridView dgvGoal, Button btnSearch, Button btnReinit, Button btnDelete, bool isConnected) { int id = 0; try { bool valueResult = false; foreach (DataGridViewRow row in dgv.Rows) { if (row.Cells[0].Value != null && row.Cells[0].Value.ToString().ToLower().Equals(searchValue.ToLower()) || row.Cells[1].Value != null && row.Cells[1].Value.ToString().ToLower().Equals(searchValue.ToLower())) { int rowIndex = row.Index; dgv.Rows[rowIndex].Selected = true; if (dgv.Name == "dgvCoureurs") { id = coureurRepository.GetIdCoureurFromName(searchValue); dgvGoal.DataSource = participationRepository.SearchParticipationByCoureurId(id); ColumnsSortingDgvParticipations(dgvGoal); dgvGoal.Visible = true; } else { id = courseRepository.GetIdCourseFromName(searchValue); dgvGoal.DataSource = participationRepository.SearchParticipationByCourseId(id); dgvGoal.DataSource = CleanRefresh(dgvGoal); ColumnsSortingDgvParticipations(dgvGoal); dgvGoal.Visible = true; } dgv.Visible = false; valueResult = true; break; } } if (!valueResult) { MessageBox.Show("Impossible de trouver " + searchValue, "Not Found"); return; } } catch (Exception exc) { MessageBox.Show(exc.Message); } btnSearch.Visible = false; btnReinit.Visible = true; if (isConnected) { btnDelete.Visible = true; } }
public void GetIdCoureurFromNameTest() { int idTestBdd = coureurRepository.GetIdCoureurFromName("Bres"); int idAttended = 1; Assert.AreEqual(idAttended, idTestBdd); }