public List <PurOrderSummary> GetByVendorProduct(VendorProductId vendorProductId)
{
List <PurOrderSummary> results = new List <PurOrderSummary>();
using (PooledConnection pooledCon = GetPooledConnection())
{
using (SqlCommand cmd = SqlHelper.CreateProc("dbo.GetPurOrderByVendorProduct", pooledCon))
{
SqlHelper.AddParamInputId(cmd, "@VendorProductId", vendorProductId.Value);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
PurOrderSummary sum = new PurOrderSummary();
sum.VendorId = new VendorId((int)reader["VendorId"]);
sum.PurOrderId = new PurOrderId((int)reader["PurOrderId"]);
sum.OrderDate = (DateTime)reader["OrderDate"];
sum.QtyOrdered = (int)reader["QtyOrdered"];
object orderedEaches = reader["OrderedEaches"];
sum.OrderedEaches = (byte)orderedEaches != 0;
if (sum.OrderedEaches)
{
sum.EachesEquivalent = sum.QtyOrdered;
}
else
{
sum.EachesEquivalent = sum.QtyOrdered * (int)reader["CountInCase"];
}
results.Add(sum);
}
}
}
}
return(results);
}
private void btnPurchaseHistory_Click(object sender, EventArgs e)
{
if (mHelper.CurrentEntity == null)
{
MessageBox.Show("Select the row with the product whose orders you want to see.");
return;
}
VendorProductId vpId = mHelper.CurrentEntity.PurLine_VendorProductId;
using (PurOrderSummaryForm frm = new PurOrderSummaryForm())
{
List <PurOrderSummary> orders;
using (Ambient.DbSession.Activate())
{
orders = OrderingRepositories.PurOrder.GetByVendorProduct(vpId);
}
frm.Show(orders, mHelper.CurrentEntity.Product_ProductName);
}
}
