public void ReadXML()
{
// Create an instance of Camera class.
ONIXmessage fileInfo_1 = new ONIXmessage();
// Create an instance of stream writer.
TextReader txtReader = new StreamReader(@"C:\Users\Kkoka\Desktop\Refactor_TM\Onix_Harlequin_ebook_onix21.xml");
// Create and instance of XmlSerializer class.
XmlSerializer xmlSerializer = new XmlSerializer(typeof(ONIXmessage));
// DeSerialize from the StreamReader
fileInfo_1 = (ONIXmessage)xmlSerializer.Deserialize(txtReader);
// Close the stream reader
txtReader.Close();
Process_Harlequin(fileInfo_1);
}
public void Process_Harlequin(ONIXmessage fileInfo_1)
{
DataTable dt_Harlequin = new DataTable();
#region 'Columns'
dt_Harlequin.Columns.Add("FileName", typeof(string));
dt_Harlequin.Columns.Add("pubId", typeof(string));
dt_Harlequin.Columns.Add("FileType", typeof(string));
dt_Harlequin.Columns.Add("b221", typeof(string));
dt_Harlequin.Columns.Add("ISBN_b244", typeof(string));
dt_Harlequin.Columns.Add("PublisherName_b081", typeof(string));
dt_Harlequin.Columns.Add("PublisherName_2_b081", typeof(string));
dt_Harlequin.Columns.Add("EbookVersion_b014", typeof(string));
dt_Harlequin.Columns.Add("TitleType_b202", typeof(string));
dt_Harlequin.Columns.Add("Title_b203", typeof(string));
dt_Harlequin.Columns.Add("SubTitle_b029", typeof(string));
dt_Harlequin.Columns.Add("UnAbridged_b056", typeof(string));
dt_Harlequin.Columns.Add("LanguageCode_b252", typeof(string));
dt_Harlequin.Columns.Add("BISAC_b064", typeof(string));
dt_Harlequin.Columns.Add("Bisac_Pubspecific_b069", typeof(string));
dt_Harlequin.Columns.Add("BISAC_b070", typeof(string));
dt_Harlequin.Columns.Add("ReleaseDate1_b003", typeof(string));
dt_Harlequin.Columns.Add("ReleaseDate2_j143", typeof(string));
dt_Harlequin.Columns.Add("PriceType_j148", typeof(string));
dt_Harlequin.Columns.Add("LibraryPrice_j151", typeof(string));
dt_Harlequin.Columns.Add("j261", typeof(string));
dt_Harlequin.Columns.Add("CurrencyCode_j152", typeof(string));
dt_Harlequin.Columns.Add("ContributorSequenceNumber_b034", typeof(string));
dt_Harlequin.Columns.Add("Authors_Narrators_Code_b035", typeof(string));
dt_Harlequin.Columns.Add("Author_Narrators_Name_b036", typeof(string));
dt_Harlequin.Columns.Add("CorporateAuthors_b047", typeof(string));
dt_Harlequin.Columns.Add("LNF_b037", typeof(string));
dt_Harlequin.Columns.Add("FNF_b036", typeof(string));
dt_Harlequin.Columns.Add("Author_Narrators_Prefix_b038", typeof(string));
dt_Harlequin.Columns.Add("Authors_Narrators_FirstName_b039", typeof(string));
dt_Harlequin.Columns.Add("Authors_Narrators_LastName_b040", typeof(string));
dt_Harlequin.Columns.Add("ProductFormCode_b012", typeof(string));
dt_Harlequin.Columns.Add("DescriptionType_d102", typeof(string));
dt_Harlequin.Columns.Add("TextFormat_d103", typeof(string));
dt_Harlequin.Columns.Add("Description_d104", typeof(string));
dt_Harlequin.Columns.Add("Description_d101", typeof(string));
dt_Harlequin.Columns.Add("Subject_b070", typeof(string));
dt_Harlequin.Columns.Add("AudibleWma_b333", typeof(string));
dt_Harlequin.Columns.Add("Status_b394", typeof(string));
dt_Harlequin.Columns.Add("status_j141", typeof(string));
dt_Harlequin.Columns.Add("Status_j396", typeof(string));
dt_Harlequin.Columns.Add("SeriesName_b018", typeof(string));
dt_Harlequin.Columns.Add("SeriesNumber_b019", typeof(string));
dt_Harlequin.Columns.Add("SeriesName_b203", typeof(string));
dt_Harlequin.Columns.Add("imprintname_b079", typeof(string));
dt_Harlequin.Columns.Add("SalesRightsTypeCode_b089", typeof(string));
dt_Harlequin.Columns.Add("RightsCountry_b090", typeof(string));
dt_Harlequin.Columns.Add("RightsTerritory_b388", typeof(string));
dt_Harlequin.Columns.Add("PageCount_b061", typeof(string));
dt_Harlequin.Columns.Add("NotForSale", typeof(string));
dt_Harlequin.Columns.Add("onix_Version", typeof(string));
dt_Harlequin.Columns.Add("b211", typeof(string));
dt_Harlequin.Columns.Add("EditionNumber_b057", typeof(string));
dt_Harlequin.Columns.Add("ClassTrade_j149", typeof(string));
dt_Harlequin.Columns.Add("CountryCode_b251", typeof(string));
dt_Harlequin.Columns.Add("BISAC_b067", typeof(string));
dt_Harlequin.Columns.Add("Bisac_pubspecific2_b191", typeof(string));
dt_Harlequin.Columns.Add("Bisac_pubspecific2_b069", typeof(string));
dt_Harlequin.Columns.Add("DigitalFormat_b213", typeof(string));
#endregion
DataRow dr = dt_Harlequin.NewRow();
dr["FileName"] = fileInfo_1.obj_FileInfo_List[0].FileName_FileInfo;
dr["pubId"] = fileInfo_1.obj_FileInfo_List[0].PubID_FileInfo;
dr["FileType"] = fileInfo_1.obj_FileInfo_List[0].FileType_FileInfo;
dt_Harlequin.Rows.Add(dr);
#region 'Unwanted'
//dt_Harlequin.Columns.Add("UniquePubIdentifier_a001", typeof(string));
//dt_Harlequin.Columns.Add("NotificationType_a002", typeof(string));
//dt_Harlequin.Columns.Add("TitlePrefix_b030", typeof(string));
//dt_Harlequin.Columns.Add("TitleWithoutPrefix_b031", typeof(string));
//dt_Harlequin.Columns.Add("UnAbridged_2_b056", typeof(string));
//dt_Harlequin.Columns.Add("ReleaseDate3_j161", typeof(string));
//dt_Harlequin.Columns.Add("PriceQualifier", typeof(string));
//dt_Harlequin.Columns.Add("b064_rank", typeof(string));
//dt_Harlequin.Columns.Add("b069_rank", typeof(string));
//dt_Harlequin.Columns.Add("b070_rank", typeof(string));
//dt_Harlequin.Columns.Add("parent_publishername", typeof(string));
//dt_Harlequin.Columns.Add("LibraryPrice_j151_CAD", typeof(string));
//dt_Harlequin.Columns.Add("RetailPrice", typeof(string));
//dt_Harlequin.Columns.Add("ContributorSequenceWithinRole_b340", typeof(string));
#endregion
#region 'Commented'
//dt_Harlequin.Columns.Add("AgeGroup_b073", typeof(string));
//dt_Harlequin.Columns.Add("Genre", typeof(string));
//dt_Harlequin.Columns.Add("Fiction", typeof(string));
//dt_Harlequin.Columns.Add("Children", typeof(string));
//dt_Harlequin.Columns.Add("PrintBookPubDate", typeof(string));
//dt_Harlequin.Columns.Add("PersonNameType_b250", typeof(string));
//dt_Harlequin.Columns.Add("UnknownAnonymous_b249", typeof(string));
//dt_Harlequin.Columns.Add("n339", typeof(string));
//dt_Harlequin.Columns.Add("CDCount_b210", typeof(string));
//dt_Harlequin.Columns.Add("IsExclusive_Flag", typeof(string));
//dt_Harlequin.Columns.Add("Royalty_Flag", typeof(string));
//dt_Harlequin.Columns.Add("IsMARC_Flag", typeof(string));
//dt_Harlequin.Columns.Add("TotalRunTime_Code_b218", typeof(string));
//dt_Harlequin.Columns.Add("TotalRunTime_b219", typeof(string));
//dt_Harlequin.Columns.Add("TotalRunTime_Unit_b220", typeof(string));
//dt_Harlequin.Columns.Add("InsertedOn", typeof(string));
// dt_Harlequin.Columns.Add("SeriesName_b233", typeof(string));
//dt_Harlequin.Columns.Add("SeriesPositionNumber", typeof(string));
//dt_Harlequin.Columns.Add("SeriesTotalNumber", typeof(string));
//dt_Harlequin.Columns.Add("SeriesID_b273", typeof(string));
//dt_Harlequin.Columns.Add("DistributionTerritory", typeof(string));
//dt_Harlequin.Columns.Add("BeginRightsDate", typeof(string));
//dt_Harlequin.Columns.Add("EndRightsDate", typeof(string));
//dt_Harlequin.Columns.Add("MetadataType", typeof(string));
//dt_Harlequin.Columns.Add("ChapterCount", typeof(string));
// dt_Harlequin.Columns.Add("Notes", typeof(string));
// dt_Harlequin.Columns.Add("LibraryAccountID", typeof(string));
// dt_Harlequin.Columns.Add("SKUNumber", typeof(string));
// dt_Harlequin.Columns.Add("Awards", typeof(string));
// dt_Harlequin.Columns.Add("ReligiousText_Bible", typeof(string));
// dt_Harlequin.Columns.Add("AbstractText", typeof(string));
//dt_Harlequin.Columns.Add("Epilogue", typeof(string));
//dt_Harlequin.Columns.Add("ContentRating", typeof(string));
//dt_Harlequin.Columns.Add("Imprints", typeof(string));
//dt_Harlequin.Columns.Add("OriginalLanguage", typeof(string));
//dt_Harlequin.Columns.Add("Keywords", typeof(string));
//dt_Harlequin.Columns.Add("TargetAudience", typeof(string));
//dt_Harlequin.Columns.Add("MediaFormat", typeof(string));
//dt_Harlequin.Columns.Add("MediaQuality", typeof(string));
//dt_Harlequin.Columns.Add("Review", typeof(string));
//dt_Harlequin.Columns.Add("IsSingleUse", typeof(string));
//dt_Harlequin.Columns.Add("IsMultiUse", typeof(string));
//dt_Harlequin.Columns.Add("IsActive", typeof(string));
//dt_Harlequin.Columns.Add("IsRenewed", typeof(string));
//dt_Harlequin.Columns.Add("IsDownloadable", typeof(string));
//dt_Harlequin.Columns.Add("IsTransferableRetail", typeof(string));
//dt_Harlequin.Columns.Add("ISBurnableRetail", typeof(string));
//dt_Harlequin.Columns.Add("IsTransferableLibrary", typeof(string));
//dt_Harlequin.Columns.Add("IsBurnableLibrary", typeof(string));
//dt_Harlequin.Columns.Add("MarcFileContent", typeof(string));
//dt_Harlequin.Columns.Add("MarcTagValueText", typeof(string));
//dt_Harlequin.Columns.Add("Agent", typeof(string));
//dt_Harlequin.Columns.Add("BookCopyright", typeof(string));
//dt_Harlequin.Columns.Add("RecordingCopyright", typeof(string));
//dt_Harlequin.Columns.Add("CreationDate", typeof(string));
//dt_Harlequin.Columns.Add("CreatedBy", typeof(string));
//dt_Harlequin.Columns.Add("LastModified", typeof(string));
//dt_Harlequin.Columns.Add("FilePath", typeof(string));
//dt_Harlequin.Columns.Add("ReviewComments", typeof(string));
//dt_Harlequin.Columns.Add("TL_Subject", typeof(string));
//dt_Harlequin.Columns.Add("TL_DRM_Type", typeof(string));
//dt_Harlequin.Columns.Add("TL_TitleMain", typeof(string));
//dt_Harlequin.Columns.Add("TL_TitlePrefix", typeof(string));
//dt_Harlequin.Columns.Add("TL_MediaType", typeof(string));
//dt_Harlequin.Columns.Add("Audio_Exist_Flag", typeof(string));
//dt_Harlequin.Columns.Add("TitleID", typeof(string));
//dt_Harlequin.Columns.Add("isRuntimeProcessed", typeof(string));
//dt_Harlequin.Columns.Add("AudioBook_x416", typeof(string));
//dt_Harlequin.Columns.Add("AudioBook_b385", typeof(string));
//dt_Harlequin.Columns.Add("EpubType_b211", typeof(string));
//dt_Harlequin.Columns.Add("DRMFlag_x317", typeof(string));
//dt_Harlequin.Columns.Add("UsageType_x318", typeof(string));
//dt_Harlequin.Columns.Add("UsageStatus_x319", typeof(string));
//dt_Harlequin.Columns.Add("UsageQuantity_x320", typeof(string));
//dt_Harlequin.Columns.Add("CreatedBy", typeof(string));
//dt_Harlequin.Columns.Add("UsageUnit_b321", typeof(string));
//dt_Harlequin.Columns.Add("Series_TitleElementLevel", typeof(string));
//dt_Harlequin.Columns.Add("Title_TitleElementLevel", typeof(string));
//dt_Harlequin.Columns.Add("TitleSuffix", typeof(string));
//dt_Harlequin.Columns.Add("ROWSalesRightsType_referencecode", typeof(string));
//dt_Harlequin.Columns.Add("SalesRestriction_b383", typeof(string));
#endregion
}
public ONIXmessage Work_With_Onix(string filelocation)
{
#region 'comment'
// XmlSerializer deserializer = new XmlSerializer(typeof(List<Refactor_TM.Harlequin.Student>));
//TextReader textReader = new StreamReader(@"C:\Users\Kkoka\Desktop\Refactor_TM\student3.xml");
// // TextReader textReader = new StreamReader(@"C:\Users\Kkoka\Desktop\Refactor_TM\student2.xml");
//// TextReader textReader = new StreamReader(@"C:\Users\Kkoka\Desktop\Refactor_TM\Onix_Harlequin_ebook_onix21.xml");
//List<Refactor_TM.Harlequin.Student> stud;
//stud = (List<Refactor_TM.Harlequin.Student>)deserializer.Deserialize(textReader);
// textReader.Close();
//XmlSerializer deserializer = new XmlSerializer(typeof(List<Refactor_TM.Harlequin.Fchetes>));
//TextReader textReader = new StreamReader(@"C:\Users\Kkoka\Desktop\Refactor_TM\student4.xml");
//// TextReader textReader = new StreamReader(@"C:\Users\Kkoka\Desktop\Refactor_TM\student2.xml");
//// TextReader textReader = new StreamReader(@"C:\Users\Kkoka\Desktop\Refactor_TM\Onix_Harlequin_ebook_onix21.xml");
//List<Refactor_TM.Harlequin.Fchetes> stud;
//stud = (List<Refactor_TM.Harlequin.Fchetes>)deserializer.Deserialize(textReader);
//textReader.Close();
#endregion 'comment'
#region 'CleanUp ONIX elements'
//System.IO.FileInfo file_1 = new System.IO.FileInfo(filelocation);
//Onix_CleanUP cleanup_xml = new Onix_CleanUP(); //(info, sort_filepath, onix_TagType , xml_encoding);
//cleanup_xml.CleanUP_OnixElements(file_1);
#endregion
// Create an instance of Camera class.
ONIXmessage fileInfo_1 = new ONIXmessage();
// Create an instance of stream writer.
string cleanedupFilePath = @"C:\Users\kkoka\Desktop\wfh\harpercollins\cleaned\HCUK_ONIX_full_20141107.xml";
// TextReader txtReader = new StreamReader(filelocation);
TextReader txtReader = new StreamReader(cleanedupFilePath);
// Create and instance of XmlSerializer class.
XmlSerializer xmlSerializer = new XmlSerializer(typeof(ONIXmessage));
// DeSerialize from the StreamReader
fileInfo_1 = (ONIXmessage)xmlSerializer.Deserialize(txtReader);
// Close the stream reader
txtReader.Close();
return(fileInfo_1);
// Process_Harlequin(fileInfo_1);
}
public void Process_Harlequin(ONIXmessage fileInfo_1)
{
DataTable dt_Harlequin = new DataTable();
#region 'Columns'
dt_Harlequin.Columns.Add("FileName", typeof(string));
dt_Harlequin.Columns.Add("pubId", typeof(string));
dt_Harlequin.Columns.Add("FileType", typeof(string));
dt_Harlequin.Columns.Add("b221", typeof(string));
dt_Harlequin.Columns.Add("ISBN_b244", typeof(string));
dt_Harlequin.Columns.Add("PublisherName_b081", typeof(string));
dt_Harlequin.Columns.Add("PublisherName_2_b081", typeof(string));
dt_Harlequin.Columns.Add("EbookVersion_b014", typeof(string));
dt_Harlequin.Columns.Add("TitleType_b202", typeof(string));
dt_Harlequin.Columns.Add("Title_b203", typeof(string));
dt_Harlequin.Columns.Add("SubTitle_b029", typeof(string));
dt_Harlequin.Columns.Add("UnAbridged_b056", typeof(string));
dt_Harlequin.Columns.Add("LanguageCode_b252", typeof(string));
dt_Harlequin.Columns.Add("BISAC_b064", typeof(string));
dt_Harlequin.Columns.Add("Bisac_Pubspecific_b069", typeof(string));
dt_Harlequin.Columns.Add("BISAC_b070", typeof(string));
dt_Harlequin.Columns.Add("ReleaseDate1_b003", typeof(string));
dt_Harlequin.Columns.Add("ReleaseDate2_j143", typeof(string));
dt_Harlequin.Columns.Add("PriceType_j148", typeof(string));
dt_Harlequin.Columns.Add("LibraryPrice_j151", typeof(string));
dt_Harlequin.Columns.Add("j261", typeof(string));
dt_Harlequin.Columns.Add("CurrencyCode_j152", typeof(string));
dt_Harlequin.Columns.Add("ContributorSequenceNumber_b034", typeof(string));
dt_Harlequin.Columns.Add("Authors_Narrators_Code_b035", typeof(string));
dt_Harlequin.Columns.Add("Author_Narrators_Name_b036", typeof(string));
dt_Harlequin.Columns.Add("CorporateAuthors_b047", typeof(string));
dt_Harlequin.Columns.Add("LNF_b037", typeof(string));
dt_Harlequin.Columns.Add("FNF_b036", typeof(string));
dt_Harlequin.Columns.Add("Author_Narrators_Prefix_b038", typeof(string));
dt_Harlequin.Columns.Add("Authors_Narrators_FirstName_b039", typeof(string));
dt_Harlequin.Columns.Add("Authors_Narrators_LastName_b040", typeof(string));
dt_Harlequin.Columns.Add("ProductFormCode_b012", typeof(string));
dt_Harlequin.Columns.Add("DescriptionType_d102", typeof(string));
//dt_Harlequin.Columns.Add("TextFormat_d103", typeof(string));
dt_Harlequin.Columns.Add("Description_d104", typeof(string));
dt_Harlequin.Columns.Add("Description_d101", typeof(string));
//dt_Harlequin.Columns.Add("Subject_b070", typeof(string));
dt_Harlequin.Columns.Add("AudibleWma_b333", typeof(string));
dt_Harlequin.Columns.Add("Status_b394", typeof(string));
dt_Harlequin.Columns.Add("status_j141", typeof(string));
dt_Harlequin.Columns.Add("Status_j396", typeof(string));
dt_Harlequin.Columns.Add("SeriesName_b018", typeof(string));
dt_Harlequin.Columns.Add("SeriesNumber_b019", typeof(string));
dt_Harlequin.Columns.Add("SeriesName_b203", typeof(string));
dt_Harlequin.Columns.Add("imprintname_b079", typeof(string));
dt_Harlequin.Columns.Add("SalesRightsTypeCode_b089", typeof(string));
dt_Harlequin.Columns.Add("RightsCountry_b090", typeof(string));
dt_Harlequin.Columns.Add("RightsTerritory_b388", typeof(string));
dt_Harlequin.Columns.Add("PageCount_b061", typeof(string));
dt_Harlequin.Columns.Add("NotForSale", typeof(string));
dt_Harlequin.Columns.Add("onix_Version", typeof(string));
//dt_Harlequin.Columns.Add("b211", typeof(string));
dt_Harlequin.Columns.Add("EditionNumber_b057", typeof(string));
dt_Harlequin.Columns.Add("ClassTrade_j149", typeof(string));
dt_Harlequin.Columns.Add("CountryCode_b251", typeof(string));
dt_Harlequin.Columns.Add("BISAC_b067", typeof(string));
dt_Harlequin.Columns.Add("Bisac_pubspecific2_b191", typeof(string));
dt_Harlequin.Columns.Add("Bisac_pubspecific2_b069", typeof(string));
dt_Harlequin.Columns.Add("DigitalFormat_b213", typeof(string));
#endregion
dt_Harlequin = Process_Harlequin(fileInfo_1, dt_Harlequin);
}
public DataTable Process_Harlequin(ONIXmessage fileInfo_1, DataTable dt_Harlequin)
{
for (int i = 0; i < fileInfo_1.obj_product_List.Count; i++)
{
DataRow dr = dt_Harlequin.NewRow();
dr["FileName"] = fileInfo_1.obj_FileInfo_List[0].FileName_FileInfo;
dr["pubId"] = fileInfo_1.obj_FileInfo_List[0].PubID_FileInfo;
dr["FileType"] = fileInfo_1.obj_FileInfo_List[0].FileType_FileInfo;
#region 'ISBN_b244'
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_product_productidentifier_List.Count; a++)
{
if (fileInfo_1.obj_product_List[i].obj_product_productidentifier_List[a].b221_product_productidentifier == "15")
{
dr["ISBN_b244"] = fileInfo_1.obj_product_List[i].obj_product_productidentifier_List[a].b244_product_productidentifier;
break;
}
}
#endregion
#region 'PublisherName_b081'
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_product_publisher_List.Count; a++)
{
dr["PublisherName_b081"] = fileInfo_1.obj_product_List[i].obj_product_publisher_List[a].b081_product_publisher;
}
#endregion
#region 'EbookVersion_b014'
dr["EbookVersion_b014"] = "";
#endregion
#region 'Title_b203 - logic in sp; SubTitle_b029'
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_product_title_List.Count; a++)
{
if (fileInfo_1.obj_product_List[i].obj_product_title_List[a].b202_product_title == "01")
{
dr["Title_b203"] = fileInfo_1.obj_product_List[i].obj_product_title_List[a].b203_product_title;
dr["SubTitle_b029"] = fileInfo_1.obj_product_List[i].obj_product_title_List[a].b029_product_title;
break;
}
}
#endregion
#region 'UnAbridged_b056'
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_b056_List.Count; a++)
{
dr["UnAbridged_b056"] = fileInfo_1.obj_product_List[i].obj_b056_List[a] + ", ";
}
#endregion
#region 'multiple tags - LanguageCode_b252'
if (fileInfo_1.obj_product_List[i].obj_product_language_List.Count > 1)
{
// Add_DuplicateRow();
}
else
{
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_product_language_List.Count; a++)
{
dr["LanguageCode_b252"] = fileInfo_1.obj_product_List[i].obj_product_language_List[a].b252_product_language;
}
}
#endregion
#region 'Bisac'
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_product_subject_List.Count; a++)
{
if (fileInfo_1.obj_product_List[i].obj_product_subject_List[a].b067_product_subject != "10")
{
}
else
{
dr["BISAC_b064"] += fileInfo_1.obj_product_List[i].obj_product_subject_List[a].b069_product_subject + ";";
}
}
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_product_mainsubject_List.Count; a++)
{
if (fileInfo_1.obj_product_List[i].obj_product_mainsubject_List[a].b069_product_mainsubject.Length > 0)
{
dr["BISAC_b064"] += fileInfo_1.obj_product_List[i].obj_product_mainsubject_List[a].b069_product_mainsubject + ";";
}
}
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_b064_List.Count; a++)
{
if (fileInfo_1.obj_product_List[i].obj_b064_List[a].Length > 0)
{
dr["BISAC_b064"] += fileInfo_1.obj_product_List[i].obj_b064_List[a] + ";";
}
}
#endregion
// BISAC_b064,
// BISAC_b067,
// Bisac_Pubspecific_b069,
// Bisac_pubspecific2_b069,
// --BISAC_b070,
// Bisac_pubspecific2_b191
//update #Bisac set Bisac_Pubspecific_b069 = '' where BISAC_b067 != '10'
#region 'ReleaseDate - ReleaseDate2_j143 - ReleaseDate1_b003'
for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_product_supplydetail_List.Count; a++)
{
dr["ReleaseDate2_j143"] = fileInfo_1.obj_product_List[i].obj_b056_List[a] + ", ";
}
#endregion
#region 'ISBN_b244'
//for (int a = 0; a < fileInfo_1.obj_product_List[i].obj_product_productidentifier_List.Count; a++)
//{
// if (fileInfo_1.obj_product_List[i].obj_product_productidentifier_List[a].b221_product_productidentifier == "15")
// {
// dr["ISBN_b244"] = fileInfo_1.obj_product_List[i].obj_product_productidentifier_List[a].b244_product_productidentifier;
// break;
// }
//}
#endregion
dt_Harlequin.Rows.Add(dr);
}
#region 'Unwanted'
//dt_Harlequin.Columns.Add("UniquePubIdentifier_a001", typeof(string));
//dt_Harlequin.Columns.Add("NotificationType_a002", typeof(string));
//dt_Harlequin.Columns.Add("TitlePrefix_b030", typeof(string));
//dt_Harlequin.Columns.Add("TitleWithoutPrefix_b031", typeof(string));
//dt_Harlequin.Columns.Add("UnAbridged_2_b056", typeof(string));
//dt_Harlequin.Columns.Add("ReleaseDate3_j161", typeof(string));
//dt_Harlequin.Columns.Add("PriceQualifier", typeof(string));
//dt_Harlequin.Columns.Add("b064_rank", typeof(string));
//dt_Harlequin.Columns.Add("b069_rank", typeof(string));
//dt_Harlequin.Columns.Add("b070_rank", typeof(string));
//dt_Harlequin.Columns.Add("parent_publishername", typeof(string));
//dt_Harlequin.Columns.Add("LibraryPrice_j151_CAD", typeof(string));
//dt_Harlequin.Columns.Add("RetailPrice", typeof(string));
//dt_Harlequin.Columns.Add("ContributorSequenceWithinRole_b340", typeof(string));
#endregion
#region 'Commented'
//dt_Harlequin.Columns.Add("AgeGroup_b073", typeof(string));
//dt_Harlequin.Columns.Add("Genre", typeof(string));
//dt_Harlequin.Columns.Add("Fiction", typeof(string));
//dt_Harlequin.Columns.Add("Children", typeof(string));
//dt_Harlequin.Columns.Add("PrintBookPubDate", typeof(string));
//dt_Harlequin.Columns.Add("PersonNameType_b250", typeof(string));
//dt_Harlequin.Columns.Add("UnknownAnonymous_b249", typeof(string));
//dt_Harlequin.Columns.Add("n339", typeof(string));
//dt_Harlequin.Columns.Add("CDCount_b210", typeof(string));
//dt_Harlequin.Columns.Add("IsExclusive_Flag", typeof(string));
//dt_Harlequin.Columns.Add("Royalty_Flag", typeof(string));
//dt_Harlequin.Columns.Add("IsMARC_Flag", typeof(string));
//dt_Harlequin.Columns.Add("TotalRunTime_Code_b218", typeof(string));
//dt_Harlequin.Columns.Add("TotalRunTime_b219", typeof(string));
//dt_Harlequin.Columns.Add("TotalRunTime_Unit_b220", typeof(string));
//dt_Harlequin.Columns.Add("InsertedOn", typeof(string));
dt_Harlequin.Columns.Add("SeriesName_b233", typeof(string));
dt_Harlequin.Columns.Add("SeriesPositionNumber", typeof(string));
dt_Harlequin.Columns.Add("SeriesTotalNumber", typeof(string));
//dt_Harlequin.Columns.Add("SeriesID_b273", typeof(string));
//dt_Harlequin.Columns.Add("DistributionTerritory", typeof(string));
//dt_Harlequin.Columns.Add("BeginRightsDate", typeof(string));
//dt_Harlequin.Columns.Add("EndRightsDate", typeof(string));
//dt_Harlequin.Columns.Add("MetadataType", typeof(string));
//dt_Harlequin.Columns.Add("ChapterCount", typeof(string));
// dt_Harlequin.Columns.Add("Notes", typeof(string));
// dt_Harlequin.Columns.Add("LibraryAccountID", typeof(string));
// dt_Harlequin.Columns.Add("SKUNumber", typeof(string));
// dt_Harlequin.Columns.Add("Awards", typeof(string));
// dt_Harlequin.Columns.Add("ReligiousText_Bible", typeof(string));
// dt_Harlequin.Columns.Add("AbstractText", typeof(string));
//dt_Harlequin.Columns.Add("Epilogue", typeof(string));
//dt_Harlequin.Columns.Add("ContentRating", typeof(string));
//dt_Harlequin.Columns.Add("Imprints", typeof(string));
//dt_Harlequin.Columns.Add("OriginalLanguage", typeof(string));
//dt_Harlequin.Columns.Add("Keywords", typeof(string));
//dt_Harlequin.Columns.Add("TargetAudience", typeof(string));
//dt_Harlequin.Columns.Add("MediaFormat", typeof(string));
//dt_Harlequin.Columns.Add("MediaQuality", typeof(string));
//dt_Harlequin.Columns.Add("Review", typeof(string));
//dt_Harlequin.Columns.Add("IsSingleUse", typeof(string));
//dt_Harlequin.Columns.Add("IsMultiUse", typeof(string));
//dt_Harlequin.Columns.Add("IsActive", typeof(string));
//dt_Harlequin.Columns.Add("IsRenewed", typeof(string));
//dt_Harlequin.Columns.Add("IsDownloadable", typeof(string));
//dt_Harlequin.Columns.Add("IsTransferableRetail", typeof(string));
//dt_Harlequin.Columns.Add("ISBurnableRetail", typeof(string));
//dt_Harlequin.Columns.Add("IsTransferableLibrary", typeof(string));
//dt_Harlequin.Columns.Add("IsBurnableLibrary", typeof(string));
//dt_Harlequin.Columns.Add("MarcFileContent", typeof(string));
//dt_Harlequin.Columns.Add("MarcTagValueText", typeof(string));
//dt_Harlequin.Columns.Add("Agent", typeof(string));
//dt_Harlequin.Columns.Add("BookCopyright", typeof(string));
//dt_Harlequin.Columns.Add("RecordingCopyright", typeof(string));
//dt_Harlequin.Columns.Add("CreationDate", typeof(string));
//dt_Harlequin.Columns.Add("CreatedBy", typeof(string));
//dt_Harlequin.Columns.Add("LastModified", typeof(string));
//dt_Harlequin.Columns.Add("FilePath", typeof(string));
//dt_Harlequin.Columns.Add("ReviewComments", typeof(string));
//dt_Harlequin.Columns.Add("TL_Subject", typeof(string));
//dt_Harlequin.Columns.Add("TL_DRM_Type", typeof(string));
//dt_Harlequin.Columns.Add("TL_TitleMain", typeof(string));
//dt_Harlequin.Columns.Add("TL_TitlePrefix", typeof(string));
//dt_Harlequin.Columns.Add("TL_MediaType", typeof(string));
//dt_Harlequin.Columns.Add("Audio_Exist_Flag", typeof(string));
//dt_Harlequin.Columns.Add("TitleID", typeof(string));
//dt_Harlequin.Columns.Add("isRuntimeProcessed", typeof(string));
//dt_Harlequin.Columns.Add("AudioBook_x416", typeof(string));
//dt_Harlequin.Columns.Add("AudioBook_b385", typeof(string));
//dt_Harlequin.Columns.Add("EpubType_b211", typeof(string));
//dt_Harlequin.Columns.Add("DRMFlag_x317", typeof(string));
//dt_Harlequin.Columns.Add("UsageType_x318", typeof(string));
//dt_Harlequin.Columns.Add("UsageStatus_x319", typeof(string));
//dt_Harlequin.Columns.Add("UsageQuantity_x320", typeof(string));
//dt_Harlequin.Columns.Add("CreatedBy", typeof(string));
//dt_Harlequin.Columns.Add("UsageUnit_b321", typeof(string));
//dt_Harlequin.Columns.Add("Series_TitleElementLevel", typeof(string));
//dt_Harlequin.Columns.Add("Title_TitleElementLevel", typeof(string));
//dt_Harlequin.Columns.Add("TitleSuffix", typeof(string));
//dt_Harlequin.Columns.Add("ROWSalesRightsType_referencecode", typeof(string));
//dt_Harlequin.Columns.Add("SalesRestriction_b383", typeof(string));
#endregion
return(dt_Harlequin);
}
