public async Task <IActionResult> Add([FromBody] CreateProposalModel model)
{
if (ModelState.IsValid)
{
if (!await ProposalService.Exists(model.Description))
{
// This should be something
var isOk = await ProposalService.Create(model);
return(Ok(isOk));
}
ModelState.AddModelError("Status", "Er bestaat al een proposal met deze naam.");
}
return(BadRequest(ModelState));
}
public static async Task <bool> Create(CreateProposalModel model)
{
using (var p_Proposal_Create = new StoredProcedure("p_Proposal_Create"))
{
p_Proposal_Create.AddParameter("sStudyFields", string.Join(';', model.Study));
p_Proposal_Create.AddParameter("sDescription", model.Description);
p_Proposal_Create.AddParameter("sToolsUsed", string.Join(';', model.Environment));
p_Proposal_Create.AddParameter("sToolsInformation", model.TechnicalDescription);
p_Proposal_Create.AddParameter("sNecessities", model.ExtraRequirements);
p_Proposal_Create.AddParameter("sTheme", model.Theme);
p_Proposal_Create.AddParameter("sActivities", string.Join(';', model.Activities));
p_Proposal_Create.AddParameter("nRequiredStudents", model.AmountOfStudents);
p_Proposal_Create.AddParameter("sPreferedStudents", string.Join(';', model.Names));
p_Proposal_Create.AddParameter("sOptionalComment", model.Remarks);
p_Proposal_Create.AddParameter("sPeriods", string.Join(';', model.Period));
p_Proposal_Create.AddOutput <int>("nID");
p_Proposal_Create.Run();
return(true);
// F**k checking temporarily.
//return (await p_Proposal_Create.Run()).GetOutput<int>("nID") != 0;
}
}
