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