/// <summary>
/// Uses the Select all data stored procedure to collect all ware information in the database.
/// </summary>
/// <returns>Returns all information of all wares in the database as a list of lists of strings.</returns>
/// <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 <List <string> > GetAllInformation()
{
string sqlString =
"EXEC SelectAllData;";
try {
return(SQLControl.GetValuesMultiWares(sqlString));
}
catch (Exception e)
{
//StorageSystemCore.Reporter.Report(e);
//Console.WriteLine($"Could not get information: {e.Message}");
//StorageSystemCore.Support.WaitOnKeyInput();
//return null;
throw e;
}
}
/// <summary>
/// Not Working as MSSQL thinks @Column is the column name. Uses the Select partly data procedure to collect the data in <paramref name="columns"/> of all wares in the database.
/// </summary>
/// <param name="columns"></param>
/// <returns>Returns information from <paramref name="columns"/> of all wares in the database as a list of lists of strings.</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 <List <string> > GetPartlyInformation(string columns)
{
if (columns == null)
{
throw new NullReferenceException();
}
string sqlString =
$"EXEC SelectPartlyData @Columns = {columns};";
try
{
return(SQLControl.GetValuesMultiWares(sqlString));
}
catch (Exception e)
{
//StorageSystemCore.Reporter.Report(e);
//Console.WriteLine($"Could not get information: {e.Message}");
//StorageSystemCore.Support.WaitOnKeyInput();
//return null;
throw e;
}
}