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();
}
