public ActionResult DeleteConfirmed(int id) { MilitaryService militaryService = db.MilitaryServices.Find(id); db.MilitaryServices.Remove(militaryService); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MilitaryServiceID,Options")] MilitaryService militaryService) { if (ModelState.IsValid) { db.Entry(militaryService).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(militaryService)); }
public ActionResult Create([Bind(Include = "MilitaryServiceID,Options")] MilitaryService militaryService) { if (ModelState.IsValid) { db.MilitaryServices.Add(militaryService); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(militaryService)); }
// GET: MilitaryServices/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MilitaryService militaryService = db.MilitaryServices.Find(id); if (militaryService == null) { return(HttpNotFound()); } return(View(militaryService)); }
public async Task <string> Handle(DeletePersonMilitaryServiceCommand request, CancellationToken cancellationToken) { if (request.ID != null) { using (_context) { MilitaryService toDeleteMilitaryService = new MilitaryService(); toDeleteMilitaryService = await(from ex in _context.MilitaryService where ex.Id == request.ID select ex).FirstOrDefaultAsync(); if (toDeleteMilitaryService != null) { _context.MilitaryService.Remove(toDeleteMilitaryService); await _context.SaveChangesAsync(cancellationToken); } } return(string.Empty); } return(string.Empty); }
/// <inheritdoc/> public string ToDelimitedString() { CultureInfo culture = CultureInfo.CurrentCulture; return(string.Format( culture, StringHelper.StringFormatSequence(0, 73, Configuration.FieldSeparator), Id, InsuredsEmployeeId != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsEmployeeId.Select(x => x.ToDelimitedString())) : null, InsuredsSocialSecurityNumber, InsuredsEmployersNameAndId != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsEmployersNameAndId.Select(x => x.ToDelimitedString())) : null, EmployerInformationData?.ToDelimitedString(), MailClaimParty != null ? string.Join(Configuration.FieldRepeatSeparator, MailClaimParty.Select(x => x.ToDelimitedString())) : null, MedicareHealthInsCardNumber, MedicaidCaseName != null ? string.Join(Configuration.FieldRepeatSeparator, MedicaidCaseName.Select(x => x.ToDelimitedString())) : null, MedicaidCaseNumber, MilitarySponsorName != null ? string.Join(Configuration.FieldRepeatSeparator, MilitarySponsorName.Select(x => x.ToDelimitedString())) : null, MilitaryIdNumber, DependentOfMilitaryRecipient?.ToDelimitedString(), MilitaryOrganization, MilitaryStation, MilitaryService?.ToDelimitedString(), MilitaryRankGrade?.ToDelimitedString(), MilitaryStatus?.ToDelimitedString(), MilitaryRetireDate.HasValue ? MilitaryRetireDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, MilitaryNonAvailCertOnFile, BabyCoverage, CombineBabyBill, BloodDeductible, SpecialCoverageApprovalName != null ? string.Join(Configuration.FieldRepeatSeparator, SpecialCoverageApprovalName.Select(x => x.ToDelimitedString())) : null, SpecialCoverageApprovalTitle, NonCoveredInsuranceCode != null ? string.Join(Configuration.FieldRepeatSeparator, NonCoveredInsuranceCode.Select(x => x.ToDelimitedString())) : null, PayorId != null ? string.Join(Configuration.FieldRepeatSeparator, PayorId.Select(x => x.ToDelimitedString())) : null, PayorSubscriberId != null ? string.Join(Configuration.FieldRepeatSeparator, PayorSubscriberId.Select(x => x.ToDelimitedString())) : null, EligibilitySource?.ToDelimitedString(), RoomCoverageTypeAmount != null ? string.Join(Configuration.FieldRepeatSeparator, RoomCoverageTypeAmount.Select(x => x.ToDelimitedString())) : null, PolicyTypeAmount != null ? string.Join(Configuration.FieldRepeatSeparator, PolicyTypeAmount.Select(x => x.ToDelimitedString())) : null, DailyDeductible?.ToDelimitedString(), LivingDependency?.ToDelimitedString(), AmbulatoryStatus != null ? string.Join(Configuration.FieldRepeatSeparator, AmbulatoryStatus.Select(x => x.ToDelimitedString())) : null, Citizenship != null ? string.Join(Configuration.FieldRepeatSeparator, Citizenship.Select(x => x.ToDelimitedString())) : null, PrimaryLanguage?.ToDelimitedString(), LivingArrangement?.ToDelimitedString(), PublicityCode?.ToDelimitedString(), ProtectionIndicator, StudentIndicator?.ToDelimitedString(), Religion?.ToDelimitedString(), MothersMaidenName != null ? string.Join(Configuration.FieldRepeatSeparator, MothersMaidenName.Select(x => x.ToDelimitedString())) : null, Nationality?.ToDelimitedString(), EthnicGroup != null ? string.Join(Configuration.FieldRepeatSeparator, EthnicGroup.Select(x => x.ToDelimitedString())) : null, MaritalStatus != null ? string.Join(Configuration.FieldRepeatSeparator, MaritalStatus.Select(x => x.ToDelimitedString())) : null, InsuredsEmploymentStartDate.HasValue ? InsuredsEmploymentStartDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, EmploymentStopDate.HasValue ? EmploymentStopDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, JobTitle, JobCodeClass?.ToDelimitedString(), JobStatus?.ToDelimitedString(), EmployerContactPersonName != null ? string.Join(Configuration.FieldRepeatSeparator, EmployerContactPersonName.Select(x => x.ToDelimitedString())) : null, EmployerContactPersonPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, EmployerContactPersonPhoneNumber.Select(x => x.ToDelimitedString())) : null, EmployerContactReason?.ToDelimitedString(), InsuredsContactPersonsName != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsContactPersonsName.Select(x => x.ToDelimitedString())) : null, InsuredsContactPersonPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsContactPersonPhoneNumber.Select(x => x.ToDelimitedString())) : null, InsuredsContactPersonReason != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsContactPersonReason.Select(x => x.ToDelimitedString())) : null, RelationshipToThePatientStartDate.HasValue ? RelationshipToThePatientStartDate.Value.ToString(Consts.DateFormatPrecisionDay, culture) : null, RelationshipToThePatientStopDate != null ? string.Join(Configuration.FieldRepeatSeparator, RelationshipToThePatientStopDate.Select(x => x.ToString(Consts.DateFormatPrecisionDay, culture))) : null, InsuranceCoContactReason?.ToDelimitedString(), InsuranceCoContactPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, InsuranceCoContactPhoneNumber.Select(x => x.ToDelimitedString())) : null, PolicyScope?.ToDelimitedString(), PolicySource?.ToDelimitedString(), PatientMemberNumber?.ToDelimitedString(), GuarantorsRelationshipToInsured?.ToDelimitedString(), InsuredsPhoneNumberHome != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsPhoneNumberHome.Select(x => x.ToDelimitedString())) : null, InsuredsEmployerPhoneNumber != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredsEmployerPhoneNumber.Select(x => x.ToDelimitedString())) : null, MilitaryHandicappedProgram?.ToDelimitedString(), SuspendFlag, CopayLimitFlag, StoplossLimitFlag, InsuredOrganizationNameAndId != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredOrganizationNameAndId.Select(x => x.ToDelimitedString())) : null, InsuredEmployerOrganizationNameAndId != null ? string.Join(Configuration.FieldRepeatSeparator, InsuredEmployerOrganizationNameAndId.Select(x => x.ToDelimitedString())) : null, Race != null ? string.Join(Configuration.FieldRepeatSeparator, Race.Select(x => x.ToDelimitedString())) : null, PatientsRelationshipToInsured?.ToDelimitedString() ).TrimEnd(Configuration.FieldSeparator.ToCharArray())); }
public async Task <List <SearchedPersonMilitaryService> > Handle(SavePersonMilitaryServiceCommand request, CancellationToken cancellationToken) { List <SearchedPersonMilitaryService> result = new List <SearchedPersonMilitaryService>(); if (request.Id == null || request.Id == default(int)) { // Save int CurrentUserId = await _currentUser.GetUserId(); using (var transaction = _context.Database.BeginTransaction()) { try { using (_context) { MilitaryService militaryService = new MilitaryService() { PersonId = request.PersonId, MilitaryServiceTypeId = request.MilitaryServiceTypeId, StartDate = request.StartDate, EndDate = request.EndDate, CreatedBy = request.CreatedBy, CreatedOn = request.CreatedOn, ModifiedBy = request.ModifiedBy, ModifiedOn = request.ModifiedOn, Remark = request.Remark }; _context.MilitaryService.Add(militaryService); await _context.SaveChangesAsync(CurrentUserId, cancellationToken); result = await _mediator.Send(new SearchPersonMilitaryServiceQuery() { Id = militaryService.Id }); transaction.Commit(); } } catch (Exception ex) { transaction.Rollback(); throw new Exception(); } } } else { using (_context) { MilitaryService toUpdateMilitaryService = await _context.MilitaryService.Where(ms => ms.Id == request.Id).SingleOrDefaultAsync(); toUpdateMilitaryService.PersonId = request.PersonId; toUpdateMilitaryService.MilitaryServiceTypeId = request.MilitaryServiceTypeId; toUpdateMilitaryService.StartDate = request.StartDate; toUpdateMilitaryService.EndDate = request.EndDate; toUpdateMilitaryService.CreatedBy = request.CreatedBy; toUpdateMilitaryService.CreatedOn = request.CreatedOn; toUpdateMilitaryService.ModifiedBy = request.ModifiedBy; toUpdateMilitaryService.ModifiedOn = request.ModifiedOn; toUpdateMilitaryService.Remark = request.Remark; await _context.SaveChangesAsync(cancellationToken); result = await _mediator.Send(new SearchPersonMilitaryServiceQuery() { Id = toUpdateMilitaryService.Id }); } } return(result); }
private void Add2DB(List <string> data) { //if (data.Count > 0) for (_i = 0; _i < data.Count; _i++) { _currentLine = data[_i]; string[] item = _currentLine.Split(','); //string[] item = data[0].Split(','); if (IsEmpty(item, 7)) { continue; } CheckAllValue(item, 7); using (var context = new StreetContext()) { //街道 StreetUnit street = context.Streets.SingleOrDefault(s => s.Name == "徐家棚"); if (street == null) { street = new StreetUnit { Name = "徐家棚" }; context.Streets.Add(street); } //社区 var community = context.Communitys.SingleOrDefault(s => s.Name == item[0].Replace("社区", "")); if (community == null) { //CheckValue(item,0); community = new Community { Name = item[0].Replace("社区", "") }; community.Street = street; //street.Communities.Add(community); context.Communitys.Add(community); } //网格 var netGrid = context.NetGrids.SingleOrDefault(s => s.Community.Id == community.Id && s.Name == item[1].Replace("网格", "")); if (netGrid == null) { // CheckValue(item, 1); netGrid = new NetGrid { Name = item[1].Replace("网格", "") }; netGrid.Community = community; context.NetGrids.Add(netGrid); } //小区 var subdivision = context.Subdivisions.SingleOrDefault(s => s.Name == item[3].Replace("小区", "")); if (subdivision == null) { //CheckValue(item,3); subdivision = new Subdivision { Name = item[3].Replace("小区", "") }; subdivision.Street = street; context.Subdivisions.Add(subdivision); } //楼栋 //var building = netGrid.Buildings.SingleOrDefault(s => s.Name == item[4]); var building = context.Buildings.SingleOrDefault(s => s.Subdivision.Id == subdivision.Id && s.Name == item[4].Replace("栋", "")); if (building == null) { building = new Building { Name = item[4].Replace("栋", ""), //房屋地址 Address = item[2], }; building.NetGrid = netGrid; building.Subdivision = subdivision; context.Buildings.Add(building); //subdivision.Buildings.Add(building); } //房屋 string roomName = $"{item[5].Replace("单元", "")}-{item[6].Replace("号", "")}"; var room = context.Rooms.SingleOrDefault(r => r.Building.Id == building.Id && r.Name == roomName); if (room == null) { room = new Room { Name = roomName, Category = item[7], Use = item[8], Area = item[10], Other = item[9], }; room.Building = building; context.Rooms.Add(room); } //单位信息 // var companyinfo = new CompanyInfo { }; if (item[11] != "") { var companyinfo = new CompanyInfo { Name = item[11], Character = item[12], SocialId = item[13], ContactPerson = item[14], PersonId = item[15], Phone = item[16], Area = item[17] }; companyinfo.Room = room; context.CompanyInfos.Add(companyinfo); } //人 var person = context.Persons.SingleOrDefault(p => p.PersonId == item[20]); //检测空名空身份证号 if (!CheckItem(item)) { continue; } //检测同身份证号不同名 if (!CheckPerson(person, item)) { continue; } if (person == null) { person = new Person { Name = item[18], EthnicGroups = item[19].Replace("族", ""), PersonId = item[20], Phone = item[21], //户籍地址 DomicileAddress = item[22], Company = item[27], PoliticalState = item[28], OrganizationalRelation = item[29], IsOverseasChinese = (item[30] == "是"), MerriedStatus = item[31], }; // person.CompanyInfo = companyinfo; context.Persons.Add(person); //单位信息 //if (item[11] != "") //{ // var companyinfo = new CompanyInfo // { // Name = item[11], // Character = item[12], // SocialId = item[13], // ContactPerson = item[14], // PersonId = item[15], // Phone = item[16], // Area = item[17] // }; // context.CompanyInfos.Add(companyinfo); //} //特殊人群 if (item[34] != "") { //var specialGroup = context.SpecialGroups.SingleOrDefault(s => s.PersonId == item[20]); //if (specialGroup == null) var specialGroup = new SpecialGroup { PersonId = item[20], Type = item[34] }; context.SpecialGroups.Add(specialGroup); } // 困难人群 if (item[35] != "") { var poorPeople = new PoorPeople { PersonId = item[20], Type = item[35], Child = item[36], Youngsters = item[37], SpecialHelp = item[38] }; context.PoorPeoples.Add(poorPeople); } //服役状况 if (item[39] != "") { var militaryService = new MilitaryService { PersonId = item[20], Type = item[39] }; context.MilitaryService.Add(militaryService); } //残疾 //var disability = context.Disabilitys.SingleOrDefault(s => s.PersonId == item[20]); //if (disability == null) if (item[40] != "") { var disability = new Disability { PersonId = item[20], Type = item[40], Class = item[41], }; context.Disability.Add(disability); } //其他信息 //var otherInfos = context.OtherInfos.SingleOrDefault(s => s.PersonId == item[20]); // if (otherInfos == null) if (item[42] != "") { var otherInfos = new OtherInfos { PersonId = item[20], //Key = item[42], Value = item[42], }; context.OtherInfos.Add(otherInfos); } } //personroom 人房信息 var personHouse = new PersonRoom { PersonId = item[20], IsHouseholder = (item[23] == "是"), RelationWithHouseholder = item[24], IsOwner = (item[25] == "是"), IsLiveHere = (item[26] == "是"), PopulationCharacter = item[32], LodgingReason = item[33] }; personHouse.Person = person; personHouse.Room = room; context.PersonRooms.Add(personHouse); context.SaveChanges(); _preItem = item; } } // tbInfo_err.Text = ""; tbInfo.Text = "Add personroomdata OK!"; tbInfo_err.Text += _errorMessage; }