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();
}
public static void DeleteAnswerRow(long answerId)
{
var deleteAnswer = new aeghealthEntities();
var deleterow = deleteAnswer.tblAnswers
.First(x => x.AnswerID == answerId);
deleteAnswer.tblAnswers.Remove(deleterow);
deleteAnswer.SaveChanges();
}
public static void DeleteConsumerRow(long consumerId)
{
var deleteconsumer = new aeghealthEntities();
var deleterow = deleteconsumer.tblConsumers
.First(x => x.ConsumerID == consumerId);
deleteconsumer.tblConsumers.Remove(deleterow);
deleteconsumer.SaveChanges();
}
public static tblAnswer GetAnswer(int consumerHistoryId, int questionId)
{
var dataModel = new aeghealthEntities();
var updateAnswerrecord = dataModel.tblAnswers //look in the table (from)
.First(i => i.ConsumerHistoryID == consumerHistoryId && // what value are you looking for(where clause)
i.QuestionID == questionId); // another Value in the (where clause)
return(updateAnswerrecord);
}
public static tblConsumer GetConsumerId(string fn, string ln)
{
var dataModel = new aeghealthEntities();
var consumerlookup = dataModel.tblConsumers //look in the table (from)
.First(i => i.FN == fn && // what value are you looking for(where clause)
i.LN == ln); // another Value in the (where clause)
return(consumerlookup);
}
public static tblConsumerHistory GetConsumerHistoryId(int consumerId, int eventid)
{
var dataModel = new aeghealthEntities();
var consumerHistorylookup = dataModel.tblConsumerHistories //look in the table (from)
.First(i => i.ConsumerID == consumerId && // what value are you looking for(where clause)
i.EventID == eventid); // another Value in the (where clause)
return(consumerHistorylookup);
}
public static void UpdateAnswer(long answerId, string value)
{
var dataModel = new aeghealthEntities();
var answerRecord = dataModel.tblAnswers
.OrderByDescending(i => i.CreateDt)
.First(i => i.AnswerID == answerId);
answerRecord.Answer = value;
dataModel.SaveChanges();
}
public static void UpdateConsumerHistory(long consumerHistoryId, short valueone, short valuetwo)
{
var dataModel = new aeghealthEntities();
var consumerHistoryRecord = dataModel.tblConsumerHistories
.OrderByDescending(i => i.CreateDT)
.First(i => i.ConsumerHistoryID == consumerHistoryId);
//values you are updating
consumerHistoryRecord.WeightInLbs = valueone;
consumerHistoryRecord.LDL = valuetwo;
dataModel.SaveChanges();
}
public static void UpdateConsumer(long consumerId, string valueone, string valuetwo)
{
var dataModel = new aeghealthEntities();
var consumerRecord = dataModel.tblConsumers
.OrderByDescending(i => i.CreateDT)
.First(i => i.ConsumerID == consumerId);
//values you are updating
consumerRecord.MlAddr1 = valueone;
consumerRecord.C_SSN = valuetwo;
dataModel.SaveChanges();
}
public static void AddNewConsumerHistoryRow(TestConsumerHistoryModel consumerhistory)
{
{
aeghealthEntities dataModel = new aeghealthEntities();
tblConsumerHistory consumerHistorydata = new tblConsumerHistory()
{
EventID = consumerhistory.EventID,
ConsumerID = consumerhistory.ConsumerID,
LDL = consumerhistory.LDL
};
dataModel.tblConsumerHistories.Add(consumerHistorydata);
dataModel.SaveChanges();
}
}
public static void AddNewAnswerRow(TestAnswers context)
{
var entities = new aeghealthEntities();
var answerdata = new tblAnswer
{
ConsumerHistoryID = context.ConsumerHistoryId,
QuestionID = context.QuestionId,
Answer = context.Answer,
CreatedByID = context.CreatedById,
ModifiedByID = context.ModifiedById
};
entities.tblAnswers.Add(answerdata);
entities.SaveChanges();
}
