/// <summary>
/// public method accepting queryName and returning object ready to be setup via interface methods
/// </summary>
/// <param name="queryName">queryName</param>
/// <returns>ISQLFlexible</returns>
public static ISQLFlexible GetQuery(SQLStatic queryName)
{
string queryText;
switch (queryName)
{
case SQLStatic.GetReleaseNotes:
queryText = GetReleaseNotes;
break;
case SQLStatic.CountPipesWeldInformation:
queryText = CountPipesWeldInformation;
break;
case SQLStatic.GetAllProducedPipesByDate:
queryText = GetAllProducedPipesByDate;
break;
case SQLStatic.CountPipesInformation:
queryText = CountPipesInformation;
break;
case SQLStatic.GetAllActivePipesByDate:
queryText = GetAllActivePipesByDate;
break;
case SQLStatic.GetAllShipped:
queryText = GetAllShipped;
break;
case SQLStatic.GetAllProduced:
queryText = GetAllProduced;
break;
case SQLStatic.GetPipelinePieces:
queryText = GetPipelinePieces;
break;
case SQLStatic.GetAllPipesFromInspection:
queryText = GetAllPipesFromInspection;
break;
case SQLStatic.GetWeldedParts:
queryText = GetWeldedParts;
break;
case SQLStatic.GetPipeByParametersPieces:
queryText = GetPipeByParametersPieces;
break;
case SQLStatic.GetJointsByDate:
queryText = GetJointsByDate;
break;
default:
queryText = "";
break;
}
return(new SQLFlexible(queryText));
}
/// <summary>
/// public method accepting queryName and returning object ready to be setup via interface methods
/// </summary>
/// <param name="queryName">queryName</param>
/// <returns>ISQLFlexible</returns>
public static ISQLFlexible GetQuery(SQLStatic queryName)
{
string queryText;
switch (queryName)
{
case SQLStatic.GetReleaseNotes:
queryText = GetReleaseNotes;
break;
case SQLStatic.CountPipesWeldInformation:
queryText = CountPipesWeldInformation;
break;
case SQLStatic.GetAllProducedPipesByDate:
queryText = GetAllProducedPipesByDate;
break;
case SQLStatic.CountPipesInformation:
queryText = CountPipesInformation;
break;
case SQLStatic.GetAllActivePipesByDate:
queryText = GetAllActivePipesByDate;
break;
case SQLStatic.GetAllShipped:
queryText = GetAllShipped;
break;
case SQLStatic.GetAllProduced:
queryText = GetAllProduced;
break;
case SQLStatic.GetPipelinePieces:
queryText = GetPipelinePieces;
break;
case SQLStatic.GetAllPipesFromInspection:
queryText = GetAllPipesFromInspection;
break;
case SQLStatic.GetWeldedParts:
queryText = GetWeldedParts;
break;
case SQLStatic.GetPipeByParametersPieces:
queryText = GetPipeByParametersPieces;
break;
case SQLStatic.GetJointsByDate:
queryText = GetJointsByDate;
break;
default:
queryText = "";
break;
}
return new SQLFlexible(queryText);
}
