private void AddMainBtn_Click(object sender, EventArgs e)
{
if (comboBox_year.SelectedIndex == -1 || comboBox_month.SelectedIndex == -1 || comboBox_station.SelectedIndex == -1 || listView_TimeTable.Items.Count == 0)
{
MessageBox.Show("Nie wypełniłeś wszystkich pól");
}
else
{
string harmName;
if (numericUpDown_Id.Value == 0)
{
harmName = numericUpDown_Id.Value + "_" + comboBox_year.SelectedItem.ToString() + "_" + comboBox_month.SelectedItem.ToString();
}
else
{
harmName = new Random().Next(0, 9999999).ToString() + "_" + comboBox_year.SelectedItem.ToString() + "_" + comboBox_month.SelectedItem.ToString();
}
FormIntoDatabase form = new FormIntoDatabase("ALTER TABLE Harmonogramy ADD [" + harmName + "] VARCHAR(MAX) ", new string[] { harmName });
form.Qery();
for (int i = 0; i < listView_TimeTable.Items.Count; i++)
{
string row = "";
for (int j = 0; j < listView_TimeTable.Items[i].SubItems.Count; j++)
{
row += listView_TimeTable.Items[i].SubItems[j].Text + "#";
}
form = new FormIntoDatabase("UPDATE Harmonogramy SET [" + harmName + "]=$ WHERE Id = $", new string[] { row, (i + 1).ToString() });
form.Qery();
}
listView_TimeTable.Items.Clear();
listView_TimeTable.Columns.Clear();
this.Close();
}
}
