//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);
}