public PrescribedMedicine InsertPrescribedMedicine(PrescribedMedicine prescribedMedicineObj, string connString)
{
SqlParameter pMedicineName = new SqlParameter("@MedicineName", SqlDbType.NVarChar, 50);
SqlParameter pPrescriptionId = new SqlParameter("@PrescriptionId", SqlDbType.Int, 50);
SqlParameter pDosageBreakfast = new SqlParameter("@DosageBreakfast", SqlDbType.NVarChar, 7);
SqlParameter pDosageLunch = new SqlParameter("@DosageLunch", SqlDbType.NVarChar, 7);
SqlParameter pDosageDinner = new SqlParameter("@DosageDinner", SqlDbType.NVarChar, 7);
SqlParameter pDays = new SqlParameter("@Days", SqlDbType.Int, 10);
SqlParameter pNumberOfTablets = new SqlParameter("@NumberOfTablets", SqlDbType.Int, 10);
//parmeter value intialization
pMedicineName.Value = prescribedMedicineObj.MedicineName;
pPrescriptionId.Value = prescribedMedicineObj.PrescriptionId;
pDosageBreakfast.Value = prescribedMedicineObj.DosageBreakfast;
pDosageLunch.Value = prescribedMedicineObj.DosageLunch;
pDosageDinner.Value = prescribedMedicineObj.DosageDinner;
pDays.Value = prescribedMedicineObj.Days;
pNumberOfTablets.Value = prescribedMedicineObj.NumberOfTablets;
SqlCommand cmdSql = new SqlCommand();
cmdSql.CommandType = CommandType.StoredProcedure;
cmdSql.CommandText = "usp_InsertPrescribedMedicines";
cmdSql.Parameters.Add(pMedicineName);
cmdSql.Parameters.Add(pPrescriptionId);
cmdSql.Parameters.Add(pDosageBreakfast);
cmdSql.Parameters.Add(pDosageLunch);
cmdSql.Parameters.Add(pDosageDinner);
cmdSql.Parameters.Add(pDays);
cmdSql.Parameters.Add(pNumberOfTablets);
DataLayer datalayerObj = new DataLayer();
cmdSql = datalayerObj.Insert(cmdSql, connString);
return prescribedMedicineObj;
}
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");
}
