private void btnVendor_Click(object sender, EventArgs e) { object rValue; rValue = FrmGSearch.Show("Select PrID,Convert(varchar(12),PrDate,106) AS [PrDate],VendorName From Trans_PurchaseM Where IsActive=1", false, "All Purchase Items"); if (rValue == null) { return; } PrID = long.Parse(rValue.ToString()); DataTable dt = new DataTable(); Bp_RptPurchase NewBP = new Bp_RptPurchase(); dt = NewBP.GetVendorName(int.Parse(PrID.ToString())); if (dt.Rows.Count > 0) { txtVendorName.Text = dt.Rows[0]["VendorName"].ToString(); } dt.Dispose(); }
private void btnPreview_Click(object sender, EventArgs e) { try { if (!ValidateReportForm()) { return; } if (lstvReports.SelectedItems[0].Key.Equals("RptClientIssuenceDateWise")) { DataTable dt = new DataTable(); BP_RptClientIssuencecDateWise NewBP = new BP_RptClientIssuencecDateWise(); dt = NewBP.GetReportData(int.Parse(ClientID.ToString())); if (dt.Rows.Count == 0) { MessageBox.Show("No Record Found", "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } else { Reports.RptClientIssuenceDateWise rpt = new EasyRashanManagementSystem.Reports.RptClientIssuenceDateWise(); rpt.SetDataSource(dt); CommonDAL.ShowReport(rpt, "Isuence Report DateWise"); dt.Dispose(); } } if (lstvReports.SelectedItems[0].Key.Equals("RptStockBalance")) { DataTable dt = new DataTable(); BP_RptStockBalance NewBPObj = new BP_RptStockBalance(); dt = NewBPObj.GetStockBalance(); if (dt.Rows.Count == 0) { MessageBox.Show("No Record Found", "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { Reports.RptStockBalance rpt = new EasyRashanManagementSystem.Reports.RptStockBalance(); rpt.SetDataSource(dt); TextObject txtDate = (TextObject)rpt.ReportDefinition.ReportObjects["txtDate"]; txtDate.Text = DateTime.Now.ToString(); CommonDAL.ShowReport(rpt, "Stock Balance Report"); dt.Dispose(); } } if (lstvReports.SelectedItems[0].Key.Equals("Rpt_Purchase")) { DataTable dt = new DataTable(); Bp_RptPurchase NewBP = new Bp_RptPurchase(); dt = NewBP.ShowPurchaseItems(int.Parse(PrID.ToString())); if (dt.Rows.Count == 0) { MessageBox.Show("No Record Found", "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { Reports.Rpt_Purchase rpt = new EasyRashanManagementSystem.Reports.Rpt_Purchase(); rpt.SetDataSource(dt); CommonDAL.ShowReport(rpt, "All PurchaseItems"); dt.Dispose(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }