public static List <DistributionCentreStock> getMockedDistributionCentreStock()
{
List <DistributionCentreStock> stockList = new List <DistributionCentreStock>();
DistributionCentreStock s1 = new DistributionCentreStock();
s1.DistributionCenterName = "CentreA";
s1.DistributionCentreId = 1;
s1.CostPerPackage = 44;
s1.NumberOfPackages = 5;
s1.PackageTypeId = 4;
s1.TotalValue = 145;
DistributionCentreStock s2 = new DistributionCentreStock();
s2.DistributionCenterName = "CentreB";
s2.DistributionCentreId = 2;
s2.CostPerPackage = 34;
s2.NumberOfPackages = 15;
s2.PackageTypeId = 3;
s2.TotalValue = 245;
DistributionCentreStock s3 = new DistributionCentreStock();
s3.DistributionCenterName = "CentreC";
s3.DistributionCentreId = 3;
s3.CostPerPackage = 14;
s3.NumberOfPackages = 12;
s3.PackageTypeId = 1;
s3.TotalValue = 45;
stockList.Add(s1); stockList.Add(s2); stockList.Add(s3);
return(stockList);
}
public List <DistributionCentreStock> GetDistributionCentreStock()
{
var stockList = new List <DistributionCentreStock>();
var stock = new DistributionCentreStock()
{
PackageTypeId = 1,
PackageTypeDescription = "100 Panadol Tablets",
CostPerPackage = 10,
DistributionCentreId = 1,
DistributionCenterName = "North Centre",
NumberOfPackages = 2,
TotalValue = 20
};
stockList.Add(stock);
return(stockList);
}
/// <summary>
/// Query for Distribution Centre Stock Report
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
public static List <DistributionCentreStock> GetDistributionCentreStock(SqlConnection connection)
{
var stockList = new List <DistributionCentreStock>();
string query = "select PackageTypeId, PackageTypeDescription, CostPerPackage, DistributionCentreId, DistributionCenterName, NumberOfPackages, TotalValue from DistributionCentreStock order by DistributionCentreId, PackageTypeId";
var cmd = new SqlCommand(query);
cmd.Connection = connection;
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default))
{
while (reader.Read())
{
var stock = new DistributionCentreStock();
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["DistributionCentreId"] != DBNull.Value)
{
stock.DistributionCentreId = Convert.ToInt32(reader["DistributionCentreId"]);
}
if (reader["DistributionCenterName"] != DBNull.Value)
{
stock.DistributionCentreName = (string)reader["DistributionCenterName"];
}
if (reader["NumberOfPackages"] != DBNull.Value)
{
stock.NumberOfPackages = Convert.ToInt32(reader["NumberOfPackages"]);
}
if (reader["TotalValue"] != DBNull.Value)
{
stock.TotalValue = Convert.ToDecimal(reader["TotalValue"]);
}
stockList.Add(stock);
}
}
return(stockList);
}
public string CentreStockToString(DistributionCentreStock s)
{
return("C_Id:" + s.DistributionCentreId + " / CentreName:" + s.DistributionCenterName + " / T_Id:" + s.PackageTypeId + " / TypeDesc:" + s.PackageTypeDescription + " / NumbOfPs:" + s.NumberOfPackages + " / Value:" + s.TotalValue);
}
