public string AddCollection(EntityPropertyCollection col)
{
Debug.WriteLine(col.TableName);
return(col.TableName);
return(col.Properties.First().GetType().Name);
}
private static string GenerateInsertStatement(EntityPropertyCollection propertyCollection)
{
StringBuilder insertSql = new StringBuilder();
StringBuilder entitySql = new StringBuilder();
StringBuilder selectSql = new StringBuilder("SELECT ");
insertSql.Append(GenerateCreateEntityTables(propertyCollection));
insertSql.AppendFormat("INSERT INTO {0}\r\n", GetPriceNetTableName(propertyCollection.TableName));
insertSql.Append("(");
if (PrimaryEntityIdsSupplied(propertyCollection))
{
insertSql.AppendFormat("[{0}], ", GetUidColumn(propertyCollection.PrimaryEntityTableName));
selectSql.Append("pe.[EntityUID], ");
entitySql.AppendLine("FROM #PrimaryEntity pe");
if (SecondaryEntityIdsSupplied(propertyCollection))
{
insertSql.AppendFormat("[{0}], ", GetUidColumn(propertyCollection.SecondaryEntityTableName));
selectSql.Append("se.[EntityUID], ");
entitySql.AppendLine("CROSS JOIN #SecondaryEntity se");
}
}
selectSql.AppendLine(GetParameterList(propertyCollection));
insertSql.AppendFormat("{0})\r\n", GetColumnList(propertyCollection));
insertSql.Append(selectSql);
insertSql.Append(entitySql);
insertSql.Append(GenerateDropEntityTables(propertyCollection));
return(insertSql.ToString());
}
protected static string GetColumnList(EntityPropertyCollection entityPropertyCollection)
{
var properties = GetNonNullProperties(entityPropertyCollection);
var columnNames = properties.Select(e => e.Name);
return("[" + string.Join("], [", columnNames) + "]");
}
protected static string GetParameterList(EntityPropertyCollection entityPropertyCollection)
{
var properties = GetNonNullProperties(entityPropertyCollection);
var count = 1;
return(string.Join(", ", properties.Select(p => string.Format("@P{0}", count++))));
}
protected EntityPropertyCollection CreateEntityPropertyCollection()
{
var entityPropertyCollection = new EntityPropertyCollection()
{
TableName = "Area",
Properties = new[] { CreateNameProperty() }
};
return(entityPropertyCollection);
}
public static IDbCommand GenerateInsertCommand(EntityPropertyCollection entityPropertyCollection)
{
var properties = GetNonNullProperties(entityPropertyCollection);
ValidateInsertProperties(entityPropertyCollection);
//SqlCommand cmd = new SqlCommand(GenerateInsertStatement(entityPropertyCollection));
//cmd.Parameters.AddRange(GetCommandParameters(properties).ToArray());
return(null);
}
private void Test2(EntityPropertyCollection propertyCollection)
{
//Moq
//var controller = new EntityPropertiesController();
//controller.Insert(propertyCollection);
//controller.Request = new HttpRequestMessage();
//controller.Configuration = new HttpConfiguration();
//var response = controller.Insert(propertyCollection);
}
public static IDbCommand GenerateUpdateCommand(EntityPropertyCollection entityPropertyCollection)
{
var properties = GetAmendedProperties(entityPropertyCollection);
ValidateUpdateProperties(entityPropertyCollection);
SqlCommand cmd = new SqlCommand(GenerateUpdateStatement(entityPropertyCollection));
cmd.Parameters.AddRange(GetCommandParameters(properties).ToArray());
return(cmd);
}
private IEntityPropertyCollection GetEntityProperties(string[] fieldValues)
{
IEntityPropertyCollection properties = new EntityPropertyCollection();
for (int i = 0; i < fieldValues.Length; i++)
{
properties.Add(new EntityProperty {
PropertyName = this._normalizedColumns[i], PropertyHeader = this._csvColumns[i], PropertyValue = fieldValues[i]
});
}
return(properties);
}
private static string GetSetClause(EntityPropertyCollection entityPropertyCollection)
{
var setClause = new StringBuilder();
var properties = GetAmendedProperties(entityPropertyCollection);
int count = 1;
foreach (var property in properties)
{
setClause.AppendFormat("[{0}] = @P{1},\r\n", property.Name, count++);
}
setClause.Length -= 3;
return(setClause.ToString());
}
protected static string GenerateDropEntityTables(EntityPropertyCollection entityPropertyCollection)
{
var dropTableSql = new StringBuilder();
if (PrimaryEntityIdsSupplied(entityPropertyCollection))
{
dropTableSql.AppendLine();
dropTableSql.AppendLine("DROP TABLE #PrimaryEntity");
}
if (SecondaryEntityIdsSupplied(entityPropertyCollection))
{
dropTableSql.AppendLine("DROP TABLE #SecondaryEntity");
}
return(dropTableSql.ToString());
}
protected static void ValidateUpdateProperties(EntityPropertyCollection entityPropertyCollection)
{
if (string.IsNullOrWhiteSpace(entityPropertyCollection.TableName))
{
throw new ArgumentNullException(nameof(entityPropertyCollection.TableName), "A table name must be supplied.");
}
if (entityPropertyCollection.PrimaryEntityIds == null || !entityPropertyCollection.PrimaryEntityIds.Any())
{
throw new ArgumentNullException(nameof(entityPropertyCollection.PrimaryEntityIds), "A set of one or more entity ids must be supplied.");
}
var properties = GetAmendedProperties(entityPropertyCollection);
if (!properties.Any())
{
throw new ArgumentOutOfRangeException(nameof(entityPropertyCollection.Properties), "At least one amended property must be supplied.");
}
}
protected static string GenerateCreateEntityTables(EntityPropertyCollection propertyCollection)
{
StringBuilder entityTableSql = new StringBuilder();
if (PrimaryEntityIdsSupplied(propertyCollection))
{
entityTableSql.AppendLine(GenerateEntityTempTable("PrimaryEntity", propertyCollection.PrimaryEntityTableName,
propertyCollection.PrimaryEntityIds));
if (SecondaryEntityIdsSupplied(propertyCollection))
{
entityTableSql.AppendLine(GenerateEntityTempTable("SecondaryEntity", propertyCollection.SecondaryEntityTableName,
propertyCollection.SecondaryEntityIds));
}
}
return(entityTableSql.ToString());
}
private static string GenerateUpdateStatement(EntityPropertyCollection propertyCollection)
{
StringBuilder updateSql = new StringBuilder();
updateSql.Append(GenerateCreateEntityTables(propertyCollection));
updateSql.AppendLine("UPDATE t");
updateSql.AppendLine("SET");
updateSql.AppendLine(GetSetClause(propertyCollection));
updateSql.AppendFormat("FROM {0} t\r\n", GetPriceNetTableName(propertyCollection.TableName));
updateSql.AppendFormat("JOIN #PrimaryEntity pe ON pe.[EntityUID] = t.[{0}]", GetUidColumn(propertyCollection.PrimaryEntityTableName));
if (SecondaryEntityIdsSupplied(propertyCollection))
{
updateSql.AppendFormat("JOIN #SecondaryEntity se ON se.[EntityUID] = t.[{0}]", GetUidColumn(propertyCollection.SecondaryEntityTableName));
}
return(updateSql.ToString());
}
private void SendToApi(EntityPropertyCollection propertyCollection)
{
var json = JsonConvert.SerializeObject(propertyCollection);
var apiUrl = "";
var content = new StringContent(json, Encoding.UTF8, "application/json");
if (string.IsNullOrWhiteSpace(apiUrl))
{
throw new ArgumentNullException("The URL of the connect API was blank or null.");
}
using (var client = new HttpClient())
{
var response = client.PostAsync(apiUrl, content).GetAwaiter().GetResult();
if (!response.IsSuccessStatusCode)
{
throw new System.Web.HttpException((int)response.StatusCode, response.ReasonPhrase + " Uri: " + apiUrl);
}
}
}
protected static void ValidateInsertProperties(EntityPropertyCollection entityPropertyCollection)
{
var nullrequiredProperties = entityPropertyCollection.Properties.Where(p => p.Required && p.Value == null);
var nonNullProperties = GetNonNullProperties(entityPropertyCollection);
if (entityPropertyCollection == null)
{
throw new ArgumentNullException(nameof(entityPropertyCollection), "An.entity property collection must be supplied.");
}
if (string.IsNullOrWhiteSpace(entityPropertyCollection.TableName))
{
throw new ArgumentNullException(nameof(entityPropertyCollection.TableName), "A table name must be supplied.");
}
if (!nonNullProperties.Any())
{
throw new ArgumentOutOfRangeException(nameof(entityPropertyCollection.Properties), "A number of non-null properties must be supplied.");
}
if (nullrequiredProperties.Any())
{
throw new ArgumentNullException("A value must be supplied for all required properties.");
}
if (PrimaryEntityIdsSupplied(entityPropertyCollection))
{
if (string.IsNullOrWhiteSpace(entityPropertyCollection.PrimaryEntityTableName))
{
throw new ArgumentNullException(nameof(entityPropertyCollection.PrimaryEntityTableName),
"If a set of entities has been supplied then an entity table name must also be supplied.");
}
}
if (SecondaryEntityIdsSupplied(entityPropertyCollection))
{
if (string.IsNullOrWhiteSpace(entityPropertyCollection.SecondaryEntityTableName))
{
throw new ArgumentNullException(nameof(entityPropertyCollection.SecondaryEntityTableName),
"If a set of secondary entities has been supplied then a secondary entity table name must also be supplied.");
}
}
}
private void Test(EntityPropertyCollection propertyCollection)
{
foreach (var property in propertyCollection.Properties)
{
property.InitialValue = property.Value;
//if (property is EntityProperty<bool?> p1)
//{
// p1.InitialValue = p1.Value;
//}
//else
//if (property is EntityProperty<DateTime?> p2)
//{
// p2.InitialValue = p2.Value;
//}
//else
//if (property is EntityProperty<decimal?> p3)
//{
// p3.InitialValue = p3.Value;
//}
//else
//if (property is EntityProperty<Guid?> p4)
//{
// p4.InitialValue = p4.Value;
//}
//else
//if (property is EntityProperty<int?> p5)
//{
// p5.InitialValue = p5.Value;
//}
//else
//if (property is EntityProperty<string> p6)
//{
// p6.InitialValue = p6.Value;
//}
}
}
public static EntityPropertyCollection Get()
{
var propertyCollection = new EntityPropertyCollection
{
TableName = "Area",
};
propertyCollection.Properties = new EntityProperty[]
{
new EntityProperty
{
Id = 29,
Name = "Name",
DataType = typeof(string),
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = "Manchester"
},
new EntityProperty
{
Id = 22,
Name = "ImportCode",
DataType = typeof(string),
DisplayOrder = 11,
Required = true,
TxId = 11,
Value = "A5"
},
new EntityProperty
{
Id = 25,
Name = "ManagerName",
DataType = typeof(string),
DisplayOrder = 62,
Required = false,
TxId = 62,
Value = "Joe Bloggs"
},
new EntityProperty
{
Id = 26,
Name = "ManagerPhone",
DataType = typeof(string),
DisplayOrder = 63,
Required = false,
TxId = 63
},
new EntityProperty
{
Id = 23,
Name = "ManagerEmail",
DataType = typeof(string),
DisplayOrder = 64,
Required = false,
TxId = 64,
Value = "*****@*****.**"
},
new EntityProperty
{
Id = 24,
Name = "ManagerFax",
DataType = typeof(string),
DisplayOrder = 65,
Required = false,
TxId = 65,
Value = "0123456789"
},
new EntityProperty
{
Id = 27,
Name = "ManagerSMS",
DataType = typeof(string),
DisplayOrder = 66,
Required = false,
TxId = 66
},
new EntityProperty
{
Id = 28,
Name = "ManagerUserUID",
DataType = typeof(Guid),
DisplayOrder = 67,
Required = false,
TxId = 67,
RelationTypeId = "USER",
Value = new Guid("A45083AC-9D5E-46CC-BD3A-53A2F25553F4")
},
new EntityProperty
{
Id = 17,
Name = "ExportSubject",
DataType = typeof(string),
DisplayOrder = 10,
Required = false,
TxId = 10
},
new EntityProperty
{
Id = 30,
Name = "UseEmail",
DataType = typeof(bool),
DisplayOrder = 20,
Required = false,
TxId = 20,
Value = true
},
new EntityProperty
{
Id = 18,
Name = "FormatTemplateEmailUID",
DataType = typeof(Guid),
DisplayOrder = 30,
Required = false,
TxId = 30,
Value = "71E2C96D-D865-44BE-80B0-91F5118B76A5"
},
new EntityProperty
{
Id = 31,
Name = "UseFax",
DataType = typeof(bool),
DisplayOrder = 40,
Required = false,
TxId = 40,
Value = false
},
new EntityProperty
{
Id = 19,
Name = "FormatTemplateFaxUID",
DataType = typeof(Guid),
DisplayOrder = 50,
Required = false,
TxId = 50,
Value = new Guid("5659ACC1-324E-4356-BA43-DD58CF8C052C")
}
};
return(propertyCollection);
}
protected static IEnumerable <EntityProperty> GetAmendedProperties(EntityPropertyCollection entityPropertyCollection)
{
return(entityPropertyCollection.Properties.Where(p => p.IsModified));
}
public static EntityPropertyCollection Get()
{
var propertyCollection = new EntityPropertyCollection
{
TableName = "CompetitorProduct",
};
propertyCollection.Properties = new EntityProperty[]
{
new EntityProperty
{
Id = 84,
Name = "Active",
DisplayOrder = 2,
Required = true,
TxId = 2,
Value = true
},
new EntityProperty
{
Id = 85,
Name = "CardPriceDiscount",
DisplayOrder = 11,
Required = true,
TxId = 11,
Value = 0.00m
},
new EntityProperty
{
Id = 86,
Name = "CompetitorSiteUID",
DisplayOrder = 1,
Required = true,
TxId = 1,
Value = new Guid("A7932646-918F-40DC-AE87-072A4EF994E3")
},
new EntityProperty
{
Id = 89,
Name = "GlobalProductUID",
DisplayOrder = 1,
Required = true,
TxId = 1,
Value = new Guid("26B4AF2D-AC09-48D2-AB77-4A44350104C2")
},
new EntityProperty
{
Id = 91,
Name = "InStock",
DisplayOrder = 3,
Required = true,
TxId = 3,
Value = false
},
new EntityProperty
{
Id = 92,
Name = "MaxListPricePercentage",
DisplayOrder = 2,
Required = true,
TxId = 2,
Value = 0.00m
},
new EntityProperty
{
Id = 93,
Name = "MaxPrice",
DisplayOrder = 5,
Required = true,
TxId = 5,
Value = 3.40m
},
new EntityProperty
{
Id = 94,
Name = "MaxPriceDecrement",
DisplayOrder = 6,
Required = true,
TxId = 6,
Value = 0.00m
},
new EntityProperty
{
Id = 95,
Name = "MaxPriceIncrement",
DisplayOrder = 7,
Required = true,
TxId = 7,
Value = 0.00m
},
new EntityProperty
{
Id = 96,
Name = "MinListPricePercentage",
DisplayOrder = 1,
Required = true,
TxId = 1,
Value = 0.00m
},
new EntityProperty
{
Id = 97,
Name = "MinPrice",
DisplayOrder = 4,
Required = true,
TxId = 4,
Value = 1.00m
},
new EntityProperty
{
Id = 98,
Name = "NearestOwnSiteUID",
DisplayOrder = 20,
Required = false,
TxId = 20,
},
new EntityProperty
{
Id = 102,
Name = "SurveyPossible",
DisplayOrder = 12,
Required = true,
TxId = 12,
Value = false
}
};
return(propertyCollection);
}
public static EntityPropertyCollection Get()
{
var propertyCollection = new EntityPropertyCollection
{
TableName = "OwnSite",
};
propertyCollection.Properties = new EntityProperty[]
{
new EntityProperty
{
Id = 531,
Name = "AreaUID",
DisplayOrder = 40,
Required = true,
TxId = 40,
Value = new Guid("38173EF8-8359-434E-A096-4C937C4F9CEA")
},
new EntityProperty
{
Id = 568,
Name = "NetworkUID",
DisplayOrder = 50,
Required = true,
TxId = 50,
Value = new Guid("6A5FE10C-B433-4724-8524-E6994ADDFF18")
},
new EntityProperty
{
Id = 554,
Name = "ImportCode",
DisplayOrder = 20,
Required = true,
TxId = 20,
Value = "K999"
},
new EntityProperty
{
Id = 567,
Name = "Name",
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = "NewOwnSite"
},
new EntityProperty
{
Id = 525,
Name = "Address",
DisplayOrder = 55,
Required = false,
TxId = 55,
Value = "1191 S BUCKLEY RD / E ARIZONA DR"
},
new EntityProperty
{
Id = 526,
Name = "Address2",
DisplayOrder = 56,
Required = false,
TxId = 56,
},
new EntityProperty
{
Id = 527,
Name = "Address3",
DisplayOrder = 57,
Required = false,
TxId = 57,
},
new EntityProperty
{
Id = 528,
Name = "Address4",
DisplayOrder = 58,
Required = false,
TxId = 58,
},
new EntityProperty
{
Id = 529,
Name = "Address5",
DisplayOrder = 59,
Required = false,
TxId = 59,
},
new EntityProperty
{
Id = 573,
Name = "PostCode",
DisplayOrder = 60,
Required = false,
TxId = 60,
},
new EntityProperty
{
Id = 537,
Name = "Country",
DisplayOrder = 61,
Required = false,
TxId = 61,
},
new EntityProperty
{
Id = 591,
Name = "TimeZoneID",
DisplayOrder = 62,
Required = true,
TxId = 62,
Value = 36
},
new EntityProperty
{
Id = 561,
Name = "ManagerName",
DisplayOrder = 63,
Required = false,
TxId = 63,
Value = "Anthony Thompson"
},
new EntityProperty
{
Id = 562,
Name = "ManagerPhone",
DisplayOrder = 64,
Required = false,
TxId = 64,
},
new EntityProperty
{
Id = 559,
Name = "ManagerEmail",
DisplayOrder = 65,
Required = false,
TxId = 65,
Value = ""
},
new EntityProperty
{
Id = 560,
Name = "ManagerFax",
DisplayOrder = 66,
Required = false,
TxId = 66,
},
new EntityProperty
{
Id = 563,
Name = "ManagerSMS",
DisplayOrder = 67,
Required = false,
TxId = 67,
},
new EntityProperty
{
Id = 564,
Name = "ManagerUserUID",
DisplayOrder = 68,
Required = false,
TxId = 68,
},
new EntityProperty
{
Id = 577,
Name = "PriorityUID",
DisplayOrder = 54,
Required = true,
TxId = 54,
Value = new Guid("0FDAE974-229F-4F21-A607-EB2E633D1522")
},
new EntityProperty
{
Id = 594,
Name = "UserUID",
DisplayOrder = 80,
Required = false,
TxId = 80,
},
new EntityProperty
{
Id = 534,
Name = "BrandUID",
DisplayOrder = 51,
Required = true,
TxId = 51,
Value = new Guid("EF19D207-B3C6-43E7-AD4C-72686AAFD16B")
},
new EntityProperty
{
Id = 589,
Name = "TerminalUID",
DisplayOrder = 53,
Required = true,
TxId = 53,
Value = new Guid("4C9DE53D-C594-4E70-8C92-2BDD2638563B")
},
new EntityProperty
{
Id = 535,
Name = "ChannelOfTradeUID",
DisplayOrder = 52,
Required = true,
TxId = 52,
Value = new Guid("15541EF2-63EF-4954-9F1A-13554ED486E6")
},
new EntityProperty
{
Id = 582,
Name = "SFROnPGFail",
DisplayOrder = 0,
Required = false,
TxId = 0,
Value = false
},
new EntityProperty
{
Id = 592,
Name = "UseEmail",
DisplayOrder = 20,
Required = false,
TxId = 20,
Value = false
},
new EntityProperty
{
Id = 593,
Name = "UseFax",
DisplayOrder = 40,
Required = false,
TxId = 40,
Value = false
},
new EntityProperty
{
Id = 595,
Name = "UseSMS",
DisplayOrder = 60,
Required = false,
TxId = 60,
Value = false
},
new EntityProperty
{
Id = 578,
Name = "ProposedIsImplemented",
DisplayOrder = 200,
Required = true,
TxId = 200,
Value = false
},
new EntityProperty
{
Id = 545,
Name = "ExportSubject",
DisplayOrder = 10,
Required = false,
TxId = 10,
},
new EntityProperty
{
Id = 546,
Name = "FormatTemplateEmailUID",
DisplayOrder = 30,
Required = false,
TxId = 30,
},
new EntityProperty
{
Id = 547,
Name = "FormatTemplateFaxUID",
DisplayOrder = 50,
Required = false,
TxId = 50,
},
new EntityProperty
{
Id = 548,
Name = "FormatTemplateSMSUID",
DisplayOrder = 70,
Required = false,
TxId = 70,
},
new EntityProperty
{
Id = 549,
Name = "FutureEffectiveTime",
DisplayOrder = 10,
Required = false,
TxId = 10,
},
new EntityProperty
{
Id = 536,
Name = "ContractTypeUID",
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = new Guid("00000000-0000-0002-0001-000000000000")
},
new EntityProperty
{
Id = 581,
Name = "RunningRateDays",
DisplayOrder = 130,
Required = true,
TxId = 130,
Value = 0
},
new EntityProperty
{
Id = 590,
Name = "TimeWeightedCostDays",
DisplayOrder = 140,
Required = true,
TxId = 140,
Value = 0
},
new EntityProperty
{
Id = 555,
Name = "Latitude",
DisplayOrder = 501,
Required = false,
TxId = 501,
Value = 39.56m
},
new EntityProperty
{
Id = 558,
Name = "Longitude",
DisplayOrder = 502,
Required = false,
TxId = 502,
Value = -104.78m
},
new EntityProperty
{
Id = 557,
Name = "ListPriceCompetitorUID",
DisplayOrder = 1,
Required = false,
TxId = 1,
},
new EntityProperty
{
Id = 571,
Name = "PHHSiteCode",
DisplayOrder = 300,
Required = false,
TxId = 300,
},
new EntityProperty
{
Id = 580,
Name = "RegionalManagerName",
DisplayOrder = 67,
Required = false,
TxId = 67,
},
new EntityProperty
{
Id = 552,
Name = "GPCGroup",
DisplayOrder = 90,
Required = false,
TxId = 90,
},
new EntityProperty
{
Id = 570,
Name = "OwnPriceTriggersPG",
DisplayOrder = 50,
Required = true,
TxId = 50,
Value = false
},
new EntityProperty
{
Id = 806,
Name = "TriggerCompetingOwnSitePG",
DisplayOrder = 50,
Required = true,
TxId = 50,
Value = false
},
new EntityProperty
{
Id = 550,
Name = "GenerateAllProductGroups",
DisplayOrder = 60,
Required = true,
TxId = 60,
Value = false
},
new EntityProperty
{
Id = 585,
Name = "SiteStockTypeUID",
DisplayOrder = 50,
Required = false,
TxId = 50,
Value = new Guid("A92E52E8-C860-44A5-AAA8-A2DEA52E5DBF")
},
new EntityProperty
{
Id = 543,
Name = "EnableDelayedPricing",
DisplayOrder = 11,
Required = false,
TxId = 11,
Value = false
},
new EntityProperty
{
Id = 542,
Name = "DelayedPricingPeriod",
DisplayOrder = 12,
Required = true,
TxId = 12,
Value = 24
},
new EntityProperty
{
Id = 572,
Name = "PNWebSubmitPriceRequest",
DisplayOrder = 10,
Required = false,
TxId = 10,
Value = false
},
new EntityProperty
{
Id = 538,
Name = "DealerControl",
DisplayOrder = 1,
Required = false,
TxId = 1,
Value = false
},
new EntityProperty
{
Id = 539,
Name = "DealerControlExport",
DisplayOrder = 2,
Required = false,
TxId = 2,
Value = false
},
new EntityProperty
{
Id = 540,
Name = "DealerTrustCategoryUID",
DisplayOrder = 1,
Required = false,
TxId = 1,
},
new EntityProperty
{
Id = 565,
Name = "MappingLabel",
DisplayOrder = 503,
Required = false,
TxId = 503,
},
new EntityProperty
{
Id = 579,
Name = "RecodeSales",
DisplayOrder = 504,
Required = false,
TxId = 504,
Value = false
},
new EntityProperty
{
Id = 566,
Name = "Motorway",
DisplayOrder = 505,
Required = false,
TxId = 505,
Value = false
},
new EntityProperty
{
Id = 541,
Name = "DefinedOffsetCompetitorUID",
DisplayOrder = 2,
Required = false,
TxId = 2,
},
new EntityProperty
{
Id = 576,
Name = "PricingStrategy",
DisplayOrder = 10,
Required = false,
TxId = 10,
},
new EntityProperty
{
Id = 583,
Name = "SignType",
DisplayOrder = 910,
Required = false,
TxId = 910,
},
new EntityProperty
{
Id = 586,
Name = "SiteSystemActive",
DisplayOrder = 99,
Required = true,
TxId = 99,
Value = false
},
new EntityProperty
{
Id = 575,
Name = "PriceIncreaseSetupDelay",
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = 0
},
new EntityProperty
{
Id = 574,
Name = "PriceDecreaseSetupDelay",
DisplayOrder = 20,
Required = true,
TxId = 20,
Value = 0
},
new EntityProperty
{
Id = 588,
Name = "SysCommsDelay",
DisplayOrder = 30,
Required = true,
TxId = 30,
Value = 0
},
new EntityProperty
{
Id = 584,
Name = "SiteOperational",
DisplayOrder = 120,
Required = true,
TxId = 120,
Value = false
},
new EntityProperty
{
Id = 544,
Name = "ExportProperty",
DisplayOrder = 80,
Required = false,
TxId = 80,
},
new EntityProperty
{
Id = 530,
Name = "AlwaysWait",
DisplayOrder = 501,
Required = true,
TxId = 501,
Value = false
},
new EntityProperty
{
Id = 596,
Name = "Volatility",
DisplayOrder = 130,
Required = false,
TxId = 130,
},
new EntityProperty
{
Id = 551,
Name = "GeneratePricesOnCostImport",
DisplayOrder = 510,
Required = true,
TxId = 510,
Value = false
},
new EntityProperty
{
Id = 808,
Name = "ExportMinutesPastTheHourSwitch",
DisplayOrder = 90,
Required = true,
TxId = 90,
Value = false
},
new EntityProperty
{
Id = 807,
Name = "ExportMinutesPastTheHour",
DisplayOrder = 100,
Required = true,
TxId = 100,
Value = 0
}
};
return(propertyCollection);
}
public static EntityPropertyCollection Get()
{
var propertyCollection = new EntityPropertyCollection
{
TableName = "Network",
};
propertyCollection.Properties = new EntityProperty[]
{
new EntityProperty
{
Id = 405,
Name = "ImportCode",
DisplayOrder = 20,
Required = true,
TxId = 20,
Value = "A12"
},
new EntityProperty
{
Id = 406,
Name = "ManagerEmail",
DisplayOrder = 40,
Required = false,
TxId = 40,
Value = ""
},
new EntityProperty
{
Id = 407,
Name = "ManagerName",
DisplayOrder = 30,
Required = false,
TxId = 30,
},
new EntityProperty
{
Id = 408,
Name = "ManagerSMS",
DisplayOrder = 50,
Required = false,
TxId = 50,
},
new EntityProperty
{
Id = 409,
Name = "ManagerUserUID",
DisplayOrder = 51,
Required = false,
TxId = 51,
},
new EntityProperty
{
Id = 410,
Name = "Name",
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = "East2"
}
};
return(propertyCollection);
}
public static EntityPropertyCollection Get()
{
var propertyCollection = new EntityPropertyCollection
{
TableName = "GlobalProduct",
};
propertyCollection.Properties = new EntityProperty[]
{
new EntityProperty
{
Id = 273,
Name = "CFEnableCompetitorPrice",
DataType = typeof(bool),
DisplayOrder = 2,
Required = true,
TxId = 2,
Value = false
},
new EntityProperty
{
Id = 274,
Name = "CFEnableOwnPrice",
DisplayOrder = 1,
Required = true,
TxId = 1,
Value = false
},
new EntityProperty
{
Id = 275,
Name = "CFFillClosedPeriods",
DisplayOrder = 4,
Required = true,
TxId = 4,
Value = false
},
new EntityProperty
{
Id = 276,
Name = "CFMaximumPriceAge",
DisplayOrder = 6,
Required = true,
TxId = 6,
Value = 14
},
new EntityProperty
{
Id = 277,
Name = "CFNumberOfDays",
DisplayOrder = 5,
Required = true,
TxId = 5,
Value = 14
},
new EntityProperty
{
Id = 278,
Name = "CFTimeLag",
DisplayOrder = 7,
Required = true,
TxId = 7,
Value = 1
},
new EntityProperty
{
Id = 279,
Name = "CFValidOnly",
DisplayOrder = 3,
Required = true,
TxId = 3,
Value = false
},
new EntityProperty
{
Id = 280,
Name = "FixedCompanyMargin",
DisplayOrder = 310,
Required = true,
TxId = 310,
Value = 0.000000000m
},
new EntityProperty
{
Id = 281,
Name = "FixedDealerMargin",
DisplayOrder = 320,
Required = true,
TxId = 320,
Value = 0.000000000m
},
new EntityProperty
{
Id = 282,
Name = "DisplayOrder",
DisplayOrder = 30,
Required = true,
TxId = 30,
Value = 1
},
new EntityProperty
{
Id = 284,
Name = "ImportCode",
DisplayOrder = 20,
Required = true,
TxId = 20,
Value = "DSL2"
},
new EntityProperty
{
Id = 285,
Name = "LFLVolumePercentageTarget",
DisplayOrder = 200,
Required = false,
TxId = 200,
},
new EntityProperty
{
Id = 286,
Name = "MarginAllocationMethodID",
DisplayOrder = 300,
Required = true,
TxId = 300,
Value = 0
},
new EntityProperty
{
Id = 287,
Name = "MaxCost",
DisplayOrder = 160,
Required = true,
TxId = 160,
Value = 0.000000000m
},
new EntityProperty
{
Id = 288,
Name = "MaxPrice",
DisplayOrder = 50,
Required = true,
TxId = 50,
Value = 180.00m
},
new EntityProperty
{
Id = 289,
Name = "MaxPriceDecrement",
DisplayOrder = 140,
Required = true,
TxId = 140,
Value = 0.25m
},
new EntityProperty
{
Id = 290,
Name = "MaxPriceIncrement",
DisplayOrder = 150,
Required = true,
TxId = 150,
Value = 0.25m
},
new EntityProperty
{
Id = 291,
Name = "MaxSales",
DisplayOrder = 90,
Required = true,
TxId = 90,
Value = 0m
},
new EntityProperty
{
Id = 292,
Name = "MinCost",
DisplayOrder = 170,
Required = true,
TxId = 170,
Value = 0.000000000m
},
new EntityProperty
{
Id = 293,
Name = "MinPrice",
DisplayOrder = 50,
Required = true,
TxId = 50,
Value = 120.00m
},
new EntityProperty
{
Id = 294,
Name = "MinSales",
DisplayOrder = 80,
Required = true,
TxId = 80,
Value = 0m
},
new EntityProperty
{
Id = 295,
Name = "Name",
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = "Diesel2"
},
new EntityProperty
{
Id = 296,
Name = "OctaneCode",
DisplayOrder = 900,
Required = false,
TxId = 900,
},
new EntityProperty
{
Id = 297,
Name = "PGMaxPrice",
DisplayOrder = 100,
Required = true,
TxId = 100,
Value = 170.00m
},
new EntityProperty
{
Id = 298,
Name = "PGMaxPriceDecrement",
DisplayOrder = 120,
Required = true,
TxId = 120,
Value = 2.50m
},
new EntityProperty
{
Id = 299,
Name = "PGMaxPriceIncrement",
DisplayOrder = 130,
Required = true,
TxId = 130,
Value = 0.00m
},
new EntityProperty
{
Id = 300,
Name = "PGMinPrice",
DisplayOrder = 110,
Required = true,
TxId = 110,
Value = 120.00m
},
new EntityProperty
{
Id = 301,
Name = "PricePointSetUID",
DisplayOrder = 40,
Required = true,
TxId = 40,
Value = new Guid("6A185D57-D349-4824-844D-039A862BA0E9")
},
new EntityProperty
{
Id = 302,
Name = "TaxRate",
DisplayOrder = 60,
Required = true,
TxId = 60,
Value = 0.175000000m
},
new EntityProperty
{
Id = 303,
Name = "TaxRateEffectiveTime",
DisplayOrder = 70,
Required = true,
TxId = 70,
Value = DateTime.Parse("2013-10-11 00:00:00")
},
new EntityProperty
{
Id = 809,
Name = "MaxDelivery",
DisplayOrder = 190,
Required = true,
TxId = 190,
Value = 40000
},
new EntityProperty
{
Id = 810,
Name = "MinDelivery",
DisplayOrder = 180,
Required = true,
TxId = 180,
Value = 0
},
new EntityProperty
{
Id = 813,
Name = "MaxCostBreakdown",
DisplayOrder = 178,
Required = true,
TxId = 178,
Value = 0.000000000m
},
new EntityProperty
{
Id = 814,
Name = "MinCostBreakdown",
DisplayOrder = 179,
Required = true,
TxId = 179,
Value = 0.000000000m
}
};
return(propertyCollection);
}
public static EntityPropertyCollection Get()
{
var propertyCollection = new EntityPropertyCollection
{
TableName = "OwnProduct",
PrimaryEntityTableName = "OwnSite",
PrimaryEntityIds = new int[] { 1, 2 },
SecondaryEntityIds = new int[] { 7 },
SecondaryEntityTableName = "GlobalProduct"
};
propertyCollection.Properties = new EntityProperty[]
{
new EntityProperty {
Id = 413, Name = "Active", DisplayOrder = 4, Required = true, TxId = 4, Value = true
},
new EntityProperty {
Id = 414, Name = "AllowOptimise", DisplayOrder = 1, Required = true, TxId = 1, Value = true
},
new EntityProperty {
Id = 415, Name = "CardPriceDiscount", DisplayOrder = 14, Required = true, TxId = 14, Value = 0.00m
},
new EntityProperty {
Id = 416, Name = "FixedCompanyMargin", DisplayOrder = 310, Required = true, TxId = 310, Value = 0.00m
},
new EntityProperty {
Id = 425, Name = "DealerIndustryZoneMargin", DisplayOrder = 50, Required = false, TxId = 50,
},
new EntityProperty {
Id = 426, Name = "FixedDealerMargin", DisplayOrder = 320, Required = true, TxId = 320, Value = 0.00m
},
new EntityProperty {
Id = 427, Name = "EndTime", DisplayOrder = 7, Required = false, TxId = 7,
},
new EntityProperty {
Id = 429, Name = "HighPriceIncrease", DisplayOrder = 100, Required = true, TxId = 100, Value = 0.00m
},
new EntityProperty {
Id = 431, Name = "InStock", DisplayOrder = 5, Required = true, TxId = 5, Value = true
},
new EntityProperty {
Id = 432, Name = "ListPrice", DisplayOrder = 1, Required = false, TxId = 1,
},
new EntityProperty {
Id = 433, Name = "ListPriceChangeLimit", DisplayOrder = 3, Required = false, TxId = 3, Value = 0.00m
},
new EntityProperty {
Id = 434, Name = "ListPriceOffset", DisplayOrder = 2, Required = false, TxId = 2,
},
new EntityProperty {
Id = 435, Name = "LocalReferencePriceOffset", DisplayOrder = 1, Required = false, TxId = 1,
},
new EntityProperty {
Id = 436, Name = "MaintainSpread", DisplayOrder = 40, Required = true, TxId = 40, Value = false
},
new EntityProperty {
Id = 437, Name = "MarginAllocationMethodID", DisplayOrder = 300, Required = true, TxId = 300, Value = 0
},
new EntityProperty {
Id = 438, Name = "MaxCost", DisplayOrder = 30, Required = true, TxId = 30, Value = 200.00m
},
new EntityProperty {
Id = 439, Name = "MaxPrice", DisplayOrder = 16, Required = true, TxId = 16, Value = 999.00m
},
new EntityProperty {
Id = 440, Name = "MaxPriceDecrement", DisplayOrder = 18, Required = true, TxId = 18, Value = 999.00m
},
new EntityProperty {
Id = 441, Name = "MaxPriceIncrement", DisplayOrder = 19, Required = true, TxId = 19, Value = 999.00m
},
new EntityProperty {
Id = 442, Name = "MaxSales", DisplayOrder = 70, Required = true, TxId = 70, Value = 9999999.00m
},
new EntityProperty {
Id = 443, Name = "MinCost", DisplayOrder = 25, Required = true, TxId = 25, Value = 100.00m
},
new EntityProperty {
Id = 444, Name = "MinPrice", DisplayOrder = 15, Required = true, TxId = 15, Value = 1.00m
},
new EntityProperty {
Id = 445, Name = "MinSales", DisplayOrder = 60, Required = true, TxId = 60, Value = 0.00m
},
new EntityProperty {
Id = 446, Name = "NumberOfHoses", DisplayOrder = 8, Required = true, TxId = 8, Value = 4
},
new EntityProperty {
Id = 448, Name = "PGMaxPrice", DisplayOrder = 21, Required = true, TxId = 21, Value = 180.00m
},
new EntityProperty {
Id = 449, Name = "PGMaxPriceDecrement", DisplayOrder = 10, Required = true, TxId = 10, Value = 2.50m
},
new EntityProperty {
Id = 450, Name = "PGMaxPriceIncrement", DisplayOrder = 11, Required = true, TxId = 11, Value = 0.00m
},
new EntityProperty {
Id = 451, Name = "PGMinPrice", DisplayOrder = 20, Required = true, TxId = 20, Value = 100.00m
},
new EntityProperty {
Id = 458, Name = "PricePointSetUID", DisplayOrder = 3, Required = true, TxId = 3, Value = new Guid("6A185D57-D349-4824-844D-039A862BA0E9")
},
new EntityProperty {
Id = 459, Name = "SOEInclude", DisplayOrder = 10, Required = true, TxId = 10, Value = false
},
new EntityProperty {
Id = 460, Name = "SOEMargin", DisplayOrder = 20, Required = false, TxId = 20,
},
new EntityProperty {
Id = 461, Name = "SOEMarginEffectiveTime", DisplayOrder = 30, Required = false, TxId = 30,
},
new EntityProperty {
Id = 462, Name = "SOEMaxPrice", DisplayOrder = 40, Required = false, TxId = 40,
},
new EntityProperty {
Id = 463, Name = "SOEMaxPriceEffectiveTime", DisplayOrder = 50, Required = false, TxId = 50,
},
new EntityProperty {
Id = 464, Name = "StartTime", DisplayOrder = 6, Required = false, TxId = 6,
},
new EntityProperty {
Id = 465, Name = "SupplierName", DisplayOrder = 60, Required = false, TxId = 60,
},
new EntityProperty {
Id = 466, Name = "TaxRate", DisplayOrder = 12, Required = true, TxId = 12, Value = 0.18m
},
new EntityProperty {
Id = 467, Name = "TaxRateEffectiveTime", DisplayOrder = 13, Required = true, TxId = 13, Value = DateTime.Parse("2013-10-11 00:00:00")
},
new EntityProperty {
Id = 468, Name = "VolatilityCostChangeCountFrom", DisplayOrder = 7, Required = false, TxId = 7,
},
new EntityProperty {
Id = 469, Name = "VolatilityCostChangeCountTo", DisplayOrder = 8, Required = false, TxId = 8,
},
new EntityProperty {
Id = 470, Name = "VolatilityCostChangeValueFrom", DisplayOrder = 9, Required = false, TxId = 9,
},
new EntityProperty {
Id = 471, Name = "VolatilityCostChangeValueTo", DisplayOrder = 10, Required = false, TxId = 10,
},
new EntityProperty {
Id = 472, Name = "VolatilityCostChangeWithinLastXDays", DisplayOrder = 11, Required = false, TxId = 11,
},
new EntityProperty {
Id = 473, Name = "VolatilityCostEnabled", DisplayOrder = 12, Required = true, TxId = 12, Value = false
},
new EntityProperty {
Id = 474, Name = "VolatilityPriceChangeCountFrom", DisplayOrder = 1, Required = false, TxId = 1,
},
new EntityProperty {
Id = 475, Name = "VolatilityPriceChangeCountTo", DisplayOrder = 2, Required = false, TxId = 2,
},
new EntityProperty {
Id = 476, Name = "VolatilityPriceChangeValueFrom", DisplayOrder = 3, Required = false, TxId = 3,
},
new EntityProperty {
Id = 477, Name = "VolatilityPriceChangeValueTo", DisplayOrder = 4, Required = false, TxId = 4,
},
new EntityProperty {
Id = 478, Name = "VolatilityPriceChangeWithinLastXHours", DisplayOrder = 5, Required = false, TxId = 5,
},
new EntityProperty {
Id = 479, Name = "VolatilityPriceEnabled", DisplayOrder = 6, Required = true, TxId = 6, Value = false
},
new EntityProperty {
Id = 480, Name = "ZOffset", DisplayOrder = 34, Required = false, TxId = 34,
},
new EntityProperty {
Id = 481, Name = "ZOffsetEffectiveTime", DisplayOrder = 38, Required = false, TxId = 38,
},
new EntityProperty {
Id = 811, Name = "MaxDelivery", DisplayOrder = 50, Required = true, TxId = 50, Value = 40000
},
new EntityProperty {
Id = 812, Name = "MinDelivery", DisplayOrder = 40, Required = true, TxId = 40, Value = 0
},
new EntityProperty {
Id = 815, Name = "MaxCostBreakdown", DisplayOrder = 39, Required = true, TxId = 39, Value = 200.00m
},
new EntityProperty {
Id = 816, Name = "MinCostBreakdown", DisplayOrder = 38, Required = true, TxId = 38, Value = 100.00m
}
};
return(propertyCollection);
}
protected static IEnumerable <EntityProperty> GetNonNullProperties(EntityPropertyCollection entityPropertyCollection)
{
return(entityPropertyCollection.Properties.Where(p => p.Value != null));
}
public static EntityPropertyCollection Get()
{
var propertyCollection = new EntityPropertyCollection
{
TableName = "OwnProductGroup",
PrimaryEntityTableName = "OwnSite",
PrimaryEntityIds = new int[] { 1, 2 },
SecondaryEntityIds = new int[] { 4 },
SecondaryEntityTableName = "GlobalProductGroup"
};
propertyCollection.Properties = new EntityProperty[]
{
new EntityProperty
{
Id = 482,
Name = "Active",
DisplayOrder = 30,
Required = true,
TxId = 30,
Value = false
},
new EntityProperty
{
Id = 483,
Name = "AlternativeMainMarkerUID",
DisplayOrder = 81,
Required = false,
TxId = 81,
},
new EntityProperty
{
Id = 484,
Name = "AutoImplement",
DisplayOrder = 40,
Required = true,
TxId = 40,
Value = false
},
new EntityProperty
{
Id = 485,
Name = "GenerateOnGPCEnd",
DisplayOrder = 73,
Required = true,
TxId = 73,
Value = false
},
new EntityProperty
{
Id = 486,
Name = "GeneratePrices",
DisplayOrder = 70,
Required = true,
TxId = 70,
Value = 0
},
new EntityProperty
{
Id = 489,
Name = "IncludeInOptimise",
DisplayOrder = 50,
Required = true,
TxId = 50,
Value = false
},
new EntityProperty
{
Id = 490,
Name = "LFAutoImplement",
DisplayOrder = 45,
Required = true,
TxId = 45,
Value = 0
},
new EntityProperty
{
Id = 492,
Name = "OwnSiteCompetitorUID",
DisplayOrder = 80,
Required = false,
TxId = 80,
},
new EntityProperty
{
Id = 493,
Name = "PMIAutoImplement",
DisplayOrder = 110,
Required = true,
TxId = 110,
Value = false
},
new EntityProperty
{
Id = 494,
Name = "PMIFrequency",
DisplayOrder = 170,
Required = true,
TxId = 170,
Value = 0
},
new EntityProperty
{
Id = 495,
Name = "PMILastRunDate",
DisplayOrder = 120,
Required = false,
TxId = 120,
},
new EntityProperty
{
Id = 496,
Name = "PMIMarginRunningLength",
DisplayOrder = 180,
Required = true,
TxId = 180,
Value = 0
},
new EntityProperty
{
Id = 497,
Name = "PMIRunningLength",
DisplayOrder = 150,
Required = true,
TxId = 150,
Value = 0
},
new EntityProperty
{
Id = 498,
Name = "PMIRunningRate",
DisplayOrder = 140,
Required = true,
TxId = 140,
Value = 0
},
new EntityProperty
{
Id = 499,
Name = "PMISalesImpactLimitPercentage",
DisplayOrder = 160,
Required = true,
TxId = 160,
Value = 0
},
new EntityProperty
{
Id = 500,
Name = "PMISuggestedPolicy",
DisplayOrder = 130,
Required = true,
TxId = 130,
Value = 50
},
new EntityProperty
{
Id = 502,
Name = "PMITemplateUID",
DisplayOrder = 100,
Required = false,
TxId = 100,
},
new EntityProperty
{
Id = 504,
Name = "Policy",
DisplayOrder = 90,
Required = true,
TxId = 90,
Value = 0
},
new EntityProperty
{
Id = 505,
Name = "RestActive",
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = false
},
new EntityProperty
{
Id = 506,
Name = "RestAllowDecrease",
DisplayOrder = 120,
Required = true,
TxId = 120,
Value = false
},
new EntityProperty
{
Id = 507,
Name = "RestAllowFirstLower",
DisplayOrder = 140,
Required = true,
TxId = 140,
Value = false
},
new EntityProperty
{
Id = 508,
Name = "RestConsiderAllProducts",
DisplayOrder = 115,
Required = true,
TxId = 115,
Value = false
},
new EntityProperty
{
Id = 509,
Name = "RestFirstGenToSFR",
DisplayOrder = 220,
Required = true,
TxId = 220,
Value = false
},
new EntityProperty
{
Id = 510,
Name = "RestGeneratePricesAtEnd",
DisplayOrder = 210,
Required = true,
TxId = 210,
Value = false
},
new EntityProperty
{
Id = 511,
Name = "RestGPCToRest",
DisplayOrder = 160,
Required = true,
TxId = 160,
Value = false
},
new EntityProperty
{
Id = 512,
Name = "RestGPCTriggerCount",
DisplayOrder = 180,
Required = true,
TxId = 180,
Value = 0
},
new EntityProperty
{
Id = 513,
Name = "RestGroup",
DisplayOrder = 20,
Required = false,
TxId = 20,
},
new EntityProperty
{
Id = 514,
Name = "RestLaggardModeID",
DisplayOrder = 190,
Required = true,
TxId = 190,
Value = 0
},
new EntityProperty
{
Id = 515,
Name = "RestMatchHighestCompetitor",
DisplayOrder = 110,
Required = true,
TxId = 110,
Value = false
},
new EntityProperty
{
Id = 516,
Name = "RestMaxHours",
DisplayOrder = 200,
Required = true,
TxId = 200,
Value = 0m
},
new EntityProperty
{
Id = 517,
Name = "RestPreRestPricing",
DisplayOrder = 70,
Required = true,
TxId = 70,
Value = 0
},
new EntityProperty
{
Id = 518,
Name = "RestSFROnDRop",
DisplayOrder = 150,
Required = true,
TxId = 150,
Value = false
},
new EntityProperty
{
Id = 519,
Name = "RestSuspendAutoImplement",
DisplayOrder = 90,
Required = true,
TxId = 90,
Value = false
},
new EntityProperty
{
Id = 520,
Name = "RestTriggerCount",
DisplayOrder = 60,
Required = true,
TxId = 60,
Value = 0
},
new EntityProperty
{
Id = 521,
Name = "RestTriggerWaitPeriod",
DisplayOrder = 80,
Required = true,
TxId = 80,
Value = 0m
},
new EntityProperty
{
Id = 522,
Name = "RestTurnOffAutoImplementAtEnd",
DisplayOrder = 100,
Required = true,
TxId = 100,
Value = false
},
new EntityProperty
{
Id = 523,
Name = "RestUseGPCTriggerCount",
DisplayOrder = 170,
Required = true,
TxId = 170,
Value = false
},
new EntityProperty
{
Id = 524,
Name = "RestUseHigherRulesPrice",
DisplayOrder = 130,
Required = true,
TxId = 130,
Value = false
}
};
return(propertyCollection);
}
private string SerializeProperties(EntityPropertyCollection entityProperties)
{
List<KeyValuePair<string, string>> properties = new List<KeyValuePair<string, string>>();
foreach (EntityProperty property in entityProperties)
{
properties.Add(new KeyValuePair<string,string>(property.PropertyName, property.PropertyValue));
}
return Newtonsoft.Json.JsonConvert.SerializeObject(properties);
}
public static EntityPropertyCollection Get()
{
var propertyCollection = new EntityPropertyCollection
{
TableName = "CompetitorSite",
};
propertyCollection.Properties = new EntityProperty[]
{
new EntityProperty
{
Id = 117,
Name = "ImportCode",
DisplayOrder = 2,
Required = true,
TxId = 2,
Value = "C999"
},
new EntityProperty
{
Id = 121,
Name = "Name",
DisplayOrder = 1,
Required = true,
TxId = 1,
Value = "CompetitorSite001"
},
new EntityProperty
{
Id = 104,
Name = "Address",
DisplayOrder = 55,
Required = false,
TxId = 55,
},
new EntityProperty
{
Id = 105,
Name = "Address2",
DisplayOrder = 56,
Required = false,
TxId = 56,
},
new EntityProperty
{
Id = 106,
Name = "Address3",
DisplayOrder = 57,
Required = false,
TxId = 57,
},
new EntityProperty
{
Id = 107,
Name = "Address4",
DisplayOrder = 58,
Required = false,
TxId = 58,
},
new EntityProperty
{
Id = 108,
Name = "Address5",
DisplayOrder = 59,
Required = false,
TxId = 59,
},
new EntityProperty
{
Id = 127,
Name = "PostCode",
DisplayOrder = 60,
Required = false,
TxId = 60,
},
new EntityProperty
{
Id = 115,
Name = "Country",
DisplayOrder = 61,
Required = false,
TxId = 61,
},
new EntityProperty
{
Id = 136,
Name = "TimeZoneID",
DisplayOrder = 62,
Required = true,
TxId = 62,
Value = 36
},
new EntityProperty
{
Id = 111,
Name = "BrandUID",
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = new Guid("120306FD-64EA-4C5A-A93B-AC32FEDAF9D3")
},
new EntityProperty
{
Id = 112,
Name = "CompetitorGroupUID",
DisplayOrder = 15,
Required = true,
TxId = 15,
Value = new Guid("4F7B3AF0-F4F9-4FEC-9A1C-69B31B040A16")
},
new EntityProperty
{
Id = 109,
Name = "AreaUID",
DisplayOrder = 12,
Required = false,
TxId = 12,
},
new EntityProperty
{
Id = 122,
Name = "Percentile",
DisplayOrder = 10,
Required = false,
TxId = 10,
Value = 0
},
new EntityProperty
{
Id = 124,
Name = "PercentileMinutes",
DisplayOrder = 50,
Required = false,
TxId = 50,
},
new EntityProperty
{
Id = 123,
Name = "PercentileExcludeCompetitor",
DisplayOrder = 20,
Required = true,
TxId = 20,
Value = false
},
new EntityProperty
{
Id = 125,
Name = "PercentileRoundDown",
DisplayOrder = 40,
Required = true,
TxId = 40,
Value = false
},
new EntityProperty
{
Id = 126,
Name = "PercentileRoundUp",
DisplayOrder = 30,
Required = true,
TxId = 30,
Value = false
},
new EntityProperty
{
Id = 118,
Name = "Latitude",
DisplayOrder = 501,
Required = false,
TxId = 501,
},
new EntityProperty
{
Id = 119,
Name = "Longitude",
DisplayOrder = 502,
Required = false,
TxId = 502,
},
new EntityProperty
{
Id = 110,
Name = "AssignElasticities",
DisplayOrder = 50,
Required = false,
TxId = 50,
Value = false
},
new EntityProperty
{
Id = 114,
Name = "CompetitorPriorityID",
DisplayOrder = 16,
Required = true,
TxId = 16,
Value = 2
},
new EntityProperty
{
Id = 130,
Name = "PriceCheckingPossible",
DisplayOrder = 15,
Required = false,
TxId = 15,
Value = false
},
new EntityProperty
{
Id = 137,
Name = "ValidationSeconds",
DisplayOrder = 15,
Required = true,
TxId = 15,
Value = 0
},
new EntityProperty
{
Id = 113,
Name = "CompetitorPriceAge",
DisplayOrder = 10,
Required = true,
TxId = 10,
Value = 0
},
new EntityProperty
{
Id = 135,
Name = "SpiderCompetitorPriceAge",
DisplayOrder = 11,
Required = true,
TxId = 11,
Value = 0
},
new EntityProperty
{
Id = 134,
Name = "PriceCheckWebsite",
DisplayOrder = 20,
Required = false,
TxId = 20,
},
new EntityProperty
{
Id = 133,
Name = "PriceCheckStreet",
DisplayOrder = 20,
Required = false,
TxId = 20,
},
new EntityProperty
{
Id = 128,
Name = "PriceCheckCity",
DisplayOrder = 20,
Required = false,
TxId = 20,
},
new EntityProperty
{
Id = 131,
Name = "PriceCheckPostcode",
DisplayOrder = 20,
Required = false,
TxId = 20,
},
new EntityProperty
{
Id = 129,
Name = "PriceCheckCountry",
DisplayOrder = 20,
Required = false,
TxId = 20,
},
new EntityProperty
{
Id = 132,
Name = "PriceCheckSource",
DisplayOrder = 20,
Required = false,
TxId = 20,
},
new EntityProperty
{
Id = 120,
Name = "MappingLabel",
DisplayOrder = 503,
Required = false,
TxId = 503,
},
new EntityProperty
{
Id = 805,
Name = "Recipients",
DisplayOrder = 505,
Required = false,
TxId = 505
}
};
return(propertyCollection);
}
protected static bool SecondaryEntityIdsSupplied(EntityPropertyCollection entityPropertyCollection)
{
return(entityPropertyCollection.SecondaryEntityIds != null && entityPropertyCollection.SecondaryEntityIds.Any());
}
