/// <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
};
}
