public HttpResponseMessage Add(TrackAddRequest model)
{
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
ItemResponse<int> response = new ItemResponse<int>();
//grabbing the ID that is currently assgined to UserService (current user)
//this is where you get the current userId
response.Item = _trackService.Add(model);
return Request.CreateResponse(response);
}
public HttpResponseMessage Add(TrackAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
//grabbing the ID that is currently assgined to UserService (current user)
//this is where you get the current userId
response.Item = _trackService.Add(model);
return(Request.CreateResponse(response));
}
public int Add(TrackAddRequest model)
{
var id = 0;
//connecting to SQL server, which will call the database and the stored procedure
//1 database call = get connection with stored procedure below "CourseTrack_Insert"
//ADO is a library of code that is used to communicate wiht the database
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Tracks_Insert",
//(SQLparam)suitcase of data that the .NET will populate and send to the server
//inline function in .NET(delegate)
//Delegate x = fx()} delegate points to a function.
//type //Name
inputParamMapper: delegate(SqlParameterCollection parameterCollection)
{
parameterCollection.AddWithValue("@Name", model.Name);
parameterCollection.AddWithValue("@Format", model.Format);
parameterCollection.AddWithValue("@ExpectedOutcome", model.ExpectedOutCome);
parameterCollection.AddWithValue("@Cost", model.Cost);
parameterCollection.AddWithValue("@Description", model.Description);
SqlParameter s = new SqlParameter("@Id", System.Data.SqlDbType.Int);
s.Direction = System.Data.ParameterDirection.Output;
parameterCollection.Add(s);
},
returnParameters: delegate(SqlParameterCollection para)
{ //this will come from the database server
int.TryParse(para["@Id"].Value.ToString(), out id);
}
//when using the insert method in REST Client the intent is to see that Id will return a value to the user.
);
foreach (var courseId in model.CourseIds)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.TrackCourses_Insert",
delegate(SqlParameterCollection para)
{
para.AddWithValue("@TracksId", id);
para.AddWithValue("@CourseId", courseId);
});
}
return id;
}
public int Add(TrackAddRequest model)
{
var id = 0;
//connecting to SQL server, which will call the database and the stored procedure
//1 database call = get connection with stored procedure below "CourseTrack_Insert"
//ADO is a library of code that is used to communicate wiht the database
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Tracks_Insert",
//(SQLparam)suitcase of data that the .NET will populate and send to the server
//inline function in .NET(delegate)
//Delegate x = fx()} delegate points to a function.
//type //Name
inputParamMapper : delegate(SqlParameterCollection parameterCollection)
{
parameterCollection.AddWithValue("@Name", model.Name);
parameterCollection.AddWithValue("@Format", model.Format);
parameterCollection.AddWithValue("@ExpectedOutcome", model.ExpectedOutCome);
parameterCollection.AddWithValue("@Cost", model.Cost);
parameterCollection.AddWithValue("@Description", model.Description);
SqlParameter s = new SqlParameter("@Id", System.Data.SqlDbType.Int);
s.Direction = System.Data.ParameterDirection.Output;
parameterCollection.Add(s);
},
returnParameters : delegate(SqlParameterCollection para)
{ //this will come from the database server
int.TryParse(para["@Id"].Value.ToString(), out id);
}
//when using the insert method in REST Client the intent is to see that Id will return a value to the user.
);
foreach (var courseId in model.CourseIds)
{
DataProvider.ExecuteNonQuery(GetConnection, "dbo.TrackCourses_Insert",
delegate(SqlParameterCollection para)
{
para.AddWithValue("@TracksId", id);
para.AddWithValue("@CourseId", courseId);
});
}
return(id);
}
