/// <summary>
/// Importation du fichier
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnValider_Click(object sender, EventArgs e)
{
string _msgDump = String.Empty;
progBar.Visible = true;
lblNum.Visible = true;
int nbAnomalies = 0;
Log.Debug("Valider l'import...");
m_numId = 0;
Log.Debug("Importer {" + p_dataTable.Rows.Count.ToString() + "} lignes ...");
int _nbAdd = 0;
progBar.Maximum = p_dataTable.Rows.Count;
for (int i = 0; i <= p_dataTable.Rows.Count - 1; i++)
{
progBar.Value = i;
lblNum.Text = i.ToString("D4");
lblNum.Refresh();
if (p_dataTable.Rows[i][cmbRefClient.SelectedIndex] != DBNull.Value)
{
try
{
m_numId++;
Ecole _lineEcole = new Ecole();
_lineEcole.IdEcole = getValue(cmbRefClient.SelectedIndex, i);
_lineEcole.Libelle = getSchoolName(getValue(cmbLibelle.SelectedIndex, i));
int _codePostal = 0;
if (cmbCodePostal.SelectedIndex > 0) { if (!Int32.TryParse(getValue(cmbCodePostal.SelectedIndex, i), out _codePostal)) { _codePostal = 0; } }
_lineEcole.CodePostal = _codePostal.ToString("D5");
_lineEcole.Adresse = getValue(cmbAdress.SelectedIndex, i);
_lineEcole.Ville = getValue(cmbLocalite.SelectedIndex, i);
_lineEcole.Telephone = getValue(cmbTelephone.SelectedIndex, i);
_lineEcole.initEcole();
_lineEcole.Contact.Nom = getValue(cmbNomContact.SelectedIndex, i);
_lineEcole.Contact.Email = getValue(cmbEmail.SelectedIndex, i);
_lineEcole.Contact.Complements = getValue(cmbComments.SelectedIndex, i);
_nbAdd += frm.UpdateSchoolFromImportFile(_lineEcole);
}
catch (Exception _exception)
{
nbAnomalies++;
Log.Debug("Anomalie lors de l'import : ligne " + i.ToString() + "..." + _exception.Message);
_msgDump += String.Format("Import de la ligne {0} : Ref {1}{2}", i, getValue(cmbRefClient.SelectedIndex, i), Environment.NewLine);
}
}
Button _bn = (Button)sender;
_bn.DialogResult = System.Windows.Forms.DialogResult.OK;
}
if (nbAnomalies > 0)
{
MessageBox.Show("Attention, plusieurs lignes non conformes ont été ignorées");
ClassOutils.writeDumpFile(_msgDump, "Import_");
}
}
