/// <summary>
/// Deprecated Method for adding a new object to the TreetyMetadatas EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToTreetyMetadatas(TreetyMetadata treetyMetadata)
{
base.AddObject("TreetyMetadatas", treetyMetadata);
}
/// <summary>
/// Create a new TreetyMetadata object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="hostCountryId">Initial value of the HostCountryId property.</param>
/// <param name="partnerCountryId">Initial value of the PartnerCountryId property.</param>
/// <param name="fileTypeName">Initial value of the FileTypeName property.</param>
public static TreetyMetadata CreateTreetyMetadata(global::System.Int32 id, global::System.Int32 hostCountryId, global::System.Int32 partnerCountryId, global::System.String fileTypeName)
{
TreetyMetadata treetyMetadata = new TreetyMetadata();
treetyMetadata.Id = id;
treetyMetadata.HostCountryId = hostCountryId;
treetyMetadata.PartnerCountryId = partnerCountryId;
treetyMetadata.FileTypeName = fileTypeName;
return treetyMetadata;
}
private void UpdateConceptAndArticle(UnitOfWork work, DataRow row, TreetyMetadata treatyMetadata, List<PublisherStatus> publisherStatus)
{
//var concept = GetConcept(treatyMetadata, row);
//Add To DB
//var article = GetArticle(treatyMetadata, row);
var treatyArticleConceptMetadata = GetArticleConceptMetadata(treatyMetadata, row);
var repository = RepositoryContainer.GetRepository<TreetyArticleMetadata>(work);
var dbTacMetadata =
repository.Filter(
c => c.TreetyMetadataId == treatyMetadata.Id &&
c.ConceptId == treatyArticleConceptMetadata.ConceptId &&
c.ArticleId == treatyArticleConceptMetadata.ArticleId).FirstOrDefault();
if (dbTacMetadata == null)
{
//Add To DB
if (string.IsNullOrWhiteSpace(treatyArticleConceptMetadata.ArticleId))
{
if(!string.IsNullOrWhiteSpace(treatyArticleConceptMetadata.ConceptId))
{
publisherStatus.Add(new PublisherStatus()
{
Status = false,
Message = string.Format("Article ID not found for Concept [{0}]", treatyArticleConceptMetadata.Concept)
});
}
}
else
{
repository.Add(treatyArticleConceptMetadata);
}
}
else
{
//Update
dbTacMetadata.ArticleContent = treatyArticleConceptMetadata.ArticleContent;
dbTacMetadata.ArticleNo = treatyArticleConceptMetadata.ArticleNo;
dbTacMetadata.ArticleTitle = treatyArticleConceptMetadata.ArticleTitle;
dbTacMetadata.Concept = treatyArticleConceptMetadata.Concept;
}
}
private void RetriveTreatyMetadata(string sheetName, TreetyMetadata treatyMetadata, DataRowCollection rows,
List<PublisherStatus> publisherStatus)
{
int rowStartCount = Convert.ToInt32(ConfigurationManager.AppSettings["ExcelRowStartIndex"]);
var hostCountryCode = rows[rowStartCount].ItemArray[1].ToString();
var hostCountry = _countries.FirstOrDefault(c => c.Code == hostCountryCode);
if (hostCountry == null)
{
publisherStatus.Add(new PublisherStatus
{
Status = false,
Message = string.Format("Host Country Code not found in sheet {0}.", sheetName)
});
}
var partnerCountryCode = rows[rowStartCount + 2].ItemArray[1].ToString();
var partnerCountry = _countries.FirstOrDefault(c => c.Code == partnerCountryCode);
if (partnerCountry == null)
{
publisherStatus.Add(new PublisherStatus
{
Status = false,
Message = string.Format("Partner Country Code not found in sheet {0}.", sheetName)
});
}
if (hostCountry != null && partnerCountry != null)
{
var countryPair = TreatyCountryPair.GetPairCountries(hostCountry.Id, partnerCountry.Id, _countries);
treatyMetadata.HostCountryId = countryPair[0].Id;
treatyMetadata.PartnerCountryId = countryPair[1].Id;
}
var forceUpdate = rows[rowStartCount].ItemArray[3].ToString().Trim().ToLower() == "forceupdate";
if (CanPublishTreatyData(treatyMetadata.HostCountryId, treatyMetadata.PartnerCountryId, forceUpdate) == false)
{
publisherStatus.Add(new PublisherStatus
{
Status = false,
Message = string.Format("This data will not published as already published for this countries.Ref Sheet {0}.", sheetName)
});
}
treatyMetadata.Title = rows[rowStartCount + 3].ItemArray[1].ToString();
treatyMetadata.Title = GetSentenceCase(treatyMetadata.Title);
treatyMetadata.TitleId = rows[rowStartCount + 3].ItemArray[2].ToString();
if (string.IsNullOrWhiteSpace(treatyMetadata.TitleId))
{
publisherStatus.Add(new PublisherStatus
{
Status = false,
Message = string.Format("WARNING! Treaty already exist for this country pair, look in sheet {0}. Use ForceUpdate to update new data.", sheetName)
});
return;
}
byte[] treatyPdf = GetTreatyPdfData(rows[rowStartCount + 3].ItemArray[3].ToString(), publisherStatus, sheetName);
if (treatyPdf != null && treatyPdf.Length > 0)
{
treatyMetadata.TreatyPdf = treatyPdf;
}
treatyMetadata.FileTypeName = "pdf";
treatyMetadata.TreatyLink = rows[rowStartCount + 3].ItemArray[4].ToString().Trim();
treatyMetadata.Status = rows[rowStartCount + 5].ItemArray[0].ToString().Trim();
treatyMetadata.Negotiation = rows[rowStartCount + 5].ItemArray[1].ToString().Trim();
treatyMetadata.Signature = rows[rowStartCount + 5].ItemArray[2].ToString().Trim();
treatyMetadata.Adoption = rows[rowStartCount + 5].ItemArray[3].ToString().Trim();
treatyMetadata.MfnClauses = rows[rowStartCount + 5].ItemArray[4].ToString().Trim();
treatyMetadata.Ratification = rows[rowStartCount + 5].ItemArray[5].ToString().Trim();
treatyMetadata.EffectiveDate = rows[rowStartCount + 5].ItemArray[6].ToString().Trim();
treatyMetadata.EntryIntoForce = rows[rowStartCount + 5].ItemArray[7].ToString().Trim();
treatyMetadata.Reservations = rows[rowStartCount + 5].ItemArray[8].ToString().Trim();
treatyMetadata.Derogations = rows[rowStartCount + 5].ItemArray[9].ToString().Trim();
treatyMetadata.Denunciations = rows[rowStartCount + 5].ItemArray[10].ToString().Trim();
treatyMetadata.AccessionAdherence = rows[rowStartCount + 5].ItemArray[11].ToString().Trim();
treatyMetadata.Interpretations = rows[rowStartCount + 5].ItemArray[12].ToString().Trim();
treatyMetadata.AmendmentProtocol = rows[rowStartCount + 5].ItemArray[13].ToString().Trim();
treatyMetadata.Note = rows[rowStartCount + 5].ItemArray[14].ToString().Trim();
treatyMetadata.DomesticApplication = rows[rowStartCount + 7].ItemArray[0].ToString();
}
private TreetyArticleMetadata GetArticleConceptMetadata(TreetyMetadata treatyMetadata, DataRow row)
{
var tacMetadata = new DataAccess.TreetyArticleMetadata();
tacMetadata.Concept = row.ItemArray[0].ToString();
tacMetadata.ConceptId = row.ItemArray[1].ToString();
tacMetadata.TreetyMetadataId = treatyMetadata.Id;
tacMetadata.ArticleNo = row.ItemArray[2].ToString();
tacMetadata.ArticleTitle = row.ItemArray[3].ToString();
tacMetadata.ArticleContent = row.ItemArray[4].ToString();
tacMetadata.ArticleId = row.ItemArray[5].ToString();
return tacMetadata;
}
private static void UpdateTreatyMetadata(TreetyMetadata treatyMetadata, TreetyMetadata metadata)
{
metadata.Title = treatyMetadata.Title;
metadata.TitleId = treatyMetadata.TitleId;
metadata.Status = treatyMetadata.Status;
metadata.Negotiation = treatyMetadata.Negotiation;
metadata.Signature = treatyMetadata.Signature;
metadata.Adoption = treatyMetadata.Adoption;
metadata.MfnClauses = treatyMetadata.MfnClauses;
metadata.Ratification = treatyMetadata.Ratification;
metadata.EffectiveDate = treatyMetadata.EffectiveDate;
metadata.EntryIntoForce = treatyMetadata.EntryIntoForce;
if (treatyMetadata.TreatyPdf != null && treatyMetadata.TreatyPdf.Length > 0)
{
metadata.TreatyPdf = treatyMetadata.TreatyPdf;
}
metadata.Reservations = treatyMetadata.Reservations;
metadata.Derogations = treatyMetadata.Derogations;
metadata.Denunciations = treatyMetadata.Denunciations;
metadata.AccessionAdherence = treatyMetadata.AccessionAdherence;
metadata.Interpretations = treatyMetadata.Interpretations;
metadata.AmendmentProtocol = treatyMetadata.AmendmentProtocol;
metadata.TreatyLink = treatyMetadata.TreatyLink;
}