public List <ChemicalCompatibility> GetSummaryChemicalCompatibilityData(string strain, string dataset_id, string chemical1, string chemical2, string rate_dil)
{
List <ChemicalCompatibility> summaryChemicalCompatibility = new List <ChemicalCompatibility>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_GetSummaryChemicalCompatibilityDataSql, conn);
cmd.Parameters.AddWithValue("@strain", strain);
cmd.Parameters.AddWithValue("@chemical1", chemical1);
cmd.Parameters.AddWithValue("@chemical2", chemical2);
cmd.Parameters.AddWithValue("@ratedil", rate_dil);
cmd.Parameters.AddWithValue("@dataset_id", dataset_id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ChemicalCompatibility rowOfChemicalCompatibility = new ChemicalCompatibility();
rowOfChemicalCompatibility.Dataset_ID = Convert.ToString(reader["dataset_id"]);
rowOfChemicalCompatibility.Strain = Convert.ToString(reader["strain"]);
rowOfChemicalCompatibility.Chemical = Convert.ToString(reader["chemical"]);
rowOfChemicalCompatibility.Rep = Convert.ToString(reader["rep"]);
rowOfChemicalCompatibility.Rate_Dilution = Convert.ToString(reader["rate_dilution"]);
rowOfChemicalCompatibility.Dil_Zero = Convert.ToString(reader["dil_zero"]);
rowOfChemicalCompatibility.Dil_One = Convert.ToString(reader["dil_neg1"]);
rowOfChemicalCompatibility.Dil_Two = Convert.ToString(reader["dil_neg2"]);
rowOfChemicalCompatibility.Dil_Three = Convert.ToString(reader["dil_neg3"]);
rowOfChemicalCompatibility.Dil_Four = Convert.ToString(reader["dil_neg4"]);
rowOfChemicalCompatibility.Dil_Five = Convert.ToString(reader["dil_neg5"]);
rowOfChemicalCompatibility.Dil_Six = Convert.ToString(reader["dil_neg6"]);
rowOfChemicalCompatibility.Dil_Seven = Convert.ToString(reader["dil_neg7"]);
summaryChemicalCompatibility.Add(rowOfChemicalCompatibility);
}
return(summaryChemicalCompatibility);
}
}
catch (SqlException ex)
{
throw;
}
}
public List <ChemicalCompatibility> GetChemicalCompatibilityData()
{
List <ChemicalCompatibility> allChemicalCompatibilityData = new List <ChemicalCompatibility>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_GetAllChemicalCompatibilityDataSql, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ChemicalCompatibility rowOfChemicalCompatibilityData = new ChemicalCompatibility();
rowOfChemicalCompatibilityData.Dataset_ID = Convert.ToString(reader["dataset_id"]);
rowOfChemicalCompatibilityData.Strain = Convert.ToString(reader["strain"]);
rowOfChemicalCompatibilityData.Chemical = Convert.ToString(reader["chemical"]);
rowOfChemicalCompatibilityData.Rep = Convert.ToString(reader["rep"]);
rowOfChemicalCompatibilityData.Rate_Dilution = Convert.ToString(reader["rate_dilution"]);
rowOfChemicalCompatibilityData.Notes = Convert.ToString(reader["notes"]);
rowOfChemicalCompatibilityData.Dil_Zero = Convert.ToString(reader["dil_zero"]);
rowOfChemicalCompatibilityData.Dil_One = Convert.ToString(reader["dil_neg1"]);
rowOfChemicalCompatibilityData.Dil_Two = Convert.ToString(reader["dil_neg2"]);
rowOfChemicalCompatibilityData.Dil_Three = Convert.ToString(reader["dil_neg3"]);
rowOfChemicalCompatibilityData.Dil_Four = Convert.ToString(reader["dil_neg4"]);
rowOfChemicalCompatibilityData.Dil_Five = Convert.ToString(reader["dil_neg5"]);
rowOfChemicalCompatibilityData.Dil_Six = Convert.ToString(reader["dil_neg6"]);
rowOfChemicalCompatibilityData.Dil_Seven = Convert.ToString(reader["dil_neg7"]);
rowOfChemicalCompatibilityData.Outlier = Convert.ToBoolean(reader["outlier"]);
allChemicalCompatibilityData.Add(rowOfChemicalCompatibilityData);
}
}
}
catch (SqlException ex)
{
throw;
}
return(allChemicalCompatibilityData);
}
public List <ChemicalCompatibility> GetCCforPartner(string partnerName)
{
List <ChemicalCompatibility> data = new List <ChemicalCompatibility>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_getPartnerCC, conn);
cmd.Parameters.AddWithValue("@partnerName", partnerName);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ChemicalCompatibility rowOfChemicalCompatibilityData = new ChemicalCompatibility();
rowOfChemicalCompatibilityData.Dataset_ID = Convert.ToString(reader["dataset_id"]);
rowOfChemicalCompatibilityData.Strain = Convert.ToString(reader["strain"]);
rowOfChemicalCompatibilityData.Chemical = Convert.ToString(reader["chemical"]);
rowOfChemicalCompatibilityData.Rep = Convert.ToString(reader["rep"]);
rowOfChemicalCompatibilityData.Rate_Dilution = Convert.ToString(reader["rate_dilution"]);
rowOfChemicalCompatibilityData.Dil_Zero = Convert.ToString(reader["dil_zero"]);
rowOfChemicalCompatibilityData.Dil_One = Convert.ToString(reader["dil_neg1"]);
rowOfChemicalCompatibilityData.Dil_Two = Convert.ToString(reader["dil_neg2"]);
rowOfChemicalCompatibilityData.Dil_Three = Convert.ToString(reader["dil_neg3"]);
rowOfChemicalCompatibilityData.Dil_Four = Convert.ToString(reader["dil_neg4"]);
rowOfChemicalCompatibilityData.Dil_Five = Convert.ToString(reader["dil_neg5"]);
rowOfChemicalCompatibilityData.Dil_Six = Convert.ToString(reader["dil_neg6"]);
rowOfChemicalCompatibilityData.Dil_Seven = Convert.ToString(reader["dil_neg7"]);
data.Add(rowOfChemicalCompatibilityData);
}
}
}
catch (SqlException ex)
{
throw;
}
return(data);
}
