//#region ReleaseFundsOptionsDropDownListSetup //public void ReleaseFundsOptionsDropDownListSetup() //{ // string releaseFundsOptionsJavascript = "this.options[this.selectedIndex].value == " // + Convert.ToInt32(ReleaseFundsOptions.AssignExistingTransferK).ToString() + " ? document.getElementById('" + ReleaseFundsTransferKTextBox.UniqueID.Replace("$", "_") + "').style.display = '' : document.getElementById('" + ReleaseFundsTransferKTextBox.UniqueID.Replace("$", "_") + "').style.display = 'none';" // + "this.options[this.selectedIndex].value == " // + Convert.ToInt32(ReleaseFundsOptions.CreateReleaseTransfer).ToString() + " ? document.getElementById('" + TransferMethodsDropDownList.UniqueID.Replace("$", "_") + "').style.display = '' : document.getElementById('" + TransferMethodsDropDownList.UniqueID.Replace("$", "_") + "').style.display = 'none';"; // if (!this.IsPostBack) // { // ReleaseFundsOptionsDropDownList.Items.Clear(); // //ReleaseFundsOptionsDropDownList.Items.Add(new ListItem("<Release Funds Options>", "-1")); // ReleaseFundsOptionsDropDownList.Items.Add(new ListItem(Utilities.CamelCaseToString(ReleaseFundsOptions.AssignExistingTransferK.ToString()), Convert.ToInt32(ReleaseFundsOptions.AssignExistingTransferK).ToString())); // ReleaseFundsOptionsDropDownList.Items.Add(new ListItem(Utilities.CamelCaseToString(ReleaseFundsOptions.CreateReleaseTransfer.ToString()), Convert.ToInt32(ReleaseFundsOptions.CreateReleaseTransfer).ToString())); // ReleaseFundsOptionsDropDownList.Attributes.Remove("onchange"); // ReleaseFundsOptionsDropDownList.Attributes.Add("onchange", "javascript:" + releaseFundsOptionsJavascript); // } // ReleaseFundsOptionsJavascriptLabel.Visible = true; // ReleaseFundsOptionsJavascriptLabel.Text = "<script type=\"text/javascript\">" + releaseFundsOptionsJavascript.Replace("this.", "document.getElementById('" + ReleaseFundsOptionsDropDownList.UniqueID.Replace("$", "_") + "').") + "</script>"; //} //#endregion //#region TransferTypesDropDownListSetup //public void TransferMethodsDropDownListSetup() //{ // this.TransferMethodsDropDownList.Items.Clear(); // this.TransferMethodsDropDownList.Items.Add(new ListItem(Utilities.CamelCaseToString(Transfer.Methods.BankTransfer.ToString()), Convert.ToInt32(Transfer.Methods.BankTransfer).ToString())); // this.TransferMethodsDropDownList.Items.Add(new ListItem(Transfer.Methods.Cheque.ToString(), Convert.ToInt32(Transfer.Methods.Cheque).ToString())); //} //#endregion #region GetTicketPromoterEvents public void GetTicketPromoterEvents() { Query ticketPromoterEventFundsQuery = new Query(); List<Q> QueryConditionList = new List<Q>(); ticketPromoterEventFundsQuery.TableElement = new Join(TicketPromoterEvent.Columns.EventK, Event.Columns.K); ticketPromoterEventFundsQuery.OrderBy = new OrderBy(Event.Columns.DateTime, OrderBy.OrderDirection.Descending); if (this.uiPromotersAutoComplete.Value != null && !uiPromotersAutoComplete.Value.Equals("")) QueryConditionList.Add(new Q(TicketPromoterEvent.Columns.PromoterK, Convert.ToInt32(uiPromotersAutoComplete.Value))); if (this.StatusDropDownList.SelectedValue != "") { if (this.StatusDropDownList.SelectedValue == "Locked") QueryConditionList.Add(TicketPromoterEvent.LockedFundsQ); else if (this.StatusDropDownList.SelectedValue == "Funds Released") QueryConditionList.Add(TicketPromoterEvent.FundsReleasedQ); else if (this.StatusDropDownList.SelectedValue == "Funds Not Released") QueryConditionList.Add(TicketPromoterEvent.AwaitingFundsReleaseQ); else if (this.StatusDropDownList.SelectedValue == "Funds Released With Money Remaining") { QueryConditionList.Add(TicketPromoterEvent.FundsReleasedQ); ticketPromoterEventFundsQuery.TableElement = new Join(ticketPromoterEventFundsQuery.TableElement, Transfer.Columns.K, TicketPromoterEvent.Columns.FundsTransferK); QueryConditionList.Add(new Q(Transfer.Columns.IsFullyApplied, false)); } else if (this.StatusDropDownList.SelectedValue == "No Plus Account") { QueryConditionList.Add(new Or(new Q(Promoter.Columns.EnableTickets, QueryOperator.IsNull, null), new Q(Promoter.Columns.EnableTickets, false))); } } if (this.SalesUsrDropDownList.SelectedValue != "") QueryConditionList.Add(new Q(Promoter.Columns.SalesUsrK, Convert.ToInt32(SalesUsrDropDownList.SelectedValue))); if (this.SalesUsrDropDownList.SelectedValue != "" || this.StatusDropDownList.SelectedValue == "No Plus Account") ticketPromoterEventFundsQuery.TableElement = new Join(ticketPromoterEventFundsQuery.TableElement, Promoter.Columns.K, TicketPromoterEvent.Columns.PromoterK); if (this.FromDateCal.Date != DateTime.MinValue) QueryConditionList.Add(new Q(Event.Columns.DateTime, QueryOperator.GreaterThanOrEqualTo, this.FromDateCal.Date)); if (this.ToDateCal.Date != DateTime.MinValue) QueryConditionList.Add(new Q(Event.Columns.DateTime, QueryOperator.LessThanOrEqualTo, this.ToDateCal.Date)); ticketPromoterEventFundsQuery.QueryCondition = new And(QueryConditionList.ToArray()); //ticketPromoterEventFundsQuery.Paging.RecordsPerPage = this.RecordsPerPage; //ticketPromoterEventFundsQuery.Paging.RequestedPage = this.PageNumber; //ticketPromoterEventFundsQuery.TopRecords = (this.PageNumber * this.RecordsPerPage) + 1; var ticketPromoterEventSet = new TicketPromoterEventSet(ticketPromoterEventFundsQuery); TicketPromoterEvent.CalculateTicketsAndRunFundLocksChecksAndReleaseFunds(ticketPromoterEventSet); ticketPromoterEventSet.Reset(); List<TicketPromoterEvent> ticketPromoterEvents = ticketPromoterEventSet.ToList().FindAll(tpe => tpe.TotalFunds > 0 || this.ShowZeroMoneyTicketRunsCheckBox.Checked); if (this.StatusDropDownList.SelectedValue == "Funds Released With Money Remaining") { for (int i = ticketPromoterEvents.Count - 1; i >= 0; i--) { if (ticketPromoterEvents[i].FundsTransfer != null && ticketPromoterEvents[i].FundsTransfer.AmountRemaining() == 0) ticketPromoterEvents.RemoveAt(i); } } this.TicketPromoterEventFundsGridView.DataSource = ticketPromoterEvents; this.TicketPromoterEventFundsGridView.DataBind(); TotalsP.Visible = ticketPromoterEvents.Count > 0; if (ticketPromoterEvents.Count > 0) { decimal totalFunds = 0; decimal totalBookingFees = 0; int totalTickets = 0; int totalRefundTickets = 0; foreach (TicketPromoterEvent tpe in ticketPromoterEvents) { totalFunds += tpe.TotalFunds; totalBookingFees += tpe.TotalBookingFees; totalTickets += tpe.SoldTickets; totalRefundTickets += tpe.CancelledTickets; } this.TotalFundsLabel.Text = totalFunds.ToString("c"); this.TotalBookingFeesLabel.Text = totalBookingFees.ToString("c"); this.TotalTicketsLabel.Text = totalTickets.ToString() + (totalRefundTickets > 0 ? " (" + totalRefundTickets.ToString() + ")" : ""); } //this.SelectAllTicketFundsLinkButton.Enabled = !FundsSelection.Equals(FundsSelectionEnum.All); //this.SelectAwaitingFundsReleaseLinkButton.Enabled = !FundsSelection.Equals(FundsSelectionEnum.AwaitingFundsRelease); //this.SelectLockedFundsLinkButton.Enabled = !FundsSelection.Equals(FundsSelectionEnum.LockedFunds); //H1Title.InnerHtml = Utilities.CamelCaseToString(FundsSelection.ToString()); //this.NextPageLinkButton.Enabled = ticketPromoterEventSet.Paging.ShowNextPageLink; //this.PrevPageLinkButton.Enabled = ticketPromoterEventSet.Paging.ShowPrevPageLink; }