public HttpResponseMessage GetChildById([FromUri] int id, ChildAddRequest payload) { ChildService childSvc = new ChildService(); Child child = childSvc.GetChildById(id); return(Request.CreateResponse(HttpStatusCode.OK, child)); } //GetChildById
public HttpResponseMessage CreateChild(ChildAddRequest payload) { ItemResponse <int> response = new ItemResponse <int>(); ChildService childSvc = new ChildService(); response.Item = childSvc.CreateChild(payload); return(Request.CreateResponse(response)); } //CreateChild
public int CreateChild(ChildAddRequest payload) { /* * 1. You need a connection * 2. You need a command (a function) * a. Name * b. Parameters * 3. You need to execute that command * a. ExecuteNonQuery ==> public void C# * b. ExeuteReader ==> public List<T> C# */ int id = 0; // setting connection string to a variable string connString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; //establish connection using (SqlConnection sqlConn = new SqlConnection(connString)) { // establlish command object using (SqlCommand cmd = new SqlCommand("dbo.Child_Insert", sqlConn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ChildName", payload.ChildName); cmd.Parameters.AddWithValue("@ChildAgeYears", payload.ChildAgeYears); cmd.Parameters.AddWithValue("@ChildAgeMonths", payload.ChildAgeMonths); SqlParameter param = new SqlParameter(); param.ParameterName = "@ID"; param.SqlDbType = System.Data.SqlDbType.Int; param.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(param); // open SQL connection sqlConn.Open(); // for insert or update statements cmd.ExecuteNonQuery();// takes total number of rows that are affected id = (int)cmd.Parameters["@ID"].Value; } } return(id); } //CreateChild