protected void btnSubmit_Click(object sender, EventArgs e)//For Entering Billing Informaiton in Database { //Database tblBilling mapped class form Entity Layer EntityBilling entityBilling = new EntityBilling(); entityBilling.BillAmount = Convert.ToInt32(tbBillAmount.Text); entityBilling.ModeOfPayment = ddlModeOfPayment.SelectedItem.Text; if (ddlModeOfPayment.SelectedItem.Text == "Card")//Card value { entityBilling.CardNumber = tbCardNumber.Text; } //Get the DiagnosisId form the ViewState variable. if (ViewState != null) { entityBilling.DiagnosisId = Convert.ToInt32(ViewState["DiagnosisId"]); } BusinessEnterPatientDiagnosisDetails bus = new BusinessEnterPatientDiagnosisDetails(); int result; result = bus.businessUpdateEnterBillingDetails(entityBilling); if (result == 1) { //Disable Billing section Enable Diagnosis Section. When Billing Details inserted seccessfully in Database. PanelBilling.Enabled = false; PanelDiagnosis.Enabled = true; lblBillingMassage.Text = "Data Inserted Secussefully"; } else { lblBillingMassage.Text = "Data Insertion Error"; } }
public int businessUpdateEnterBillingDetails(EntityBilling entityBilling) { SqlParameter[] objPara = new SqlParameter[4]; objPara[0] = new SqlParameter("@BillAmount", SqlDbType.VarChar, 20); objPara[0].Value = entityBilling.BillAmount; objPara[1] = new SqlParameter("@ModeOfPayment", SqlDbType.VarChar, 5); objPara[1].Value = entityBilling.ModeOfPayment; objPara[2] = new SqlParameter("@CardNumber", SqlDbType.VarChar, 30); objPara[2].Value = entityBilling.CardNumber; objPara[3] = new SqlParameter("@DiagnosisId", SqlDbType.Int); objPara[3].Value = entityBilling.DiagnosisId; int result; result = objData.dataUpdateEnterBillingDetails(objPara); return(result); }