protected void btnSave_Click(object sender, EventArgs e) { EntityPatientDiagnosis objEn = new EntityPatientDiagnosis(); BusinessEnterPatientDiagnosisDetails objBus = new BusinessEnterPatientDiagnosisDetails(); //PatientId if (ddlPatientIdName.SelectedItem.Value == "-1") { //Error Massage } else { objEn.PatientId = Convert.ToInt32(ddlPatientIdName.SelectedValue); } objEn.Symptoms = tbSymptoms.Text; objEn.DiagnosisProvided = tbDiagnosisProvided.Text; if (ddlPhysicianIdName.SelectedItem.Value == "-1") { //Error Massage } else { objEn.AdministeredBy = ddlPhysicianIdName.SelectedValue; } objEn.DateofDiagnosis = DateTime.ParseExact(tbDateofDiagnosis.Text, "dd-MM-yy", System.Globalization.CultureInfo.InvariantCulture); if (cbFollowUpRequired.Checked) { objEn.FollowUpRequired = "Y"; objEn.DateOfFollowUp = DateTime.ParseExact(tbFollowUpDate.Text, "dd-MM-yy", System.Globalization.CultureInfo.InvariantCulture); } else { objEn.FollowUpRequired = "N"; } int result; result = objBus.businessUpdateEnterPatientDiagnosisDetails(objEn); if (result == 1) //NonExecuteQuary(Stored Procedure) Execution Success { ViewState["DiagnosisId"] = objEn.DiagnosisId; //Save the DiagnosisId In a view State to pass later with billing Information. lblDiagnosisMassage.Text = "Data Inserted Secussefully" + objEn.DiagnosisId; //Enable Billing section Disable Diagnosis Section. When Diagnosis Details inserted seccessfully in Database PanelBilling.Enabled = true; PanelDiagnosis.Enabled = false; } else { lblDiagnosisMassage.Text = "Data Insertion Error"; } // Enabling the Billin Section(Panel) after clicking the Save Button }
public int businessUpdateEnterPatientDiagnosisDetails(EntityPatientDiagnosis objEn) { SqlParameter[] objPara = new SqlParameter[8]; objPara[0] = new SqlParameter("@DiagnosisId", SqlDbType.Int); //objEn.DiagnosisId = objPara[0].ParameterName().Value; //objPara[0].Value = objEn.DiagnosisId; objPara[0].Direction = ParameterDirection.Output; objPara[1] = new SqlParameter("@PatientId", SqlDbType.Int); objPara[1].Value = objEn.PatientId; objPara[2] = new SqlParameter("@Symptoms", SqlDbType.VarChar, 20); objPara[2].Value = objEn.Symptoms; objPara[3] = new SqlParameter("@DiagnosisProvided", SqlDbType.VarChar, 30); objPara[3].Value = objEn.DiagnosisProvided; objPara[4] = new SqlParameter("@AdministeredBy", SqlDbType.VarChar, 5); objPara[4].Value = objEn.AdministeredBy; objPara[5] = new SqlParameter("@DateofDiagnosis", SqlDbType.Date); objPara[5].Value = objEn.DateofDiagnosis; objPara[6] = new SqlParameter("@FollowUpRequired", SqlDbType.VarChar, 1); objPara[6].Value = objEn.FollowUpRequired; objPara[7] = new SqlParameter("@DateOfFollowUp", SqlDbType.Date); objPara[7].Value = objEn.DateOfFollowUp; int result; result = objData.dataUpdateEnterPatientDiagnosisDetails(objPara); //We are getting the output parameter from SqlParameter Class Object index:0 which is DiagnosisId //And we are setting that value to the DiagnosisId Property in the Entity Layer. objEn.DiagnosisId = Convert.ToInt32(objPara[0].Value); return(result); }