/// <summary> /// Views the subseries. /// </summary> private void ViewSubseries() { RequestModel requestModel = new RequestModel() { SubseriesId = SubseriesId, }; ResponseModel response = App.BaseUserControl.InternalService.GetSubseies(requestModel); if (response.IsOperationSuccess) { SubseryModel subseries = response.SubseriesModel; ((SubseriesUIModel)DataContext).SelectedCollection = subseries.CollectionId.ToString(); SubseriesNameTextBox.Text = subseries.SubseryName; NumberTextBox.Text = subseries.Number; DatesTextBox.Text = subseries.Dates; NotesTextBox.Text = subseries.Note; SubjectTextBox.Text = subseries.Subjects; KeywordsTextBox.Text = subseries.Keywords; DescriptionTextBox.Text = subseries.Description; ScopeAndContentTextBox.Text = subseries.ScopeAndContent; CustodialHistoryTextBox.Text = subseries.CustodialHistory; SizeTextBox.Text = subseries.Size; AcquisitioninfoTextBox.Text = subseries.Acquisitioninfo; LanguageTextBox.Text = subseries.Language; PreservationNoteTextBox.Text = subseries.PreservationNote; RightsTextBox.Text = subseries.Rights; AccessRestrictionsTextBox.Text = subseries.AccessRestrictions; PublicationRightsTextBox.Text = subseries.PublicationRights; PreferredCitationTextBox.Text = subseries.PreferredCitation; RelatedCollectionTextBox.Text = subseries.RelatedCollection; SeparatedMaterialTextBox.Text = subseries.SeparatedMaterial; OriginalLocationTextBox.Text = subseries.OriginalLocation; CopiesLocationTextBox.Text = subseries.CopiesLocation; PublicationNoteTextBox.Text = subseries.PublicationNote; CreatorTextBox.Text = subseries.Creator; ContributorsTextBox.Text = subseries.Contributors; ProcessedByTextBox.Text = subseries.ProcessedBy; SponsorsTextBox.Text = subseries.Sponsors; } else { App.ShowMessage(false, response.ErrorMessage); } }
private SubseryModel GetSubseriesModel(bool isNewRecord) { SubseryModel subseryModel = new SubseryModel() { CollectionId = short.Parse(((SubseriesUIModel)DataContext).SelectedCollection), SubseryName = SubseriesNameTextBox.Text, Number = NumberTextBox.Text, Dates = DatesTextBox.Text, Note = NotesTextBox.Text, Subjects = SubjectTextBox.Text, Keywords = KeywordsTextBox.Text, Description = DescriptionTextBox.Text, ScopeAndContent = ScopeAndContentTextBox.Text, CustodialHistory = CustodialHistoryTextBox.Text, Size = SizeTextBox.Text, Acquisitioninfo = AcquisitioninfoTextBox.Text, Language = LanguageTextBox.Text, PreservationNote = PreservationNoteTextBox.Text, Rights = RightsTextBox.Text, AccessRestrictions = AccessRestrictionsTextBox.Text, PublicationRights = PublicationRightsTextBox.Text, PreferredCitation = PreferredCitationTextBox.Text, RelatedCollection = RelatedCollectionTextBox.Text, SeparatedMaterial = SeparatedMaterialTextBox.Text, OriginalLocation = OriginalLocationTextBox.Text, CopiesLocation = CopiesLocationTextBox.Text, PublicationNote = PublicationNoteTextBox.Text, Creator = CreatorTextBox.Text, Contributors = ContributorsTextBox.Text, ProcessedBy = ProcessedByTextBox.Text, Sponsors = SponsorsTextBox.Text }; if (!isNewRecord) { subseryModel.Id = SubseriesId; } return(subseryModel); }
public static subsery ConvertToSubsery(SubseryModel subseryModel) { return(new subsery() { Id = subseryModel.Id, CollectionId = subseryModel.CollectionId, SubseriesName = subseryModel.SubseryName, Number = subseryModel.Number, Dates = subseryModel.Dates, Note = subseryModel.Note, Subjects = subseryModel.Subjects, Keywords = subseryModel.Keywords, Description = subseryModel.Description, ScopeAndContent = subseryModel.ScopeAndContent, CustodialHistory = subseryModel.CustodialHistory, Size = subseryModel.Size, Acquisitioninfo = subseryModel.Acquisitioninfo, Language = subseryModel.Language, PreservationNote = subseryModel.PreservationNote, Rights = subseryModel.Rights, AccessRestrictions = subseryModel.AccessRestrictions, PublicationRights = subseryModel.PublicationRights, PreferredCitation = subseryModel.PreferredCitation, RelatedCollection = subseryModel.RelatedCollection, SeparatedMaterial = subseryModel.SeparatedMaterial, OriginalLocation = subseryModel.OriginalLocation, CopiesLocation = subseryModel.CopiesLocation, PublicationNote = subseryModel.PublicationNote, Creator = subseryModel.Creator, Contributors = subseryModel.Contributors, ProcessedBy = subseryModel.ProcessedBy, Sponsors = subseryModel.Sponsors, CreatedBy = subseryModel.CreatedBy, CreatedDate = subseryModel.CreatedDate, UpdatedBy = subseryModel.UpdatedBy, UpdatedDate = subseryModel.UpdatedDate, }); }
/// <summary> /// Handles the MouseDoubleClick event of the SubseriesListViewListView control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="MouseButtonEventArgs"/> instance containing the event data.</param> void SubseriesListViewListView_MouseDoubleClick(object sender, MouseButtonEventArgs e) { UIElement clicked = e.OriginalSource as UIElement; string name = ((FrameworkElement)clicked).Name; if (clicked != null && !string.IsNullOrEmpty(name)) { string[] words = name.Split('_'); if (words.Length > 1) { BackToListButton.Visibility = Visibility.Visible; SubseryModel subseryModel = ((FrameworkElement)e.OriginalSource).DataContext as SubseryModel; MainGrid.Visibility = Visibility.Hidden; cc.Content = new ModifySubseries(subseryModel.Id); } } }
/// <summary /// The actual Work to be done. /// </summary> protected override void Execute() { List <CollectionModel> newlist = new List <CollectionModel>(); List <SubseryModel> newSubseriesList = new List <SubseryModel>(); SubseryModel subseryModel = new SubseryModel(); List <collection> collections = CollectionRepository.GetCollections().OrderBy(o => o.CollectionName).ToList(); if (this.Request.SubseriesId > 0) { subsery subsery = SubseryRepository.FirstOrDefault(s => s.Id == this.Request.SubseriesId); subseryModel = Util.ConvertToSubseryModel(subsery, collections.FirstOrDefault(s => s.Id == subsery.CollectionId).CollectionName); } else { List <SubseryModel> newSubseriesUnorderedList = new List <SubseryModel>(); foreach (collection item in collections) { newlist.Add(Util.ConvertToCollectionModel(item, string.Empty)); } foreach (subsery item in SubseryRepository.GetSubseries()) { newSubseriesUnorderedList.Add(Util.ConvertToSubseryModel(item, collections.FirstOrDefault(s => s.Id == item.CollectionId).CollectionName)); } newSubseriesList = newSubseriesUnorderedList.OrderBy(i => i.CollectionName).ThenBy(i => i.SubseryName).ToList(); } Response = new ResponseModel() { Subseries = newSubseriesList, Collections = newlist, SubseriesModel = subseryModel, IsOperationSuccess = true }; }
/// <summary> /// Handles the Click event of the UploadButton control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs" /> instance containing the event data.</param> private void UploadButton_Click(object sender, RoutedEventArgs e) { ClearError(); string filePath = fileUploadLabel.Content.ToString(); try { if (!string.IsNullOrEmpty(filePath)) { fileUploadLabel.Content = filePath; DataTable dt = ReadExcelFile(filePath); if (IsColumnExists(dt)) { List <TranscriptionModel> transcriptionModels = new List <TranscriptionModel>(); int recordcount = 1; foreach (DataRow item in dt.Rows) { string interviewee = GetStringValue(item, IntervieweeColumnName); try { recordcount++; // Reading and matching the collection name string collectionName = GetStringValue(item, CollectionColumnName); CollectionModel collection = App.BaseUserControl.Collections.FirstOrDefault(c => c.CollectionName.Contains(collectionName)); short collectionId = 0; if (collection != null) { collectionId = (short)collection.Id; } else { throw new Exception("collection not found '" + collectionName + "'"); } // Reading and matching the subseries name List <SubseryModel> subseriesList = App.BaseUserControl.Subseries.FindAll(s => s.CollectionId == collectionId); int subseriesId = 0; if (subseriesList != null) { string subseriesName = GetStringValue(item, SubseriesColumnName); SubseryModel subseries = subseriesList.FirstOrDefault(c => c.SubseryName.Contains(subseriesName)); SubseryModel nAsubseries = subseriesList.FirstOrDefault(s => s.SubseryName.Equals("N/A")); if (subseries != null) { subseriesId = (short)subseries.Id; } else if (nAsubseries != null) { subseriesId = (short)nAsubseries.Id; } else { throw new Exception("subseries not found '" + subseriesName + "'"); } } TranscriptionModel transcriptionModel = new TranscriptionModel() { CollectionId = collectionId, ConvertToDigitalDate = GetDateValue(item, DateDigitalColumnName), CoverageSpatial = GetStringValue(item, CoverageSpatialColumnName), CoverageTemporal = GetStringValue(item, CoverageTemporalColumnName), CreatedBy = App.BaseUserControl.UserModel.UserId, CreatedDate = DateTime.Now, Description = GetStringValue(item, DescriptionColumnName), TranscriptNote = GetStringValue(item, TranscriptionNotesColumnName), EquipmentNumber = GetStringValue(item, EquipmentNumberColumnName), MetadataDraft = GetStringValue(item, MetadataDraftColumnName), Format = GetStringValue(item, FormatColumnName), Interviewee = interviewee, Interviewer = GetStringValue(item, InterviewerColumnName), InterviewerNote = GetStringValue(item, InterviewerNotesColumnName), IsAccessMediaStatus = CheckStringContains(GetStringValue(item, AccessMediaStatusColumnName), "complete"), IsBornDigital = GetBoolValue(item, BornDigitalColumnName), IsConvertToDigital = GetBoolValue(item, ConvertedColumnName), IsOnline = GetBoolValue(item, OnlineColumnName), IsPriority = false, IsRestriction = GetBoolValue(item, RestrictionsColumnName), RestrictionNote = GetStringValue(item, RestrictionNotesColumnName), IsDarkArchive = false, AudioEquipmentUsed = GetStringValue(item, AudioEquipmentUsedColumnName), VideoEquipmentUsed = GetStringValue(item, VideoEquipmentUsedColumnName), IsVideoFormat = !string.IsNullOrEmpty(GetStringValue(item, VideoEquipmentUsedColumnName)) ? true : false, IsAudioFormat = !string.IsNullOrEmpty(GetStringValue(item, AudioEquipmentUsedColumnName)) ? true : false, IsRosetta = false, IsRosettaForm = false, Keywords = GetStringValue(item, KeywordColumnName), Language = GetStringValue(item, LanguageColumnName), OriginalMediumType = 1, ProjectCode = GetStringValue(item, ProjectCodeColumnName), Publisher = GetStringValue(item, PublisherColumnName), ReleaseForm = GetBoolValue(item, ReleaseFormColumnName), Rights = GetStringValue(item, RightsColumnName), ScopeAndContents = GetStringValue(item, ScopeAndContentsColumnName), Subject = GetStringValue(item, SubjectColumnName), SubseriesId = subseriesId, TranscriberAssigned = GetStringValue(item, TranscriberAssignedColumnName), TranscriptStatus = true, Place = GetStringValue(item, LocationOfInterviewColumnName), Title = GetStringValue(item, TitleColumnName), Type = GetStringValue(item, TypeColumnName), InterviewerDescription = GetStringValue(item, InterviewerDescriptionColumnName), InterviewerKeywords = GetStringValue(item, InterviewerKeywordsColumnName), InterviewerSubjects = GetStringValue(item, InterviewerSubjectsColumnName), RelationIsPartOf = GetStringValue(item, RelationIsPartOfColumnName), SentOut = GetBoolValue(item, SentOutColumnName), UpdatedBy = App.BaseUserControl.UserModel.UserId, UpdatedDate = DateTime.Now, }; SetDates(ref transcriptionModel, item); transcriptionModels.Add(transcriptionModel); } catch (Exception ex) { //TextBlock tb = new TextBlock //{ // TextWrapping = TextWrapping.Wrap, // Margin = new Thickness(10) //}; //tb.Inlines.Add(new Run("Row id-") { FontWeight = FontWeights.Bold }); //tb.Inlines.Add(recordcount.ToString()); //tb.Inlines.Add(new Run(" interviewee-") { FontWeight = FontWeights.Bold }); //tb.Inlines.Add(interviewee); //tb.Inlines.Add(new Run(" error-") { FontWeight = FontWeights.Bold }); //tb.Inlines.Add(ex.Message + "\n"); //this.Content = tb; StatTextBox.Text += "Row id-" + recordcount + " interviewee-" + interviewee + " error -" + ex.Message + "\n"; } } RequestModel requestModel = new RequestModel() { TranscriptionModels = transcriptionModels, }; ResponseModel response = App.BaseUserControl.InternalService.ImportTranscription(requestModel); if (response.IsOperationSuccess) { App.BaseUserControl.InitializeComponent(false); App.ShowMessage(true, response.ErrorMessage); } else { App.ShowMessage(false, response.ErrorMessage); } ClearAll(); } } else { App.ShowMessage(false, "Browse and select the file first."); } } catch (Exception ex) { App.ShowMessage(false, "Upload the correct formatted excel file. \n " + ex.Message); } }