protected void GrdOrganisation_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Insert")) { DropDownList ddlParent = (DropDownList)GrdOrganisation.FooterRow.FindControl("ddlNewParent"); DropDownList ddlUseParentOffernigPrices = (DropDownList)GrdOrganisation.FooterRow.FindControl("ddlUseParentOffernigPrices"); TextBox txtName = (TextBox)GrdOrganisation.FooterRow.FindControl("txtNewName"); DropDownList ddlType = (DropDownList)GrdOrganisation.FooterRow.FindControl("ddlNewType"); DropDownList ddlCustType = (DropDownList)GrdOrganisation.FooterRow.FindControl("ddlNewCustType"); TextBox txtABN = (TextBox)GrdOrganisation.FooterRow.FindControl("txtNewABN"); TextBox txtACN = (TextBox)GrdOrganisation.FooterRow.FindControl("txtNewACN"); TextBox txtBPayAccount = (TextBox)GrdOrganisation.FooterRow.FindControl("txtNewBPayAccount"); DropDownList ddlServiceCycle = (DropDownList)GrdOrganisation.FooterRow.FindControl("ddlNewServiceCycle"); DropDownList ddlIsDebtor = (DropDownList)GrdOrganisation.FooterRow.FindControl("ddlNewIsDebtor"); DropDownList ddlIsCreditor = (DropDownList)GrdOrganisation.FooterRow.FindControl("ddlNewIsCreditor"); DropDownList ddlFreeServices = (DropDownList)GrdOrganisation.FooterRow.FindControl("ddlNewFreeServices"); TimeSpan defaultDayStartTime = new TimeSpan(8, 0, 0); TimeSpan defaultDayEndTime = new TimeSpan(20, 0, 0); TimeSpan defaultDayLunchStartTime = new TimeSpan(12, 0, 0); TimeSpan defaultDayLunchEndTime = new TimeSpan(12, 0, 0); UrlParamType urlParamType = GetUrlParamType(); if (urlParamType == UrlParamType.External) { if (urlParamType == UrlParamType.External && IsValidFormOrgTypeIDs() && GetFormOrgTypeIDs() == "191") { OrganisationDB.InsertExtOrg(Convert.ToInt32(GetFormOrgTypeIDs()), txtName.Text, txtACN.Text, txtABN.Text, OrganisationTypeDB.IsDebtor(191), OrganisationTypeDB.IsCreditor(191), "", ""); } else { OrganisationDB.Insert(Convert.ToInt32(ddlParent.SelectedValue), false, Convert.ToInt32(ddlType.SelectedValue), Convert.ToInt32(ddlCustType.SelectedValue), txtName.Text, txtACN.Text, txtABN.Text, OrganisationTypeDB.IsDebtor(Convert.ToInt32(ddlType.SelectedValue)), OrganisationTypeDB.IsCreditor(Convert.ToInt32(ddlType.SelectedValue)), "", 0, DateTime.MinValue, DateTime.MinValue, "", 0, //txtBPayAccount.Text, Convert.ToInt32(ddlServiceCycle.SelectedValue), //DateTime.MinValue DateTime.MinValue, "", Convert.ToInt32(ddlFreeServices.SelectedValue), false, false, false, false, false, false, false, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, DateTime.MinValue); } } else { OrganisationDB.Insert(Convert.ToInt32(ddlParent.SelectedValue), Convert.ToBoolean(ddlUseParentOffernigPrices.SelectedValue), Convert.ToInt32(ddlType.SelectedValue), Convert.ToInt32(ddlCustType.SelectedValue), txtName.Text, txtACN.Text, txtABN.Text, OrganisationTypeDB.IsDebtor(Convert.ToInt32(ddlType.SelectedValue)), OrganisationTypeDB.IsCreditor(Convert.ToInt32(ddlType.SelectedValue)), txtBPayAccount.Text, Convert.ToInt32(ddlServiceCycle.SelectedValue), DateTime.MinValue, DateTime.MinValue, "", Convert.ToInt32(ddlFreeServices.SelectedValue), true, false, false, false, false, false, true, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayStartTime, defaultDayEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, defaultDayLunchStartTime, defaultDayLunchEndTime, DateTime.MinValue); } FillGrid(); } if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete")) { int organisation_id = Convert.ToInt32(e.CommandArgument); try { if (e.CommandName.Equals("_Delete")) { OrganisationDB.UpdateInactive(organisation_id); } else { OrganisationDB.UpdateActive(organisation_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(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { // need to be able to roll back .. so keep id's same as invoice int person_id = -1; int referrer_id = -1; int new_org_id = 0; bool referrer_added = false; int address_id = -1; int phone_id1 = -1; int phone_id2 = -1; int email_id = -1; bool contacts_added = false; try { // add referrer if (lblId.Text == "-1") // add new referrer { Staff loggedInStaff = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"])); 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)); referrer_id = ReferrerDB.Insert(person_id); } else // set existing referrer { referrer_id = Convert.ToInt32(lblId.Text); } // get org (or add new org) int org_id = 0; if (orgsListRow.Visible) { org_id = Convert.ToInt32(ddlOrgsList.SelectedValue); } else { org_id = new_org_id = OrganisationDB.InsertExtOrg(191, txtOrgName.Text, txtOrgACN.Text, txtOrgABN.Text, false, false, "", txtOrgComments.Text); // add contact info Organisation org = OrganisationDB.GetByID(org_id); if (Utilities.GetAddressType().ToString() == "Contact") { if (txtAddressAddrLine1.Text.Trim().Length > 0 || txtAddressAddrLine2.Text.Trim().Length > 0) { address_id = ContactDB.Insert(org.EntityID, Convert.ToInt32(ddlAddressContactType.SelectedValue), txtAddressFreeText.Text, txtAddressAddrLine1.Text, txtAddressAddrLine2.Text, Convert.ToInt32(ddlAddressAddressChannel.SelectedValue), //Convert.ToInt32(ddlAddressSuburb.SelectedValue), Convert.ToInt32(suburbID.Value), Convert.ToInt32(ddlAddressCountry.SelectedValue), Convert.ToInt32(Session["SiteID"]), true, true); } if (txtPhoneNumber1.Text.Trim().Length > 0) { phone_id1 = ContactDB.Insert(org.EntityID, Convert.ToInt32(ddlPhoneNumber1.SelectedValue), txtPhoneNumber1FreeText.Text, System.Text.RegularExpressions.Regex.Replace(txtPhoneNumber1.Text, "[^0-9]", ""), string.Empty, -1, -1, -1, Convert.ToInt32(Session["SiteID"]), true, true); } if (txtPhoneNumber2.Text.Trim().Length > 0) { phone_id2 = ContactDB.Insert(org.EntityID, Convert.ToInt32(ddlPhoneNumber2.SelectedValue), txtPhoneNumber2FreeText.Text, System.Text.RegularExpressions.Regex.Replace(txtPhoneNumber2.Text, "[^0-9]", ""), string.Empty, -1, -1, -1, Convert.ToInt32(Session["SiteID"]), true, true); } if (txtEmailAddrLine1.Text.Trim().Length > 0) { email_id = ContactDB.Insert(org.EntityID, Convert.ToInt32(ddlEmailContactType.SelectedValue), "", txtEmailAddrLine1.Text, string.Empty, -1, -1, -1, Convert.ToInt32(Session["SiteID"]), true, true); } } else if (Utilities.GetAddressType().ToString() == "ContactAus") { if (txtAddressAddrLine1.Text.Trim().Length > 0 || txtAddressAddrLine2.Text.Trim().Length > 0) { address_id = ContactAusDB.Insert(org.EntityID, Convert.ToInt32(ddlAddressContactType.SelectedValue), txtAddressFreeText.Text, txtAddressAddrLine1.Text, txtAddressAddrLine2.Text, txtStreet.Text, Convert.ToInt32(ddlAddressAddressChannelType.SelectedValue), //Convert.ToInt32(ddlAddressSuburb.SelctedValue), Convert.ToInt32(suburbID.Value), Convert.ToInt32(ddlAddressCountry.SelectedValue), Convert.ToInt32(Session["SiteID"]), true, true); } if (txtPhoneNumber1.Text.Trim().Length > 0) { phone_id1 = ContactAusDB.Insert(org.EntityID, Convert.ToInt32(ddlPhoneNumber1.SelectedValue), txtPhoneNumber1FreeText.Text, System.Text.RegularExpressions.Regex.Replace(txtPhoneNumber1.Text, "[^0-9]", ""), string.Empty, string.Empty, -1, -1, -1, Convert.ToInt32(Session["SiteID"]), true, true); } if (txtPhoneNumber2.Text.Trim().Length > 0) { phone_id2 = ContactAusDB.Insert(org.EntityID, Convert.ToInt32(ddlPhoneNumber2.SelectedValue), txtPhoneNumber2FreeText.Text, System.Text.RegularExpressions.Regex.Replace(txtPhoneNumber2.Text, "[^0-9]", ""), string.Empty, string.Empty, -1, -1, -1, Convert.ToInt32(Session["SiteID"]), true, true); } if (txtEmailAddrLine1.Text.Trim().Length > 0) { email_id = ContactAusDB.Insert(org.EntityID, Convert.ToInt32(ddlEmailContactType.SelectedValue), "", txtEmailAddrLine1.Text, string.Empty, string.Empty, -1, -1, -1, Convert.ToInt32(Session["SiteID"]), true, true); } } else { throw new Exception("Unknown AddressType in config: " + Utilities.GetAddressType().ToString().ToString()); } } contacts_added = true; // join association RegisterReferrerDB.Insert(org_id, referrer_id, txtProviderNumber.Text, chkIsReportEveryVisit.Checked, chkIsBatchSendAllPatientsTreatmentNotes.Checked); referrer_added = true; if (GetUrlIsPopup()) { Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script language=javascript>window.returnValue=false;self.close();</script>"); } else { Response.Redirect("~/ReferrerList_DoctorClinicV2.aspx?surname_search=" + Utilities.FormatName(txtSurname.Text) + "&surname_starts_with=1", false); return; } } catch (Exception) { // roll back - backwards of creation order if (Utilities.GetAddressType().ToString() == "Contact") { ContactDB.Delete(address_id); ContactDB.Delete(phone_id1); ContactDB.Delete(phone_id2); ContactDB.Delete(email_id); } else if (Utilities.GetAddressType().ToString() == "ContactAus") { ContactAusDB.Delete(address_id); ContactAusDB.Delete(phone_id1); ContactAusDB.Delete(phone_id2); ContactAusDB.Delete(email_id); } else { throw new Exception("Unknown AddressType in config: " + Utilities.GetAddressType().ToString().ToString()); } OrganisationDB.Delete(new_org_id); ReferrerDB.Delete(referrer_id); PersonDB.Delete(person_id); throw; } }
protected void GrdReferrer_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Insert")) { DropDownList ddlTitle = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewTitle"); TextBox txtName = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewName"); TextBox txtABN = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewABN"); TextBox txtACN = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewACN"); OrganisationDB.InsertExtOrg(191, txtName.Text, txtACN.Text, txtABN.Text, false, false, "", ""); FillGrid(); } if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete")) { try { // if getting orgs of a referer, set the reg-ref relationship as active/inactive if (Request.QueryString["referrer"] != 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 orgs, set the org as active/inactive else { int org_id = Convert.ToInt32(e.CommandArgument); if (e.CommandName.Equals("_Delete")) { OrganisationDB.UpdateInactive(org_id); } else { OrganisationDB.UpdateActive(org_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["referrer"] == null) { FillGrid_Patients(typeof(Organisation), id); } else { FillGrid_Patients(typeof(RegisterReferrer), id); } } }
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"); TextBox txtName = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewName"); TextBox txtABN = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewABN"); TextBox txtACN = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewACN"); TextBox txtProviderNumber = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewProviderNumber"); DropDownList ddlIsClinic = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewIsClinic"); CheckBox chkIsReportEveryVisit = (CheckBox)GrdReferrer.FooterRow.FindControl("chkNewIsReportEveryVisit"); CheckBox chkIsBatchSendAllPatientsTreatmentNotes = (CheckBox)GrdReferrer.FooterRow.FindControl("chkNewIsBatchSendAllPatientsTreatmentNotes"); int person_id = -1; int referrer_id = -1; int organisation_id = 0; int register_referrer_id = -1; try { Staff loggedInStaff = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"])); 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)); referrer_id = ReferrerDB.Insert(person_id); organisation_id = OrganisationDB.InsertExtOrg(191, txtName.Text, txtACN.Text, txtABN.Text, false, false, "", ""); register_referrer_id = RegisterReferrerDB.Insert(organisation_id, referrer_id, txtProviderNumber.Text, chkIsReportEveryVisit.Checked, chkIsBatchSendAllPatientsTreatmentNotes.Checked); FillGrid(); } catch (Exception) { // roll back - backwards of creation order RegisterReferrerDB.Delete(register_referrer_id); OrganisationDB.Delete(organisation_id); ReferrerDB.Delete(referrer_id); PersonDB.Delete(person_id); } } if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete")) { int register_referrer_id = Convert.ToInt32(e.CommandArgument); try { if (e.CommandName.Equals("_Delete")) { RegisterReferrerDB.UpdateInactive(register_referrer_id); } else { RegisterReferrerDB.UpdateActive(register_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(); } }