Hello,
Question on btnSubmitAssign_Click(object sender, System.EventArgs e) ...
On the 3 drop boxes:
County:
Default Community:
Code Area:
When the page first loaded, it will automatically show up with 3 dropdown list boxes and the default fills in automatically.
County: AAY
Default Community: BENTON
Code Area: 01
These are the paired up agent_guid & agent_char_guid in the
agent_has_agent_char table..
4fe72d9f-05cd-4ea6-9f27-2c2ab14f57e2 --> AAY
600BC9EB-3675-4B61-8114-472462BB476B --> BENTON
4fe72d9f-05cd-4ea6-9f27-2c2ab14f57e2 --> AAY
760F29E9-2201-4DAF-8346-21805E4738D1 --> 01
======================================================
To test the code for debugging I switched over to
CHRISTIAN
HOPKINSVILLE
02
then changed HOPKINSVILLE to WILLIAMSTOWN
then hit submit to save.
I put on the debug to see the flow of data, to see how it is passed and see why it fails to clear old data and save the lastest data in the table.
This is the paired data in the agent_has_agent_char table...
92105FB7-7E07-4D1C-BB81-B549DEAEB540--> CHRISTIAN
23F69FAC-7D33-4CAC-B85D-35E2D404A7CA --> HOPKINSVILLE
changed HOPKINSVILLE to 5A80B74D-80C5-40A5-AC13-84C790D05047 --> WILLIAMSTOWN
92105FB7-7E07-4D1C-BB81-B549DEAEB540--> CHRISTIAN
850CA87C-996F-4604-8F2E-0274D38C8C97 --> 02
========================================================
Here is the real question...<sigh> .... I put debug along side the 3 ListItems,
agentModel.Guid, agentModel.sGUIDCommunity,agentModel.sGUIDEMArea,
locationBo.UpdateLocComRelationship(agentModel) > 0 ),
locationBo.UpdateLocEMAreaRelationship(agentModel) >0,
I noticed that ListItem itemLocation = ddlLocation.SelectedItem;
always show up with
4fe72d9f-05cd-4ea6-9f27-2c2ab14f57e2 --> AAY and not the changed one..which is
92105FB7-7E07-4D1C-BB81-B549DEAEB540--> CHRISTIAN but the the other 2
changed to 5A80B74D-80C5-40A5-AC13-84C790D05047 --> WILLIAMSTOWN
850CA87C-996F-4604-8F2E-0274D38C8C97 --> 02
showed up ok,
I tried to traced it to see why it is always
4fe72d9f-05cd-4ea6-9f27-2c2ab14f57e2 --> AAY
but nothing I can see obvious. Can you tell me why ? I
am thinking that because of that piece of data did not clear/replaced properly, that is why it keep failing
in saving into the database table.
Thank you for your help.
Ngai88
Question on btnSubmitAssign_Click(object sender, System.EventArgs e) ...
On the 3 drop boxes:
County:
Default Community:
Code Area:
When the page first loaded, it will automatically show up with 3 dropdown list boxes and the default fills in automatically.
County: AAY
Default Community: BENTON
Code Area: 01
These are the paired up agent_guid & agent_char_guid in the
agent_has_agent_char table..
4fe72d9f-05cd-4ea6-9f27-2c2ab14f57e2 --> AAY
600BC9EB-3675-4B61-8114-472462BB476B --> BENTON
4fe72d9f-05cd-4ea6-9f27-2c2ab14f57e2 --> AAY
760F29E9-2201-4DAF-8346-21805E4738D1 --> 01
======================================================
To test the code for debugging I switched over to
CHRISTIAN
HOPKINSVILLE
02
then changed HOPKINSVILLE to WILLIAMSTOWN
then hit submit to save.
I put on the debug to see the flow of data, to see how it is passed and see why it fails to clear old data and save the lastest data in the table.
This is the paired data in the agent_has_agent_char table...
92105FB7-7E07-4D1C-BB81-B549DEAEB540--> CHRISTIAN
23F69FAC-7D33-4CAC-B85D-35E2D404A7CA --> HOPKINSVILLE
changed HOPKINSVILLE to 5A80B74D-80C5-40A5-AC13-84C790D05047 --> WILLIAMSTOWN
92105FB7-7E07-4D1C-BB81-B549DEAEB540--> CHRISTIAN
850CA87C-996F-4604-8F2E-0274D38C8C97 --> 02
========================================================
Here is the real question...<sigh> .... I put debug along side the 3 ListItems,
agentModel.Guid, agentModel.sGUIDCommunity,agentModel.sGUIDEMArea,
locationBo.UpdateLocComRelationship(agentModel) > 0 ),
locationBo.UpdateLocEMAreaRelationship(agentModel) >0,
I noticed that ListItem itemLocation = ddlLocation.SelectedItem;
always show up with
4fe72d9f-05cd-4ea6-9f27-2c2ab14f57e2 --> AAY and not the changed one..which is
92105FB7-7E07-4D1C-BB81-B549DEAEB540--> CHRISTIAN but the the other 2
changed to 5A80B74D-80C5-40A5-AC13-84C790D05047 --> WILLIAMSTOWN
850CA87C-996F-4604-8F2E-0274D38C8C97 --> 02
showed up ok,
I tried to traced it to see why it is always
4fe72d9f-05cd-4ea6-9f27-2c2ab14f57e2 --> AAY
but nothing I can see obvious. Can you tell me why ? I
am thinking that because of that piece of data did not clear/replaced properly, that is why it keep failing
in saving into the database table.
Thank you for your help.
Ngai88