Example #1
0
        public HttpResponseMessage WaiterAddItemForCus(HttpRequestMessage req, RP_WaiterAddItemForCus rpWaiterAddItemForCus)
        {
            if (rpWaiterAddItemForCus != null)
            {
                RM_WaiterAddItemForCus rmWaiterAddItemForCus = new RM_WaiterAddItemForCus();
                List<RPR_WaiterAddItemForCus> rprWaiterAddItemForCus = rmWaiterAddItemForCus.WaiterAddItemForCus(rpWaiterAddItemForCus);

                if (rmWaiterAddItemForCus._IsSuccess)
                    return req.CreateResponse<List<RPR_WaiterAddItemForCus>>(HttpStatusCode.Created, rprWaiterAddItemForCus);

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

            return req.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request");
        }
Example #2
0
        public List<RPR_WaiterAddItemForCus> WaiterAddItemForCus(RP_WaiterAddItemForCus rpWaiterAddItemForCus)
        {
            this.SpName = "DigitalMenu_WaiterAddItemForCus"; //Sp Name
              _IsSuccess = true;
              try
              {
                  string[] categoryDetails = new string[4];
                  JArray a = JArray.Parse(rpWaiterAddItemForCus.ItemDetails);
                  int count = a.Count;
                  int last_sp_call = 0; // to send Status to searlize json object
                  foreach (JObject o in a.Children<JObject>())
                  {
                      int i = 0;
                      foreach (JProperty p in o.Properties())
                      {
                          categoryDetails[i] = p.Value.ToString();
                          i++;
                      }
                      SqlParameter[] param = new SqlParameter[8];
                      param[0] = new SqlParameter("@RestId", int.Parse(rpWaiterAddItemForCus.RestId));
                      param[1] = new SqlParameter("@key", rpWaiterAddItemForCus.key);
                      param[2] = new SqlParameter("@waiterId", rpWaiterAddItemForCus.WaiterId);
                      param[3] = new SqlParameter("@tableNum", rpWaiterAddItemForCus.TableId);
                      param[4] = new SqlParameter("@itemId", categoryDetails[0]);
                      param[5] = new SqlParameter("@price", float.Parse(categoryDetails[1]));
                      param[6] = new SqlParameter("@qunatity", int.Parse(categoryDetails[2]));
                      param[7] = new SqlParameter("@amount", float.Parse(categoryDetails[3]));

                      ds = db.GetDataSet(this.SpName, param);
                      last_sp_call++;
                      if (last_sp_call == count)
                      {
                          if (ds != null && ds.Tables.Count > 0)
                          {
                              rprWaiterAddItemForCus = SerializeData.SerializeMultiValue<RPR_WaiterAddItemForCus>(ds.Tables[0]);
                          }
                      } //if end

                  } //foreach end

              }
              catch (Exception ex)
              {
                  _IsSuccess = false;
                  Logger.WriteLog(LogLevelL4N.ERROR, " waiter Order Item | Exception : " + ex.Message);
              }

              return rprWaiterAddItemForCus;
        }