public HttpResponseMessage CreateParent(ParentAddRequest model)
{
ParentService parentSvc = new ParentService();
int id = parentSvc.CreateParent(model);
return(Request.CreateResponse(HttpStatusCode.OK, id));
}
public int CreateParent(ParentAddRequest 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.Parent_Insert", sqlConn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FamilySize", payload.FamilySize);
cmd.Parameters.AddWithValue("@NumberOfChildren", payload.NumberOfChildren);
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);
} //CreateParent
