public HttpResponseMessage CancelOrder(HttpRequestMessage req, RP_CancelOrder rpCancelOrder) { if (rpCancelOrder != null) { RM_CancelOrder rmCancelOrder = new RM_CancelOrder(); List<RPR_CancelOrder> rprCancelOrder = rmCancelOrder.CancelOrder(rpCancelOrder); if (rmCancelOrder._IsSuccess) return req.CreateResponse<List<RPR_CancelOrder>>(HttpStatusCode.Created, rprCancelOrder); return req.CreateErrorResponse(HttpStatusCode.InternalServerError, "ServerError"); } return req.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request"); }
public List<RPR_CancelOrder> CancelOrder(RP_CancelOrder rpCancelOrder) { this.SpName = "DigitalMenu_CancelOrder"; //Sp Name _IsSuccess = true; try { SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@key", rpCancelOrder.key); param[1] = new SqlParameter("@PosId", int.Parse(rpCancelOrder.PosId)); param[2] = new SqlParameter("@RestId", int.Parse(rpCancelOrder.RestId)); param[3] = new SqlParameter("@TableNo", rpCancelOrder.TableNo); param[4] = new SqlParameter("@WaitorId", string.IsNullOrEmpty(rpCancelOrder.WaitorId)?Convert.DBNull:rpCancelOrder.WaitorId); param[5] = new SqlParameter("@ItemId", rpCancelOrder.ItemId); param[6] = new SqlParameter("@CancelReason", string.IsNullOrEmpty(rpCancelOrder.CancelReason)?Convert.DBNull:rpCancelOrder.CancelReason); ds = db.GetDataSet(this.SpName, param); if (ds != null && ds.Tables.Count > 0) { rprCancelOrder = SerializeData.SerializeMultiValue<RPR_CancelOrder>(ds.Tables[0]); } } catch (Exception ex) { _IsSuccess = false; Logger.WriteLog(LogLevelL4N.ERROR, " Cancel Order | Exception : " + ex.Message); } return rprCancelOrder; }