protected DataTable createDataTable()
{
if (_ordernumber != null)
{
_dt = _dao.getItemsToReturn((int)_ordernumber).Tables[0];
}
ViewState["dt"] = _dt;
return(_dt);
}
public OrderHeaderResponse GetResponse(ConsignmentOrderNumberRequest ConsignmentOrderNumber)
{
{
ReturnsDAO dao = new ReturnsDAO();
// to all the Order header deatils
DataSet orderH = dao.getOrderDetails(ConsignmentOrderNumber.SearchKey);
var OrderHdr = orderH.Tables[0];
if (OrderHdr.Rows.Count == 0)
{
return(null);
}
DataSet OrderD = dao.getItemsToReturn(int.Parse(orderH.Tables[0].Rows[0]["ORDERNUMBER"].ToString()));
var OrderDtl = OrderD.Tables[0];
var Hdr = OrderHdr.Rows[0];
var Dtl = OrderDtl.Rows[0];
var itemsList = new List <OrderDetailResponse>();
int?reasonCode;
if (Dtl["action"] == DBNull.Value)
{
reasonCode = null;
}
else
{
reasonCode = int.Parse(Dtl["action"].ToString());
}
foreach (var RowValue in OrderDtl.Rows)
{
var item = new OrderDetailResponse();
item.Sku = int.Parse(Dtl["sku"].ToString());
item.ItemNumber = int.Parse(Dtl["itemnumber"].ToString());
item.Description = Dtl["skudescr"].ToString();
item.ReasonCode = reasonCode;
itemsList.Add(item);
}
return(new OrderHeaderResponse
{
OrderNumber = int.Parse(Hdr["ORDERNUMBER"].ToString()),
CustomerURN = int.Parse(Hdr["CUSTOMERURN"].ToString()),
CustomerName = Hdr["customername"].ToString(),
OrderDate = Hdr["ORDERDATE"].ToString(),
PostCode = Hdr["customername"].ToString(),
Parcel_Scanned_Ind = Hdr["PARCEL_SCANNED_IND"].ToString(),
Items = itemsList
});
}
}