/// <summary>
/// Verifies that the sql script files are set to EmbeddedResource build action
/// </summary>
/// <param name="result"></param>
/// <param name="fileName"></param>
/// <returns></returns>
TaskResult VerifyEmbeddedResource(TaskResult result, string fileName)
{
try
{
var fileContent = File.ReadAllText(UpgradeProjectVbProjectFile);
var targetFileName = Path.GetFileName(fileName);
//var targetFileLine = String.Format(@"xxx", 0, 1, 2, 3);
var targetFileLine = String.Format("<EmbeddedResource Include=\"{0}.{1}\\{0}.{1}.{2}\\{3}\" />", PendingDbVersion.Major, PendingDbVersion.Minor, PendingDbVersion.Build, targetFileName);
//<EmbeddedResource Include="16.4\16.4.5\NotifyEventTypes.16.4.5.sql" />
//<EmbeddedResource Include="{0}.{1}\{0}.{1}.{2}\{3}" />
if (fileContent.Contains(targetFileLine))
{
var newFileLine = String.Format("<EmbeddedResource Include=\"{0}.{1}\\{0}.{1}.{2}\\{3}\" />", NewDbVersion.Major, NewDbVersion.Minor, NewDbVersion.Build, targetFileName);
fileContent = fileContent.Replace(targetFileLine, newFileLine);
File.WriteAllText(UpgradeProjectVbProjectFile, fileContent);
}
else
{
result.AddError(String.Format("{0} is not set as an embedded resource!", targetFileName));
}
}
catch (Exception ex)
{
result.AddException(ex);
}
return(result);
}
/// <summary>
/// Validates the version number increment.
/// </summary>
/// <param name="result"></param>
/// <returns></returns>
TaskResult ValidateVersionIncrement(TaskResult result)
{
try
{
if (CurrentDbVersion.Major != VersionFileVersion.Major || CurrentDbVersion.Minor != VersionFileVersion.Minor || CurrentDbVersion.Build != VersionFileVersion.Build)
{
result.AddError("Version file and AdvUpgrade project out of sync!");
}
}
catch (Exception ex)
{
result.AddException(ex);
}
return(result);
}
