public LoanSearchResults(DataSet s, PawnInquiry criteria, string dataTableName) : base(s, criteria, dataTableName) { #region Data Grid Initialization System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); //Display grid with current principal if partial payments are allowed. if (new BusinessRulesProcedures(GlobalDataAccessor.Instance.DesktopSession).IsPartialPaymentAllowed(GlobalDataAccessor.Instance.CurrentSiteId)) { this.Shop = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.ticket = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.cust_name = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.DateTime = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.LnAmount = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.PrinicipalAmount = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.Status = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.UserID = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.resultsGrid_dg.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.Shop, this.ticket, this.cust_name, this.DateTime, this.LnAmount, this.PrinicipalAmount, this.Status, this.UserID }); } else { this.Shop = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.ticket = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.cust_name = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.DateTime = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.LnAmount = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.Status = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.UserID = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.resultsGrid_dg.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.Shop, this.ticket, this.cust_name, this.DateTime, this.LnAmount, this.Status, this.UserID }); } // // Shop // this.Shop.DataPropertyName = "STORENUMBER"; this.Shop.HeaderText = "Shop"; this.Shop.Name = "Shop"; this.Shop.ReadOnly = true; this.Shop.Width = 50; // // ticket // this.ticket.DataPropertyName = "TICKET_NUMBER"; this.ticket.HeaderText = "Current Tkt #"; this.ticket.Name = "ticket"; this.ticket.ReadOnly = true; this.ticket.Width = 83; // // cust_name // this.cust_name.DataPropertyName = "CUST_NAME"; this.cust_name.HeaderText = "Name"; this.cust_name.Name = "cust_name"; this.cust_name.ReadOnly = true; this.cust_name.Width = 170; // // DateTime // this.DateTime.DataPropertyName = "DATE_MADE"; dataGridViewCellStyle3.Format = "g"; dataGridViewCellStyle3.NullValue = null; this.DateTime.DefaultCellStyle = dataGridViewCellStyle3; this.DateTime.HeaderText = "Made Date/Time"; this.DateTime.Name = "DateTime"; this.DateTime.ReadOnly = true; this.DateTime.Width = 115; // // LnAmount // this.LnAmount.DataPropertyName = "PRIN_AMOUNT"; dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; dataGridViewCellStyle4.Format = "C2"; dataGridViewCellStyle4.NullValue = null; this.LnAmount.DefaultCellStyle = dataGridViewCellStyle4; this.LnAmount.HeaderText = "Loan Amount"; this.LnAmount.Name = "LnAmount"; this.LnAmount.ReadOnly = true; this.LnAmount.Width = 90; // // Current Prin. Amount // //Only show current principal column if partial payments are allowed. if (new BusinessRulesProcedures(GlobalDataAccessor.Instance.DesktopSession).IsPartialPaymentAllowed(GlobalDataAccessor.Instance.CurrentSiteId)) { this.PrinicipalAmount.DataPropertyName = "PartPymtPrinAmt"; dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; dataGridViewCellStyle5.Format = "C2"; dataGridViewCellStyle5.NullValue = null; this.PrinicipalAmount.DefaultCellStyle = dataGridViewCellStyle5; this.PrinicipalAmount.HeaderText = "Current Prin. Amt"; this.PrinicipalAmount.Name = "PrinAmt"; this.PrinicipalAmount.ReadOnly = true; this.PrinicipalAmount.Width = 100; } // // Status // this.Status.DataPropertyName = "STATUS_CD"; this.Status.HeaderText = "Status"; this.Status.Name = "Status"; this.Status.ReadOnly = true; this.Status.Width = 65; // // UserID // this.UserID.DataPropertyName = "ENT_ID"; this.UserID.HeaderText = "UserID"; this.UserID.Name = "UserID"; this.UserID.ReadOnly = true; this.UserID.Width = 65; this.resultsGrid_dg.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.resultsGrid_dg_CellContentClick); #endregion if (criteria.byDate) { resultsGrid_dg.Columns[4].HeaderText = StringDBMap_Enum <PawnInquiry.searchDateType_enum> .displayValue(criteria.dateType) + " Date / Time"; resultsGrid_dg.Columns[4].DataPropertyName = StringDBMap_Enum <PawnInquiry.searchDateType_enum> .toDBValue(criteria.dateType); } else { resultsGrid_dg.Columns[2].HeaderText = StringDBMap_Enum <PawnInquiry.searchTicketType_enum> .displayValue(criteria.ticketType) + " Tkt #"; resultsGrid_dg.Columns[2].DataPropertyName = StringDBMap_Enum <PawnInquiry.searchTicketType_enum> .toDBValue(criteria.ticketType); } this.Print_btn.Enabled = true; this.Print_btn.Click += new System.EventHandler(this.Print_btn_Click); }
private void Find_btn_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; PawnInquiry.searchDateType_enum dateSearchType = (PawnInquiry.searchDateType_enum) this.dateOptions_CB.SelectedIndex; PawnInquiry.searchTicketType_enum ticketSearchType = (PawnInquiry.searchTicketType_enum)TicketNumberType_CB.SelectedIndex; var loanData = new PawnInquiry() { byDate = dateOption_rb.Checked, dateType = dateSearchType, startDate = dateCalendarStart.SelectedDate, endDate = dateCalendarEnd.SelectedDate, ticketType = ticketSearchType, status = (PawnInquiry.searchStatus_enum)status_cb.SelectedIndex, userID = userID_tb.Text, sortBy = (PawnInquiry.sortField_enum)sortBy_cb.SelectedIndex, sortDir = (PawnInquiry.sortDir_enum)sortDir_cb.SelectedIndex }; if (fromTicket_tb.Text.Length > 0) { int.TryParse(fromTicket_tb.Text, out loanData.lowTicketNumber); } if (toTicket_tb.Text.Length > 0) { int.TryParse(toTicket_tb.Text, out loanData.highTicketNumber); } if (lowLoanAmt_tb.Text.Length > 0) { double.TryParse(lowLoanAmt_tb.Text, out loanData.lowAmount); } if (highLoanAmt_tb.Text.Length > 0) { double.TryParse(highLoanAmt_tb.Text, out loanData.highAmount); } switch (mailer_cb.SelectedIndex) { case 0: loanData.pfiMailer = "Y"; break; case 1: loanData.pfiMailer = "N"; break; default: loanData.pfiMailer = string.Empty; break; } DataSet s = null; try { s = loanData.getData(); if (s.IsNullOrEmpty()) { throw new BusinessLogicException(ReportConstants.NODATA); } } catch (BusinessLogicException blex) { MessageBox.Show(blex.Message); return; } //this.NavControlBox.Action = NavBox.NavAction.HIDEANDSHOW; Cursor.Current = Cursors.Default; this.Visible = false; // var resultsDisplay = new LoanSearchResults(s, loanData,"PAWN_INFO"); if (loanData.errorLevel != 0) { MessageBox.Show(loanData.errorMessage); } else { this.Visible = false; var resultsDisplay = new LoanSearchResults(s, loanData, "PAWN_INFO"); resultsDisplay.ShowDialog(); if (resultsDisplay.DialogResult == DialogResult.Cancel) { this.Close(); } else { this.Visible = true; } } }