public void CreateStorageStabilityFormTest()
{
//Arrange
ExperimentFormSqlDAL dalObject = new ExperimentFormSqlDAL(connectionString);
string username = "******";
List <string> trts = new List <string> {
"baselinetest", "beadstest"
};
List <string> ages = new List <string> {
"0", "2", "4", "6"
};
List <string> dpas = new List <string> {
"2", "7", "14"
};
StorageStabilityForm testSSForm = new StorageStabilityForm()
{
Strain = "ss test strain",
FormTreatments = trts,
Reps = 3,
PreActivationAges = ages,
TempdegreesCelsius = "RT",
DPAs = dpas
};
//Act
int[] check = dalObject.CreateStorageStabilityForm(username, testSSForm);
//Assert
Assert.AreEqual(true, check[1] > 0);
}
public ActionResult StorageStabilityConfirm(StorageStabilityForm 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 CreateStorageStabilityForm(StorageStabilityForm storageStForm)
{
if (!ModelState.IsValid)
{
return(View("CreateStorageStabilityForm", storageStForm));
}
int[] results = sqlDAL.CreateStorageStabilityForm(DateTime.Now, storageStForm);
//error view????
Session["lastSavedFormID"] = results[0];
return(RedirectToAction("StorageStabilityConfirm", "ExperimentForm", storageStForm));
}
//Create Storage Stability Form
public int[] CreateStorageStabilityForm(DateTime now, StorageStabilityForm 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", "storage_stability");
datasetId = (int)cmd.ExecuteScalar();
}
}
catch (SqlException ex)
{
throw;
}
//insert satement for storage_stability
string storageStabilityInsert = "";
for (int i = 0; i < newForm.PreActivationAges.Count; i++)
{
for (int j = 0; j < newForm.FormTreatments.Count; j++)
{
for (int k = 0; k < newForm.DPAs.Count; k++)
{
for (int m = 0; m < newForm.Reps; m++)
{
storageStabilityInsert += "insert into storage_stability (dataset_id, strain, form_trt, rep, preactivation_age, temp, dpa) values(@dataset_id, @strain, '" + newForm.FormTreatments[j] + "', '" + (m + 1) + "', '" + newForm.PreActivationAges[i] + "', @temp, '" + newForm.DPAs[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);
cmd.Parameters.AddWithValue("@temp", newForm.TempdegreesCelsius);
rowsAffected = cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw;
}
return(new int[] { datasetId, rowsAffected });
}
