public static void SaveNewPresc(PrescDetail newPresc)
{
cmdString = new OracleCommand();
try
{
cntString.Open();
cmdString.Connection = cntString;
cmdString.CommandText = "TESTSP_PRESC";
cmdString.CommandType = CommandType.StoredProcedure;
cmdString.ArrayBindCount = newPresc.MedID.Length;
cmdString.Parameters.Add("@PARA_PREID", OracleDbType.Varchar2).Value = newPresc.PrescID;
//cmdString.Parameters.Add("@PARA_MEDID", OracleDbType.Varchar2);
//cmdString.Parameters[0].Value = newPresc.MedID;
cmdString.Parameters.Add("@PARA_MEDID", OracleDbType.Varchar2).Value = newPresc.MedID;
//cmdString.Parameters.Add("@PARA_MEDQTY", OracleDbType.Varchar2);
//cmdString.Parameters[1].Value = newPresc.MedQty;
cmdString.Parameters.Add("@PARA_MEDQTY", OracleDbType.Varchar2).Value = newPresc.MedQty;
cmdString.ExecuteNonQuery();
}
finally
{
cntString.Close();
}
}
protected void save(object sender, EventArgs e)
{
// Populating array of Prescription ID, same length of Medication IDs and Medication Quantities
string TPrescID = displayPrescID.Text;
string[] PrescID = new string[MediArray.Length];
for (int i = 0; i < MediArray.Length; i++)
{
PrescID[i] = TPrescID;
}
PrescDetail newPrescDetails = new PrescDetail(PrescID, MediIDArray, MediQtyArray);
try
{
ConnectionClass.SaveNewPresc(newPrescDetails);
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert(' Prescription saved successfully! ');</script>");
}
catch
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert(' Cancelled ');</script>");
}
}