public List <BeadStabilityRowData> GetSummaryBeadStabilityData(string strain, string dataset_id_1, string dataset_id_2, string hours, string formTreatment1, string formTreatment2)
{
List <BeadStabilityRowData> summaryBeadStabilityData = new List <BeadStabilityRowData>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
string SQL_SummaryBeadStabilityData = "";
string columnDilName = "";
if (hours == "1")
{
SQL_SummaryBeadStabilityData = "SELECT dataset_id, strain, form_trt, rep, bead_age, dil_1HR_zero, dil_1HR_neg1, dil_1HR_neg2, dil_1HR_neg3, dil_1HR_neg4, dil_1HR_neg5, dil_1HR_neg6, dil_1HR_neg7 From beads_stability WHERE strain = @strain AND dataset_id = @dataset_id_1 OR dataset_id = @dataset_id_2 AND form_trt = @formtreatment1 OR form_trt = @formtreatment2;";
columnDilName = "dil_1HR_";
}
else if (hours == "6")
{
SQL_SummaryBeadStabilityData = "SELECT dataset_id, strain, form_trt, rep, bead_age, dil_6HR_zero, dil_6HR_neg1, dil_6HR_neg2, dil_6HR_neg3, dil_6HR_neg4, dil_6HR_neg5, dil_6HR_neg6, dil_6HR_neg7 From beads_stability WHERE strain = @strain AND dataset_id = @dataset_id_1 OR dataset_id = @dataset_id_2 AND form_trt = @formtreatment1 OR form_trt = @formtreatment2;";
columnDilName = "dil_6HR_";
}
else if (hours == "24")
{
SQL_SummaryBeadStabilityData = "SELECT dataset_id, strain, form_trt, rep, bead_age, dil_24HR_zero, dil_24HR_neg1, dil_24HR_neg2, dil_24HR_neg3, dil_24HR_neg4, dil_24HR_neg5, dil_24HR_neg6, dil_24HR_neg7 From beads_stability WHERE strain = @strain AND dataset_id = @dataset_id_1 OR dataset_id = @dataset_id_2 AND form_trt = @formtreatment1 OR form_trt = @formtreatment2;";
columnDilName = "dil_24HR_";
}
SqlCommand cmd = new SqlCommand(SQL_SummaryBeadStabilityData, conn);
cmd.Parameters.AddWithValue("@strain", strain);
cmd.Parameters.AddWithValue("@dataset_id_1", dataset_id_1);
cmd.Parameters.AddWithValue("@dataset_id_2", dataset_id_2);
cmd.Parameters.AddWithValue("@formtreatment1", formTreatment1);
cmd.Parameters.AddWithValue("@formtreatment2", formTreatment2);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BeadStabilityRowData rowOfBeadStabilityData = new BeadStabilityRowData();
rowOfBeadStabilityData.Dataset_ID = Convert.ToString(reader["dataset_id"]);
rowOfBeadStabilityData.Strain = Convert.ToString(reader["strain"]);
rowOfBeadStabilityData.FormulationTitration = Convert.ToString(reader["form_trt"]);
rowOfBeadStabilityData.Rep = Convert.ToString(reader["rep"]);
rowOfBeadStabilityData.BeadAge = Convert.ToString(reader["bead_age"]);
rowOfBeadStabilityData.Dil_1HR_Zero = Convert.ToString(reader[columnDilName + "zero"]);
rowOfBeadStabilityData.Dil_1HR_One = Convert.ToString(reader[columnDilName + "neg1"]);
rowOfBeadStabilityData.Dil_1HR_Two = Convert.ToString(reader[columnDilName + "neg2"]);
rowOfBeadStabilityData.Dil_1HR_Three = Convert.ToString(reader[columnDilName + "neg3"]);
rowOfBeadStabilityData.Dil_1HR_Four = Convert.ToString(reader[columnDilName + "neg4"]);
rowOfBeadStabilityData.Dil_1HR_Five = Convert.ToString(reader[columnDilName + "neg5"]);
rowOfBeadStabilityData.Dil_1HR_Six = Convert.ToString(reader[columnDilName + "neg6"]);
rowOfBeadStabilityData.Dil_1HR_Seven = Convert.ToString(reader[columnDilName + "neg7"]);
summaryBeadStabilityData.Add(rowOfBeadStabilityData);
}
return(summaryBeadStabilityData);
}
}
catch (SqlException ex)
{
throw;
}
}
public List <BeadStabilityRowData> GetBeadStabilityData()
{
List <BeadStabilityRowData> allBeadStabilityData = new List <BeadStabilityRowData>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_GetAllBeadStabilityDataSql, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BeadStabilityRowData rowOfBeadStabilityData = new BeadStabilityRowData();
rowOfBeadStabilityData.Dataset_ID = Convert.ToString(reader["dataset_id"]);
rowOfBeadStabilityData.Strain = Convert.ToString(reader["strain"]);
rowOfBeadStabilityData.FormulationTitration = Convert.ToString(reader["form_trt"]);
rowOfBeadStabilityData.Rep = Convert.ToString(reader["rep"]);
rowOfBeadStabilityData.BeadAge = Convert.ToString(reader["notes"]);
rowOfBeadStabilityData.Dil_1HR_Zero = Convert.ToString(reader["dil_1HR_zero"]);
rowOfBeadStabilityData.Dil_1HR_One = Convert.ToString(reader["dil_1HR_neg1"]);
rowOfBeadStabilityData.Dil_1HR_Two = Convert.ToString(reader["dil_1HR_neg2"]);
rowOfBeadStabilityData.Dil_1HR_Three = Convert.ToString(reader["dil_1HR_neg3"]);
rowOfBeadStabilityData.Dil_1HR_Four = Convert.ToString(reader["dil_1HR_neg4"]);
rowOfBeadStabilityData.Dil_1HR_Five = Convert.ToString(reader["dil_1HR_neg5"]);
rowOfBeadStabilityData.Dil_1HR_Six = Convert.ToString(reader["dil_1HR_neg6"]);
rowOfBeadStabilityData.Dil_1HR_Seven = Convert.ToString(reader["dil_1HR_neg7"]);
rowOfBeadStabilityData.Dil_6HR_Zero = Convert.ToString(reader["dil_6HR_zero"]);
rowOfBeadStabilityData.Dil_6HR_One = Convert.ToString(reader["dil_6HR_neg1"]);
rowOfBeadStabilityData.Dil_6HR_Two = Convert.ToString(reader["dil_6HR_neg2"]);
rowOfBeadStabilityData.Dil_6HR_Three = Convert.ToString(reader["dil_6HR_neg3"]);
rowOfBeadStabilityData.Dil_6HR_Four = Convert.ToString(reader["dil_6HR_neg4"]);
rowOfBeadStabilityData.Dil_6HR_Five = Convert.ToString(reader["dil_6HR_neg5"]);
rowOfBeadStabilityData.Dil_6HR_Six = Convert.ToString(reader["dil_6HR_neg6"]);
rowOfBeadStabilityData.Dil_6HR_Seven = Convert.ToString(reader["dil_6HR_neg7"]);
rowOfBeadStabilityData.Dil_6HR_Eight = Convert.ToString(reader["dil_6HR_neg8"]);
rowOfBeadStabilityData.Dil_24HR_Zero = Convert.ToString(reader["dil_24HR_zero"]);
rowOfBeadStabilityData.Dil_24HR_One = Convert.ToString(reader["dil_24HR_neg1"]);
rowOfBeadStabilityData.Dil_24HR_Two = Convert.ToString(reader["dil_24HR_neg2"]);
rowOfBeadStabilityData.Dil_24HR_Three = Convert.ToString(reader["dil_24HR_neg3"]);
rowOfBeadStabilityData.Dil_24HR_Four = Convert.ToString(reader["dil_24HR_neg4"]);
rowOfBeadStabilityData.Dil_24HR_Five = Convert.ToString(reader["dil_24HR_neg5"]);
rowOfBeadStabilityData.Dil_24HR_Six = Convert.ToString(reader["dil_24HR_neg6"]);
rowOfBeadStabilityData.Dil_24HR_Seven = Convert.ToString(reader["dil_24HR_neg7"]);
rowOfBeadStabilityData.Outlier = Convert.ToBoolean(reader["outlier"]);
allBeadStabilityData.Add(rowOfBeadStabilityData);
}
return(allBeadStabilityData);
}
}
catch (SqlException ex)
{
throw;
}
}
public List <BeadStabilityRowData> GetBSforPartner(string partnerName)
{
List <BeadStabilityRowData> data = new List <BeadStabilityRowData>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_getPartnerBS, conn);
cmd.Parameters.AddWithValue("@partnerName", partnerName);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BeadStabilityRowData rowOfBeadStabilityData = new BeadStabilityRowData();
rowOfBeadStabilityData.Dataset_ID = Convert.ToString(reader["dataset_id"]);
rowOfBeadStabilityData.Strain = Convert.ToString(reader["strain"]);
rowOfBeadStabilityData.FormulationTitration = Convert.ToString(reader["form_trt"]);
rowOfBeadStabilityData.Rep = Convert.ToString(reader["rep"]);
rowOfBeadStabilityData.BeadAge = Convert.ToString(reader["notes"]);
rowOfBeadStabilityData.Dil_1HR_Zero = Convert.ToString(reader["dil_1HR_zero"]);
rowOfBeadStabilityData.Dil_1HR_One = Convert.ToString(reader["dil_1HR_neg1"]);
rowOfBeadStabilityData.Dil_1HR_Two = Convert.ToString(reader["dil_1HR_neg2"]);
rowOfBeadStabilityData.Dil_1HR_Three = Convert.ToString(reader["dil_1HR_neg3"]);
rowOfBeadStabilityData.Dil_1HR_Four = Convert.ToString(reader["dil_1HR_neg4"]);
rowOfBeadStabilityData.Dil_1HR_Five = Convert.ToString(reader["dil_1HR_neg5"]);
rowOfBeadStabilityData.Dil_1HR_Six = Convert.ToString(reader["dil_1HR_neg6"]);
rowOfBeadStabilityData.Dil_1HR_Seven = Convert.ToString(reader["dil_1HR_neg7"]);
rowOfBeadStabilityData.Dil_6HR_Zero = Convert.ToString(reader["dil_6HR_zero"]);
rowOfBeadStabilityData.Dil_6HR_One = Convert.ToString(reader["dil_6HR_neg1"]);
rowOfBeadStabilityData.Dil_6HR_Two = Convert.ToString(reader["dil_6HR_neg2"]);
rowOfBeadStabilityData.Dil_6HR_Three = Convert.ToString(reader["dil_6HR_neg3"]);
rowOfBeadStabilityData.Dil_6HR_Four = Convert.ToString(reader["dil_6HR_neg4"]);
rowOfBeadStabilityData.Dil_6HR_Five = Convert.ToString(reader["dil_6HR_neg5"]);
rowOfBeadStabilityData.Dil_6HR_Six = Convert.ToString(reader["dil_6HR_neg6"]);
rowOfBeadStabilityData.Dil_6HR_Seven = Convert.ToString(reader["dil_6HR_neg7"]);
rowOfBeadStabilityData.Dil_6HR_Eight = Convert.ToString(reader["dil_6HR_neg8"]);
rowOfBeadStabilityData.Dil_24HR_Zero = Convert.ToString(reader["dil_24HR_zero"]);
rowOfBeadStabilityData.Dil_24HR_One = Convert.ToString(reader["dil_24HR_neg1"]);
rowOfBeadStabilityData.Dil_24HR_Two = Convert.ToString(reader["dil_24HR_neg2"]);
rowOfBeadStabilityData.Dil_24HR_Three = Convert.ToString(reader["dil_24HR_neg3"]);
rowOfBeadStabilityData.Dil_24HR_Four = Convert.ToString(reader["dil_24HR_neg4"]);
rowOfBeadStabilityData.Dil_24HR_Five = Convert.ToString(reader["dil_24HR_neg5"]);
rowOfBeadStabilityData.Dil_24HR_Six = Convert.ToString(reader["dil_24HR_neg6"]);
rowOfBeadStabilityData.Dil_24HR_Seven = Convert.ToString(reader["dil_24HR_neg7"]);
data.Add(rowOfBeadStabilityData);
}
return(data);
}
}
catch (SqlException ex)
{
throw;
}
}
