public int PostFAdetailEntities(FAdetailEntities faDetailEntities) { try { IFAdetailOperations faDetailOperations = new FAdetailOperations(); IFAaddressDetailOperations faAddressDetailOperation = new FAaddressDetailOperations(); IFAeducationDetailOperations faEducationDetailOperation = new FAeducationDetailOperations(); IFAexperianceDetailOperations faExperienceDetailOperation = new FAexperianceDetailOperations(); IFAtargetOperations faTargetOperation = new FAtargetOperations(); IFAtargetVillageMappingOperations targetVillageMappingOperation = new FAtargetVillageMappingOperations(); IFAapprovalOperations faApprovalOperation = new FAapprovalOperations(); IFAuploadedDocumentDetailOperations faUploadDocumentDetailOperations = new FAuploadedDocumentDetailOperations(); FAdetail faDetail = new FAdetail(); faDetail = MapEntities.Map <FAdetailEntities, FAdetail>(faDetailEntities); int faDetailId = faDetailOperations.InsertFAdetail(faDetail); FAaddressDetail faAddressDetail = new FAaddressDetail(); faAddressDetail = MapEntities.Map <FAaddressDetailEntities, FAaddressDetail>(faDetailEntities.AddressDetailEntities); faAddressDetail.FAdetailId = faDetailId; int faAddressDetailId = faAddressDetailOperation.InsertFAAddressDetail(faAddressDetail); IEnumerable <FAeducationDetail> faEducationDetailList = new List <FAeducationDetail>(); faEducationDetailList = MapEntities.MapIEnumerableCollection <FAeducationDetailEntities, FAeducationDetail>(faDetailEntities.EducationDetailEntityList); faEducationDetailList.ToList().ForEach(x => x.FAid = faDetailId); faEducationDetailList = faEducationDetailOperation.InsertFAeducationDetail(faEducationDetailList); IEnumerable <FAexperianceDetail> faExperienceDetailList = new List <FAexperianceDetail>(); faExperienceDetailList = MapEntities.MapIEnumerableCollection <FAexperianceDetailEntities, FAexperianceDetail>(faDetailEntities.ExperienceDetailEntityList); faExperienceDetailList.ToList().ForEach(x => x.FAid = faDetailId); faExperienceDetailList = faExperienceDetailOperation.InsertFAexperienceDetail(faExperienceDetailList); IEnumerable <FAtargetDetail> faTargetDetailList = new List <FAtargetDetail>(); faTargetDetailList = MapEntities.MapIEnumerableCollection <FAtargetDetailEntities, FAtargetDetail>(faDetailEntities.TargetDetailEntityList); faTargetDetailList.ToList().ForEach(x => x.FAid = faDetailId); for (int faTargetEntityCount = 0; faTargetEntityCount < faDetailEntities.TargetDetailEntityList.Count(); faTargetEntityCount++) { faTargetDetailList.ElementAt(faTargetEntityCount).FAtargetVillageMappings = MapEntities.MapIEnumerableCollection <FAtargetVillageMappingEntities, FAtargetVillageMapping>(faDetailEntities.TargetDetailEntityList.ElementAt(faTargetEntityCount).TargetCropsEntityMappingList).ToList(); } faTargetDetailList = faTargetOperation.InsertTargetsForFA(faTargetDetailList); FAapproval faApproval = new FAapproval(); faApproval = MapEntities.Map <FAapprovalEntities, FAapproval>(faDetailEntities.ApprovalEntities); faApproval.FAid = faDetailId; faApproval = faApprovalOperation.InsertFAapproval(faApproval); IEnumerable <FAuploadedDocumentDetail> fauploadDetailList = new List <FAuploadedDocumentDetail>(); fauploadDetailList = MapEntities.MapIEnumerableCollection <FAuploadedDocumentDetailEntities, FAuploadedDocumentDetail>(faDetailEntities.UploadedDocumentList); fauploadDetailList.ToList().ForEach(x => x.FAid = faDetailId); fauploadDetailList = faUploadDocumentDetailOperations.InsertUploadedDocumentDetailIst(fauploadDetailList); return(faDetailId); } catch (Exception ex) { throw ex; } }
public int InsertFAAddressDetail(FAaddressDetail faAddressDetail) { try { db.FAaddressDetails.Add(faAddressDetail); db.SaveChanges(); return(faAddressDetail.Id); } catch (Exception ex) { throw ex; } }
public int UpdateFAaddressDetail(List <FAaddressDetail> addressDetailList) { try { int faId = addressDetailList.ElementAt(0).FAdetailId.Value; List <FAaddressDetail> ExistingAddressList = db.FAaddressDetails.Select(x => x).Where(x => x.FAdetailId == faId).ToList(); List <FAaddressDetail> AddressListToAdd = new List <FAaddressDetail>(); List <FAaddressDetail> AddressListToUpdate = new List <FAaddressDetail>(); List <FAaddressDetail> AddressListToDelete = new List <FAaddressDetail>(); foreach (var address in addressDetailList) { FAaddressDetail newAddress = ExistingAddressList.Select(x => x).Where(x => x.Id == address.Id).FirstOrDefault(); if (newAddress == null) { AddressListToAdd.Add(address); } else { AddressListToUpdate.Add(address); } } foreach (var address in ExistingAddressList) { FAaddressDetail existingAddress = addressDetailList.Select(x => x).Where(x => x.Id == address.Id).FirstOrDefault(); if (existingAddress == null) { AddressListToDelete.Add(address); } } foreach (var address in AddressListToAdd) { InsertFAAddressDetail(address); } foreach (var address in AddressListToDelete) { //RemoveFAaddressDetail(address.Id); FAaddressDetail adddtl = db.FAaddressDetails.Select(x => x).Where(x => x.Id == address.Id).FirstOrDefault(); db.FAaddressDetails.Remove(adddtl); } FAaddressDetail addressToUpdate; foreach (var address in AddressListToUpdate) { addressToUpdate = ExistingAddressList.Select(x => x).Where(x => x.Id == address.Id).FirstOrDefault(); if (addressToUpdate != null) { addressToUpdate.Address = address.Address; addressToUpdate.ContactNo = address.ContactNo; addressToUpdate.District = address.District; addressToUpdate.EmailId = address.EmailId; addressToUpdate.MobileNo = address.MobileNo; addressToUpdate.Pincode = address.Pincode; addressToUpdate.SubDistrictId = address.SubDistrictId; addressToUpdate.Village = address.Village; } } return(db.SaveChanges()); } catch (Exception ex) { throw ex; } }