public PURPurchaseLineCollection SelectByHeaderID(int HeaderID)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
oDatabaseHelper.AddParameter("@HeaderID", HeaderID);
oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
IDataReader rdr = oDatabaseHelper.ExecuteReader("usp_PURPurchaseLine_SelectByHeaderID", ref ExecutionState);
PURPurchaseLineCollection lines = new PURPurchaseLineCollection();
while (rdr.Read())
{
PURPurchaseLine obj = new PURPurchaseLine();
obj.PurchaseLineID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseLineID));
//obj.PurchaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseHeaderID));
obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.ProductID));
obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.TotalQty));
obj.BonusQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.BonusQty));
obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountRatio));
obj.IsAcceptBatch = rdr.GetBoolean(rdr.GetOrdinal("IsAcceptBatch"));
//obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountAmount));
obj.Unitprice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.Unitprice));
if (rdr.GetOrdinal("PurchaseLineBatchID") != null && rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")) != 0)
{
obj.PurchaseLineBatchID = rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID"));
}
if (rdr.GetOrdinal("BatchID") != null && rdr.GetInt32(rdr.GetOrdinal("BatchID")) != 0)
{
obj.BatchID = rdr.GetInt32(rdr.GetOrdinal("BatchID"));
obj.BatchNumber = rdr.GetString(rdr.GetOrdinal("BatchNumber"));
obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal("ExpiryDate"));
}
lines.Add(obj);
}
rdr.Close();
return(lines);
}
internal static PURPurchaseLineCollection FillCollection(IDataReader rdr)
{
PURPurchaseLineCollection list = new PURPurchaseLineCollection();
while (rdr.Read())
{
PURPurchaseLine obj = new PURPurchaseLine();
obj.PurchaseLineID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseLineID));
//obj.PurchaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseHeaderID));
obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.ProductID));
obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.TotalQty));
obj.BonusQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.BonusQty));
obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountRatio));
//obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountAmount));
obj.Unitprice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.Unitprice));
if (rdr.GetOrdinal("PurchaseLineBatchID") != null)
{
obj.PurchaseLineBatchID = rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID"));
}
if (rdr.GetOrdinal("BatchID") != null)
{
obj.BatchID = rdr.GetInt32(rdr.GetOrdinal("BatchID"));
}
if (rdr.GetOrdinal("BatchNumber") != null)
{
obj.BatchNumber = rdr.GetString(rdr.GetOrdinal("BatchNumber"));
}
if (rdr.GetOrdinal("ExpiryDate") != null)
{
obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal("ExpiryDate"));
}
list.Add(obj);
}
return(list);
}
