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