private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
String idObj = "nepoznato";
String imeObj = "nepoznato";
String vojnaPosta = "nepoznato";
String imeGrada = "nepoznato";
String telefon = "nepoznato";
String faks = "nepoznato";
int selectedrowindex = dataGridView1.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView1.Rows[selectedrowindex];
idObj = Convert.ToString(selectedRow.Cells[0].Value);
imeObj = Convert.ToString(selectedRow.Cells[1].Value);
vojnaPosta = Convert.ToString(selectedRow.Cells[2].Value);
imeGrada = Convert.ToString(selectedRow.Cells[3].Value);
telefon = Convert.ToString(selectedRow.Cells[4].Value);
faks = Convert.ToString(selectedRow.Cells[5].Value);
EditObjekta editGrad = new EditObjekta(this, sqlite, idObj, imeObj, vojnaPosta, imeGrada, telefon, faks);
editGrad.Show();
}
private void buttonEdit_Click(object sender, EventArgs e)
{
String idObj = "nepoznato";
String imeObj = "nepoznato";
String vojnaPosta = "nepoznato";
String imeGrada = "nepoznato";
String telefon = "nepoznato";
String faks = "nepoznato";
if (comboBoxObjekti.SelectedIndex == -1)
{
if (dataGridView1.SelectedCells.Count > 0)
{
int selectedrowindex = dataGridView1.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView1.Rows[selectedrowindex];
idObj = Convert.ToString(selectedRow.Cells[0].Value);
imeObj = Convert.ToString(selectedRow.Cells[1].Value);
vojnaPosta = Convert.ToString(selectedRow.Cells[2].Value);
imeGrada = Convert.ToString(selectedRow.Cells[3].Value);
telefon = Convert.ToString(selectedRow.Cells[4].Value);
faks = Convert.ToString(selectedRow.Cells[5].Value);
EditObjekta editGrad = new EditObjekta(this, sqlite, idObj, imeObj, vojnaPosta, imeGrada, telefon, faks);
editGrad.Show();
}
}
else
{
SQLiteCommand nadjiIObj = sqlite.CreateCommand();
nadjiIObj.CommandText = "select objekatID, vojnaPosta, gradID, telefon, faks from OBJEKAT where imeObjekta ='" + comboBoxObjekti.SelectedItem.ToString() + "';";
SQLiteDataReader dr = nadjiIObj.ExecuteReader();
dr.Read();
idObj = Convert.ToString(dr.GetInt32(0));
imeObj = comboBoxObjekti.SelectedItem.ToString();
try
{
vojnaPosta = Convert.ToString(dr.GetInt32(1));
}
catch { }
int gradID = dr.GetInt32(2);
try
{
telefon = dr.GetString(3);
}
catch { }
try
{
faks = dr.GetString(3);
}
catch { }
dr.Close();
SQLiteCommand nadjiImeGrada = sqlite.CreateCommand();
nadjiImeGrada.CommandText = "select imeGrada from GRAD where gradID =" + gradID + ";";
dr = nadjiImeGrada.ExecuteReader();
dr.Read();
imeGrada = dr.GetString(0);
dr.Close();
EditObjekta editGrad = new EditObjekta(this, sqlite, idObj, imeObj, vojnaPosta, imeGrada, telefon, faks);
editGrad.Show();
}
}