private void DataGridView7_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Event_Types_View event_Types_View = new Event_Types_View();
switch (e.ColumnIndex)
{
case 2:
Event_Types_View.edit = false;
event_Types_View.Show();
break;
case 3:
Event_Types_View.edit = true;
event_Types_View.Show();
break;
case 4:
DialogResult delete = MessageBox.Show("Do you really want to delete this entry?", "Delete", MessageBoxButtons.YesNo);
if (delete == DialogResult.Yes)
{
//do shit
}
else
{
//dont do shit
}
break;
default:
break;
}
}
private void DataGridView7_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string eventTypeID = "";
Event_Types_View event_Types_View = new Event_Types_View();
switch (e.ColumnIndex)
{
case 3:
Event_Types_View.edit = false;
eventTypeID = dataGridView7.Rows[e.RowIndex].Cells[0].Value.ToString();
event_Types_View.GetEventTypeViewRow = eventTypeID;
event_Types_View.ShowDialog();
break;
case 4:
Event_Types_View.edit = true;
eventTypeID = dataGridView7.Rows[e.RowIndex].Cells[0].Value.ToString();
event_Types_View.GetEventTypeViewRow = eventTypeID;
event_Types_View.ShowDialog();
break;
case 5:
eventTypeID = dataGridView7.Rows[e.RowIndex].Cells[0].Value.ToString();
event_Types_View.GetEventTypeViewRow = eventTypeID;
DialogResult delete = MessageBox.Show("Do you really want to delete this entry?", "Delete", MessageBoxButtons.YesNo);
if (delete == DialogResult.Yes)
{
try
{
DBConnection dBConnection = DBConnection.Instance();
if (dBConnection.IsConnect())
{
string query = "DELETE FROM `event_type` WHERE event_type_id = '" + eventTypeID + "'";
var command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
catch (Exception except)
{
System.Windows.Forms.MessageBox.Show("This event type is being used and can not be deleted");
}
dataGridView7.Rows.Clear();
try
{
DBConnection dBConnection = DBConnection.Instance();
if (dBConnection.IsConnect())
{
string eventTypesID = " ";
string eventTypeName1 = " ";
string eventTypeDescription = " ";
DataTable EventTypes = new DataTable();
string query = "SELECT event_type_id, event_type_name, event_type_description FROM event_type";
var command = new MySqlCommand(query, dBConnection.Connection);
var reader = command.ExecuteReader();
EventTypes.Load(reader);
for (int i = 0; i < EventTypes.Rows.Count; i++)
{
eventTypesID = EventTypes.Rows[i].ItemArray[0].ToString();
eventTypeName1 = EventTypes.Rows[i].ItemArray[1].ToString();
eventTypeDescription = EventTypes.Rows[i].ItemArray[2].ToString();
dataGridView7.Rows.Add(eventTypesID, eventTypeName1, eventTypeDescription, "View", "Edit", "Delete");
}
reader.Close();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
else
{
//dont do shit
}
break;
default:
break;
}
}
