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; } }