/// <summary>
/// Query for Global Stock Report
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
public static List <GlobalStock> GetGlobalStock(SqlConnection connection)
{
string query = "select PackageTypeId, PackageTypeDescription, CostPerPackage, NumberOfPackages, TotalValue " +
"from GlobalStock " +
"order by PackageTypeId";
List <GlobalStock> stocks = new List <GlobalStock>();
var cmd = new SqlCommand(query);
cmd.Connection = connection;
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default))
{
while (reader.Read())
{
var stock = new GlobalStock();
if (reader["PackageTypeId"] != DBNull.Value)
{
stock.PackageTypeId = Convert.ToInt32(reader["PackageTypeId"]);
}
if (reader["PackageTypeDescription"] != DBNull.Value)
{
stock.PackageTypeDescription = (string)reader["PackageTypeDescription"];
}
if (reader["CostPerPackage"] != DBNull.Value)
{
stock.CostPerPackage = Convert.ToDecimal(reader["CostPerPackage"]);
}
if (reader["NumberOfPackages"] != DBNull.Value)
{
stock.NumberOfPackages = Convert.ToInt32(reader["NumberOfPackages"]);
}
if (reader["TotalValue"] != DBNull.Value)
{
stock.TotalValue = Convert.ToDecimal(reader["TotalValue"]);
}
stocks.Add(stock);
}
}
return(stocks);
}
public static List <GlobalStock> getMockedGlobalStock()
{
List <GlobalStock> stockList = new List <GlobalStock>();
GlobalStock g1 = new GlobalStock();
g1.CostPerPackage = 56;
g1.NumberOfPackages = 9;
g1.PackageTypeDescription = "blah blah blah";
g1.PackageTypeId = 2;
g1.TotalValue = 70;
GlobalStock g2 = new GlobalStock();
g2.CostPerPackage = 16;
g2.NumberOfPackages = 2;
g2.PackageTypeDescription = " blah blah";
g2.PackageTypeId = 1;
g2.TotalValue = 50;
stockList.Add(g1); stockList.Add(g2);
return(stockList);
}
public string GlobalStockToString(GlobalStock gs)
{
return("T_Id:" + gs.PackageTypeId + " / T_Description:" + gs.PackageTypeDescription + " / CostPerP:" + gs.CostPerPackage + " / TotValue:" + gs.TotalValue);
}
