// @SurveyId INT -- @CopyFromId -- > 1 //,@LeaverYear CHAR(7) = NULL -- > 2 //,@Name nvarchar(500) = NULL -- > 3 //,@Description nvarchar(3000) = NULL -- > 4 //,@SurveyTypeCode varchar(50) = NULL -- > 5 //,@Instructions nvarchar(3000) = NULL -- > 6 //,@IsLocked bit = NULL-- > 7 //,@CreatedBy varchar(50) = NULL -- > 8 //,@UpdatedBy varchar(50) = NULL -- > 9 //,@SchoolYear char (7) = NULL -- > 10 //,@IsReported bit = NULL-- > 11 public void AddSurveyBase(SurveyBaseNoDateDTO surveyBase) { // id, leaverYear for now; TODO: add the remaining post fields //var proc = "[test].[usp_SurveyDetail_Add] @p0, @p1"; var proc = "[test].[usp_SurveyDetail_Add] @p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10"; //_db.Database.ExecuteSqlCommand(proc, surveyBase.CopyFromId, surveyBase.LeaverYear); _db.Database.ExecuteSqlCommand(proc, surveyBase.CopyFromId, surveyBase.LeaverYear, surveyBase.Name, surveyBase.Description, surveyBase.SurveyTypeCode, surveyBase.Instructions, surveyBase.IsLocked, surveyBase.CreatedBy, surveyBase.UpdatedBy, surveyBase.SchoolYear, surveyBase.IsReported); return; }
public IActionResult PostSurveyBase([FromBody] SurveyBaseNoDateDTO surveyBase) { if (surveyBase == null) { return(BadRequest()); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _rep.AddSurveyBase(surveyBase); return(CreatedAtRoute("GetSurveyBaseById", new { id = surveyBase.Id }, surveyBase)); }