public HttpResponseMessage Create(SectionsAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
string userId = UserService.GetCurrentUserId();
response.Item = _sectionService.Create(userId, model);
return(Request.CreateResponse(response));
}
public int Create(string userId, SectionsAddRequest model)
{
var id = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Sections_Insert_v3",
inputParamMapper : delegate(SqlParameterCollection parameterCollection)
{
parameterCollection.AddWithValue("@CourseId", model.CourseId);
parameterCollection.AddWithValue("@StartDate", model.StartDate);
parameterCollection.AddWithValue("@EndDate", model.EndDate);
parameterCollection.AddWithValue("@DaysOfWeek", model.DaysOfWeek);
parameterCollection.AddWithValue("@StartTime", model.StartTime);
parameterCollection.AddWithValue("@EndTime", model.EndTime);
parameterCollection.AddWithValue("@TimeZone", model.TimeZone);
//parameterCollection.AddWithValue("@Info", model.Info);
parameterCollection.AddWithValue("@Format", model.Format);
//parameterCollection.AddWithValue("@CampusLocation", model.CampusLocation);
//parameterCollection.AddWithValue("@RoomNumber", model.RoomNumber);
parameterCollection.AddWithValue("@Capacity", model.Capacity);
//parameterCollection.AddWithValue("@CurrentEnrollment", model.CurrentEnrollment);
parameterCollection.AddWithValue("@Status", model.Status);
parameterCollection.AddWithValue("@RegistrationDeadline", model.RegistrationDeadline);
parameterCollection.AddWithValue("@UserId", userId);
SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
parameterCollection.Add(p);
}, returnParameters : delegate(SqlParameterCollection para)
{
int.TryParse(para["@Id"].Value.ToString(), out id);
}
);
//foreach (var Id in model.Instructors)
// DataProvider.ExecuteNonQuery(GetConnection, "SectionInstructors_InsertV2",
// inputParamMapper: delegate (SqlParameterCollection param)
// {
// param.AddWithValue("@SectionId", id);
// param.AddWithValue("@InstructorId", Id);
// });
return(id);
}
