public Prescriptions InsertPrescription(Prescriptions prescriptionsObj, string connString)
{
SqlParameter pUsername = new SqlParameter("@Username", SqlDbType.NVarChar, 50);
SqlParameter pPrescriptionDateTime = new SqlParameter("@PrescriptionDateTime", SqlDbType.DateTime);
SqlParameter pQueryId = new SqlParameter("@QueryId", SqlDbType.NVarChar, 7);
SqlParameter pPrescriptionId = new SqlParameter("@PrescriptionId", SqlDbType.Int);
//parmeter value intialization
pUsername.Value = prescriptionsObj.Username;
pPrescriptionDateTime.Value = prescriptionsObj.PrescriptionDateTime;
pQueryId.Value = prescriptionsObj.QueryId;
pPrescriptionId.Direction = ParameterDirection.Output;
SqlCommand cmdSql = new SqlCommand();
cmdSql.CommandType = CommandType.StoredProcedure;
cmdSql.CommandText = "usp_InsertPrescription_test";
cmdSql.Parameters.Add(pUsername);
cmdSql.Parameters.Add(pPrescriptionDateTime);
cmdSql.Parameters.Add(pQueryId);
cmdSql.Parameters.Add(pPrescriptionId);
DataLayer datalayerObj = new DataLayer();
cmdSql = datalayerObj.Insert(cmdSql, connString);
prescriptionsObj.PrescriptionId = Convert.ToInt32(pPrescriptionId.Value);
return prescriptionsObj;
}
protected void Save_Click(object sender, EventArgs e)
{
string connectionString = ConfigurationManager.AppSettings.Get("connString");
//create prescribedMedicineObj object to Intialize
BusinessLayer businessLyerObj = new BusinessLayer();
DomainClassLayer.Prescriptions prescriptionsObj = new DomainClassLayer.Prescriptions();
prescriptionsObj.PrescriptionDateTime = DateTime.Now;
prescriptionsObj.QueryId = int.Parse(queryId.Text);
prescriptionsObj.Username = user.Text;
prescriptionsObj = businessLyerObj.InsertPrescription(prescriptionsObj, connectionString);
if (M1.Text != "")
{
PrescribedMedicine prescribedMedicineObj1 = new PrescribedMedicine();
prescribedMedicineObj1.MedicineName = M1.Text ?? null;
prescribedMedicineObj1.DosageBreakfast = (br1.Text);
prescribedMedicineObj1.DosageLunch = (lu1.Text);
prescribedMedicineObj1.DosageDinner = (di1.Text);
prescribedMedicineObj1.Days = int.Parse(NOD1.Text);
prescribedMedicineObj1.NumberOfTablets = int.Parse(NOT1.Text);
prescribedMedicineObj1.PrescriptionId = prescriptionsObj.PrescriptionId;
prescribedMedicineObj1 = businessLyerObj.InsertPrescribedMedicine(prescribedMedicineObj1, connectionString);
}
if (M2.Text != "")
{
DomainClassLayer.PrescribedMedicine prescribedMedicineObj2 = new DomainClassLayer.PrescribedMedicine();
prescribedMedicineObj2.MedicineName = M2.Text ?? null;
prescribedMedicineObj2.DosageBreakfast = (br2.Text);
prescribedMedicineObj2.DosageLunch = (lu2.Text);
prescribedMedicineObj2.DosageDinner = (di2.Text);
prescribedMedicineObj2.Days = int.Parse(NOD2.Text);
prescribedMedicineObj2.NumberOfTablets = int.Parse(NOT2.Text);
prescribedMedicineObj2 = businessLyerObj.InsertPrescribedMedicine(prescribedMedicineObj2, connectionString);
}
if (M3.Text != "")
{
PrescribedMedicine prescribedMedicineObj3 = new PrescribedMedicine();
prescribedMedicineObj3.MedicineName = M3.Text ?? null;
prescribedMedicineObj3.DosageBreakfast = (br3.Text);
prescribedMedicineObj3.DosageLunch = (lu3.Text);
prescribedMedicineObj3.DosageDinner = (di3.Text);
prescribedMedicineObj3.Days = int.Parse(NOD3.Text);
prescribedMedicineObj3.NumberOfTablets = int.Parse(NOT3.Text);
prescribedMedicineObj3 = businessLyerObj.InsertPrescribedMedicine(prescribedMedicineObj3, connectionString);
}
if (M4.Text != "")
{
PrescribedMedicine prescribedMedicineObj4 = new PrescribedMedicine();
prescribedMedicineObj4.MedicineName = M4.Text ?? null;
prescribedMedicineObj4.DosageBreakfast = (br4.Text);
prescribedMedicineObj4.DosageLunch = (lu4.Text);
prescribedMedicineObj4.DosageDinner = (di4.Text);
prescribedMedicineObj4.Days = int.Parse(NOD4.Text);
prescribedMedicineObj4.NumberOfTablets = int.Parse(NOT4.Text);
prescribedMedicineObj4 = businessLyerObj.InsertPrescribedMedicine(prescribedMedicineObj4, connectionString);
}
if (M5.Text != "")
{
PrescribedMedicine prescribedMedicineObj5 = new PrescribedMedicine();
prescribedMedicineObj5.MedicineName = M5.Text ?? null;
prescribedMedicineObj5.DosageBreakfast = (br5.Text);
prescribedMedicineObj5.DosageLunch = (lu5.Text);
prescribedMedicineObj5.DosageDinner = (di5.Text);
prescribedMedicineObj5.Days = int.Parse(NOD5.Text);
prescribedMedicineObj5.NumberOfTablets = int.Parse(NOT5.Text);
prescribedMedicineObj5 = businessLyerObj.InsertPrescribedMedicine(prescribedMedicineObj5, connectionString);
}
if (M6.Text != "")
{
PrescribedMedicine prescribedMedicineObj6 = new PrescribedMedicine();
prescribedMedicineObj6.MedicineName = M6.Text ?? null;
prescribedMedicineObj6.DosageBreakfast = (br6.Text);
prescribedMedicineObj6.DosageLunch = (lu6.Text);
prescribedMedicineObj6.DosageDinner = (di6.Text);
prescribedMedicineObj6.Days = int.Parse(NOD6.Text);
prescribedMedicineObj6.NumberOfTablets = int.Parse(NOT6.Text);
prescribedMedicineObj6 = businessLyerObj.InsertPrescribedMedicine(prescribedMedicineObj6, connectionString);
}
Response.Redirect("thankpres.aspx");
}
