/// <summary>
/// This function allows the Remote Data Store to return a baseline definition.
/// </summary>
/// <param name="pBLVersion">The version number of the baseline to look after.</param>
/// <returns>The definition of the baseline already defined in the baselines definitions data store. This baseline is referenced by its versions number.</returns>
public DataContainer mGetBaselineDefinition(string pBLVersion)
{
using (DataTable lBaselineTable = new DataTable("BaselineDefinition"))
{
lBaselineTable.Locale = CultureInfo.InvariantCulture;
lock (_SQLWrapper)
{
_SQLWrapper.mExecuteQuery(String.Format(CultureInfo.InvariantCulture, "SELECT * FROM {0} WHERE BaselineVersion == '{1}'", _baselinesDataStore, pBLVersion), lBaselineTable);
}
DataContainer lBLContainer = new DataContainer();
lBLContainer.initFromDataTable(lBaselineTable);
return(lBLContainer);
}
}
/// <summary>
/// This function allows the Remote Data Store to return the baselines definitions list.
/// </summary>
/// <returns>The list of baselines already defined in the baselines definitions data store, an empty list when no baselines are defined in the baselines definitions data store.</returns>
public DataContainer mGetBaselinesDefinitions()
{
using (DataTable lBaselinesTable = new DataTable("BaselinesDefinitions"))
{
lBaselinesTable.Locale = CultureInfo.InvariantCulture;
lock (_SQLWrapper)
{
_SQLWrapper.mExecuteQuery(String.Format(CultureInfo.InvariantCulture, "SELECT * FROM {0}", _baselinesDataStore), lBaselinesTable);
}
DataContainer lBLContainer = new DataContainer();
lBLContainer.initFromDataTable(lBaselinesTable);
return(lBLContainer);
}
}
/// <summary>
/// Return a data package depending of type and version.
/// </summary>
/// <param name="pDPType">the data package type.</param>
/// <param name="pDPVersion">the data package version.</param>
/// <returns>The data package.</returns>
public DataContainer mGetDataPackageCharacteristics(string pDPType, string pDPVersion)
{
using (DataTable lDataPackageTable = new DataTable("DataPackageCharacteristics"))
{
lDataPackageTable.Locale = CultureInfo.InvariantCulture;
lock (_SQLWrapper)
{
_SQLWrapper.mExecuteQuery(String.Format(CultureInfo.InvariantCulture, "SELECT DataPackageType, DataPackageVersion, DataPackagePath FROM {0} WHERE DataPackageType == '{1}' AND DataPackageVersion == '{2}'", _dataPackagesDataStore, pDPType, pDPVersion), lDataPackageTable);
}
DataContainer lDPCharCont = new DataContainer();
lDPCharCont.initFromDataTable(lDataPackageTable);
return(lDPCharCont);
}
}
/// <summary>
/// Returns the list of all data packages from Remote Data Store.
/// </summary>
/// <returns>The data packages list.</returns>
public DataContainer mGetDataPackagesList()
{
using (DataTable lDataPackageTable = new DataTable("DataPackagesVersionsList"))
{
lDataPackageTable.Locale = CultureInfo.InvariantCulture;
lock (_SQLWrapper)
{
_SQLWrapper.mExecuteQuery(String.Format(CultureInfo.InvariantCulture, "SELECT DataPackageType, DataPackageVersion, DataPackagePath FROM {0}", _dataPackagesDataStore), lDataPackageTable);
}
DataContainer lDPCharCont = new DataContainer();
lDPCharCont.initFromDataTable(lDataPackageTable);
return(lDPCharCont);
}
}
/// <summary>
/// This function allows the Remote Data Store to return the assigned baselines versions.
/// </summary>
/// <returns>The assigned baselines versions.</returns>
public DataContainer mGetAssignedBaselinesVersions()
{
using (DataTable lAssignedBaselinesVersionTable = new DataTable("BaselinesVersions"))
{
lAssignedBaselinesVersionTable.Locale = CultureInfo.InvariantCulture;
lock (_SQLWrapper)
{
string lSqlCommand = "SELECT ElementID, AssignedCurrentBaseline, AssignedFutureBaseline FROM {0} WHERE " +
"AssignedCurrentBaseline IS NOT NULL OR " +
"AssignedFutureBaseline IS NOT NULL";
_SQLWrapper.mExecuteQuery(String.Format(CultureInfo.InvariantCulture, lSqlCommand, _elementsDataStore), lAssignedBaselinesVersionTable);
}
DataContainer lBLContainer = new DataContainer();
lBLContainer.initFromDataTable(lAssignedBaselinesVersionTable);
return(lBLContainer);
}
}
