private void save_button_Click(object sender, EventArgs e)
{
//------------- check parms
if (String.IsNullOrEmpty(separator_csv_textBox.Text))
{
MessageBox.Show("Erreur : le séparateur de champ de fichier CSV est null");
return;
}
TextBox[] list = new TextBox[] { last_name_textBox, first_name_textBox, division_textBox, sex_textBox, half_board_days_textBox, exit_regime_textBox };
TextBox[] list_allowed_no_index = new TextBox[] { exit_regime_textBox };
List <int> index = new List <int>();
for (int i = 0; i < list.Length; i++)
{
TextBox textBox = list[i];
if (textBox.Text == "")
{
MessageBox.Show("ATTENTION : les champs surmontés d’un astérisque « * » doivent obligatoirement être renseignés");
return;
}
int tmp = getIndexFromTextBox(textBox);
if (tmp != -1)
{
if (index.Contains(tmp))
{
MessageBox.Show("ATTENTION : L'indice " + (tmp + 1) + " est utilisé à plusieurs reprises");
return;
}
index.Add(tmp);
}
else
{
if (!list_allowed_no_index.Contains(textBox))
{
MessageBox.Show("Les champ (*) ne peuvent pas avoir comme indices 0");
return;
}
}
}
var tmp_var = halfBoardDaysCorrect();
if (!tmp_var.Item1)
{
MessageBox.Show("Erreur : " + tmp_var.Item2);
return;
}
tmp_var = sexCorrect();
if (!tmp_var.Item1)
{
MessageBox.Show("Erreur : " + tmp_var.Item2);
return;
}
//------------- save changes
try
{
Parms parms = new Parms();
parms.toDefault();
//take out one for each result because we ask the user to start the counting at 1 (and not 0)
parms.lastNameIndex = getIndexFromTextBox(last_name_textBox);
parms.firstNameIndex = getIndexFromTextBox(first_name_textBox);
parms.divisionIndex = getIndexFromTextBox(division_textBox);
parms.sexIndex = getIndexFromTextBox(sex_textBox);
parms.halfBoardDaysIndex = getIndexFromTextBox(half_board_days_textBox);
parms.femaleShortname = shortname_female_textBox.Text;
parms.maleShortname = shortname_male_textBox.Text;
parms.exitRegimeIndex = getIndexFromTextBox(exit_regime_textBox);
parms.mondayShortname = mon_textBox.Text;
parms.tuesdayShortname = tue_textBox.Text;
parms.wednesdayShortname = wed_textBox.Text;
parms.thursdayShortname = thu_textBox.Text;
parms.fridayShortname = fri_textBox.Text;
parms.saturdayShortname = sat_textBox.Text;
parms.sundayShortname = sun_textBox.Text;
var tmp = getCharFromTextBox(separator_days_textBox);
parms.separatorDays = tmp.Item2;
tmp = getCharFromTextBox(separator_csv_textBox);
parms.separatorCsv = tmp.Item2;
if (encapsulation_checkBox.Checked)
{
parms.encapsulationByQuote = true;
}
else
{
parms.encapsulationByQuote = false;
}
ToolsClass.Settings.StudentsStateFileParameters = parms;
if (path_to_new_file != "")
{
try
{
DataBase database = new DataBase();
//copy file
string path_source_file = ToolsClass.Definition.PATH_TO_TMP_FOLDER + ToolsClass.Definition.SEPARATOR + Path.GetRandomFileName();
File.Copy(path_to_new_file, path_source_file, true);
string path_error_file = ToolsClass.Definition.PATH_TO_TMP_FOLDER + ToolsClass.Definition.SEPARATOR + Path.GetRandomFileName();
//update database
int res = database.updateStudentTableFromFile(path_source_file, path_error_file);
if (res != ToolsClass.Definition.NO_ERROR_INT_VALUE)//ask user if he wants to see logs
{
string msg = "Une erreur est survenue lors de la mise à jour.\n"
+ "Certaines informations sont peut-être incomplètes ou incorrectes. Dans ce cas, elles n'ont pas été prise en compte.\n"
+ "\nVoulez vous consulter le fichier des logs ?\n";
DialogResult dialogResult = MessageBox.Show(msg, "Erreur", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{//export error file to the selected directory
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "CSV Files(*.csv) | *.csv";
saveFileDialog1.FilterIndex = 2;
saveFileDialog1.RestoreDirectory = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
File.Copy(path_error_file, saveFileDialog1.FileName + ".csv", true);
}
}
}
//remove file
File.Delete(path_source_file);
File.Delete(path_error_file);
} catch (Exception ef)
{
MessageBox.Show("Une erreur est survenue : impossible de mettre à jour la base de données à partir du fichier source selectionné !\n" + ef);
return;
}
}
}
catch
{
MessageBox.Show("ERREUR : certains paramètres ne sont pas valides ! ");
return;
}
this.Close();
}
public SettingsStudentsStateFile()
{
InitializeComponent();
path_to_new_file = "";
defaultTextBoxColor = textBox1.BackColor;
last_name_textBox.KeyPress += new KeyPressEventHandler(textBoxes_KeyPress);
first_name_textBox.KeyPress += new KeyPressEventHandler(textBoxes_KeyPress);
division_textBox.KeyPress += new KeyPressEventHandler(textBoxes_KeyPress);
sex_textBox.KeyPress += new KeyPressEventHandler(textBoxes_KeyPress);
half_board_days_textBox.KeyPress += new KeyPressEventHandler(textBoxes_KeyPress);
exit_regime_textBox.KeyPress += new KeyPressEventHandler(textBoxes_KeyPress);
last_name_textBox.TextChanged += new EventHandler(textBoxes_TextChanged);
first_name_textBox.TextChanged += new EventHandler(textBoxes_TextChanged);
division_textBox.TextChanged += new EventHandler(textBoxes_TextChanged);
sex_textBox.TextChanged += new EventHandler(textBoxes_TextChanged);
half_board_days_textBox.TextChanged += new EventHandler(textBoxes_TextChanged);
exit_regime_textBox.TextChanged += new EventHandler(textBoxes_TextChanged);
Parms parms = ToolsClass.Settings.StudentsStateFileParameters;
//add 1 for each result because we store columns index from 0 to ... (and not from 1 to ...)
setUserIndexTextBox(last_name_textBox, parms.lastNameIndex);
setUserIndexTextBox(first_name_textBox, parms.firstNameIndex);
setUserIndexTextBox(division_textBox, parms.divisionIndex);
setUserIndexTextBox(sex_textBox, parms.sexIndex);
setUserIndexTextBox(half_board_days_textBox, parms.halfBoardDaysIndex);
setUserIndexTextBox(exit_regime_textBox, parms.exitRegimeIndex);
shortname_female_textBox.Text = "" + parms.femaleShortname;
shortname_male_textBox.Text = "" + parms.maleShortname;
mon_textBox.Text = "" + parms.mondayShortname;
tue_textBox.Text = "" + parms.tuesdayShortname;
wed_textBox.Text = "" + parms.wednesdayShortname;
thu_textBox.Text = "" + parms.thursdayShortname;
fri_textBox.Text = "" + parms.fridayShortname;
sat_textBox.Text = "" + parms.saturdayShortname;
sun_textBox.Text = "" + parms.sundayShortname;
if (parms.separatorDays == ' ') //space
{
separator_days_textBox.Text = TAG_SPACE;
}
else if (parms.separatorDays == (char)13) //enter
{
separator_days_textBox.Text = TAG_RETURN;
}
else
{
separator_days_textBox.Text = "" + parms.separatorDays;
}
if (parms.separatorCsv == ' ') //space
{
separator_csv_textBox.Text = TAG_SPACE;
}
else if (parms.separatorCsv == (char)13) //enter
{
separator_csv_textBox.Text = TAG_RETURN;
}
else
{
separator_csv_textBox.Text = "" + parms.separatorCsv;
}
if (parms.encapsulationByQuote)
{
encapsulation_checkBox.Checked = true;
}
else
{
encapsulation_checkBox.Checked = false;
}
}
