public static void AddNewConsumerRow(TestConsumerModel consumer)
{
aeghealthEntities context = new aeghealthEntities();
tblConsumer consumerdata = new tblConsumer()
{
ConsumerID = consumer.ConsumerID,
GroupID = consumer.GroupID,
LN = consumer.LN,
FN = consumer.FN,
MI = consumer.MI,
LNSoundex = consumer.LNSoundex,
MlAddr1 = consumer.MlAddr1,
MlCity = consumer.MlCity,
MlState = consumer.MlState,
MlZip = consumer.MlZip,
AcTel = consumer.AcTel,
Tel = consumer.Tel,
C_SSN = consumer.C_SSN,
DOB = consumer.DOB,
bChildren = consumer.bChildren,
MaritalStatusID = consumer.MaritalStatusID,
bFamilyIns = consumer.bFamilyIns,
bHasDr = consumer.bHasDr,
DrLocCit = consumer.DrLocCit,
DrLocSt = consumer.DrLocSt,
Gender = consumer.Gender,
EmploymentStatusID = consumer.EmploymentStatusID,
CreatedByID = consumer.CreatedByID
};
context.tblConsumers.Add(consumerdata);
context.SaveChanges();
}
private IList <TestConsumerModel> HydrateConsumerValues()
{
var returnList = new List <TestConsumerModel>();
var consumerData = new TestConsumerModel
{
GroupID = 12345,
LN = "Mctest",
FN = "Tester",
MI = "T",
LNSoundex = "Sdn",
MlAddr1 = "123 Test St",
MlCity = "Nashville",
MlState = "TN",
MlZip = "37211",
AcTel = "615",
Tel = "615",
C_SSN = "123456789",
DOB = Convert.ToDateTime("1/1/1982"),
bChildren = 0,
MaritalStatusID = 113,
bFamilyIns = 1,
bHasDr = 1,
DrLocCit = "Nashville",
DrLocSt = "TN",
Gender = "M",
EmploymentStatusID = 18,
bFamHisCancer = 0,
bFamHisHd = 0,
bFamHisDiabetes = 0,
InsCarrier = "Testinsurace",
CreatedByID = 68,
Update_SSN = "123121234",
Update_MlAddr1 = "124 Updated St"
};
returnList.Add(consumerData);
return(returnList);
}
