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