/// <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; } }