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