private void GetTodaysOrders()
{
_todaysOrders = new SortedList<long, Order>();
Order order;
SqlService sql = new SqlService(_sqlConnection);
if (_customerKey != null)
{
sql.AddParameter("@pCustKey", System.Data.SqlDbType.UniqueIdentifier, _customerKey);
}
//TODO fix stored procedure to get todays orders
using (SqlDataReader reader = sql.ExecuteSPReader("ICMS_spGetTodaysOrders"))
{
if (reader.HasRows)
{
while (reader.Read())
{
order = new Order();
order.IndentNo = reader.SafeGetInt64(reader.GetOrdinal("indentNo")).Value;
order.InvoiceNo = reader.SafeGetString(reader.GetOrdinal("invoiceNo"));
//order.OrderKey = reader.SafeGetGuid(reader.GetOrdinal("orderKey")).Value;
order.DeliveryDate = reader.SafeGetString(reader.GetOrdinal("deliveryDate"));
order.OrderNo = reader.SafeGetString(reader.GetOrdinal("orderNo"));
order.Status = reader.SafeGetString(reader.GetOrdinal("orderStatus"));
order.TTNo = reader.SafeGetString(reader.GetOrdinal("orderTTNo"));
order.Customer = reader.SafeGetString(reader.GetOrdinal("customer"));
order.SalesArea = reader.SafeGetString(reader.GetOrdinal("ordAreaCode"));
order.TTOutTime = reader.SafeGetString(reader.GetOrdinal("orderTTOut"));
_todaysOrders.Add(order.IndentNo, order);
}
}
}
}
/// <summary>
/// ICMS_spGetCustHistory
//@pUserKey as uniqueidentifier = NULL,
//@pCustKey as uniqueidentifier = NULL,
//@pStartDate as varchar(30) = NULL,
//@pEndDate as varchar(30) = NULL
/// </summary>
private void GetOrderSummary(Guid? customerKey)
{
//TODO get order summary from database
//TODO add index field to query so it can be sorted easily
_orderSummary = new SortedList<Int64, Order>();
Order order;
SqlService sql = new SqlService(_sqlConnection);
//TODO Get from logged in user
sql.AddParameter("@pCustKey", System.Data.SqlDbType.UniqueIdentifier, customerKey);
using (SqlDataReader reader = sql.ExecuteSPReader("ICMS_spGetCustHistory"))
{
if (reader.HasRows)
{
while (reader.Read())
{
order = new Order();
order.IndentNo = reader.SafeGetInt64(reader.GetOrdinal("indentNo")).Value;
order.InvoiceNo = reader.SafeGetString(reader.GetOrdinal("invoiceNo"));
//order.OrderKey = reader.SafeGetGuid(reader.GetOrdinal("orderKey")).Value;
order.Date = reader.SafeGetString(reader.GetOrdinal("orderDate"));
order.OrderNo = reader.SafeGetString(reader.GetOrdinal("orderNo"));
order.Status = reader.SafeGetString(reader.GetOrdinal("orderStatus"));
order.TTNo = reader.SafeGetString(reader.GetOrdinal("orderTTNo"));
order.TTOutTime = reader.SafeGetString(reader.GetOrdinal("orderTTOut"));
order.CreatedBy = reader.SafeGetString(reader.GetOrdinal("orderedBy"));
_orderSummary.Add(order.IndentNo, order);
}
}
}
}
