private void StatusTest()
{
/*
* Status field
* */
//Valid values
Assert.IsTrue(
XrmEntity.GetOptionSetValue(XrmService.ParseField(Fields.jmcg_testentity_.statuscode, Entities.jmcg_testentity, "Active")) ==
OptionSets.TestEntity.StatusReason.Active);
Assert.IsTrue(
XrmEntity.GetOptionSetValue(XrmService.ParseField(Fields.jmcg_testentity_.statuscode, Entities.jmcg_testentity,
OptionSets.TestEntity.StatusReason.Active)) ==
OptionSets.TestEntity.StatusReason.Active);
Assert.IsTrue(
XrmEntity.GetOptionSetValue(XrmService.ParseField(Fields.jmcg_testentity_.statuscode, Entities.jmcg_testentity,
XrmEntity.CreateOptionSet(OptionSets.TestEntity.StatusReason.Active))) ==
OptionSets.TestEntity.StatusReason.Active);
try
{
var blah = XrmService.ParseField(Fields.jmcg_testentity_.statuscode, Entities.jmcg_testentity, "NOTASTATUS");
Assert.Fail();
}
catch (Exception ex)
{
CheckException(ex);
}
}
private void StatusTest()
{
/*
* Status field
* */
//Valid values
Assert.IsTrue(
XrmEntity.GetOptionSetValue(XrmService.ParseField("statuscode", Entities.jmcg_testentity, "Active")) ==
TestEntityConstants.Statusses.TestStatus);
Assert.IsTrue(
XrmEntity.GetOptionSetValue(XrmService.ParseField("statuscode", Entities.jmcg_testentity,
TestEntityConstants.Statusses.TestStatus)) ==
TestEntityConstants.Statusses.TestStatus);
Assert.IsTrue(
XrmEntity.GetOptionSetValue(XrmService.ParseField("statuscode", Entities.jmcg_testentity,
XrmEntity.CreateOptionSet(
TestEntityConstants.Statusses.TestStatus))) ==
TestEntityConstants.Statusses.TestStatus);
try
{
var blah = XrmService.ParseField("statuscode", Entities.jmcg_testentity, "NOTASTATUS");
Assert.Fail();
}
catch (Exception ex)
{
CheckException(ex);
}
}
private void PicklistTest()
{
/*
* Picklist field
* */
//Valid values
Assert.IsTrue(
XrmEntity.GetOptionSetValue(XrmService.ParseField(Fields.jmcg_testentity_.jmcg_picklist, Entities.jmcg_testentity, "Option 1")) ==
OptionSets.TestEntity.Picklist.Option1);
Assert.IsTrue(
XrmEntity.GetOptionSetValue(XrmService.ParseField(Fields.jmcg_testentity_.jmcg_picklist, Entities.jmcg_testentity,
OptionSets.TestEntity.Picklist.Option1)) ==
OptionSets.TestEntity.Picklist.Option1);
try
{
var blah = XrmService.ParseField(Fields.jmcg_testentity_.jmcg_picklist, Entities.jmcg_testentity, "NOTANOPTION");
Assert.Fail();
}
catch (Exception ex)
{
CheckException(ex);
}
}
public void UpdateSql(Entity target)
{
var type = target.LogicalName;
var table = type; // + "ExtensionBase";
var fieldsToUpdate = new List <KeyValuePair <string, string> >();
foreach (var field in target.GetFieldsInEntity())
{
var fieldType = XrmService.GetFieldType(field, type);
var value = target.GetField(field);
if (value == null)
{
if (fieldType == AttributeTypeCode.Money)
{
fieldsToUpdate.Add(new KeyValuePair <string, string>(field + "_base", "null"));
}
fieldsToUpdate.Add(new KeyValuePair <string, string>(field, "null"));
}
else
{
switch (fieldType)
{
case AttributeTypeCode.DateTime:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field,
SqlProvider.ToSqlDateString((DateTime)value)));
break;
case AttributeTypeCode.Money:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field,
XrmEntity.GetMoneyValue(value).ToString(CultureInfo.InvariantCulture)));
fieldsToUpdate.Add(new KeyValuePair <string, string>(field + "_base",
XrmEntity.GetMoneyValue(value).ToString(CultureInfo.InvariantCulture)));
break;
case AttributeTypeCode.Lookup:
var id = XrmEntity.GetLookupGuid(value);
if (!id.HasValue)
{
throw new NullReferenceException("error no id in " + field);
}
fieldsToUpdate.Add(new KeyValuePair <string, string>(field,
WrapSqlString(id.Value.ToString())));
break;
case AttributeTypeCode.Picklist:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field,
XrmEntity.GetOptionSetValue(value).ToString(CultureInfo.InvariantCulture)));
break;
case AttributeTypeCode.Status:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field,
XrmEntity.GetOptionSetValue(value).ToString(CultureInfo.InvariantCulture)));
break;
case AttributeTypeCode.Integer:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field, value.ToString()));
break;
case AttributeTypeCode.Decimal:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field, value.ToString()));
break;
case AttributeTypeCode.Boolean:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field,
XrmEntity.GetBoolean(value) ? "1" : "0"));
break;
case AttributeTypeCode.String:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field,
SqlProvider.ToSqlString((string)value)));
break;
case AttributeTypeCode.Memo:
fieldsToUpdate.Add(new KeyValuePair <string, string>(field,
SqlProvider.ToSqlString((string)value)));
break;
case AttributeTypeCode.Uniqueidentifier:
break;
default:
throw new NotImplementedException("No update logic implemented for field type " + fieldType);
}
}
}
var setStrings = string.Join(",",
fieldsToUpdate.Select(kv => string.Format("{0} = {1}", kv.Key, kv.Value)));
var primaryKey = XrmService.GetPrimaryKeyField(target.LogicalName);
var primaryKeySql = SqlProvider.ToSqlString(target.Id);
var sql = string.Format("update {0} set {1} where {2} = {3}", table, setStrings, primaryKey, primaryKeySql);
SqlProvider.ExecuteNonQuery(sql);
}
