//[AllowAnonymous] public async Task <IActionResult> SaveGDManInformation([FromBody] GDManInformationViewModel model) { //return Ok("Success"); try { var user = await _userManager.FindByNameAsync(model.userName); string gdNumber = RandomString(6); GDInformation gDInformation = new GDInformation { ApplicationUserId = user.Id, gdFor = model.gdFor, gdDate = DateTime.Now, gdNumber = gdNumber, gDTypeId = model.gDTypeId, productTypeId = model.productTypeId, documentTypeId = model.documentTypeId == 0 ? null : model.documentTypeId, documentDescription = model.documentDescription, statusId = 1 }; int gdId = await lostAndFoundService.SaveGDInformation(gDInformation); ManInformation manInformation = new ManInformation { gDInformationId = gdId, relationTypeId = model.relationTypeId, name = model.name, aproxAge = model.aproxAge, agePeriodId = model.agePeriodId, genderId = model.genderId, isHealthDisabled = model.isHealthDisabled, fatherName = model.fatherName, motherName = model.motherName, spouseName = model.spouseName, nationalIdentityTypeId = model.manNationalIdentityTypeId, identityNo = model.identityNo, numberTypeId = model.numberTypeId, number = model.number }; int manid = await lostAndFoundService.SaveManInformation(manInformation); if (model.gdFor == "OTHERS") { OtherPersonInformation otherPerson = new OtherPersonInformation { gDInformationId = gdId, nationalIdentityTypeId = model.nationalIdentityTypeId == 0 ? null : model.nationalIdentityTypeId, identityNo = model.identityNo, mobileNo = model.mobileNo }; int opi = await lostAndFoundService.SaveOtherPersonInformation(otherPerson); } IndentifyInfo indentifyInfo = new IndentifyInfo { gDInformationId = gdId, colorsId = model.colorsId, identifySign = model.identifySign, descriptionCircumcisionId = model.descriptionCircumcisionId, religionId = model.religionId, bloodGroup = model.bloodGroup, occupationId = model.occupationId, maritalStatusId = model.maritalStatusId }; int identityid = await lostAndFoundService.SaveIndentifyInfo(indentifyInfo); AddressInformation addressInformation = new AddressInformation { districtId = model.manDistrictId, thanaId = model.thanaId, houseVillage = model.postOffice, addressDetails = model.addressDetails, type = model.addressType, oneLineAddress = model.oneLineAddress, }; int addressId = await addressInformationService.SaveAddressInformation(addressInformation); PhysicalDescription physical = new PhysicalDescription { manInformationId = manid, eyeTypeId = model.eyeTypeId, noseTypeId = model.noseTypeId, hairTypeId = model.hairTypeId, foreHeadTypeId = model.foreHeadTypeId, beardTypeId = model.beardTypeId, weight = model.weight, bodyStructureId = model.bodyStructureId, faceShapeTypeId = model.faceShapeTypeId, bodyChinTypeId = model.bodyChinTypeId, bodyColorId = model.bodyColorId, moustacheTypeId = model.moustacheTypeId, earTypeId = model.earTypeId, neckTypeId = model.neckTypeId, heightFeet = model.heightFeet, heightInch = model.heightInch, specialBirthMarkTypeId = model.specialBirthMarkTypeId, specialBirthMarkBodyPartId = model.specialBirthMarkBodyPartId, specialBirthMarkBodyPartPositionId = model.specialBirthMarkBodyPartPositionId, visibleTatto = model.visibleTatto, otherIdentityfyMark = model.otherIdentityfyMark, teethTypeId = model.teethTypeId, specialBodyConditionId = model.specialBodyConditionId, }; int phyId = await lostAndFoundService.SavePhysicalDescription(physical); DressDescription dress = new DressDescription { manInformationId = manid, inTheHeadId = model.inTheHeadId, inTheHeadColorId = model.inTheHeadColorId, inTheBodyId = model.inTheBodyId, inTheBodyColorId = model.inTheBodyColorId, inTheThroatId = model.inTheThroatId, inTheThroatColorId = model.inTheThroatColorId, inTheWaistId = model.inTheWaistId, inTheWaistColorId = model.inTheWaistColorId, inTheLegsId = model.inTheLegsId, inTheLegsColorId = model.inTheLegsColorId, inTheEyeId = model.inTheEyeId, inTheEyeColorId = model.inTheEyeColorId, shoesSize = model.shoesSize, shoesSizeType = model.shoesSizeType, }; int dressId = await lostAndFoundService.SaveDressDescription(dress); SpaceAndTime spaceAndTime = new SpaceAndTime { gDInformationId = gdId, placeDetails = model.placeDetails, lafDate = model.lafDate, lafTime = model.lafTime, postOfficeId = model.postOfficeId, thanaId = model.thanaId, districtId = model.districtId, divisionId = model.divisionId }; int sdid = await lostAndFoundService.SaveSpaceAndTime(spaceAndTime); if (model.dNAProfileViewModels != null) { List <DNAProfileDetails> lstDNAProfile = new List <DNAProfileDetails>(); foreach (var item in model.dNAProfileViewModels) { DNAProfileDetails dNAProfileDetails = new DNAProfileDetails { manInformationId = manid, locous = item.locous, genotype1 = item.genotype1, genotype2 = item.genotype2 }; lstDNAProfile.Add(dNAProfileDetails); } int dnaId = await lostAndFoundService.SaveDNAProfileDetails(lstDNAProfile); } return(Ok(gdNumber)); } catch (Exception ex) { throw ex; } }
public async Task <IEnumerable <GDInformation> > GetMenInformationBySearching(GDManInformationViewModel model) { var result = await(from m in _context.ManInformation join g in _context.GDInformation on m.gDInformationId equals g.Id join py in _context.PhysicalDescriptions on m.Id equals py.manInformationId into pyy from p in pyy.DefaultIfEmpty() join gnr in _context.Genders on m.genderId equals gnr.Id into gg from gr in gg.DefaultIfEmpty() join ind in _context.IndentifyInfos on g.Id equals ind.gDInformationId into inn from id in inn.DefaultIfEmpty() join stt in _context.SpaceAndTimes on g.Id equals stt.gDInformationId into sttt from st in sttt.DefaultIfEmpty() join d in _context.DressDescriptions on m.Id equals d.manInformationId into ds from dd in ds.DefaultIfEmpty() where p.eyeTypeId == (model.eyeTypeId == null ? p.eyeTypeId : model.eyeTypeId) && p.noseTypeId == (model.noseTypeId == null ? p.noseTypeId : model.noseTypeId) && p.hairTypeId == (model.hairTypeId == null ? p.hairTypeId : model.hairTypeId) && p.foreHeadTypeId == (model.foreHeadTypeId == null ? p.foreHeadTypeId : model.foreHeadTypeId) && p.beardTypeId == (model.beardTypeId == null ? p.beardTypeId : model.beardTypeId) && p.bodyStructureId == (model.bodyStructureId == null ? p.bodyStructureId : model.bodyStructureId) && p.faceShapeTypeId == (model.faceShapeTypeId == null ? p.faceShapeTypeId : model.faceShapeTypeId) && p.bodyChinTypeId == (model.bodyChinTypeId == null ? p.bodyChinTypeId : model.bodyChinTypeId) && p.bodyColorId == (model.bodyColorId == null ? p.bodyColorId : model.bodyColorId) && p.moustacheTypeId == (model.moustacheTypeId == null ? p.moustacheTypeId : model.moustacheTypeId) && p.earTypeId == (model.earTypeId == null ? p.earTypeId : model.earTypeId) && p.neckTypeId == (model.neckTypeId == null ? p.neckTypeId : model.neckTypeId) && p.teethTypeId == (model.teethTypeId == null ? p.teethTypeId : model.teethTypeId) && p.specialBodyConditionId == (model.specialBodyConditionId == null ? p.specialBodyConditionId : model.specialBodyConditionId) && p.specialBirthMarkTypeId == (model.specialBirthMarkTypeId == null ? p.specialBirthMarkTypeId : model.specialBirthMarkTypeId) && p.specialBirthMarkBodyPartId == (model.specialBirthMarkBodyPartId == null ? p.specialBirthMarkBodyPartId : model.specialBirthMarkBodyPartId) && p.specialBirthMarkBodyPartPositionId == (model.specialBirthMarkBodyPartPositionId == null ? p.specialBirthMarkBodyPartPositionId : model.specialBirthMarkBodyPartPositionId) && p.weight == (model.weight == null ? p.weight : model.weight) && p.heightFeet == (model.heightFeet == null ? p.heightFeet : model.heightFeet) && p.heightInch == (model.heightInch == null ? p.heightInch : model.heightInch) && p.visibleTatto == (model.visibleTatto == string.Empty ? p.visibleTatto : model.visibleTatto) && p.otherIdentityfyMark == (model.otherIdentityfyMark == string.Empty ? p.otherIdentityfyMark : model.otherIdentityfyMark) && dd.inTheHeadId == (model.inTheHeadId == null ? dd.inTheHeadId : model.inTheHeadId) && dd.inTheHeadColorId == (model.inTheHeadColorId == null ? dd.inTheHeadColorId : model.inTheHeadColorId) && dd.inTheEyeId == (model.inTheEyeId == null ? dd.inTheEyeId : model.inTheEyeId) && dd.inTheEyeColorId == (model.inTheEyeColorId == null ? dd.inTheEyeColorId : model.inTheEyeColorId) && dd.inTheThroatId == (model.inTheThroatId == null ? dd.inTheThroatId : model.inTheThroatId) && dd.inTheThroatColorId == (model.inTheThroatColorId == null ? dd.inTheThroatColorId : model.inTheThroatColorId) && dd.inTheBodyId == (model.inTheBodyId == null ? dd.inTheBodyId : model.inTheBodyId) && dd.inTheBodyColorId == (model.inTheBodyColorId == null ? dd.inTheBodyColorId : model.inTheBodyColorId) && dd.inTheWaistId == (model.inTheWaistId == null ? dd.inTheWaistId : model.inTheWaistId) && dd.inTheWaistColorId == (model.inTheWaistColorId == null ? dd.inTheWaistColorId : model.inTheWaistColorId) && dd.inTheLegsId == (model.inTheLegsId == null ? dd.inTheLegsId : model.inTheLegsId) && dd.inTheLegsColorId == (model.inTheLegsColorId == null ? dd.inTheLegsColorId : model.inTheLegsColorId) && dd.shoesSize == (model.shoesSize == null ? dd.shoesSize : model.shoesSize) && dd.shoesSizeType == (model.shoesSizeType == string.Empty ? dd.shoesSizeType : model.shoesSizeType) //&& g.Id==model.gDInformationId //g.ApplicationUserId == (userId == "5eeaabd4-0abc-4836-aa58-e1de72a626a8" ? g.ApplicationUserId : userId) //&& g.statusId == 1 select new GDInformation { Id = g.Id, gdFor = g.gdFor, productTypeId = g.productTypeId, gDTypeId = g.gDTypeId, documentTypeId = g.documentTypeId, gdNumber = g.gdNumber, gdDate = g.gdDate, date = Convert.ToDateTime(g.gdDate).ToString("dd-MM-yyyy"), statusId = g.statusId, status = g.statusId == 1 ? "Allegation" : g.statusId == 2 ? "Investigation" : g.statusId == 3 ? "Disposal" : "Cancel" }).ToListAsync(); return(result); }
public async Task <IEnumerable <GDInformation> > GetMenGDInformationBySearching([FromBody] GDManInformationViewModel model) { var result = await lostAndFoundService.GetMenInformationBySearching(model); return(result); }