private void scheduleButton_Click(object sender, RoutedEventArgs e)
{
//UPDATE `employeedatabase`.`employeedata` SET `Sunday_Start` = '12' WHERE(`id` = '2');
try
{
string[] days = { "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday" };
int dbColumn = column + 1;
string connectionstring = "SERVER=localhost;DATABASE=employeedatabase;UID=root;PASSWORD=Thisisit123#;";
MySqlConnection connection = new MySqlConnection(connectionstring);
MySqlCommand cmd = new MySqlCommand("UPDATE `employeedatabase`.`employeeshift` SET `Shift" + dbColumn.ToString() + "` = '" + this.suggestionID.Text + "' WHERE (`Day` = '" + days[row] + "');", connection);
connection.Open();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
MainWindow win = (MainWindow)Window.GetWindow(this);
win.fetch();
win.suggestionStack.Children.Clear();
}
