public ProjectVisitModel AddProjectVisit([FromBody] ProjectVisitModel project)
{
Response.StatusCode = 201;
string result = ProjectVisitService.AddProjectVisit(project, dbConn);
project.Id = Convert.ToInt32(result);
return(project);
}
public static string AddProjectVisit(ProjectVisitModel projectVisit, string connstring)
{
try
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@ProjectId", projectVisit.ProjectId);
spParams.Add("@VisitStart", projectVisit.VisitStart);
spParams.Add("@VisitEnd", projectVisit.VisitEnd);
spParams.Add("@Visitor", projectVisit.Visitor);
return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_AddVisitToProject(@ProjectId, @VisitStart, @VisitEnd, @Visitor)", spParams));
}
catch (Exception)
{
return("An error occurred");
}
}
public string UpdateProjectVisit([FromRoute] int id, [FromBody] ProjectVisitModel project)
{
return(ProjectVisitService.UpdateProjectVisit(project, dbConn));
}
