public StorageStabilityExperimentData MakeSSExploreModel(SqlDataReader results) { StorageStabilityExperimentData data = new StorageStabilityExperimentData() { Dataset_ID = results["dataset_id"].ToString(), Strain = results["strain"].ToString(), FormTreatments = results["form_trt"].ToString(), Rep = results["rep"].ToString(), PreActivationAges = results["preactivation_age"].ToString(), Temp = results["temp"].ToString(), DPA = results["dpa"].ToString(), Notes = results["notes"].ToString(), Dil_Zero = results["dil_zero"].ToString(), Dil_One = results["dil_neg1"].ToString(), Dil_Two = results["dil_neg2"].ToString(), Dil_Three = results["dil_neg3"].ToString(), Dil_Four = results["dil_neg4"].ToString(), Dil_Five = results["dil_neg5"].ToString(), Dil_Six = results["dil_neg6"].ToString(), Dil_Seven = results["dil_neg7"].ToString(), Outlier = (bool)results["outlier"] }; return(data); }
public List <StorageStabilityExperimentData> GetSummaryStorageStabilityData(string strain, string dpa, string dataset_id) { List <StorageStabilityExperimentData> summaryStorageStability = new List <StorageStabilityExperimentData>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_SummaryStorageStabilityData, conn); cmd.Parameters.AddWithValue("@strain", strain); cmd.Parameters.AddWithValue("@dpa", dpa); cmd.Parameters.AddWithValue("@dataset_id", dataset_id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { StorageStabilityExperimentData rowOfStorageStabilityData = new StorageStabilityExperimentData(); rowOfStorageStabilityData.Dataset_ID = Convert.ToString(reader["dataset_id"]); rowOfStorageStabilityData.Strain = Convert.ToString(reader["strain"]); rowOfStorageStabilityData.FormTreatments = Convert.ToString(reader["form_trt"]); rowOfStorageStabilityData.Rep = Convert.ToString(reader["rep"]); rowOfStorageStabilityData.Temp = Convert.ToString(reader["temp"]); rowOfStorageStabilityData.PreActivationAges = Convert.ToString(reader["preactivation_age"]); rowOfStorageStabilityData.DPA = Convert.ToString(reader["dpa"]); rowOfStorageStabilityData.Notes = Convert.ToString(reader["notes"]); rowOfStorageStabilityData.Dil_Zero = Convert.ToString(reader["dil_zero"]); rowOfStorageStabilityData.Dil_One = Convert.ToString(reader["dil_neg1"]); rowOfStorageStabilityData.Dil_Two = Convert.ToString(reader["dil_neg2"]); rowOfStorageStabilityData.Dil_Three = Convert.ToString(reader["dil_neg3"]); rowOfStorageStabilityData.Dil_Four = Convert.ToString(reader["dil_neg4"]); rowOfStorageStabilityData.Dil_Five = Convert.ToString(reader["dil_neg5"]); rowOfStorageStabilityData.Dil_Six = Convert.ToString(reader["dil_neg6"]); rowOfStorageStabilityData.Dil_Seven = Convert.ToString(reader["dil_neg7"]); summaryStorageStability.Add(rowOfStorageStabilityData); } return(summaryStorageStability); } } catch (SqlException ex) { throw; } }
public List <StorageStabilityExperimentData> GetStorageStabilityData() { List <StorageStabilityExperimentData> allStorageStabilityData = new List <StorageStabilityExperimentData>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(SQL_getAllStorageStabilityDataSql, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { StorageStabilityExperimentData rowOfStorageStabilityData = new StorageStabilityExperimentData(); rowOfStorageStabilityData.Dataset_ID = Convert.ToString(reader["dataset_id"]); rowOfStorageStabilityData.Strain = Convert.ToString(reader["strain"]); rowOfStorageStabilityData.FormTreatments = Convert.ToString(reader["form_trt"]); rowOfStorageStabilityData.Temp = Convert.ToString(reader["temp"]); rowOfStorageStabilityData.Rep = Convert.ToString(reader["rep"]); rowOfStorageStabilityData.PreActivationAges = Convert.ToString(reader["preactivation_age"]); rowOfStorageStabilityData.DPA = Convert.ToString(reader["dpa"]); rowOfStorageStabilityData.Notes = Convert.ToString(reader["notes"]); rowOfStorageStabilityData.Dil_Zero = Convert.ToString(reader["dil_zero"]); rowOfStorageStabilityData.Dil_One = Convert.ToString(reader["dil_neg1"]); rowOfStorageStabilityData.Dil_Two = Convert.ToString(reader["dil_neg2"]); rowOfStorageStabilityData.Dil_Three = Convert.ToString(reader["dil_neg3"]); rowOfStorageStabilityData.Dil_Four = Convert.ToString(reader["dil_neg4"]); rowOfStorageStabilityData.Dil_Five = Convert.ToString(reader["dil_neg5"]); rowOfStorageStabilityData.Dil_Six = Convert.ToString(reader["dil_neg6"]); rowOfStorageStabilityData.Dil_Seven = Convert.ToString(reader["dil_neg7"]); rowOfStorageStabilityData.Outlier = Convert.ToBoolean(reader["outlier"]); allStorageStabilityData.Add(rowOfStorageStabilityData); } return(allStorageStabilityData); } } catch (SqlException ex) { throw; } }