public ProjectNGOModel PostProjectNGO([FromBody] ProjectNGOModel projectNGO) { Response.StatusCode = 201; string result = ProjectNGOService.AddProjectNGO(projectNGO, dbConn); projectNGO.Id = Convert.ToInt32(result); return(projectNGO); }
public static string AddProjectNGO(ProjectNGOModel projectNGO, string connstring) { try { Dictionary <string, object> spParams = new Dictionary <string, object>(); spParams.Add("@ProjectId", projectNGO.ProjectId); spParams.Add("@NGOId", projectNGO.NGOId); return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_AddNGOToProject(@ProjectId, @NGOId)", spParams)); } catch (Exception) { return("An error occurred"); } }