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); } }