private void btnViewReport_Click(object sender, EventArgs e) { Bonus_Instrument_Receive_Report_DSE_21_3BAL objBAL = new Bonus_Instrument_Receive_Report_DSE_21_3BAL(); DataTable data = new DataTable(); frmReportViewer rptviewer = new frmReportViewer(); crBonus__Instrument__Receive__Report__DSE__21_3 objrpt = new crBonus__Instrument__Receive__Report__DSE__21_3(); try { CheckValidation(); SetInstrumentInfo(); if (_instrumentId != "" && _instrumentName == "") { //data = objBAL.BonusInstrumentReceiveReportData(dtpFromDate.Value, dtpToDate.Value, _instrumentId, ""); _instrumentName = GetInstrumentNameByInstrumentID(_instrumentId); } else if (_instrumentId == "" && _instrumentName != "") { //data = objBAL.BonusInstrumentReceiveReportData(dtpFromDate.Value, dtpToDate.Value, "", _instrumentName); _instrumentId = GetInstrumentIDByInstrumentName(_instrumentName); } data = objBAL.BonusInstrumentReceiveReportData(dtpFromDate.Value, dtpToDate.Value, _instrumentId, _instrumentName); objrpt.SetDataSource(data); ((TextObject)objrpt.Section2.ReportObjects["txtfromDate"]).Text = Convert.ToDateTime(dtpFromDate.Value.ToString()).ToString("dd/MM/yyyy"); ((TextObject)(objrpt.Section2.ReportObjects["txttoDate"])).Text = Convert.ToDateTime(dtpToDate.Value.ToShortDateString()).ToString("dd/MM/yyyy"); rptviewer.crvReportViewer.ReportSource = objrpt; rptviewer.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private string GetInstrumentIDByInstrumentName(string _instrumentname) { Bonus_Instrument_Receive_Report_DSE_21_3BAL objBAL = new Bonus_Instrument_Receive_Report_DSE_21_3BAL(); string tempInstrumentname = ""; tempInstrumentname = objBAL.GetInstrumentIDByName(_instrumentname); return(tempInstrumentname); }
private string GetInstrumentNameByInstrumentID(string _instrumentID) { Bonus_Instrument_Receive_Report_DSE_21_3BAL objBAL = new Bonus_Instrument_Receive_Report_DSE_21_3BAL(); string tempInstrumentID = ""; tempInstrumentID = objBAL.GetInstrumentNameByID(_instrumentID); return(tempInstrumentID); }
private void frmBonus_Instrument_Receive_Report_DSE_21_3_Load(object sender, EventArgs e) { try { Bonus_Instrument_Receive_Report_DSE_21_3BAL objBAL = new Bonus_Instrument_Receive_Report_DSE_21_3BAL(); ddlInstrumentID.DataSource = objBAL.GetInstrumentID(); ddlInstrumentID.DisplayMember = "Comp_Short_Code"; ddlInstrumentName.DataSource = objBAL.GetInstrumentName(); ddlInstrumentName.DisplayMember = "Comp_Name"; rdbByInstrumentID.Checked = true; ddlInstrumentName.Enabled = false; ddlInstrumentName.SelectedIndex = -1; } catch {} }