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));
}
}
}
