public AppViewModel GetAppViewModel(Guid id) { AppViewModel avm = new AppViewModel(); avm.Id = id; using (SlpContext context = new SlpContext()) { SlpApplication dbApp = context.SlpApplication.Find(avm.Id); if (dbApp != null) { avm.AssistanceProgramId = dbApp.AssistanceProgramId; avm.AssistanceProgramCaseNumber = dbApp.AssistanceProgramCaseNumber; avm.TotalMembers = dbApp.TotalMembers; avm.MemberLastFourSSN = dbApp.MemberLastFourSSN; avm.StreetAddress = dbApp.StreetAddress; avm.AptNo = dbApp.AptNo; avm.City = dbApp.City; avm.State = dbApp.State; avm.Zip = dbApp.Zip; avm.Email = dbApp.Email; avm.Phone = dbApp.Phone; avm.AdultFilledByName = dbApp.AdultFilledByName; avm.EthnicityId = dbApp.EthnicityId; avm.NoSSN = dbApp.NoSSN; } } List<MemberViewModel> members = GetMembers(avm.Id); avm.Children = members.Where(a => a.IsChild == true).ToList(); avm.Adults = members.Where(a => a.IsChild == false).ToList(); //set domain values, default for all applications new/old using (SlpContext context = new SlpContext()) { avm.AssistancePrograms = context.AssistanceProgram.Where(a => a.Visible == true).Select(a => new NameValueViewModel { Name = a.Name, Value = a.Id }).OrderBy(a => a.Value).ToList(); avm.Ethnicities = context.Ethnicity.Where(a => a.Visible == true).Select(a => new NameValueViewModel { Name = a.Name, Value = a.Id }).OrderBy(a => a.Value).ToList(); avm.Frequencies = context.Frequency.Where(a => a.Visible == true).Select(a => new NameValueViewModel { Name = a.Name, Value = a.Id }).OrderBy(a => a.Value).ToList(); avm.Races = context.Race.Where(a => a.Visible == true).Select(a => new NameValueViewModel { Name = a.Name, Value = a.Id }).OrderBy(a => a.Value).ToList(); foreach (SlpApplicationRace dbrace in context.SlpApplicationRace.Where(a => a.SlpApplicationId == avm.Id)) { NameValueViewModel race = avm.Races.Where(a => a.Value == dbrace.RaceId).FirstOrDefault(); if (race != null) { race.SelectedItem = true; } } } avm.AssistanceProgramNoneId = (int)AssistanceProgramsEnum.None; return avm; }
public AppViewModel CompletedAppMembers(Guid applicationGuid) { List<AppMembersViewModel> avm = new List<AppMembersViewModel>(); List<MemberViewModel> mvm = new List<MemberViewModel>(); using (SlpContext context = new SlpContext()) { mvm = context.Members.Where(a => a.SlpApplication.CompletedDate != null).Select(b => new MemberViewModel { AppId = b.SlpApplicationId, FirstName = b.FirstName, MiddleInitial = b.MiddleInitial, LastName = b.LastName, IsChild = b.IsChild, ApplicationCompletedDate = b.SlpApplication.CompletedDate }).ToList(); } foreach (Guid appId in mvm.Select(a => a.AppId).Distinct()) { List<MemberViewModel> appMembers = mvm.Where(a => a.AppId == appId).ToList(); avm.Add( new AppMembersViewModel { AppId = appId, CompletedDate = appMembers.FirstOrDefault().ApplicationCompletedDate.ToString(), CompletedDateTime = appMembers.FirstOrDefault().ApplicationCompletedDate.Value, Adults = string.Join(", ", appMembers.Where(a => a.IsChild == false).Select(b => b.DisplayName)), Children = string.Join(", ", appMembers.Where(a => a.IsChild == true).Select(b => b.DisplayName)) } ); } AppViewModel appVM = new AppViewModel(); AppOrchestrator appOrc = new AppOrchestrator(); appVM = appOrc.GetAppViewModel(applicationGuid); //init objects with random guid appVM.AppMembers = avm.OrderByDescending(a => a.CompletedDateTime).ToList(); //members for report return appVM; }
public JsonResult GetAplication(Guid appId) { AppViewModel avm = new AppViewModel(); avm = appOrchestrator.GetAppViewModel(appId); return Json(avm, JsonRequestBehavior.AllowGet); }