public List<MemberViewModel> MemberSave(MemberViewModel mvm) { TextInfo textInfo = new CultureInfo("en-US", false).TextInfo; List<MemberViewModel> cvmList = new List<MemberViewModel>(); using (SlpContext context = new SlpContext()) { SlpApplication slpApp = context.SlpApplication.Find(mvm.AppId); if (slpApp == null) { context.SlpApplication.Add(new SlpApplication { Id = mvm.AppId, CreateDate = DateTime.Now }); } if (mvm.Id == new Guid()) //add child { mvm.Id = Guid.NewGuid(); context.Members.Add(new Member { Id = mvm.Id, SlpApplicationId = mvm.AppId, FirstName = textInfo.ToTitleCase(mvm.FirstName.ToLower()), LastName = textInfo.ToTitleCase(mvm.LastName.ToLower()), MiddleInitial = mvm.MiddleInitial == "" || mvm.MiddleInitial == null ? "" : mvm.MiddleInitial.ToUpper(), IsChild = mvm.IsChild, CreatedDate = DateTime.Now }); } else //update child { Member child = context.Members.Where(a => a.Id == mvm.Id).FirstOrDefault(); child.FirstName = textInfo.ToTitleCase(mvm.FirstName.ToLower()); child.LastName = textInfo.ToTitleCase(mvm.LastName.ToLower()); child.MiddleInitial = mvm.MiddleInitial == "" || mvm.MiddleInitial == null ? "" : mvm.MiddleInitial.ToUpper(); } if (mvm.IsChild) { context.MemberChildAttributes.RemoveRange(context.MemberChildAttributes.Where(a => a.MemberId == mvm.Id)); foreach (NameValueViewModel vm in mvm.ChildAttributes) { context.MemberChildAttributes.Add(new MemberChildAttribute { MemberId = mvm.Id, AttributeTypeId = vm.Value, IsSelected = vm.SelectedItem }); } } context.SaveChanges(); } cvmList = GetMembers(mvm.AppId).Where(a => a.IsChild == mvm.IsChild).ToList(); return cvmList; }
public void SaveListViewModel(ListViewModel lvm) { using (SlpContext context = new SlpContext()) { if (lvm.ListId == (int)ListEnum.AssistancePrograms) { foreach (NameValueViewModel item in lvm.TableValues) { if (item.Value == 0 && item.Name != null && item.Name.Trim()!= "") { context.AssistanceProgram.Add(new AssistanceProgram { Name = item.Name, Visible = item.SelectedItem }); } else { var dbitem = context.AssistanceProgram.Find(item.Value); dbitem.Name = item.Name; dbitem.Visible = item.SelectedItem; } } } else if (lvm.ListId == (int)ListEnum.ChildCategories) { foreach (NameValueViewModel item in lvm.TableValues) { if (item.Value == 0 && item.Name != null && item.Name.Trim() != "") { context.ChildAttributeTypes.Add(new ChildAttributeType { Name = item.Name, Visible = item.SelectedItem }); } else { var dbitem = context.ChildAttributeTypes.Find(item.Value); dbitem.Name = item.Name; dbitem.Visible = item.SelectedItem; } } } else if (lvm.ListId == (int)ListEnum.EthnicityList) { foreach (NameValueViewModel item in lvm.TableValues) { if (item.Value == 0 && item.Name != null && item.Name.Trim() != "") { context.Ethnicity.Add(new Ethnicity { Name = item.Name, Visible = item.SelectedItem }); } else { var dbitem = context.Ethnicity.Find(item.Value); dbitem.Name = item.Name; dbitem.Visible = item.SelectedItem; } } } else if (lvm.ListId == (int)ListEnum.RaceList) { foreach (NameValueViewModel item in lvm.TableValues) { if (item.Value == 0 && item.Name != null && item.Name.Trim() != "") { context.Race.Add(new Race { Name = item.Name, Visible = item.SelectedItem }); } else { var dbitem = context.Race.Find(item.Value); dbitem.Name = item.Name; dbitem.Visible = item.SelectedItem; } } } else if (lvm.ListId == (int)ListEnum.IncomeFrequencies) { foreach (NameValueViewModel item in lvm.TableValues) { if (item.Value == 0 && item.Name != null && item.Name.Trim() != "") { context.Frequency.Add(new Frequency { Name = item.Name, Visible = item.SelectedItem }); } else { var dbitem = context.Frequency.Find(item.Value); dbitem.Name = item.Name; dbitem.Visible = item.SelectedItem; } } } else if (lvm.ListId == (int)ListEnum.IncomeQuestionsChild || lvm.ListId == (int)ListEnum.IncomeQuestionsAdult) { foreach (NameValueViewModel item in lvm.TableValues) { if (item.Value == 0 && item.Name != null && item.Name.Trim() != "") { context.IncomeQuestions.Add(new IncomeQuestion { Text = item.Name, Visible = item.SelectedItem, IsChild = lvm.ListId == (int)ListEnum.IncomeQuestionsChild, Type = item.Type }); } else { var dbitem = context.IncomeQuestions.Find(item.Value); dbitem.Text = item.Name; dbitem.Visible = item.SelectedItem; dbitem.Type = item.Type; } } } context.SaveChanges(); } }
public List<MemberViewModel> SaveMemberIncome(IncomeViewModel ivm) { Member member = null; using (SlpContext context = new SlpContext()) { member = context.Members.Find(ivm.MemberId); context.MemberIncomeResponses.RemoveRange(context.MemberIncomeResponses.Where(a => a.MemberId == ivm.MemberId)); foreach (IncomeResponseViewModel irm in ivm.IncomeResponses) { List<MemberIncomeResponseDetail> details = new List<MemberIncomeResponseDetail>(); if (irm.ResponseDetails.Count > 0) { details = irm.ResponseDetails.Select(a => new MemberIncomeResponseDetail { Amount = a.Amount.Value, CreatedDate = DateTime.Now, FrequencyId = a.FrequencyId.Value }).ToList(); } context.MemberIncomeResponses.Add(new MemberIncomeResponse { IncomeQuestionId = irm.IncomeQuestionId, MemberId = ivm.MemberId, Response = irm.Response.Value, IncomeResponseDetails = details }); } context.SaveChanges(); } return GetMembers(member.SlpApplicationId).Where(a => a.IsChild == member.IsChild).ToList(); }
public void SaveContactInformation(ContactViewModel cvm) { using (SlpContext context = new SlpContext()) { SlpApplication dbApp = context.SlpApplication.Find(cvm.AppId); dbApp.StreetAddress = cvm.StreetAddress; dbApp.AptNo = cvm.AptNo; dbApp.City = cvm.City; dbApp.State = cvm.State; dbApp.Zip = cvm.Zip; dbApp.Email = cvm.Email; dbApp.Phone = cvm.Phone; dbApp.AdultFilledByName = cvm.AdultFilledByName == null || cvm.AdultFilledByName == "" ? "" : cvm.AdultFilledByName.ToUpper(); dbApp.EthnicityId = cvm.EthnicityId; dbApp.CompletedDate = DateTime.Now; dbApp.Steps = string.Join(",", cvm.StepsRequired); if (!cvm.StepsRequired.Contains(2)) //if 2 not present, remove data for step 2 { dbApp.AssistanceProgramId = null; dbApp.AssistanceProgramCaseNumber = ""; } if (!cvm.StepsRequired.Contains(3)) //if 3 not present remove data from step 3, all adults, all income records, total members, ssn field and no ssn field { dbApp.TotalMembers = null; dbApp.MemberLastFourSSN = null; dbApp.NoSSN = false; context.Members.RemoveRange(context.Members.Where(a=>a.SlpApplicationId == cvm.AppId && a.IsChild == false)); //remove adults //remove all income responses and income details List<Guid> allmembers = context.Members.Where(a => a.SlpApplicationId == cvm.AppId).Select(a => a.Id).ToList(); context.MemberIncomeResponses.RemoveRange(context.MemberIncomeResponses.Where(a=> allmembers.Contains(a.MemberId))); } context.SlpApplicationRace.RemoveRange(context.SlpApplicationRace.Where(a => a.SlpApplicationId == cvm.AppId)); foreach (NameValueViewModel selectedRace in cvm.Races.Where(a=>a.SelectedItem)) { context.SlpApplicationRace.Add(new SlpApplicationRace { SlpApplicationId = cvm.AppId, RaceId = selectedRace.Value }); } context.SaveChanges(); } }
public void SaveStep3(Step3ViewModel svm) { using (SlpContext context = new SlpContext()) { SlpApplication dbApp = context.SlpApplication.Find(svm.AppId); dbApp.TotalMembers = svm.TotalMembers; dbApp.MemberLastFourSSN = svm.MemberLastFourSSN; dbApp.NoSSN = svm.NoSSN; context.SaveChanges(); } }
public void SaveAssistanceProgram(AssistanceProgramViewModel apvm) { using (SlpContext context = new SlpContext()) { SlpApplication dbApp = context.SlpApplication.Find(apvm.AppId); dbApp.AssistanceProgramId = apvm.Id; // apvm.Id == null || apvm.Id == ? null : apvm.Id; dbApp.AssistanceProgramCaseNumber = apvm.Id == null || apvm.Id == (int)AssistanceProgramsEnum.None ? "" : apvm.CaseNumber; context.SaveChanges(); } }
public List<MemberViewModel> MemberDelete(MemberViewModel mvm) { List<MemberViewModel> cvmList = new List<MemberViewModel>(); using (SlpContext context = new SlpContext()) { Member member = context.Members.Find(mvm.Id); context.Members.Remove(member); context.SaveChanges(); } cvmList = GetMembers(mvm.AppId).Where(a => a.IsChild == mvm.IsChild).ToList(); return cvmList; }