public void CreateChemCompatFormTest()
{
//Arrange
ExperimentFormSqlDAL dalObject = new ExperimentFormSqlDAL(connectionString);
string username = "******";
List <string> chems = new List <string> {
"6-24-6", "8-19-3-1S-.2Zn", "4-24-0"
};
List <string> rateDilutions = new List <string> {
"4X", "2X", "1X", "1/2X", "1/4X", "1/8X"
};
ChemCompatForm testCCForm = new ChemCompatForm()
{
Strain = "cc test strain",
Chemicals = chems,
Reps = 2,
RateDilutions = rateDilutions
};
//Act
int[] check = dalObject.CreateChemicalCompatibilityForm(username, testCCForm);
//Assert
Assert.AreEqual(true, check[1] > 0);
}
public int[] CreateChemicalCompatibilityForm(DateTime now, ChemCompatForm newForm)
{
int datasetId = 0;
//insert statement for datasets
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd;
conn.Open();
cmd = new SqlCommand(SQL_AddDataset, conn);
cmd.Parameters.AddWithValue("@now", now);
cmd.Parameters.AddWithValue("@expType", "chem_compatibility");
datasetId = (int)cmd.ExecuteScalar();
}
}
catch (SqlException ex)
{
throw;
}
//insert satement for chem_stability
string storageStabilityInsert = "";
for (int i = 0; i < newForm.Chemicals.Count; i++)
{
for (int j = 0; j < newForm.Reps; j++)
{
for (int k = 0; k < newForm.RateDilutions.Count; k++)
{
storageStabilityInsert += "insert into chem_compatibility (dataset_id, strain, chemical, rep, rate_dilution) values(@dataset_id, @strain, '" + newForm.Chemicals[i] + "', '" + (j + 1) + "', '" + newForm.RateDilutions[k] + "');";
}
}
}
int rowsAffected = 0;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd;
conn.Open();
cmd = new SqlCommand(storageStabilityInsert, conn);
cmd.Parameters.AddWithValue("@dataset_id", datasetId);
cmd.Parameters.AddWithValue("@strain", newForm.Strain);
rowsAffected = cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw;
}
return(new int[] { datasetId, rowsAffected });
}
public ActionResult ChemCompatConfirm(ChemCompatForm newForm)
{
if (Session["currentUser"] != null)
{
if ((Session["currentUser"] as User).Researcher || (Session["currentUser"] as User).Administrator)
{
return(View(newForm));
}
}
return(RedirectToAction("AccessDenied", "User"));
}
public ActionResult CreateChemCompatForm(ChemCompatForm chemForm)
{
if (!ModelState.IsValid)
{
return(View("CreateChemCompatForm", chemForm));
}
int[] results = sqlDAL.CreateChemicalCompatibilityForm(DateTime.Now, chemForm);
//error message???
Session["lastSavedFormID"] = results[0];
return(RedirectToAction("ChemCompatConfirm", "ExperimentForm", chemForm));
}
