public void CreateBeadStabilityFormTest()
{
//Arrange
ExperimentFormSqlDAL dalObject = new ExperimentFormSqlDAL(connectionString);
string username = "******";
List <string> trts = new List <string> {
"B"
};
List <string> ages = new List <string> {
"0", "16", "20", "24"
};
BeadStabilityForm testBSForm = new BeadStabilityForm()
{
Strain = "bs test strain",
FormTreatments = trts,
TotalReps = 2,
NumPerRep = 3,
BeadAge = ages
};
//Act
int[] check = dalObject.CreateBeadStabilityForm(username, testBSForm);
//Assert
Assert.AreEqual(true, check[1] > 0);
}
//Create Bead Stability Form
public int[] CreateBeadStabilityForm(DateTime now, BeadStabilityForm bSForm)
{
int datasetID = 0;
int rowsAffected = 0;
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", "beads_stability");
datasetID = (int)cmd.ExecuteScalar();
}
}
catch (SqlException ex)
{
throw;
}
string beadStabilityInsert = "";
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd;
conn.Open();
foreach (string t in bSForm.FormTreatments)
{
foreach (string b in bSForm.BeadAge)
{
for (int i = 1; i <= bSForm.TotalReps; i++)
{
for (int j = 0; j < bSForm.NumPerRep; j++)
{
beadStabilityInsert += "INSERT INTO beads_stability (dataset_id, strain, form_trt, rep, bead_age) VALUES (@datasetid, @strain,'" + t + "', '" + i + "', '" + b + "');";
}
}
}
}
cmd = new SqlCommand(beadStabilityInsert, conn);
cmd.Parameters.AddWithValue("@datasetid", datasetID);
cmd.Parameters.AddWithValue("@strain", bSForm.Strain);
rowsAffected = cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw;
}
;
return(new int[] { datasetID, rowsAffected });
}
public ActionResult BeadStabilityConfirm(BeadStabilityForm 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 CreateBeadStabilityForm(BeadStabilityForm beadStForm)
{
if (!ModelState.IsValid)
{
return(View("CreateBeadStabilityForm", beadStForm));
}
int[] results = sqlDAL.CreateBeadStabilityForm(DateTime.Now, beadStForm);
//error view????
Session["lastSavedFormID"] = results[0];
return(RedirectToAction("BeadStabilityConfirm", "ExperimentForm", beadStForm));
}
