/// <summary> /// Traverse all rows and save geo data /// </summary> private void SaveGeoData() { SqlConnection objConnection = new SqlConnection(UserSession.ProviderConnection); objConnection.Open(); m_objGridView = (DevExpress.XtraGrid.Views.Grid.GridView)gcCompany.FocusedView; for (int i = 0; i < m_objGridView.RowCount; i++) { m_objCompany = null; m_objCompany = (CTGetGeographicalDataCompany)m_objGridView.GetRow(i); if ((bool)m_objCompany.include && (m_objCompany.geo_latitude != 0 && m_objCompany.geo_longitude != 0)) { m_objGeoDataInstance = null; m_objGeoDataInstance = new ObjectGeographicalData.GeoDataInstance() { table_source = (int)ObjectGeographicalData.eTableSource.Companies, table_id = m_objCompany.id, latitude = (decimal)m_objCompany.geo_latitude, longitude = (decimal)m_objCompany.geo_longitude }; ObjectGeographicalData.SaveGeoData(m_objGeoDataInstance, objConnection); } } objConnection.Close(); objConnection = null; //this.PopulateCompanyView(null, 1); MessageBox.Show("Successfully updated!", m_MessageBoxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); }
/// <summary> /// Traverse all rows and save geo data /// </summary> private void SaveGeoData() { //SqlConnection objConnection = new SqlConnection(ConfigurationManager.AppSettings["DatabaseConnectionString"].ToString()); SqlConnection objConnection = new SqlConnection(UserSession.ProviderConnection); objConnection.Open(); m_objGridView = (DevExpress.XtraGrid.Views.Grid.GridView)gcContact.FocusedView; for (int i = 0; i < m_objGridView.RowCount; i++) { m_objContact = null; m_objContact = (CTGeographicalDataContact)m_objGridView.GetRow(i); if ((bool)m_objContact.include && (m_objContact.geo_latitude != 0 && m_objContact.geo_longitude != 0)) { m_objGeoDataInstance = null; m_objGeoDataInstance = new ObjectGeographicalData.GeoDataInstance(); m_objGeoDataInstance.table_source = (int)ObjectGeographicalData.eTableSource.Contacts; m_objGeoDataInstance.table_id = m_objContact.id; m_objGeoDataInstance.latitude = (decimal)m_objContact.geo_latitude; m_objGeoDataInstance.longitude = (decimal)m_objContact.geo_longitude; ObjectGeographicalData.SaveGeoData(m_objGeoDataInstance, objConnection); } } objConnection.Close(); objConnection = null; //this.PopulateContactView(null, 1); MessageBox.Show("Successfully updated!", m_MessageBoxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); }