protected void GrdReferrer_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Insert")) { DropDownList ddlTitle = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewTitle"); TextBox txtFirstname = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewFirstname"); TextBox txtMiddlename = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewMiddlename"); TextBox txtSurname = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewSurname"); DropDownList ddlGender = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewGender"); txtFirstname.Text = txtFirstname.Text.Trim(); txtMiddlename.Text = txtMiddlename.Text.Trim(); txtSurname.Text = txtSurname.Text.Trim(); if (txtSurname.Text.Length == 0) { SetErrorMessage("Surname can not be empty"); return; } if (txtSurname.Text.Length == 0) { SetErrorMessage("Firstname can not be empty"); return; } Staff loggedInStaff = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"])); int person_id = PersonDB.Insert(loggedInStaff.Person.PersonID, Convert.ToInt32(ddlTitle.SelectedValue), Utilities.FormatName(txtFirstname.Text), Utilities.FormatName(txtMiddlename.Text), Utilities.FormatName(txtSurname.Text), "", ddlGender.SelectedValue, new DateTime(1900, 1, 1)); ReferrerDB.Insert(person_id); FillGrid(); SetErrorMessage("Added."); } if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete")) { try { // if getting referers of an org, set the reg-ref relationship as active/inactive if (Request.QueryString["org"] != null) { int reg_ref_id = Convert.ToInt32(e.CommandArgument); if (e.CommandName.Equals("_Delete")) { RegisterReferrerDB.UpdateInactive(reg_ref_id); } else { RegisterReferrerDB.UpdateActive(reg_ref_id); } } // if getting all referrers, set the ref as active/inactive else { int referrer_id = Convert.ToInt32(e.CommandArgument); if (e.CommandName.Equals("_Delete")) { ReferrerDB.UpdateInactive(referrer_id); } else { ReferrerDB.UpdateActive(referrer_id); } } } catch (ForeignKeyConstraintException fkcEx) { if (Utilities.IsDev()) { SetErrorMessage("Can not delete because other records depend on this : " + fkcEx.Message); } else { SetErrorMessage("Can not delete because other records depend on this"); } } FillGrid(); } if (e.CommandName.Equals("ViewPatients")) { int id = Convert.ToInt32(e.CommandArgument); if (Request.QueryString["org"] == null) { FillGrid_Patients(typeof(Referrer), id); } else { FillGrid_Patients(typeof(RegisterReferrer), id); } } }
protected void GrdReferrer_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Insert")) { DropDownList ddlRefs = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewRefs"); TextBox txtProviderNumber = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewProviderNumber"); CheckBox chkIsReportEveryVisit = (CheckBox)GrdReferrer.FooterRow.FindControl("chkNewIsReportEveryVisit"); CheckBox chkIsBatchSendAllPatientsTreatmentNotes = (CheckBox)GrdReferrer.FooterRow.FindControl("chkNewIsBatchSendAllPatientsTreatmentNotes"); if (RegisterReferrerDB.Exists(Convert.ToInt32(Request.QueryString["org"]), Convert.ToInt32(ddlRefs.SelectedValue))) { SetErrorMessage("Clinic is already linked to " + ddlRefs.SelectedItem.Text + ". If it is not visible, use the 'show deleted' checkbox and un-delete it."); return; } RegisterReferrerDB.Insert(Convert.ToInt32(Request.QueryString["org"]), Convert.ToInt32(ddlRefs.SelectedValue), txtProviderNumber.Text.Trim(), chkIsReportEveryVisit.Checked, chkIsBatchSendAllPatientsTreatmentNotes.Checked); FillGrid(); } if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete")) { try { // if getting referers of an org, set the reg-ref relationship as active/inactive if (Request.QueryString["org"] != null) { int reg_ref_id = Convert.ToInt32(e.CommandArgument); if (e.CommandName.Equals("_Delete")) { RegisterReferrerDB.UpdateInactive(reg_ref_id); } else { RegisterReferrerDB.UpdateActive(reg_ref_id); } } // if getting all referrers, set the ref as active/inactive else { int referrer_id = Convert.ToInt32(e.CommandArgument); if (e.CommandName.Equals("_Delete")) { ReferrerDB.UpdateInactive(referrer_id); } else { ReferrerDB.UpdateActive(referrer_id); } } } catch (ForeignKeyConstraintException fkcEx) { if (Utilities.IsDev()) { SetErrorMessage("Can not delete because other records depend on this : " + fkcEx.Message); } else { SetErrorMessage("Can not delete because other records depend on this"); } } FillGrid(); } if (e.CommandName.Equals("ViewPatients")) { int id = Convert.ToInt32(e.CommandArgument); if (Request.QueryString["org"] == null) { FillGrid_Patients(typeof(Referrer), id); } else { FillGrid_Patients(typeof(RegisterReferrer), id); } } }