public static string UpdateProjectNotes(ProjectNotesModel notes, string connstring)
{
try
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@Id", notes.ProjectId);
spParams.Add("@StatusDescription", notes.StatusDescription);
spParams.Add("@ProjOfficerRecommendation", notes.ProjOfficerRecommendation);
spParams.Add("@Keywords", notes.Keywords);
spParams.Add("@Summary", notes.Summary);
spParams.Add("@Problems", notes.Problems);
spParams.Add("@StrengthsWeaknesses", notes.StrengthsWeaknesses);
spParams.Add("@FinanceOtherFunders", notes.FinanceOtherFunders);
spParams.Add("@LocalContribution", notes.LocalContribution);
spParams.Add("@LastUpdatedBy", notes.LastUpdatedBy);
return(DBAccess.ExecuteSQLNonQuery(connstring, "CALL usp_UpdateProjectNotes(@Id, @StatusDescription, @ProjOfficerRecommendation, @Keywords," +
"@Summary, @Problems, @StrengthsWeaknesses," +
"@FinanceOtherFunders,@LocalContribution,@LastUpdatedBy)", spParams));
}
catch (Exception)
{
return("An error occurred");
}
}
public string PutProjectNotes([FromRoute] int id, [FromBody] ProjectNotesModel projectNotes)
{
projectNotes.ProjectId = id;
return(ProjectService.UpdateProjectNotes(projectNotes, dbConn));
}