Example #1
0
        public HttpResponseMessage ViewAllTableOrder(HttpRequestMessage req, RP_ViewCurrentOrder rpViewCurrentOrder)
        {
            if (rpViewCurrentOrder != null)
            {
                RM_ViewCurrentOrder rmViewCurrentOrder = new RM_ViewCurrentOrder();
                List<RPR_ViewCurrentOrder> rprViewCurrentOrder = rmViewCurrentOrder.ViewAllTableOrder(rpViewCurrentOrder);

                if (rmViewCurrentOrder._IsSuccess)
                    return req.CreateResponse<List<RPR_ViewCurrentOrder>>(HttpStatusCode.Created, rprViewCurrentOrder);

                return req.CreateErrorResponse(HttpStatusCode.InternalServerError, "ServerError");
            }

            return req.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request");
        }
Example #2
0
        public List<RPR_ViewCurrentOrder> ViewAllTableOrder(RP_ViewCurrentOrder rpViewCurrentOrder)
        {
            this.SpName = "DigitalMenu_ViewCurrentOrder"; //Sp Name
                _IsSuccess = true;
                try
                {
                    SqlParameter[] param = new SqlParameter[3];
                    param[0] = new SqlParameter("@key", rpViewCurrentOrder.key);
                    param[1] = new SqlParameter("@WaitorId", rpViewCurrentOrder.WaiterId);
                    param[2] = new SqlParameter("@RestId", int.Parse(rpViewCurrentOrder.RestId));

                    ds = db.GetDataSet(this.SpName, param);
                    if (ds != null && ds.Tables.Count > 0)
                    {
                        rprViewCurrentOrder = SerializeData.SerializeMultiValue<RPR_ViewCurrentOrder>(ds.Tables[0]);
                    }
                }
                catch (Exception ex)
                {
                    _IsSuccess = false;
                    Logger.WriteLog(LogLevelL4N.ERROR, " View All Current Order | Exception : " + ex.Message);
                }
                return rprViewCurrentOrder;
        }