/// <summary> /// Deletes a data source. /// </summary> private void DeleteDataSource_Clicked(object sender, RoutedEventArgs e) { var dsd = (sender as Button).Tag as DataSourceDetails; dsd.MasterKey = GetDataSourceBingMapsKey(); var modal = new DeleteModal(dsd); var b = modal.ShowDialog(); if (b.HasValue && b.Value) { var items = DataSourceTable.ItemsSource as List <DataSourceDetails>; items.Remove(dsd); UpdateDataSourceTable(items); } }
private void handleButtons(object sender, DataGridViewCellEventArgs e, string buttonName) { if (e.ColumnIndex == this.dataGridView1.Columns[buttonName].Index) { if (buttonName == "edit") { dataGridView1.Columns[5].HeaderCell.Value = "Save"; dataGridView1.Columns[6].HeaderCell.Value = "Cancel"; dataGridView1.Columns["title"].ReadOnly = false; dataGridView1.Columns["time_slots"].ReadOnly = false; dataGridView1.Columns["room_name"].ReadOnly = false; dataGridView1.Columns["name"].ReadOnly = false; dataGridView1.Columns["edit"].Visible = false; dataGridView1.Columns["delete"].Visible = false; dataGridView1.Columns["save"].Visible = true; dataGridView1.Columns["cancel"].Visible = true; } if (buttonName == "delete") { DeleteModal popup = new DeleteModal(this.dataGridView1, e); popup.ShowDialog(this); } if (buttonName == "cancel") { dataGridView1.Columns[5].HeaderCell.Value = "Edit"; dataGridView1.Columns[6].HeaderCell.Value = "Delete"; dataGridView1.Columns["title"].ReadOnly = false; dataGridView1.Columns["time_slots"].ReadOnly = false; dataGridView1.Columns["room_name"].ReadOnly = false; dataGridView1.Columns["name"].ReadOnly = false; dataGridView1.Columns["edit"].Visible = true; dataGridView1.Columns["delete"].Visible = true; dataGridView1.Columns["save"].Visible = false; dataGridView1.Columns["cancel"].Visible = false; } if (buttonName == "edit") { DataGridViewComboBoxColumn speakerDropDown = new DataGridViewComboBoxColumn(); DataGridViewCell cell = this.dataGridView1.Rows[e.RowIndex].Cells[3]; cell.Value = speakerDropDown; } } }
private void handleButtonClick(object sender, DataGridViewCellEventArgs e, string buttonName) { if (e.ColumnIndex == this.dataGridView1.Columns[buttonName].Index) { if (buttonName == "edit") { dataGridView1.Columns[4].HeaderCell.Value = "Save"; dataGridView1.Columns[5].HeaderCell.Value = "Cancel"; dataGridView1.Columns["name"].ReadOnly = false; dataGridView1.Columns["email"].ReadOnly = false; dataGridView1.Columns["phone_number"].ReadOnly = false; dataGridView1.Columns["edit"].Visible = false; dataGridView1.Columns["delete"].Visible = false; dataGridView1.Columns["save"].Visible = true; dataGridView1.Columns["cancel"].Visible = true; } if (buttonName == "delete") { DeleteModal popup = new DeleteModal(this.dataGridView1, e, "speaker", "speaker_id"); popup.ShowDialog(this); } if (buttonName == "save") { dataGridView1.Columns[4].HeaderCell.Value = "Edit"; dataGridView1.Columns[5].HeaderCell.Value = "Delete"; dataGridView1.Columns["name"].ReadOnly = true; dataGridView1.Columns["email"].ReadOnly = true; dataGridView1.Columns["phone_number"].ReadOnly = true; dataGridView1.Columns["edit"].Visible = true; dataGridView1.Columns["delete"].Visible = true; dataGridView1.Columns["save"].Visible = false; dataGridView1.Columns["cancel"].Visible = false; // Query Database using (MySqlConnection mysqlCon = new MySqlConnection(connectionString)) { mysqlCon.Open(); var stm = "update speaker set name = @newName, email = @newEmail, phone_number = @newPhoneNumber where speaker_id = @id"; var cmd = new MySqlCommand(stm, mysqlCon); cmd.Parameters.AddWithValue("@newName", this.dataGridView1[1, e.RowIndex].Value.ToString()); cmd.Parameters.AddWithValue("@newEmail", this.dataGridView1[2, e.RowIndex].Value.ToString()); cmd.Parameters.AddWithValue("@newPhoneNumber", this.dataGridView1[3, e.RowIndex].Value.ToString()); cmd.Parameters.AddWithValue("@id", Int32.Parse(this.dataGridView1[0, e.RowIndex].Value.ToString())); cmd.ExecuteNonQuery(); mysqlCon.Close(); } } if (buttonName == "cancel") { dataGridView1.Columns[4].HeaderCell.Value = "Edit"; dataGridView1.Columns[5].HeaderCell.Value = "Delete"; dataGridView1.Columns["name"].ReadOnly = true; dataGridView1.Columns["email"].ReadOnly = true; dataGridView1.Columns["phone_number"].ReadOnly = true; dataGridView1.Columns["edit"].Visible = true; dataGridView1.Columns["delete"].Visible = true; dataGridView1.Columns["save"].Visible = false; dataGridView1.Columns["cancel"].Visible = false; } } }
private void handleButtonClick(object sender, DataGridViewCellEventArgs e, string buttonName) { if (e.ColumnIndex == this.dataGridView1.Columns[buttonName].Index) { if (buttonName == "edit") { dataGridView1.Columns[3].HeaderCell.Value = "Save"; dataGridView1.Columns[4].HeaderCell.Value = "Cancel"; dataGridView1.Columns["start_time"].ReadOnly = false; dataGridView1.Columns["end_time"].ReadOnly = false; dataGridView1.Columns["edit"].Visible = false; dataGridView1.Columns["delete"].Visible = false; dataGridView1.Columns["save"].Visible = true; dataGridView1.Columns["cancel"].Visible = true; } if (buttonName == "delete") { DeleteModal popup = new DeleteModal(this.dataGridView1, e, "time_slots", "time_slots_id"); popup.ShowDialog(this); } if (buttonName == "save") { dataGridView1.Columns[3].HeaderCell.Value = "Edit"; dataGridView1.Columns[4].HeaderCell.Value = "Delete"; dataGridView1.Columns["start_time"].ReadOnly = true; dataGridView1.Columns["end_time"].ReadOnly = true; dataGridView1.Columns["edit"].Visible = true; dataGridView1.Columns["delete"].Visible = true; dataGridView1.Columns["save"].Visible = false; dataGridView1.Columns["cancel"].Visible = false; // Query Database using (MySqlConnection mysqlCon = new MySqlConnection(connectionString)) { mysqlCon.Open(); var stm = "update time_slots set start_time = @newStartTime, end_time = @newEndTime where time_slots_id = @id"; /// To Add paramters to query /// command.Parameters.AddWithValue("@<param-placeholder-name>", "<valuetolookfor>") var cmd = new MySqlCommand(stm, mysqlCon); cmd.Parameters.AddWithValue("@newStartTime", this.dataGridView1[1, e.RowIndex].Value.ToString()); cmd.Parameters.AddWithValue("@newEndTime", this.dataGridView1[2, e.RowIndex].Value.ToString()); cmd.Parameters.AddWithValue("@id", Int32.Parse(this.dataGridView1[0, e.RowIndex].Value.ToString())); cmd.ExecuteNonQuery(); mysqlCon.Close(); } if (buttonName == "cancel") { dataGridView1.Columns[3].HeaderCell.Value = "Edit"; dataGridView1.Columns[4].HeaderCell.Value = "Delete"; dataGridView1.Columns["start_time"].ReadOnly = true; dataGridView1.Columns["end_time"].ReadOnly = true; dataGridView1.Columns["edit"].Visible = true; dataGridView1.Columns["delete"].Visible = true; dataGridView1.Columns["save"].Visible = false; dataGridView1.Columns["cancel"].Visible = false; } } } }