Hi Makeer,
How you have constructed your class ? because datagrid doesn't accept CRM complex datatypes like Lookups(entityrefernece) and Optionsets(Optionsetvalues).
I am using same grid to show records and to Create records. To explain in detail, follwing is the flow of my logic.
1. user presented with Silverlight Page.
2. This page has one text box ( to enter search text) and one button to with name "Search" to perfrom query.
3. Page also has "New" button when user click will show empty grid to enter 10 records.
4. One datagrid for above 2 purpose.
4. 'save; button to save 10 records at a time to CRM entered into the grid.
Now, while showing search result I am holding the query result into custom class which has same attributes as actual entity but datatype is all "string" in custom class.
and doing follwoing
OrganizationResponse
response = ((IOrganizationService
)result.AsyncState).EndExecute(result);
EntityCollection
results = (EntityCollection)response["EntityCollection"
];
if
(results.Entities.Count != 0)
{
foreach
(Entity
ct in
results.Entities)
{
ContactPoint
ItemCP = new
ContactPoint
();
if
(ct .GetAttributeValue<Test.CrmSdk.EntityReference>("new_salespersonid")
!= null
) // Test = Namespace, CrmSdk = SOAP service reference
{
ItemCP.Customer = ct .GetAttributeValue<Test.CrmSdk.
EntityReference>("new_salespersonid").Name;
// this is look up value in CRM
//
Rest of the values goes here....
}
}
ctList.Add(ItemCP); // ctlist is getting all the records
Dispatcher.BeginInvoke(() =>
{
this
.CTGrid.ItemsSource = ctList;
});
=========================================
// My custome class to hold records from query and to show it on form
public
class
ContactPoint
{
public
string
ContactPointName { get;
set
; }
public
string
FirstName{ get;
set
; }
public
string
LastName{ get;
set
; }
public
string
Resident{ get;
set
; } // this is optionset in CRM record
public
string
Customer { get;
set
; } // this is Lookup in CRM record
public
string
Primary Contact{ get;
set
; } // this is look up in CRM record
}
======================end class===============================
This
works fine and records are showing perfectly OK as per the value entered into the search box.
Problem
starts,when user click on "New" button and same grid appears to enter 10 records. After entering the record when use Click 'Save' button
Follwoing
your approach I have created another class but this time with CRM Datatypes and not string.
=====================================================
//
Holding classto create records in CRM
public
class
CT
{
public
CrmSdk.OptionSetValue
Resident{ get;
set
; }
public
CrmSdk.EntityReference
Customer { get;
set;
}
..rest
of the values
}
========================
end class ===========
Following
is a save method to create recrods
private
void
SaveButton_Click(object
sender, RoutedEventArgs e)
{
foreach(CT
ctRow in
CPGrid.ItemsSource) // Exception is thorwn here saying can't convert from type 'ContactPoint' to 'CP' which makes sense as CPGrid.Itemsource is of type 'ContactPoint' while 'ctRow' is of type 'CT'
{
Entity cp =
new
Entity();
sp.LogicalName =
"new_contactpoint"
;
sp[
"new_customerid"]
= new
EntityReference() { Id = new
Guid("{7D1C2E6D-C5F2-DF11-BC1B-000C29B3EC9A}"),
LogicalName = "account"
, Name = ctRow.Customer.Name };
sp[
"new_resident"]
= new
OptionSetValue() { Value = ctRow.Resident.Value };
rest of the values.....
service.BeginCreate(cp,
new
AsyncCallback(SaveButton_ClickCallBack),
service);
}
}
================
End method ============
Following
is my call back method
private
void
SaveButton_ClickCallBack(IAsyncResult
results)
{
((
IOrganizationService
)results.AsyncState).EndCreate(results);
}
====================================================
When
debugging, exception is thrown on foreach loop which I have explained in above code line.
So
Issue is while pouplating grid, datagrid can not take CRM specific datatype and while creating record Casting is failed to convert into CRM DataType.
any
idea? ( Alternatively, I can create another grid and toggle it based on the user selection but that's the last resource.)
Hope
I explained it properly.
Thanks
to you and Sam for your time.
