private void getAndBindDetails() { try { int.TryParse(_selectedData[_rowNum]["TICKET_NUMBER"].ToString(), out _currentTicketNumber); _dataSet = RetailInquiry.getDetail(_currentTicketNumber); ItemsList_dg.DataSource = null; if (_dataSet.Tables.Contains("MDSE_INFO")) { ItemsList_dg.AutoGenerateColumns = false; ItemsList_dg.DataSource = _dataSet.Tables["MDSE_INFO"]; } History_dg.DataSource = null; if (_dataSet.Tables.Contains("HISTORY_INFO")) { History_dg.AutoGenerateColumns = false; DataTable dt = _dataSet.Tables["HISTORY_INFO"]; dt.Columns.Add("TOTAL_AMOUNT", typeof(double)); foreach (DataRow row in dt.Rows) { Decimal sale = 0.0m; Decimal tax = 0.0m; Decimal.TryParse(row["AMOUNT"].ToString(), out sale); Decimal.TryParse(row["SALES_TAX"].ToString(), out tax); row["TOTAL_AMOUNT"] = sale + tax; } History_dg.DataSource = _dataSet.Tables["HISTORY_INFO"]; History_dg.Columns["TranAmount"].DefaultCellStyle.Format = "c"; History_dg.Columns["SalesTax"].DefaultCellStyle.Format = "c"; History_dg.Columns["TotalAmount"].DefaultCellStyle.Format = "c"; } cust_name.Text = String.Empty; cust_dob.Text = String.Empty; cust_no.Text = String.Empty; cust_id.Text = String.Empty; cust_since.Text = String.Empty; if (_dataSet.Tables.Contains("CUSTOMER_INFO")) { cust_name.Text = _dataSet.Tables["CUSTOMER_INFO"].DefaultView[0]["CUST_NAME"].ToString(); cust_dob.Text = _dataSet.Tables["CUSTOMER_INFO"].DefaultView[0]["DOB"].ToString(); cust_no.Text = _dataSet.Tables["CUSTOMER_INFO"].DefaultView[0]["CUSTOMERNUMBER"].ToString(); cust_id.Text = _dataSet.Tables["CUSTOMER_INFO"].DefaultView[0]["ID"].ToString(); cust_since.Text = System.DateTime.Parse(_dataSet.Tables["CUSTOMER_INFO"].DefaultView[0]["SINCE"].ToString()).ToString("MM/dd/yyyy"); } txtTenderTypes.Text = String.Empty; if (_dataSet.Tables.Contains("TENDER_INFO")) { foreach (DataRow row in _dataSet.Tables["TENDER_INFO"].Rows) { txtTenderTypes.Text += row["TENDER_TYPE"] + " $" + row["REF_AMT"] + Environment.NewLine; } } //------------------------------- if (_dataSet.Relations.Contains("customerRelation")) { _dataSet.Relations.Remove("customerRelation"); } if (_dataSet.Tables.Contains("CUSTOMER_INFO") && _dataSet.Tables.Contains("MDSE_INFO")) { _dataSet.Relations.Add("customerRelation", _dataSet.Tables["CUSTOMER_INFO"].Columns["CUSTOMERNUMBER"], _dataSet.Tables["MDSE_INFO"].Columns["CUSTOMERNUMBER"], false); } Double totalAmountWithTax = ((double)_selectedData[_rowNum]["AMOUNT"]) + ((double)_selectedData[_rowNum]["TAX"]); total_sale_amount_lbl.Text = totalAmountWithTax.ToString("c"); } catch (Exception) { return; } }
private void Find_btn_Click(object sender, EventArgs e) { try { validate(); } catch (BusinessLogicException blex) { MessageBox.Show(blex.Message); return; } Cursor.Current = Cursors.WaitCursor; var retailData = new RetailInquiry() { byDate = dateOption_rb.Checked, status = (RetailInquiry.searchStatus_enum)status_cb.SelectedIndex, userID = userID_tb.Text, sortBy = (RetailInquiry.sortField_enum)sortBy_cb.SelectedIndex, sortDir = (RetailInquiry.sortDir_enum)sortDir_cb.SelectedIndex }; if (dateOption_rb.Checked) { retailData.startDate = dateCalendarStart.SelectedDate; retailData.endDate = dateCalendarEnd.SelectedDate; } else { if (!string.IsNullOrEmpty(fromMSR_tb.Text)) { int.TryParse(fromMSR_tb.Text, out retailData.lowMSR); } if (!string.IsNullOrEmpty(toMSR_tb.Text)) { int.TryParse(toMSR_tb.Text, out retailData.highMSR); } } if (!string.IsNullOrEmpty(lowSaleAmt_tb.Text)) { double.TryParse(lowSaleAmt_tb.Text, out retailData.lowSaleAmount); } if (!string.IsNullOrEmpty(highSaleAmt_tb.Text)) { double.TryParse(highSaleAmt_tb.Text, out retailData.highSaleAmount); } if (!string.IsNullOrEmpty(lowCostAmt_tb.Text)) { double.TryParse(lowCostAmt_tb.Text, out retailData.lowCostAmount); } if (!string.IsNullOrEmpty(highCostAmt_tb.Text)) { double.TryParse(highCostAmt_tb.Text, out retailData.highCostAmount); } switch (layawayOriginated_cb.SelectedIndex) { case 0: retailData.layawayOriginated = "Y"; break; case 1: retailData.layawayOriginated = "N"; break; default: retailData.layawayOriginated = ""; break; } switch (includeVoids_cb.SelectedIndex) { case 0: retailData.includeVoids = "Y"; break; case 1: retailData.includeVoids = "N"; break; default: retailData.includeVoids = ""; break; } DataSet s = null; try { s = retailData.getData(); if (s.IsNullOrEmpty()) { throw new BusinessLogicException(ReportConstants.NODATA); } } catch (BusinessLogicException blex) { MessageBox.Show(blex.Message); return; } Cursor.Current = Cursors.Default; this.Visible = false; var resultsDisplay = new RetailSearchResults(s, retailData, "RETAIL_INFO"); resultsDisplay.ShowDialog(); if (resultsDisplay.DialogResult == DialogResult.Cancel) { this.Close(); } else { this.Visible = true; } }
public RetailSearchResults(DataSet s, RetailInquiry criteria, string dataTableName) : base(s, criteria, dataTableName, "Records") { windowHeading_lb.Text = "Retail Inquiry List"; #region Data Grid Initialization ds = s; sortedByColumn = criteria.sortBy.ToString(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); this.MSR = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.DateTime = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.SaleAmount = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.CostAmount = 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.MSR, this.DateTime, this.SaleAmount, this.CostAmount, this.Status, this.UserID }); // // Shop // this.MSR.DataPropertyName = "TICKET_NUMBER"; this.MSR.HeaderText = "MSR"; this.MSR.Name = "MSR"; this.MSR.ReadOnly = true; this.MSR.Width = 125; // // DateTime // this.DateTime.DataPropertyName = "TIME_MADE"; dataGridViewCellStyle3.Format = "g"; dataGridViewCellStyle3.NullValue = null; this.DateTime.DefaultCellStyle = dataGridViewCellStyle3; this.DateTime.HeaderText = "Date Made"; this.DateTime.Name = "DateTime"; this.DateTime.ReadOnly = true; this.DateTime.Width = 150; // // SaleAmount // this.SaleAmount.DataPropertyName = "AMOUNT"; dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; dataGridViewCellStyle4.Format = "C2"; dataGridViewCellStyle4.NullValue = null; this.SaleAmount.DefaultCellStyle = dataGridViewCellStyle4; this.SaleAmount.HeaderText = "Sale Amount"; this.SaleAmount.Name = "SaleAmount"; this.SaleAmount.ReadOnly = true; this.SaleAmount.Width = 125; // // CostAmount // this.CostAmount.DataPropertyName = "COST"; dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; dataGridViewCellStyle4.Format = "C2"; dataGridViewCellStyle4.NullValue = null; this.CostAmount.DefaultCellStyle = dataGridViewCellStyle4; this.CostAmount.HeaderText = "Cost Amount"; this.CostAmount.Name = "CostAmount"; this.CostAmount.ReadOnly = true; this.CostAmount.Width = 125; // // Status // this.Status.DataPropertyName = "STATUS_CD"; this.Status.HeaderText = "Status"; this.Status.Name = "Status"; this.Status.ReadOnly = true; this.Status.Width = 125; // // UserID // this.UserID.DataPropertyName = "ENT_ID"; this.UserID.HeaderText = "UserID"; this.UserID.Name = "UserID"; this.UserID.ReadOnly = true; this.UserID.Width = 125; this.resultsGrid_dg.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.resultsGrid_dg_CellContentClick); #endregion this.Print_btn.Enabled = true; this.Print_btn.Click += new System.EventHandler(this.Print_btn_Click); }