/// <summary>
/// Query for Stocktaking Report
/// </summary>
/// <param name="connection"></param>
/// <param name="centreId"></param>
/// <returns></returns>
public static List <StocktakingPackage> GetStocktaking(SqlConnection connection, int centreId)
{
string query = "select PackageId, BarCode, PackageTypeId, PackageTypeDescription, CostPerPackage, ExpirationDate " +
"from StockTaking " +
"where CurrentLocationCentreId = @LocationCentreId " +
"order by PackageTypeId, ExpirationDate";
List <StocktakingPackage> stocks = new List <StocktakingPackage>();
var cmd = new SqlCommand(query);
cmd.Connection = connection;
cmd.Parameters.Add("@LocationCentreId", SqlDbType.Int).Value = centreId;
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default))
{
while (reader.Read())
{
var stock = new StocktakingPackage();
if (reader["PackageId"] != DBNull.Value)
{
stock.PackageId = Convert.ToInt32(reader["PackageId"]);
}
if (reader["BarCode"] != DBNull.Value)
{
stock.BarCode = Convert.ToString(reader["barcode"]);
}
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["ExpirationDate"] != DBNull.Value)
{
stock.ExpirationDate = Convert.ToDateTime(reader["ExpirationDate"]);
}
stock.setDaysLeft();
stocks.Add(stock);
}
}
Debug.WriteLine("ViewDataAccess returns " + stocks.Count() + " items");
return(stocks);
}
public List <StocktakingPackage> GetStocktaking(int CentreId)
{
List <StocktakingPackage> sList = new List <StocktakingPackage>();
List <Package> pList = MockDataAccess.GetAllPackages();
foreach (Package p in pList)
{
if (p.CurrentLocation.CentreId == CentreId)
{
StocktakingPackage sP = new StocktakingPackage();
sP.PackageTypeId = p.PackageType.PackageTypeId;
sP.PackageTypeDescription = p.PackageType.Description;
sP.CostPerPackage = p.PackageType.Value;
sP.BarCode = p.BarCode;
sP.PackageId = p.PackageId;
sP.ExpirationDate = p.ExpirationDate;
sList.Add(sP);
}
}
return(sList);
}
