protected void ddlPatient_SelectedIndexChanged(object sender, EventArgs e) { if (ddlPatient.SelectedValue != "Please select a patient") { int pID = Convert.ToInt32(ddlPatient.SelectedValue); txtMedInfo.Text = new PatientDAO().getMedInfo(pID); txtMedInfo.Visible = true; DataTable dt = new TreatmentPlanningDAO().getTreatmentPlansByPatient(pID); if (dt.Rows.Count > 0) { lblMessage.Text = ""; } else { lblMessage.Text = "No dental history"; lblMessage.ForeColor = System.Drawing.Color.Red; } gvPatientHistory.DataSource = dt; gvPatientHistory.DataBind(); } else { gvPatientHistory.DataSource = null; gvPatientHistory.DataBind(); lblMessage.Text = ""; txtMedInfo.Visible = false; } }
protected void gvPatientHistory_RowCommand(object sender, GridViewCommandEventArgs e) { lblMessageDV.Text = ""; lblMessageDV.ForeColor = System.Drawing.Color.Green; if (e.CommandName == "ReceivePayment") { int tID = Convert.ToInt32(e.CommandArgument); string tName = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).Cells[1].Text; Session["tName"] = tName; DataSet ds = new TreatmentPlanningDAO().getPlanforPayment(tName, tID); dvReceivePayment.DataSource = ds; dvReceivePayment.ChangeMode(DetailsViewMode.Edit); dvReceivePayment.DataBind(); dvReceivePayment.Visible = true; } }
protected void dvReceivePayment_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { //int tID = Convert.ToInt32(dvReceivePayment.SelectedValue); //this also works to get tID int tID = Convert.ToInt32(e.Keys["tID"]); int paid = Convert.ToInt32(e.NewValues["paid"]); string tName = Session["tName"].ToString(); bool updateSuccess = new TreatmentPlanningDAO().updatePlanforPayment(tName, tID, paid); lblMessageDV.Text = "Payment updated"; lblMessageDV.ForeColor = System.Drawing.Color.Green; dvReceivePayment.DataSource = null; dvReceivePayment.ChangeMode(DetailsViewMode.ReadOnly); dvReceivePayment.DataBind(); dvReceivePayment.Visible = false; loadTreatmentPlansbyPatient(); Session["tName"] = ""; }
private void loadTreatmentPlansbyPatient() { int pID = Convert.ToInt32(ddlPatient.SelectedValue); DataTable dt = new TreatmentPlanningDAO().getTreatmentPlansByPatient(pID); if (dt.Rows.Count > 0) { lblMessageGV.Text = ""; lblMessageGV.ForeColor = System.Drawing.Color.Green; } else { lblMessageGV.Text = "New patient or no treatments ever done"; lblMessageGV.ForeColor = System.Drawing.Color.Red; } gvPatientHistory.DataSource = dt; gvPatientHistory.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int pID = Convert.ToInt32(Session["PatientID"]); txtMedInfo.Text = new PatientDAO().getMedInfo(pID); txtMedInfo.Visible = true; DataTable dt = new TreatmentPlanningDAO().getTreatmentPlansByPatient(pID); if (dt.Rows.Count > 0) { lblMessage.Text = ""; } else { lblMessage.Text = "No dental history"; lblMessage.ForeColor = System.Drawing.Color.Red; } gvPatientHistory.DataSource = dt; gvPatientHistory.DataBind(); } }