public void UpdateStatus(ProjectStatus projectStatus)
{
try
{
var parameters = ProjectStatusParameters.GetUpdateStatusParameters(projectDBManager, projectStatus);
projectDBManager.Update("CALL project.update_project_status(@project_id,@status_id,@resource_id,@created_by)", CommandType.Text, parameters.ToArray());
}
catch (Exception updateStatusException)
{
throw new Exception(ExceptionMessages.UPDATE_STATUS_DATA_ACCESS_ERROR_MSG, updateStatusException);
}
}
public bool IsProjectIDExists(int projectID)
{
try
{
var param = ProjectStatusParameters.GetProjectIDParam(projectDBManager, projectID);
return(Convert.ToBoolean(projectDBManager.GetScalarValue("SELECT project.is_project_id_exists(@project_id)", CommandType.Text, param.ToArray())));
}
catch (Exception isProjectIDExistsException)
{
throw new Exception(ExceptionMessages.IS_PROJECT_ID_EXISTS_DATA_ACCESS_ERROR_MSG, isProjectIDExistsException);
}
}