/// <summary> ///This method converts the reader object to the data object /// </summary> /// <param name="oReader"></param> /// <returns></returns> private COrderShow ReaderToOrderShow(IDataReader oReader) { COrderShow oOrderShow = new COrderShow(); if (oReader["order_id"] != null) { oOrderShow.OrderID = Int64.Parse(oReader["order_id"].ToString()); } if (oReader["order_type"] != null) { oOrderShow.OrderType = oReader["order_type"].ToString(); } if (oReader["status"] != null) { oOrderShow.Status = oReader["status"].ToString(); } if (oReader["guest_count"] != null) { oOrderShow.GuestCount = int.Parse(oReader["guest_count"].ToString()); } if (oReader["table_number"] != null) { oOrderShow.TableNumber = Int64.Parse(oReader["table_number"].ToString()); } if (oReader["table_name"] != null) { oOrderShow.TableName = oReader["table_name"].ToString(); } if (oReader["user_name"] != null) { oOrderShow.UserName = oReader["user_name"].ToString(); } try { if (oReader["FloorNo"] != null) { oOrderShow.FloorNo = oReader["FloorNo"].ToString(); } } catch (Exception) { } if (oReader["online_orderid"] != null) { oOrderShow.OnlineOrderID = Convert.ToInt64("0" + oReader["online_orderid"]); //Online order status .i.e whether it came from online or local order. If 1 then come from online otherwise local order } return oOrderShow; }
private COrderShow ReaderToReportOrderShow(IDataReader oReader) { COrderShow oOrderShow = new COrderShow(); if (oReader["order_id"] != null) oOrderShow.OrderID = Int64.Parse(oReader["order_id"].ToString()); if (oReader["order_type"] != null) oOrderShow.OrderType = oReader["order_type"].ToString(); if (oReader["table_number"] != null) oOrderShow.TableNumber = int.Parse(oReader["table_number"].ToString()); return oOrderShow; }
/// <summary> ///This method converts the reader object to the data object /// </summary> /// <param name="oReader"></param> /// <returns></returns> private COrderShow ReaderToOrderShow(IDataReader oReader) { COrderShow oOrderShow = new COrderShow(); if (oReader["order_id"] != null) oOrderShow.OrderID = Int64.Parse(oReader["order_id"].ToString()); if (oReader["order_type"] != null) oOrderShow.OrderType = oReader["order_type"].ToString(); if (oReader["status"] != null) oOrderShow.Status = oReader["status"].ToString(); if (oReader["guest_count"] != null) oOrderShow.GuestCount = int.Parse(oReader["guest_count"].ToString()); if (oReader["table_number"] != null) oOrderShow.TableNumber = int.Parse(oReader["table_number"].ToString()); if (oReader["table_name"] != null) oOrderShow.TableName = oReader["table_name"].ToString(); if (oReader["user_name"] != null) oOrderShow.UserName = oReader["user_name"].ToString(); return oOrderShow; }