public HttpResponseMessage Put(patternlines res, int?ID = null, string LHand = null, string RHand = null) { using (SqlConnection con = DbUtil.GetConnection()) { SqlCommand com = new SqlCommand("API_patternlines_put", con); com.CommandType = CommandType.StoredProcedure; SqlParameter RetVal = com.Parameters.Add("RetVal", SqlDbType.Int); RetVal.Direction = ParameterDirection.ReturnValue; com.Parameters.Add("ID", SqlDbType.Int).Value = ID; com.Parameters.Add("Rank", SqlDbType.VarChar, 100).Value = res.Rank; com.Parameters.Add("Order", SqlDbType.Int).Value = res.Order; com.Parameters.Add("Feet", SqlDbType.VarChar, -1).Value = res.Feet; com.Parameters.Add("LHand", SqlDbType.VarChar, -1).Value = LHand; com.Parameters.Add("RHand", SqlDbType.VarChar, -1).Value = RHand; con.Open(); com.ExecuteNonQuery(); logger.Info("patternlines_put:@ID={0}, @Rank={1}, @Order={2}, @Feet={3}, @LHand={4}, @RHand={5}, return={6}", ID, res.Rank, res.Order, res.Feet, LHand, RHand, RetVal.Value); if (0 == (int)RetVal.Value) { RetVal.Value = 200; } if (200 == (int)RetVal.Value || 201 == (int)RetVal.Value) { var response = Request.CreateResponse((HttpStatusCode)RetVal.Value, "null"); return(response); } if (DbUtil.message.Length > 0) { return(Request.CreateErrorResponse((HttpStatusCode)RetVal.Value, DbUtil.message)); } else { return(Request.CreateResponse((HttpStatusCode)RetVal.Value)); } } }
public HttpResponseMessage Post(patternlines res, string LHand = null, string RHand = null) { if (res == null) { logger.Fatal("patternlines_post: Cannot parse resource. Check parameters"); throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.BadRequest)); } int?NewId = null; using (SqlConnection con = DbUtil.GetConnection()) { SqlCommand com = new SqlCommand("API_patternlines_post", con); com.CommandType = CommandType.StoredProcedure; SqlParameter RetVal = com.Parameters.Add("RetVal", SqlDbType.Int); RetVal.Direction = ParameterDirection.ReturnValue; com.Parameters.Add("Rank", SqlDbType.VarChar, 100).Value = res.Rank; com.Parameters.Add("Order", SqlDbType.Int).Value = res.Order; com.Parameters.Add("Feet", SqlDbType.VarChar, -1).Value = res.Feet; com.Parameters.Add("LHand", SqlDbType.VarChar, -1).Value = LHand; com.Parameters.Add("RHand", SqlDbType.VarChar, -1).Value = RHand; com.Parameters.Add("NewId", SqlDbType.Int).Value = NewId; com.Parameters["NewId"].Direction = ParameterDirection.Output; try { con.Open(); com.ExecuteNonQuery(); } catch (Exception ex) { logger.Info("patternlines_post:@Rank={0}, @Order={1}, @Feet={2}, @LHand={3}, @RHand={4}, @NewId={5}, return={6}", res.Rank, res.Order, res.Feet, LHand, RHand, NewId, RetVal.Value); logger.Fatal("patternlines_post: SqlException:" + ex.Message); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } logger.Info("patternlines_post:@Rank={0}, @Order={1}, @Feet={2}, @LHand={3}, @RHand={4}, @NewId={5}, return={6}", res.Rank, res.Order, res.Feet, LHand, RHand, NewId, RetVal.Value); if (0 == (int)RetVal.Value) { RetVal.Value = 200; } if (200 == (int)RetVal.Value || 201 == (int)RetVal.Value) { var response = Request.CreateResponse((HttpStatusCode)RetVal.Value, "null"); string uri = Url.Link("DefaultApi", new { id = com.Parameters["NewID"].Value.ToString() }); response.Headers.Location = new Uri(uri); return(response); } if (DbUtil.message.Length > 0) { return(Request.CreateErrorResponse((HttpStatusCode)RetVal.Value, DbUtil.message)); } else { return(Request.CreateResponse((HttpStatusCode)RetVal.Value)); } } }