Example #1
0
        public HttpResponseMessage GetTableNumber(HttpRequestMessage req, RP_GetTableNumber rpGetTableNumber)
        {
            if (rpGetTableNumber != null)
            {
                RM_GetTableNumber rmGetTableNumber = new RM_GetTableNumber();
                List<RPR_GetTableNumber> rprGetTableNumber = rmGetTableNumber.GetTableNumber(rpGetTableNumber);

                if (rmGetTableNumber._IsSuccess)
                    return req.CreateResponse<List<RPR_GetTableNumber>>(HttpStatusCode.Created, rprGetTableNumber);

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

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

                      ds = db.GetDataSet(this.SpName, param);
                      if (ds != null && ds.Tables.Count > 0)
                      {
                          rprGetTableNumber = SerializeData.SerializeMultiValue<RPR_GetTableNumber>(ds.Tables[0]);
                      }
                  }
                  catch (Exception ex)
                  {
                      _IsSuccess = false;
                      Logger.WriteLog(LogLevelL4N.ERROR, " get table Number   | Exception : " + ex.Message);
                  }
                  return rprGetTableNumber;
        }