private void GenerateReports(int iValue) { List <ExTransactions> exTransactions = new List <ExTransactions>(); exTransactions = ORMForSDF.GetList_SP <ExTransactions>("spGetTransactionForMainReport", new { Val = iValue }, Properties.Settings.Default.Connection); dgvReports.AutoGenerateColumns = false; dgvReports.DataSource = exTransactions; }
private void GenerateReports(string sText) { List <ExTransactions> exTransactions = new List <ExTransactions>(); exTransactions = ORMForSDF.GetList_SP <ExTransactions>("spGetTransactionReport", new { sText = txtSearch.Text }, Properties.Settings.Default.Connection); dgvReports.AutoGenerateColumns = false; dgvReports.DataSource = exTransactions; }
private void txtPanNo_TextChanged(object sender, EventArgs e) { dgvReports.DataSource = null; List <ExTransactions> exTransactions = new List <ExTransactions>(); exTransactions = ORMForSDF.GetList_SP <ExTransactions>("spGetTransactionReport", new { sText = txtSearch.Text }, Properties.Settings.Default.Connection); dgvReports.AutoGenerateColumns = false; dgvReports.DataSource = exTransactions; }
private void txtSearch_TextChanged(object sender, EventArgs e) { dgDetails.DataSource = null; dgvReports.DataSource = null; AniHelper.PanelClearMethod(pnlCustomer); if (txtSearch.Text == string.Empty) { return; } List <Customer> exCustomers = new List <Customer>(); exCustomers = ORMForSDF.GetList_SP <Customer>("spGetMainCusomers", new { sText = txtSearch.Text }, Properties.Settings.Default.Connection); if (exCustomers.Count > 0) { dgDetails.AutoGenerateColumns = false; dgDetails.DataSource = exCustomers; customer = exCustomers.FirstOrDefault(); CustomerLoadMethod(); GenerateReports(txtSearch.Text); } }