public static Dictionary <string, object> PublicationToAttributes(IPublicationDataSet dataSet)
{
var publication = new Dictionary <string, object>
{
{ "Publication_ID", dataSet.ID.ToString() },
{ "WorkingTitle", dataSet.WorkingTitle },
{ "PublicationTitle", dataSet.PublicationTitle },
{ "DateOfStartWorking", dataSet.DateOfStartWorking },
{ "DateOfRelease", dataSet.DateOfRelease },
{ "Description", dataSet.Description },
{ "AdditionalInformation", dataSet.AdditionalInformation }
};
string divisionID = string.Empty;
if (!string.IsNullOrEmpty(dataSet.Division.Name))
{
divisionID = dataSet.Division.ID.ToString();
}
publication.Add("Division_ID", divisionID);
string authorID = string.Empty;
if (!string.IsNullOrEmpty(dataSet.MainAuthor.Name))
{
authorID = dataSet.MainAuthor.ID.ToString();
}
publication.Add("Author_ID", authorID);
publication.Add("CoAuthor_IDs", ConvertAuthorsToCSV(dataSet.CoAuthors));
string pubTypeID = string.Empty;
if (!string.IsNullOrEmpty(dataSet.TypeOfPublication.Name))
{
pubTypeID = dataSet.TypeOfPublication.ID.ToString();
}
publication.Add("PublicationType_ID", pubTypeID);
string stateID = string.Empty;
if (!string.IsNullOrEmpty(dataSet.CurrentState.Name))
{
stateID = dataSet.CurrentState.ID.ToString();
}
publication.Add("State_ID", stateID);
publication.Add("Tag_ID", ConvertTagsToCSV(dataSet.Tags));
string publisherID = string.Empty;
if (!string.IsNullOrEmpty(dataSet.PublishedBy?.Name))
{
publisherID = dataSet.PublishedBy.ID.ToString();
}
publication.Add("Publisher_ID", publisherID);
return(publication);
}
public void Set(IPublicationDataSet publication)
{
ID = publication.ID;
WorkingTitle = publication.WorkingTitle;
PublicationTitle = publication.PublicationTitle;
TypeOfPublication = publication.TypeOfPublication;
MainAuthor = publication.MainAuthor;
CoAuthors = publication.CoAuthors;
CurrentState = publication.CurrentState;
DateOfStartWorking = publication.DateOfStartWorking;
DateOfRelease = publication.DateOfRelease;
Tags = publication.Tags;
Description = publication.Description;
AdditionalInformation = publication.AdditionalInformation;
Division = publication.Division;
PublishedBy = publication.PublishedBy;
}
public static void InsertPublication(IPublicationDataSet dataSet)
{
CheckWorkBook();
var attributes = PublicationToAttributes(dataSet);
var id = new KeyValuePair <string, object>("Publication_ID", attributes["Publication_ID"]);
if (Excel.IO.ExcelIOAPIs.IsIDOfWorksheet(FilePath, worksheets[0], id))
{
var idColumn = new Dictionary <string, object>()
{
{ id.Key, id.Value }
};
RowUpdate.Update(FilePath, worksheets[0], idColumn, attributes);
return;
}
RowInsert.Insert(FilePath, worksheets[0], attributes);
}
