private void DisplayExperimentInfo(LssExperimentInfo experimentInfo)
{
ResetState();
txtLabClientName.Text = experimentInfo.labClientName;
txtLabClientName.Enabled = false;
txtLabClientName.BackColor = Color.FromArgb(243, 239, 229);
txtLabClientVersion.Text = experimentInfo.labClientVersion;
txtLabClientVersion.Enabled = false;
txtLabClientVersion.BackColor = Color.FromArgb(243, 239, 229);
txtClientGuid.Text = experimentInfo.labClientGuid;
txtClientGuid.ReadOnly = true;
txtClientGuid.Enabled = false;
txtClientGuid.BackColor = Color.FromArgb(243, 239, 229);
//txtLabServerID.Text = experimentInfo.labServerID;
//txtLabServerID.Enabled = false;
//txtLabServerID.BackColor = Color.FromArgb(243,239,229);
//txtLabServerName.Text = experimentInfo.labServerName;
txtMinimumTime.Text = experimentInfo.minimumTime.ToString();
txtPrepareTime.Text = experimentInfo.prepareTime.ToString();
txtProviderName.Text = experimentInfo.providerName;
txtContactEmail.Text = experimentInfo.contactEmail;
txtRecoverTime.Text = experimentInfo.recoverTime.ToString();
txtEarlyArriveTime.Text = experimentInfo.earlyArriveTime.ToString();
}
/// <summary>
/// Return an array of the immutable USSInfo objects thta correspond to the supplied USS information IDs
/// </summary>
/// <param name="experimentInfoIDs"></param>
/// <returns></returns>
public static LssExperimentInfo[] GetExperimentInfos(int[] experimentInfoIDs)
{
List<LssExperimentInfo> experimentInfos = new List<LssExperimentInfo>();
// create sql connection
DbConnection connection = FactoryDB.GetConnection();
// create sql command
// command executes the "RetrieveExperimentInfoByID" stored procedure
DbCommand cmd = FactoryDB.CreateCommand("ExperimentInfo_RetrieveByID", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters .Add(FactoryDB.CreateParameter(cmd,"@experimentInfoID", null, DbType.Int32));
//execute the command
try
{
connection.Open();
for(int i=0;i<experimentInfoIDs.Length;i++)
{
// populate the parameters
cmd.Parameters["@experimentInfoID"].Value = experimentInfoIDs[i];
DbDataReader dataReader = null;
dataReader=cmd.ExecuteReader();
while(dataReader.Read())
{
LssExperimentInfo experimentInfo = new LssExperimentInfo();
experimentInfo.experimentInfoId=experimentInfoIDs[i];
if(dataReader[0] != System.DBNull.Value )
experimentInfo.labClientGuid=dataReader.GetString(0);
if (dataReader[1] != System.DBNull.Value)
experimentInfo.labServerGuid = dataReader.GetString(1);
if(dataReader[2] != System.DBNull.Value )
experimentInfo.labServerName=dataReader.GetString(2);
if(dataReader[3] != System.DBNull.Value )
experimentInfo.labClientVersion=dataReader.GetString(3);
if(dataReader[4] != System.DBNull.Value )
experimentInfo.labClientName=dataReader.GetString(4);
if(dataReader[5] != System.DBNull.Value )
experimentInfo.providerName=dataReader.GetString(5);
if (dataReader[6] != System.DBNull.Value)
experimentInfo.contactEmail= dataReader.GetString(6);
if(dataReader[7] != System.DBNull.Value )
experimentInfo.prepareTime=dataReader.GetInt32(7);
if(dataReader[8] != System.DBNull.Value )
experimentInfo.recoverTime=dataReader.GetInt32(8);
if(dataReader[9] != System.DBNull.Value )
experimentInfo.minimumTime=dataReader.GetInt32(9);
if(dataReader[10] != System.DBNull.Value )
experimentInfo.earlyArriveTime=dataReader.GetInt32(10);
experimentInfos.Add(experimentInfo);
}
dataReader.Close();
}
}
catch (Exception ex)
{
throw new Exception("Exception thrown in get experiment inforamtion",ex);
}
finally
{
connection.Close();
}
if(experimentInfos.Count >0)
return experimentInfos.ToArray();
else
return null;
}
/*
* Builds the Select Experiments List using a specified array of experiments.
* This is used to return the results of a search
*/
private void BuildExperimentInfoListBox(LssExperimentInfo[] experimentInfos)
{
lbxSelectExperiment.Items.Clear();
foreach (LssExperimentInfo experimentInfo in experimentInfos)
{
ListItem experimentInfoItem = new ListItem();
experimentInfoItem.Text = experimentInfo.labClientName + ", " + experimentInfo.labClientVersion;
experimentInfoItem.Value = experimentInfo.experimentInfoId.ToString();
lbxSelectExperiment.Items.Add(experimentInfoItem);
}
}
