/// <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;
}
}
}
}
