/// <summary> /// The actual Work to be done. /// </summary> protected override void Execute() { transcription daTranscription = TranscriptionRepository.GetTranscription(Request.TranscriptionModel.Id); TranscriptionRepository.Delete(daTranscription); //TranscriptionRepository.Save(); Response = new ResponseModel() { IsOperationSuccess = true, }; }
/// <summary> /// The actual Work to be done. /// </summary> protected override void Execute() { transcription daTranscription = TranscriptionRepository.GetTranscription(Request.TranscriptionModel.ProjectCode); if (daTranscription != null) { WellKnownError.Value = WellKnownErrors.NotUniqueProjectCode; } Response = new ResponseModel() { IsOperationSuccess = true, }; }
/// <summary> /// Converts to transcription. /// </summary> /// <param name="transcriptionModel">The transcription model.</param> /// <param name="interview">The interview.</param> /// <param name="editMode">The edit mode.</param> /// <returns></returns> public static transcription ConvertToTranscription(TranscriptionModel transcriptionModel, transcription interview, int editMode) { return(new transcription() { CollectionId = (short)interview.CollectionId, Description = transcriptionModel.Description, Interviewee = interview.Interviewee, Interviewer = interview.Interviewer, Place = interview.Place, SubseriesId = interview.SubseriesId, AudioEquipmentUsed = interview.AudioEquipmentUsed, VideoEquipmentUsed = interview.VideoEquipmentUsed, InterviewDate = interview.InterviewDate, InterviewDate1 = interview.InterviewDate1, InterviewDate2 = interview.InterviewDate2, GeneralNote = interview.GeneralNote, InterviewerNote = interview.InterviewerNote, IsAudioFormat = interview.IsAudioFormat, IsRestriction = interview.IsRestriction, IsDarkArchive = interview.IsDarkArchive, Keywords = interview.Keywords, RestrictionNote = interview.RestrictionNote, ReleaseForm = interview.ReleaseForm, Subject = interview.Subject, Title = interview.Title, //AuditCheckCompletedDate = DateTime.MinValue,//DBNull.Value, //transcriptionModel.CreatedDate, //EditWithCorrectionDate = DateTime.MinValue, //ConvertToDigitalDate = DateTime.MinValue, //DraftSentDate = DateTime.MinValue, //FinalEditDate = DateTime.MinValue, //FinalSentDate = DateTime.MinValue, //FirstEditCompletedDate = DateTime.MinValue, //SecondEditCompletedDate = DateTime.MinValue, //TranscriberCompleted = DateTime.MinValue, //AccessFileLocation = "AccessFileLocation", //AuditCheckCompleted = "AuditCheckCompleted", //CoverageSpatial = "CoverageSpatial", //CoverageTemporal= "CoverageTemporal", //EditWithCorrectionCompleted = "EditWithCorrectionCompleted", //FileName= "FileName", //FinalEditCompleted= "FinalEditCompleted", //FirstEditCompleted = "FirstEditCompleted", //Format = "Format", //InitialNote = "Initial Note", //IsAccessMediaStatus = true, //IsBornDigital = true, //IsConvertToDigital = true, //IsRosetta = true, //IsRosettaForm = true, //Language = "Language", //MasterFileLocation= "MasterFileLocation", //OriginalMedium ="original mediunm", //OriginalMediumType = 1, //Publisher = "Publisher", //RelationIsPartOf = "RelationIsPartOf", //Rights = "roghts", //ScopeAndContents = "scope and contents", //SecondEditCompleted = "SecondEditCompleted", //Transcript = "Transcript", //TranscriptLocation = 1, //TranscriptStatus = 1, //Type = "Type", ProjectCode = transcriptionModel.ProjectCode, IsPriority = transcriptionModel.IsPriority, ReasonForPriority = transcriptionModel.ReasonForPriority, TranscriberAssigned = transcriptionModel.TranscriberAssigned, TranscriptNote = transcriptionModel.TranscriptNote, CreatedBy = transcriptionModel.CreatedBy, CreatedDate = transcriptionModel.CreatedDate, UpdatedBy = transcriptionModel.UpdatedBy, UpdatedDate = transcriptionModel.UpdatedDate }); }
/// <summary> /// Converts to transcription model. /// </summary> /// <param name="transcription">The transcription.</param> /// <returns></returns> public static TranscriptionModel ConvertToTranscriptionModel(transcription transcription) { return(new TranscriptionModel() { CollectionId = transcription.CollectionId, Description = transcription.Description, Interviewee = transcription.Interviewee, Id = transcription.Id, Interviewer = transcription.Interviewer, Place = transcription.Place, SubseriesId = transcription.SubseriesId, AudioEquipmentUsed = transcription.AudioEquipmentUsed, VideoEquipmentUsed = transcription.VideoEquipmentUsed, InterviewDate = transcription.InterviewDate, InterviewDate1 = transcription.InterviewDate1, InterviewDate2 = transcription.InterviewDate2, InterviewerNote = transcription.InterviewerNote, IsAudioFormat = transcription.IsAudioFormat, IsVideoFormat = transcription.IsVideoFormat, IsRestriction = transcription.IsRestriction, IsDarkArchive = transcription.IsDarkArchive, Keywords = transcription.Keywords, RestrictionNote = transcription.RestrictionNote, DarkArchiveNote = transcription.DarkArchiveNote, ReleaseForm = transcription.ReleaseForm, Subject = transcription.Subject, Title = transcription.Title, ProjectCode = transcription.ProjectCode, AccessFileLocation = transcription.AccessFileLocation, AuditCheckCompleted = transcription.AuditCheckCompleted, ConvertToDigitalDate = transcription.ConvertToDigitalDate != null ? transcription.ConvertToDigitalDate : null, CoverageSpatial = transcription.CoverageSpatial, CoverageTemporal = transcription.CoverageTemporal, CreatedBy = transcription.CreatedBy, CreatedDate = transcription.CreatedDate.Date, DraftSentDate = transcription.DraftSentDate != null ? transcription.DraftSentDate : null, EditWithCorrectionCompleted = transcription.EditWithCorrectionCompleted, FileName = transcription.FileName, FinalEditCompleted = transcription.FinalEditCompleted, FinalSentDate = transcription.FinalSentDate != null ? transcription.FinalSentDate : null, FirstEditCompleted = transcription.FirstEditCompleted, ThirdEditCompleted = transcription.ThirdEditCompleted, Format = transcription.Format, InitialNote = transcription.InitialNote, IsAccessMediaStatus = transcription.IsAccessMediaStatus, IsBornDigital = transcription.IsBornDigital, IsConvertToDigital = transcription.IsConvertToDigital, IsOnline = transcription.IsOnline, IsPriority = transcription.IsPriority, IsRosetta = transcription.IsRosetta, IsRosettaForm = transcription.IsRosettaForm, Language = transcription.Language, TechnicalSpecification = transcription.TechnicalSpecification, MasterFileLocation = transcription.MasterFileLocation, OriginalMedium = transcription.OriginalMedium, OriginalMediumType = transcription.OriginalMediumType, Publisher = transcription.Publisher, ReasonForPriority = transcription.ReasonForPriority, RelationIsPartOf = transcription.RelationIsPartOf, Rights = transcription.Rights, ScopeAndContents = transcription.ScopeAndContents, SecondEditCompleted = transcription.SecondEditCompleted, TranscriberAssigned = transcription.TranscriberAssigned, Transcript = transcription.Transcript, TranscriptNote = transcription.TranscriptNote, TranscriptStatus = transcription.TranscriptStatus, Type = transcription.Type, TranscriptLocation = transcription.TranscriptLocation, UpdatedBy = transcription.UpdatedBy, UpdatedDate = transcription.UpdatedDate.Date, Identifier = transcription.Identifier, GeneralNote = transcription.GeneralNote, InterviewerDescription = transcription.InterviewerDescription, InterviewerKeywords = transcription.InterviewerKeywords, InterviewerSubjects = transcription.InterviewerSubjects, SentOut = transcription.SentOut, EquipmentNumber = transcription.EquipmentNumber, MetadataDraft = transcription.MetadataDraft, CollectionName = collectionListInstance.First(c => c.Id == transcription.CollectionId).CollectionName, SubseriesName = SubseriesListInstance.First(s => s.Id == transcription.SubseriesId).SubseriesName, }); }
/// <summary> /// The actual Work to be done. /// </summary> protected override void Execute() { transcription daTranscription = TranscriptionRepository.GetTranscription(Request.TranscriptionModel.ProjectCode); if (daTranscription != null) { WellKnownError.Value = WellKnownErrors.NotUniqueProjectCode; } else { AddPredefineUser(); if (Request.TranscriptionModel.IsANewAudioEquipment) { AudioEquipmentUsedRepository.Add( new audioequipmentused() { AudioEquipmentUsedName = Request.TranscriptionModel.AudioEquipmentUsed }); AudioEquipmentUsedRepository.Save(); } if (Request.TranscriptionModel.IsANewVideoEquipment) { VideoEquipmentUsedRepository.Add(new videoequipmentused() { VideoEquipmentUsedName = Request.TranscriptionModel.VideoEquipmentUsed }); VideoEquipmentUsedRepository.Save(); } if (Request.WellKnownModificationType == Core.Enums.WellKnownModificationType.Add) { transcription transcription = Util.ConvertToTranscription(Request.TranscriptionModel); TranscriptionRepository.Add(transcription); TranscriptionRepository.Save(); } else { daTranscription = null; daTranscription = TranscriptionRepository.GetTranscription(Request.TranscriptionModel.Id); TranscriptionModel transcriptionModel = Request.TranscriptionModel; switch (Request.WellKnownTranscriptionModificationType) { case Core.Enums.WellKnownTranscriptionModificationType.Transcript: daTranscription.TranscriberAssigned = transcriptionModel.TranscriberAssigned; daTranscription.AuditCheckCompleted = transcriptionModel.AuditCheckCompleted; daTranscription.FirstEditCompleted = transcriptionModel.FirstEditCompleted; daTranscription.SecondEditCompleted = transcriptionModel.SecondEditCompleted; daTranscription.ThirdEditCompleted = transcriptionModel.ThirdEditCompleted; CheckPredefineUserAndInsert(2, transcriptionModel.TranscriberAssigned); CheckPredefineUserAndInsert(2, transcriptionModel.AuditCheckCompleted); CheckPredefineUserAndInsert(2, transcriptionModel.FirstEditCompleted); CheckPredefineUserAndInsert(2, transcriptionModel.SecondEditCompleted); CheckPredefineUserAndInsert(2, transcriptionModel.ThirdEditCompleted); daTranscription.DraftSentDate = transcriptionModel.DraftSentDate; daTranscription.SentOut = transcriptionModel.SentOut; daTranscription.EditWithCorrectionCompleted = transcriptionModel.EditWithCorrectionCompleted; daTranscription.FinalEditCompleted = transcriptionModel.FinalEditCompleted; CheckPredefineUserAndInsert(2, transcriptionModel.EditWithCorrectionCompleted); CheckPredefineUserAndInsert(2, transcriptionModel.FinalEditCompleted); daTranscription.FinalSentDate = transcriptionModel.FinalSentDate; daTranscription.MetadataDraft = transcriptionModel.MetadataDraft; daTranscription.IsPriority = transcriptionModel.IsPriority; daTranscription.ReasonForPriority = transcriptionModel.ReasonForPriority; daTranscription.TranscriptStatus = transcriptionModel.TranscriptStatus; daTranscription.TranscriptLocation = transcriptionModel.TranscriptLocation; daTranscription.TranscriptNote = transcriptionModel.TranscriptNote; break; case Core.Enums.WellKnownTranscriptionModificationType.Media: daTranscription.IsAudioFormat = transcriptionModel.IsAudioFormat; //daTranscription.IsVideoFormat = transcriptionModel.IsVideoFormat; daTranscription.IsBornDigital = transcriptionModel.IsBornDigital; daTranscription.OriginalMediumType = transcriptionModel.OriginalMediumType; daTranscription.OriginalMedium = transcriptionModel.OriginalMedium; daTranscription.IsConvertToDigital = transcriptionModel.IsConvertToDigital; daTranscription.ConvertToDigitalDate = transcriptionModel.ConvertToDigitalDate; daTranscription.IsAccessMediaStatus = transcriptionModel.IsAccessMediaStatus; daTranscription.TechnicalSpecification = transcriptionModel.TechnicalSpecification; daTranscription.MasterFileLocation = transcriptionModel.MasterFileLocation; daTranscription.AccessFileLocation = transcriptionModel.AccessFileLocation; break; case Core.Enums.WellKnownTranscriptionModificationType.Metadata: daTranscription.Title = transcriptionModel.Title; daTranscription.Interviewee = transcriptionModel.Interviewee; daTranscription.Interviewer = transcriptionModel.Interviewer; daTranscription.InterviewDate = transcriptionModel.InterviewDate; daTranscription.InterviewDate1 = transcriptionModel.InterviewDate1; daTranscription.InterviewDate2 = transcriptionModel.InterviewDate2; daTranscription.ConvertToDigitalDate = transcriptionModel.ConvertToDigitalDate; daTranscription.Subject = transcriptionModel.Subject; daTranscription.Keywords = transcriptionModel.Keywords; daTranscription.Description = transcriptionModel.Description; daTranscription.ScopeAndContents = transcriptionModel.ScopeAndContents; daTranscription.Format = transcriptionModel.Format; daTranscription.Type = transcriptionModel.Type; daTranscription.Publisher = transcriptionModel.Publisher; daTranscription.RelationIsPartOf = transcriptionModel.RelationIsPartOf; daTranscription.CoverageSpatial = transcriptionModel.CoverageSpatial; daTranscription.CoverageTemporal = transcriptionModel.CoverageTemporal; daTranscription.Rights = transcriptionModel.Rights; daTranscription.Language = transcriptionModel.Language; daTranscription.Identifier = transcriptionModel.Identifier; daTranscription.Transcript = transcriptionModel.Transcript; daTranscription.FileName = transcriptionModel.FileName; daTranscription.CollectionId = transcriptionModel.CollectionId; daTranscription.SubseriesId = transcriptionModel.SubseriesId; break; case Core.Enums.WellKnownTranscriptionModificationType.Supplement: daTranscription.IsOnline = transcriptionModel.IsOnline; daTranscription.IsRosetta = transcriptionModel.IsRosetta; daTranscription.ReleaseForm = transcriptionModel.ReleaseForm; daTranscription.IsRestriction = transcriptionModel.IsRestriction; daTranscription.IsDarkArchive = transcriptionModel.IsDarkArchive; daTranscription.MetadataDraft = transcriptionModel.MetadataDraft; daTranscription.RestrictionNote = transcriptionModel.RestrictionNote; daTranscription.DarkArchiveNote = transcriptionModel.DarkArchiveNote; daTranscription.IsAudioFormat = transcriptionModel.IsAudioFormat; daTranscription.IsVideoFormat = transcriptionModel.IsVideoFormat; daTranscription.AudioEquipmentUsed = transcriptionModel.AudioEquipmentUsed; daTranscription.VideoEquipmentUsed = transcriptionModel.VideoEquipmentUsed; daTranscription.EquipmentNumber = transcriptionModel.EquipmentNumber; daTranscription.Place = transcriptionModel.Place; daTranscription.InterviewerDescription = transcriptionModel.InterviewerDescription; daTranscription.InterviewerKeywords = transcriptionModel.InterviewerKeywords; daTranscription.InterviewerSubjects = transcriptionModel.InterviewerSubjects; daTranscription.InterviewerNote = transcriptionModel.InterviewerNote; daTranscription.GeneralNote = transcriptionModel.GeneralNote; break; default: break; } daTranscription.UpdatedBy = transcriptionModel.UpdatedBy; daTranscription.UpdatedDate = transcriptionModel.UpdatedDate; TranscriptionRepository.Edit(daTranscription); TranscriptionRepository.Save(); } } Response = new ResponseModel() { IsOperationSuccess = true, }; }
/// <summary> /// The actual Work to be done. /// </summary> protected override void Execute() { List <transcription> transcriptions = TranscriptionRepository.GetAll().ToList(); List <string> codes = transcriptions.Select(s => s.ProjectCode.ToLower()).ToList(); List <predefineduser> predefinedInterviewers = PredefineUserRepository.GetPredefinedUsers(1); List <string> importInterviewerList = new List <string>(); int duplicateRecordCount = 0, insertedRecordCount = 0; foreach (TranscriptionModel item in Request.TranscriptionModels) { if (!codes.Exists(s => s.Contains(item.ProjectCode.ToLower()))) { transcription transcription = Util.ConvertToTranscription(item); transcription.TranscriptStatus = true; TranscriptionRepository.Add(transcription); TranscriptionRepository.Save(); if (!string.IsNullOrEmpty(item.Interviewer)) { string[] splits = item.Interviewer.Split(';'); foreach (string str in splits) { if (!importInterviewerList.Contains(str.Trim())) { importInterviewerList.Add(str.Trim()); } } } insertedRecordCount++; } else { duplicateRecordCount++; } } List <string> list = predefinedInterviewers.Select(item => item.Name).ToList(); foreach (string item in importInterviewerList.Except(list)) { predefineduser interviewer = new predefineduser() { UserType = 1, Name = item }; PredefineUserRepository.Add(interviewer); PredefineUserRepository.Save(); } Response = new ResponseModel() { ErrorMessage = string.Format(" {0} record(s) were \n successfully imported and \n found" + " {1} duplicate records.", insertedRecordCount, duplicateRecordCount), IsOperationSuccess = true }; }