private void btnClientID_Click(object sender, EventArgs e) { object rValue; try { rValue = FrmGSearch.Show("Select ClientID,ClientCode as MemberCode,ClientName As MemberName,NIC,Address From Trans_Clients", false, "All Clients"); if (rValue == null) { return; } ClientID = long.Parse(rValue.ToString()); DataTable dt = new DataTable(); BP_RptClientIssuencecDateWise NewBPObj = new BP_RptClientIssuencecDateWise(); dt = NewBPObj.GetClientName(int.Parse(ClientID.ToString())); if (dt.Rows.Count > 0) { txtMemberName.Text = dt.Rows[0]["ClientName"].ToString(); } dt.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
private void btnEmp_Click(object sender, EventArgs e) { object rValue; try { rValue = FrmGSearch.Show("Select EmpName From Emp_Def", false, "All Employees"); if (rValue == null) { return; } EmpID = long.Parse(rValue.ToString()); DataTable dt = new DataTable(); BP_RptClientIssuencecDateWise NewBP = new BP_RptClientIssuencecDateWise(); dt = NewBP.GetEmpName(int.Parse(EmpID.ToString())); if (dt.Rows.Count > 0) { txtEmpName.Text = dt.Rows[0]["EmpName"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
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); } }