/// <summary>
/// Not Working as MSSQL thinks @Column is the column name. Uses the select part values from one ware stored procedure to retive the information(s) of <paramref name="columns"/> of the ware with <paramref name="id"/>.
/// </summary>
/// <param name="id">The ID of the ware to collect information from. </param>
/// <param name="columns">The column(s) to get information(s) from. </param>
/// <returns>Returns a list of strings, each string containg a column of data.</returns>
/// <exception cref="NullReferenceException"></exception>
/// <exception cref="InvalidCastException"></exception>
/// <exception cref="SqlException"></exception>
/// <exception cref="InvalidOperationException"></exception>
/// <exception cref="System.IO.IOException"></exception>
/// <exception cref="ObjectDisposedException"></exception>
public static List <string> GetPartlyInformationFromOneWareSP(string id, string columns)
{
if (id == null || columns == null)
{
throw new NullReferenceException();
}
string sqlString =
$"EXEC SelectPartValuesFromOneWare @WareID = {id}, @Columns = {columns};";
try {
return(SQLControl.GetValuesSingleWare(sqlString));
}
catch (Exception e)
{
//StorageSystemCore.Reporter.Report(e);
//Console.WriteLine($"Could not get information: {e.Message}");
//StorageSystemCore.Support.WaitOnKeyInput();
//return null;
throw e;
}
}
/// <summary>
/// Uses the get type storage procedure to retrive the type of <paramref name="id"/>.
/// </summary>
/// <param name="id">The ware id to retrive the type of</param>
/// <returns>Returns the type of <paramref name="id"/> in a string list.</returns>
/// <exception cref="NullReferenceException"></exception>
/// <exception cref="InvalidCastException"></exception>
/// <exception cref="SqlException"></exception>
/// <exception cref="InvalidOperationException"></exception>
/// <exception cref="System.IO.IOException"></exception>
/// <exception cref="ObjectDisposedException"></exception>
public static List <string> GetTypeSP(string id)
{
if (id == null)
{
throw new NullReferenceException();
}
string sqlString =
$"EXEC FindWareType @WareID = {id};";
try
{
return(SQLControl.GetValuesSingleWare(sqlString));
}
catch (Exception e)
{
throw e;
//StorageSystemCore.Reporter.Report(e);
//Console.WriteLine($"Could not find the type: {e.Message}");
//StorageSystemCore.Support.WaitOnKeyInput();
//return null;
}
}