public static ReferenceTable Create()
{
ReferenceTable t = new ReferenceTable();
t.ReferenceTableValues = new List <ReferenceTableValue>();
list.Add(":1234567890=≠≤![");
list.Add(" /STUVWXYZ],(→≡~");
list.Add("-JKLMNOPQR%$*↑↓>");
list.Add("+ABCDEFGHI<.)≥?;");
for (int row = 0; row <= 3; row++)
{
for (int col = 0; col <= 15; col++)
{
char cc = list[row].Substring(col, 1).ToCharArray()[0];
ReferenceTableValue rf = new ReferenceTableValue(
String.Format("{0:X}", row),
String.Format("{0:X}", col),
cc);
t.ReferenceTableValues.Add(rf);
}
}
return(t);
}
private static void AddTestData(DIAContext context)
{
var testUser1 = new Claim
{
ClaimIDNumber = "DI1000000001",
ClaimTypeCode = 1639,
ClaimantID = 1,
EffectiveDate = Convert.ToDateTime("1/25/2017")
};
context.Claims.Add(testUser1);
var testUser2 = new Claim
{
ClaimIDNumber = "DI1000000002",
ClaimTypeCode = 1639,
ClaimantID = 2,
EffectiveDate = Convert.ToDateTime("2/25/2017")
};
context.Claims.Add(testUser2);
var testUser3 = new Claim
{
ClaimIDNumber = "DI1000000003",
ClaimTypeCode = 1639,
ClaimantID = 2,
Id = 4,
EffectiveDate = Convert.ToDateTime("3/25/2017")
};
context.Claims.Add(testUser3);
context.SaveChanges();
var testUser4 = new Person
{
Id = 1,
DOB = Convert.ToDateTime("3/25/1997"),
FirstName = "John",
LastName = "Doe",
ECN = "00023333",
Email = "*****@*****.**"
};
context.Persons.Add(testUser4);
context.SaveChanges();
var testUser5 = new PersonPhoneNumber
{
PersonID = 1,
PhoneNumber = "111-222-3333",
PhoneNumberTypeCode = 440,
IsPrimary = true,
};
context.PersonPhoneNumbers.Add(testUser5);
context.SaveChanges();
var testUser5a = new PersonPhoneNumber
{
PersonID = 1,
PhoneNumber = "124-222-3333",
PhoneNumberTypeCode = 439,
IsPrimary = false,
};
context.PersonPhoneNumbers.Add(testUser5a);
context.SaveChanges();
var testUser6 = new PersonAddress
{
PersonID = 1,
AddressLine1 = "123 main st",
City = "fremont",
StateCode = 361,
ZipCode = "94539",
AddressTypeCode = 438
};
context.PersonAddresses.Add(testUser6);
context.SaveChanges();
var testUser7 = new PersonAddress
{
PersonID = 1,
AddressLine1 = "456 main st",
City = "sacramento",
StateCode = 361,
ZipCode = "93539",
AddressTypeCode = 437
};
context.PersonAddresses.Add(testUser7);
context.SaveChanges();
var locale1 = new LocalizationRecord
{
Key = "abouttitle",
ResourceKey = "PersonController",
Text = "this is a test",
LocalizationCulture = "en-US"
};
context.LocalizationRecords.Add(locale1);
context.SaveChanges();
var reftable = new ReferenceTable
{
TableName = "Claim_Type"
};
context.ReferenceTables.Add(reftable);
context.SaveChanges();
//int refid = reftable.Id;
var reftablevalue = new ReferenceTableValue
{
TableName = "Claim_Type",
Key = "Disability Claim"
};
context.ReferenceTableValues.Add(reftablevalue);
var reftablevalue2 = new ReferenceTableValue
{
TableName = "Claim_Type",
Key = "PFL Claim"
};
var reftablevalue3 = new ReferenceTableValue
{
TableName = "Job_Category",
Key = "light",
Text = "lightxxxxxxxxxxxxxxxxxx"
};
var reftablevalue4 = new ReferenceTableValue
{
TableName = "Job_Category",
Key = "medium",
Text = "medium cccccccccccccccccccccccccccccc"
};
var reftablevalue5 = new ReferenceTableValue
{
TableName = "Job_Category",
Key = "heavy"
};
var reftablevalue6 = new ReferenceTableValue
{
TableName = "State_Code",
Key = "CA",
Id = 361
};
var reftablevalue7 = new ReferenceTableValue
{
TableName = "State_Code",
Key = "NY",
Id = 362
};
var reftablevalue8 = new ReferenceTableValue
{
TableName = "State_Code",
Key = "Name",
Text = "Name in Italien",
ResourceKey = "PersonController",
LocalizationCulture = "en-US"
};
ReferenceTableValue reftablevalue9 = new ReferenceTableValue()
{
TableName = "State_Code",
Key = "Name",
Text = "Name in english",
ResourceKey = "PersonController",
LocalizationCulture = "es-MX"
};
context.ReferenceTableValues.Add(reftablevalue2);
context.ReferenceTableValues.Add(reftablevalue3);
context.ReferenceTableValues.Add(reftablevalue4);
context.ReferenceTableValues.Add(reftablevalue5);
context.ReferenceTableValues.Add(reftablevalue6);
context.ReferenceTableValues.Add(reftablevalue7);
context.ReferenceTableValues.Add(reftablevalue8);
context.ReferenceTableValues.Add(reftablevalue9);
context.SaveChanges();
}
