public void addDataMapItem(DataMapItem item) { if(item == null) { return; } this.hubSpotDataMapItems.Add(item.HubSpotFieldName.Trim().ToUpper(), item); this.crmDataMapItems.Add(item.CRMFieldName.Trim().ToUpper(), item); }
private void buildDataMaps() { openSQLConnection(); SqlCommand cmd = new SqlCommand("select * from HubSpotFieldMap where Process = 1", sqlConnection); SqlDataReader rdr = cmd.ExecuteReader(); while(rdr.Read()) { String mapKey = rdr["CRMTableName"].ToString().Trim().ToUpper(); DataMap map = (DataMap) dataMaps[mapKey]; if(map == null) { map = new DataMap(); dataMaps.Add(mapKey, map); } DataMapItem item = new DataMapItem(); item.HubSpotFieldName = rdr["HubSpotFieldName"].ToString().Trim(); item.HubSpotDataType = DataMapItem.getHubSpotDataType(rdr["HubSpotDataType"].ToString().Trim()); if (String.IsNullOrEmpty(rdr["HubSpotDataSize"].ToString().Trim()) == false) { item.HubSpotDataSize = System.Convert.ToInt32(rdr["HubSpotDataSize"]); } item.CRMTableName = rdr["CRMTableName"].ToString().Trim(); item.CRMFieldName = rdr["CRMFieldName"].ToString().Trim(); item.CRMDataType = DataMapItem.getCRMDataType(rdr["CRMDataType"].ToString().Trim()); if (String.IsNullOrEmpty(rdr["CRMDataSize"].ToString().Trim()) == false) { item.CRMDataSize = System.Convert.ToInt32(rdr["CRMDataSize"]); } item.DefaultValue = rdr["DefaultValue"].ToString().Trim(); item.Process = System.Convert.ToInt32(rdr["process"]); map.addDataMapItem(item); } rdr.Close(); closeSQLConnection(); }