public bool TestDatabaseConnection()
{
string connectionString = Util.GetOracleConnectionString(ConfigurationManager.AppSettings["VTLDB_Host"], ConfigurationManager.AppSettings["VTLDB_UserName"], ConfigurationManager.AppSettings["VTLDB_Pwd"]);
VTLDBManagerOracle VTLManOracle = new VTLDBManagerOracle(connectionString);
return(VTLManOracle.TestDatabaseConnection());
}
public void RemoveDataSet(string dataset_ID, string dataset_Agency, string dataset_Version)
{
try
{
string connectionString = Util.GetOracleConnectionString(ConfigurationManager.AppSettings["VTLDB_Host"], ConfigurationManager.AppSettings["VTLDB_UserName"], ConfigurationManager.AppSettings["VTLDB_Pwd"]);
VTLDBManagerOracle VTLManOracle = new VTLDBManagerOracle(connectionString);
VTLManOracle.RemoveDataSet(dataset_ID, dataset_Agency, dataset_Version);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new SoapException(ex.Message, new System.Xml.XmlQualifiedName(), ex);
}
}
public string InsertDataSet(string ref_dsd_ID, string ref_dsd_Agency, string ref_dsd_Version, string dataset_id, string dataset_agency, string dataset_version, LocalizedValue[] dataset_names, BaseComponentInfo[] dsd_componentList, int creationType)
{
try
{
string connectionString = Util.GetOracleConnectionString(ConfigurationManager.AppSettings["VTLDB_Host"], ConfigurationManager.AppSettings["VTLDB_UserName"], ConfigurationManager.AppSettings["VTLDB_Pwd"]);
VTLDBManagerOracle VTLManOracle = new VTLDBManagerOracle(connectionString);
return(VTLManOracle.InsertDataSet(ref_dsd_ID, ref_dsd_Agency, ref_dsd_Version, dataset_id, dataset_agency, dataset_version, dataset_names, dsd_componentList, creationType));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new SoapException(ex.Message, new System.Xml.XmlQualifiedName(), ex);
}
}
public bool InsertValueDomainSubset(string ValueDomainSubsetID, string ValueDomainSubsetAgency, string ValueDomainSubsetVersion, string ref_ValueDomainID, string ref_ValueDomainAgency, string ref_ValueDomainVersion, LocalizedValue[] names, int[] valueList, int creationType)
{
try
{
string connectionString = Util.GetOracleConnectionString(ConfigurationManager.AppSettings["VTLDB_Host"], ConfigurationManager.AppSettings["VTLDB_UserName"], ConfigurationManager.AppSettings["VTLDB_Pwd"]);
VTLDBManagerOracle VTLManOracle = new VTLDBManagerOracle(connectionString);
return(VTLManOracle.InsertValueDomainSubset(ValueDomainSubsetID, ValueDomainSubsetAgency, ValueDomainSubsetVersion, ref_ValueDomainID, ref_ValueDomainAgency, ref_ValueDomainVersion, names, valueList, creationType));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new SoapException(ex.Message, new System.Xml.XmlQualifiedName(), ex);
}
}
public string InsertValueDomainDescribed(string ValueDomainID, string ValueDomainAgency, string ValueDomainVersion, LocalizedValue[] names, string valueRestriction, bool check_presence, int creationType, VTL_Model.VTL_DATATYPE data_type = VTL_Model.VTL_DATATYPE.String)
{
try
{
string connectionString = Util.GetOracleConnectionString(ConfigurationManager.AppSettings["VTLDB_Host"], ConfigurationManager.AppSettings["VTLDB_UserName"], ConfigurationManager.AppSettings["VTLDB_Pwd"]);
VTLDBManagerOracle VTLManOracle = new VTLDBManagerOracle(connectionString);
return(VTLManOracle.InsertValueDomainDescribed(ValueDomainID, ValueDomainAgency, ValueDomainVersion, names, valueRestriction, check_presence, creationType, data_type));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new SoapException(ex.Message, new System.Xml.XmlQualifiedName(), ex);
}
}
public void RemoveUserDefinedOperator(string operatorName)
{
try
{
string connectionString = Util.GetOracleConnectionString(ConfigurationManager.AppSettings["VTLDB_Host"], ConfigurationManager.AppSettings["VTLDB_UserName"], ConfigurationManager.AppSettings["VTLDB_Pwd"]);
VTLDBManagerOracle VTLManOracle = new VTLDBManagerOracle(connectionString);
VTLManOracle.RemoveUserDefinedOperator(operatorName);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new SoapException(ex.Message, new System.Xml.XmlQualifiedName(), ex);
}
}
public bool InsertUserDefinedOperator(string Operator_ID, string body, int operator_type)
{
try
{
string connectionString = Util.GetOracleConnectionString(ConfigurationManager.AppSettings["VTLDB_Host"], ConfigurationManager.AppSettings["VTLDB_UserName"], ConfigurationManager.AppSettings["VTLDB_Pwd"]);
VTLDBManagerOracle VTLManOracle = new VTLDBManagerOracle(connectionString);
return(VTLManOracle.InsertUserDefinedOperator(Operator_ID, body, operator_type));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new SoapException(ex.Message, new System.Xml.XmlQualifiedName(), ex);
}
}
public void InsertTransformation(string trasformationID, string agency, string version, string trasformationText, string clearedAndOrderedStatements)
{
try
{
string connectionString = Util.GetOracleConnectionString(ConfigurationManager.AppSettings["VTLDB_Host"], ConfigurationManager.AppSettings["VTLDB_UserName"], ConfigurationManager.AppSettings["VTLDB_Pwd"]);
VTLDBManagerOracle VTLManOracle = new VTLDBManagerOracle(connectionString);
VTLManOracle.InsertTransformation(trasformationID, agency, version, trasformationText, clearedAndOrderedStatements);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new SoapException(ex.Message, new System.Xml.XmlQualifiedName(), ex);
}
}
