private void DataGridView7_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Service_Types_View service_Types_View = new Service_Types_View();
switch (e.ColumnIndex)
{
case 2:
Service_Types_View.edit = false;
service_Types_View.Show();
break;
case 3:
Service_Types_View.edit = true;
service_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)
{
Service_Types_View service_Types_View = new Service_Types_View();
string serviceTypeID = "";
switch (e.ColumnIndex)
{
case 3:
Service_Types_View.edit = false;
serviceTypeID = dataGridView7.Rows[e.RowIndex].Cells[0].Value.ToString();
service_Types_View.GetServiceTypeRow = serviceTypeID;
service_Types_View.ShowDialog();
break;
case 4:
Service_Types_View.edit = true;
serviceTypeID = dataGridView7.Rows[e.RowIndex].Cells[0].Value.ToString();
service_Types_View.GetServiceTypeRow = serviceTypeID;
service_Types_View.ShowDialog();
break;
case 5:
serviceTypeID = dataGridView7.Rows[e.RowIndex].Cells[0].Value.ToString();
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 `service_type` WHERE service_type_id = '" + serviceTypeID + "'";
var command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
catch (Exception)
{
System.Windows.Forms.MessageBox.Show("This service type contains services. It can not be deleted.");
}
dataGridView7.Rows.Clear();
try
{
DBConnection dBConnection = DBConnection.Instance();
if (dBConnection.IsConnect())
{
string serviceTypesID = " ";
string serviceTypeName = " ";
string serviceTypeDescription = " ";
DataTable ServiceTypes = new DataTable();
string query = "SELECT service_type_id, service_type_name, service_type_description FROM service_type";
var command = new MySqlCommand(query, dBConnection.Connection);
var reader = command.ExecuteReader();
ServiceTypes.Load(reader);
for (int i = 0; i < ServiceTypes.Rows.Count; i++)
{
serviceTypesID = ServiceTypes.Rows[i].ItemArray[0].ToString();
serviceTypeName = ServiceTypes.Rows[i].ItemArray[1].ToString();
serviceTypeDescription = ServiceTypes.Rows[i].ItemArray[2].ToString();
dataGridView7.Rows.Add(serviceTypesID, serviceTypeName, serviceTypeDescription, "View", "Edit", "Delete");
}
reader.Close();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
else
{
//dont do shit
}
break;
default:
break;
}
}
