public static List <IDbDataParameter> GetProtocolIDParameter(IProjectDBManager projectDBManager, string protocolID)
{
List <IDbDataParameter> projectParams = new List <IDbDataParameter>();
projectParams.Add(projectDBManager.CreateParameter("@protocol_id", protocolID, DbType.String));
return(projectParams);
}
public static List <IDbDataParameter> GetResourceIDParameter(IProjectDBManager projectDBManager, int resourceID)
{
List <IDbDataParameter> projectParams = new List <IDbDataParameter>();
projectParams.Add(projectDBManager.CreateParameter("@resource_id", resourceID, DbType.Int32));
return(projectParams);
}
public static List <IDbDataParameter> GetInputAdvisorIDParameter(IProjectDBManager projectDBManager, int inputAdvisorID)
{
List <IDbDataParameter> inputAdvisorParams = new List <IDbDataParameter>();
inputAdvisorParams.Add(projectDBManager.CreateParameter("@input_advisor_id", inputAdvisorID, DbType.Int32));
return(inputAdvisorParams);
}
public static List <IDbDataParameter> GetProjectIDParam(IProjectDBManager projectDBManager, int projectID)
{
List <IDbDataParameter> statusParameters = new List <IDbDataParameter>();
statusParameters.Add(projectDBManager.CreateParameter("@project_id", projectID, DbType.Int32));
return(statusParameters);
}
public static List <IDbDataParameter> GetProjectParameters(IProjectDBManager projectDBManager, string name, string version)
{
List <IDbDataParameter> projectParams = new List <IDbDataParameter>();
projectParams.Add(projectDBManager.CreateParameter("@name", name, DbType.String));
projectParams.Add(projectDBManager.CreateParameter("@version", version, DbType.String));
return(projectParams);
}
public static List <IDbDataParameter> GetInputAdvisorParameters(IProjectDBManager projectDBManager, int resourceID, int projectID)
{
List <IDbDataParameter> inputAdvisorParams = new List <IDbDataParameter>();
inputAdvisorParams.Add(projectDBManager.CreateParameter("@project_id", projectID, DbType.Int32));
inputAdvisorParams.Add(projectDBManager.CreateParameter("@resource_id", resourceID, DbType.Int32));
return(inputAdvisorParams);
}
public static List <IDbDataParameter> GetStaticIdAndValueParameters(IProjectDBManager projectDBManager, int staticID, string staticValue)
{
List <IDbDataParameter> staticIdAndValueParameters = new List <IDbDataParameter>();
staticIdAndValueParameters.Add(projectDBManager.CreateParameter("@static_id", staticID, DbType.Int32));
staticIdAndValueParameters.Add(projectDBManager.CreateParameter("@static_value", staticValue, DbType.String));
return(staticIdAndValueParameters);
}
public static List <IDbDataParameter> GetProgramNameParameter(IProjectDBManager projectDBManager, string programName, int resourceID)
{
List <IDbDataParameter> programParams = new List <IDbDataParameter>();
programParams.Add(projectDBManager.CreateParameter("@program_name", programName, DbType.String));
programParams.Add(projectDBManager.CreateParameter("@resource_id", resourceID, DbType.Int32));
return(programParams);
}
public static List <IDbDataParameter> GetProjectParameters(IProjectDBManager projectDBManager, int projectID, int resourceID, bool listAllProjects)
{
List <IDbDataParameter> projectParams = new List <IDbDataParameter>();
projectParams.Add(projectDBManager.CreateParameter("@project_id", projectID, DbType.Int32));
projectParams.Add(projectDBManager.CreateParameter("@resource_id", resourceID, DbType.Int32));
projectParams.Add(projectDBManager.CreateParameter("@list_all_projects", listAllProjects, DbType.Boolean));
return(projectParams);
}
public static List <IDbDataParameter> GetUpdateStatusParameters(IProjectDBManager projectDBManager, ProjectStatus projectStatus)
{
List <IDbDataParameter> statusParameters = new List <IDbDataParameter>();
statusParameters.Add(projectDBManager.CreateParameter("@project_id", projectStatus.ProjectID, DbType.Int32));
statusParameters.Add(projectDBManager.CreateParameter("@status_id", projectStatus.StatusID, DbType.Int16));
statusParameters.Add(projectDBManager.CreateParameter("@resource_id", projectStatus.ResourceID, DbType.Int32));
statusParameters.Add(projectDBManager.CreateParameter("@created_by", projectStatus.CreatedBy, DbType.String));
return(statusParameters);
}
public static List <IDbDataParameter> GetCreateProgramParameters(IProjectDBManager projectDBManager, Program program)
{
List <IDbDataParameter> programParameters = new List <IDbDataParameter>();
programParameters.Add(projectDBManager.CreateParameter("@program_name", program.Name, DbType.String));
programParameters.Add(projectDBManager.CreateParameter("@created_by", program.CreatedBy, DbType.String));
programParameters.Add(projectDBManager.CreateParameter("@resource_id", program.ResourceID, DbType.Int32));
programParameters.Add(projectDBManager.CreateParameter("@program_id", 1, DbType.Int32));
return(programParameters);
}
public static List <IDbDataParameter> GetCreateInputAdvisorInputParameters(IProjectDBManager projectDBManager, InputAdvisor inputAdvisor)
{
List <IDbDataParameter> saveInputAdvisorInputParameters = new List <IDbDataParameter>();
saveInputAdvisorInputParameters.Add(projectDBManager.CreateParameter("@project_id", inputAdvisor.ProjectID, DbType.Int32));
saveInputAdvisorInputParameters.Add(projectDBManager.CreateParameter("@resource_id", inputAdvisor.ResourceID, DbType.Int32));
saveInputAdvisorInputParameters.Add(projectDBManager.CreateParameter("@created_by", inputAdvisor.CreatedBy, DbType.String));
saveInputAdvisorInputParameters.Add(projectDBManager.CreateParameter("@input_advisor_object", inputAdvisor.Object.ToString(), DbType.String));
saveInputAdvisorInputParameters.Add(projectDBManager.CreateParameter("@input_advisor_id", 1, DbType.Int32));
return(saveInputAdvisorInputParameters);
}
public static List <IDbDataParameter> GetCreateProjectParameters(IProjectDBManager projectDBManager, Project project)
{
List <IDbDataParameter> projectParameters = new List <IDbDataParameter>();
projectParameters.Add(projectDBManager.CreateParameter("@project_name", project.Name, DbType.String));
projectParameters.Add(projectDBManager.CreateParameter("@protocol_id", project.ProtocolID, DbType.String));
projectParameters.Add(projectDBManager.CreateParameter("@program_id", project.Program.ID, DbType.Int32));
projectParameters.Add(projectDBManager.CreateParameter("@indication_id", project.Indication.ID, DbType.Int16));
projectParameters.Add(projectDBManager.CreateParameter("@phase_id", project.Phase, DbType.Int16));
projectParameters.Add(projectDBManager.CreateParameter("@time_unit_id", project.ProjectTimeUnit.ID, DbType.Int16));
projectParameters.Add(projectDBManager.CreateParameter("@currency_id", project.Currency.ID, DbType.Int16));
projectParameters.Add(projectDBManager.CreateParameter("@resource_id", project.ResourceID, DbType.Int32));
projectParameters.Add(projectDBManager.CreateParameter("@created_by", project.CreatedBy, DbType.String));
projectParameters.Add(projectDBManager.CreateParameter("@project_id", 1, DbType.Int32));
return(projectParameters);
}
public InputAdvisorDataAccess(string connectionString)
{
projectDBManager = new ProjectDBManager(connectionString);
}
public ProjectDataAccess(string connectionString)
{
projectDBManager = new ProjectDBManager(connectionString);
}