private void cmbUF_SelectedIndexChanged(object sender, EventArgs e)
{
cmbIdMunicipioGeosWeb.Items.Clear();
DataTable dtMunicipios = (DataTable)DBAccessGeos.ExecutarComando("select Id,Name from Municipalities where stateid =" + cmbUF.SelectedItem.ToString().Split('-')[0] + " order by name ", CommandType.Text, null, DBAccessGeos.TypeCommand.ExecuteDataTable);
for (int x = 0; x <= dtMunicipios.Rows.Count - 1; x++)
{
cmbIdMunicipioGeosWeb.Items.Add(dtMunicipios.Rows[x]["Id"].ToString() + " - " + dtMunicipios.Rows[x]["Name"].ToString());
}
}
public frmGerarSQLite()
{
InitializeComponent();
DBSettingMobile.ConnectionString = txtCaminhoBancoSQLite.Text + ";Version=3;";
DataTable dtProjetos = (DataTable)DBAccessGeos.ExecutarComando("select id,name,case when special = 1 then 'Sim' else 'Não' end special from DispatchCenters where status =1 order by id", CommandType.Text, null, DBAccessGeos.TypeCommand.ExecuteDataTable);
for (int x = 0; x <= dtProjetos.Rows.Count - 1; x++)
{
cmbProjetos.Items.Add(dtProjetos.Rows[x]["Id"].ToString() + " - " + dtProjetos.Rows[x]["Name"].ToString() + " - SPecial:" + dtProjetos.Rows[x]["special"].ToString());
}
DataTable dtUF = (DataTable)DBAccessGeos.ExecutarComando("select id, name,cod from States order by name", CommandType.Text, null, DBAccessGeos.TypeCommand.ExecuteDataTable);
for (int x = 0; x <= dtUF.Rows.Count - 1; x++)
{
cmbUF.Items.Add(dtUF.Rows[x]["Id"].ToString() + " - " + dtUF.Rows[x]["Name"].ToString() + " - " + dtUF.Rows[x]["cod"].ToString());
}
}
private void btnImportCentroDespacho_Click(object sender, EventArgs e)
{
DataTable dtCentroDispacho = (DataTable)DBAccessGeos.ExecutarComando("select id,name from DispatchCenters where id =" + cmbProjetos.SelectedItem.ToString().Split('-')[0], CommandType.Text, null, DBAccessGeos.TypeCommand.ExecuteDataTable);
if (dtCentroDispacho.Rows.Count > 0)
{
query = "insert into DispatchCenters (id,Name,CentreId) values (@id,@Name,@CentreId)";
SQLiteConnection connection = new SQLiteConnection(DBSettingMobile.ConnectionString);
connection.Open();
SQLiteCommand comando = new SQLiteCommand(query, connection);
comando.Parameters.AddWithValue("@id", dtCentroDispacho.Rows[0]["id"]);
comando.Parameters.AddWithValue("@Name", dtCentroDispacho.Rows[0]["name"]);
comando.Parameters.AddWithValue("@CentreId", 1);
comando.CommandType = CommandType.Text;
comando.ExecuteNonQuery();
}
else
{
MessageBox.Show("Centro de despacho não encontrado");
}
}