public List <ClientSurveyVM> GetClientSurveys()
{
SuperEarthComEntities1 ctx = new SuperEarthComEntities1();
List <ClientSurveyVM> clientSurveys = (from c in ctx.Clients
join sr in ctx.SurveyResponses
on c.ID equals sr.ClientID
join s in ctx.Surveys
on sr.SurveyID equals s.ID
select new ClientSurveyVM
{
ClientID = c.ID,
SurveyID = s.ID,
SurveyResponseID = sr.SurveyID,
FirstName = c.FirstName,
MiddleName = c.MiddleName,
LastName = c.LastName,
CreateDate = sr.CreateDate
}).ToList();
return(clientSurveys);
}
public ClientSurveyVM GetSurveyResponse(int surveyResponseId)
{
SuperEarthComEntities1 ctx = new SuperEarthComEntities1();
ClientSurveyVM vm = (from c in ctx.Clients
join sr in ctx.SurveyResponses
on c.ID equals sr.ClientID
join s in ctx.Surveys
on sr.SurveyID equals s.ID
where sr.ID == surveyResponseId
select new ClientSurveyVM
{
ClientID = c.ID,
SurveyID = s.ID,
SurveyResponseID = sr.SurveyID,
FirstName = c.FirstName,
MiddleName = c.MiddleName,
LastName = c.LastName,
CreateDate = sr.CreateDate,
QuestionString = s.Questions,
ResponseString = sr.Responses
}).SingleOrDefault();
return(vm);
}
public void Add(ContactVM contact)
{
SuperEarthComEntities1 ctx = new SuperEarthComEntities1();
try
{
ctx.ContactRequests.Add(new ContactRequest
{
CreateDate = DateTime.Now,
Email = contact.Email,
ID = Guid.NewGuid(),
Message = contact.Message,
Name = contact.Name,
Phone = contact.Phone,
CanText = contact.CanText,
HasEngaged = contact.HasEngaged
});
ctx.SaveChanges();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
