private string[] GetIDs(DBConnector connector)
{
var ids = new string[2];
var tables = new string[] { "city", "region" };
var names = new string[] { "'" + capitalTextBox.Text + "'", "'" + regionTextBox.Text + "'" };
for (var i = 0; i < 2; i++)
{
try
{
var tbName = "dbo." + tables[i];
var q = "SELECT " + tbName + ".id FROM " + tbName +
" WHERE " + tbName + ".name = " + names[i];
var ds = connector.GetDataSet(q);
if (ds.Tables[0].Rows.Count == 0)
{
connector.ExecuteQuery("INSERT " + tbName + "(name) VALUES(" + names[i] + ")");
ds = connector.GetDataSet(q);
}
ids[i] = ds.Tables[0].Rows[0].ItemArray[0].ToString();
}
catch (SqlException)
{
MessageBox.Show("Some problems with DB");
return(null);
}
}
return(ids);
}
private void ShowButtonClick(object sender, EventArgs e)
{
string script = File.ReadAllText("../../RequestAll.sql");
new DataViewForm(DBConnector.GetDataSet(script).Tables[0]).Show(this);
}
