// @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));
}
