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"); }