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