public void GetAllDonor()
{
var q = TheDonorCmd.GetAllDonors();
ReportDataSource rs = new ReportDataSource();
List<DonaorReportObj> ls = new List<DonaorReportObj>();
int counter = 0;
foreach (var item in q)
{
counter++;
ls.Add(new DonaorReportObj()
{
DonorID = counter,
DonorName = item.Name,
DonorAgentname = item.agentName,
DonorFaxnumber = item.Fax,
DonorAddress = item.Adderss,
DonorPhoneNumber = item.PhoneNumber,
DonorEmail = item.Email
});
}
rs.Name = "DonorDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptDonor.rdlc";
frm.ShowDialog();
}
public void GetRptContractByProjectId(int ProjID)
{
var q = ContractCmd.GetAllContractsByproID(ProjID);
ReportDataSource rs = new ReportDataSource();
List<ContractReportObj> ls = new List<ContractReportObj>();
int counter = 0;
foreach (var item in q)
{
counter++;
ls.Add(new ContractReportObj()
{
ContractID=counter,
ProjectName=item.ProjectProfile.ProjectName,
EmployeeName=item.Employee.EmployeeName,
EmployeeJobNumber=item.Employee.EmployeejobNumber,
StartDate=item.StartDate.Value,
EndDate=item.EndDate.Value,
MonthlySalary =item.SelaryAmount.Value,
TotalSalary=item.TotalSalary.Value,
Coin=item.ProjectProfile.Coin,
});
}
rs.Name = "ContractDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptContract.rdlc";
frm.ShowDialog();
}
public void GetAllEmployee()
{
var q = EmployeeCmd.GetAll();
ReportDataSource rs = new ReportDataSource();
List<EmployeeReportObj> ls = new List<EmployeeReportObj>();
int counter = 0;
foreach (var item in q)
{
counter++;
ls.Add(new EmployeeReportObj()
{
EmoloyeeID = counter,
employeeName = item.EmployeeName ,
EmployeeGender = item.EmployeeGender,
EmployeejobNumber = item.EmployeejobNumber,
EmployeeNationalNumber = item.EmployeeNationalNumber,
PhoneNumber = item.PhoneNumber,
Mobilenumber=item.Mobilenumber,
Email=item.Email,
});
}
rs.Name = "EmplyeeDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptEmolyee.rdlc";
frm.ShowDialog();
}
public void GetRptAmountRecvByProjectId(int ProjID)
{
var q = AmountsReceivedsCmd.GetAllAmountsReceivedBypro(ProjID);
ReportDataSource rs = new ReportDataSource();
List<AmountRecvtReportObj> ls = new List<AmountRecvtReportObj>();
foreach (var item in q)
{
ls.Add(new AmountRecvtReportObj()
{
ProjectName=item.ProjectProfile.ProjectName,
Coin=item.ProjectProfile.Coin,
DonerName=item.TheDonorsProject.TheDonor.Name,
Date=item.Date.Value,
Cost=item.Cost.Value,
});
}
rs.Name = "AmountsReceivedDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptAmountsReceived.rdlc";
frm.ShowDialog();
}
public void GetAllSupplier()
{
var q = SuppliersCmd.GetAll();
ReportDataSource rs = new ReportDataSource();
List<SupplierReportObj> ls = new List<SupplierReportObj>();
int counter = 0;
foreach (var item in q)
{
counter++;
ls.Add(new SupplierReportObj()
{
SupplierID = counter,
SupplierName = item.Name,
SuppliersNatural = item.SuppliersNatural,
Faxnumber = item.Fax,
Address = item.Adderss,
PhoneNumber = item.PhoneNumber,
Email = item.Email
});
}
rs.Name = "SupplierDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptSupplier.rdlc";
frm.ShowDialog();
}
public void ShowReportByGrid(List<AmountRecvtReportObj> ls)
{
ReportDataSource rs = new ReportDataSource();
rs.Name = "AmountsReceivedDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptAmountsReceived.rdlc";
frm.ShowDialog();
}
public void ShowSuppReportByGrid(List<SupplierReportObj> ls)
{
ReportDataSource rs = new ReportDataSource();
rs.Name = "SupplierDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptSupplier.rdlc";
frm.ShowDialog();
}
private void DisplayReport(DataTable dt)
{
//construct parameter
// string periode;
List <ReportParameter> rptParams = new List <ReportParameter>();
//Add parameter
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("ArusStock.rptBuktiPengembalianPinjaman.rdlc", rptParams, dt, "dsPinjam_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
string periode;
periode = String.Format("{0} s/d {1}", ((DateTime)rangeDateBoxPenjualan.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rangeDateBoxPenjualan.ToDate).ToString("dd/MM/yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
// rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Penjualan.RptPenjualanPerBarangNetto.rdlc", rptParams, dt, "dsLaporanPenjualanPerBarangNetto_Data");
ifrmReport.Show();
}
private void BtnPreview_Click(object sender, EventArgs e)
{
if (ucPR.PRGrid.GetFocusedRow() is PurchaseRequests pr)
{
UnitOfWork unitOfWork = new UnitOfWork();
var model = unitOfWork.PurchaseRequestsRepo.Find(m => m.Id == pr.Id);
var officeId = User.OfficeId();
var office = unitOfWork.OfficesRepo.Find(x => x.Id == officeId);
model.PRDetails = model?.PRDetails.OrderBy(x => x.ItemNo).ToList();
model.ControlNo = IdHelper.ReplaceOldControlNo(officeId, "PR", model.ControlNo);
foreach (var i in model.PRDetails.Where(x => !x.Item.Contains("rtf1")))
{
var rtf = new RichTextBox();
rtf.Font = new Font("Calibri", 9.5f);
rtf.Text = i.Item;
i.Item = rtf.Rtf;
}
unitOfWork.Save();
var rpt = new rptPurchaseRequest()
{
DataSource = new List <PurchaseRequests>()
{
model
}
};
if (office.IsDivision != true)
{
foreach (XRControl control in rpt.AllControls <XRControl>().Where(x => x.Tag == "Division"))
{
control.Visible = false;
}
rpt.lblDepName.DataBindings.Clear();
rpt.lblDepName.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Offices].[OfficeName]")
});
}
rpt.CreateDocument();
if (rpt.Pages.Count == 1)
{
rpt.grpFooter.PrintAtBottom = true;
}
frmReportViewer frm = new frmReportViewer(rpt);
frm.ShowDialog();
}
}
private void DisplayReport(DataTable dt)
{
string periode = String.Format("{0} s/d {1}", ((DateTime)rangeDateBox1.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rangeDateBox1.ToDate).ToString("dd/MM/yyyy"));
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Periode", periode));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Laporan.Salesman.rptPerbandinganDONotaBO.rdlc", rptParams, dt, "dsOrderPenjualan_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Periode", dateTextBox1.DateValue.Value.ToString("dd-MMM-yyyy")));
rptParams.Add(new ReportParameter("Kelompok", cboKel.Text));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Persediaan.rptStandarStokAVGJual.rdlc", rptParams, dt, "dsOpname_Data");
ifrmReport.Show();
}
private void DisplayReport(DataSet ds)
{
try
{
DateTime da = monthYearBox1.FirstDateOfMonth;
DateTime da2 = monthYearBox1.LastDateOfMonth;
string periode = string.Empty;
periode = String.Format("{0} s/d {1}", da.ToString("dd/MM/yyyy"), da2.ToString("dd/MM/yyyy"));
DateTime d1 = (DateTime)dateTextBox1.DateValue;
string col2 = string.Empty;
col2 = string.Format("REALISASI ({0} s/d {1})", monthYearBox1.FirstDateOfMonth.ToString("dd MMM yyyy"), monthYearBox1.LastDateOfMonth.ToString("dd MMM yyyy"));
this.Cursor = Cursors.WaitCursor;
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Title", " PIUTANG JT DAN OVERDUE"));
rptParams.Add(new ReportParameter("Initial", GlobalVar.PerusahaanName + "-" + GlobalVar.Gudang));
rptParams.Add(new ReportParameter("User", SecurityManager.UserInitial + " " + DateTime.Now.ToString("dd/MM/yyyy")));
List <ReportParameter> rptParams2 = new List <ReportParameter>();
rptParams2.Add(new ReportParameter("Periode", periode));
rptParams2.Add(new ReportParameter("Title", " REKAP REALISASI TAGIHAN "));
rptParams2.Add(new ReportParameter("Initial", GlobalVar.PerusahaanName + "-" + GlobalVar.Gudang));
rptParams2.Add(new ReportParameter("User", SecurityManager.UserInitial + " " + DateTime.Now.ToString("dd/MM/yyyy")));
rptParams2.Add(new ReportParameter("Col1", "TARGET TAGIHAN PIUTANG (s/d " + d1.ToString("dd MMM yyyy") + " )"));
rptParams2.Add(new ReportParameter("Col2", col2));
rptParams2.Add(new ReportParameter("Col3", "REALISASI (setelah " + monthYearBox1.LastDateOfMonth.ToString("dd MMM yyyy") + ")"));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Piutang.Report.rpt17NotaJTOVDA.rdlc", rptParams, ds.Tables[0], "dsKpiutang_Data2");
ifrmReport.Text = "Lap 17 A";
ifrmReport.Show();
if (checkBox1.Checked)
{
frmReportViewer ifrmReport2 = new frmReportViewer("Piutang.Report.rpt17NotaJTOVDB.rdlc", rptParams2, ds.Tables[1], "dsKpiutang_Data4");
ifrmReport2.Text = "Lap 17 B";
ifrmReport2.Show();
}
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void DG_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 5)
{
if (Utility.gblnAccessControl)
{
if (!Utility.glngGetPriviliges(strComID, Utility.gstrUserName, lngFormPriv, 3))
{
MessageBox.Show("You have no Permission to Access", "Privileges", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
var strResponse = MessageBox.Show("Do You want to Delete?", "Delete Button", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (strResponse == DialogResult.Yes)
{
string i = objExtra.mDeleteMonthlyProjection(strComID, DG.CurrentRow.Cells[0].Value.ToString(), DG.CurrentRow.Cells[2].Value.ToString());
string strAudit = Utility.gblnAuditTrail(Utility.gstrUserName, DateTime.Now.ToString("dd/MM/yyyy"), "Month Setup", "Month Setup",
3, 0, (int)Utility.MODULE_TYPE.mtPURCHASE, "0001");
//MessageBox.Show(i.ToString());
GetMonthSetupList();
}
}
if (e.ColumnIndex == 4)
{
if (Utility.gblnAccessControl)
{
if (!Utility.glngGetPriviliges(strComID, Utility.gstrUserName, lngFormPriv, 2))
{
MessageBox.Show("You have no Permission to Access", "Privileges", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (onAddAllButtonClicked != null)
{
onAddAllButtonClicked(GetSelectedItem(), sender, e);
}
this.Dispose();
}
if (e.ColumnIndex == 3)
{
frmReportViewer frmviewer = new frmReportViewer();
frmviewer.selector = ViewerSelector.ProjectionRM;
frmviewer.strString1 = DG.CurrentRow.Cells[1].Value.ToString();
frmviewer.strString2 = DG.CurrentRow.Cells[2].Value.ToString();
frmviewer.intmode = 0;
frmviewer.Show();
}
}
private void DisplayReport(DataTable dt)
{
string periode;
periode = String.Format("{0} s/d {1}", ((DateTime)rangePeriode.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rangePeriode.ToDate).ToString("dd/MM/yyyy"));
string sorting = string.Empty;
if (rbIdWil.Checked)
{
sorting = "IdWil";
}
else if (rbKota.Checked)
{
sorting = "Kota";
}
else if (rbNoNota.Checked)
{
sorting = "NoSuratJalan";
}
else if (rbSales.Checked)
{
sorting = "KodeSales";
}
else if (rbTglNota.Checked)
{
sorting = "TglSuratJalan";
}
else if (rbTglTerima.Checked)
{
sorting = "TglTerima";
}
else
{
sorting = "Toko";
}
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Sorting", sorting));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptLaporanInputSerahTerima.rdlc", rptParams, dt, "dsToko_Data2");
ifrmReport.Show();
}
private void PrintCommand()
{
if (!TFCMODEL.PartNo.IsNotNullOrEmpty() || !TFCMODEL.ROUTENO.IsNotNullOrEmpty())
{
ShowInformationMessage(PDMsg.NotEmpty("Part No and Process No"));
return;
}
else
{
DataTable dt;
GridValues();
dt = tfcbll.GetPrint(TFCMODEL);
if (dt == null || dt.Rows.Count == 0)
{
ShowInformationMessage(PDMsg.NoRecordsPrint);
}
else
{
if (!dt.Columns.Contains("PCR_NO"))
{
dt.Columns.Add("PCR_NO", typeof(string));
}
if (!dt.Columns.Contains("PCR_DATE"))
{
dt.Columns.Add("PCR_DATE", typeof(DateTime));
}
if (dt.Columns.Contains("PCR_NO") && dt.Columns.Contains("PCR_DATE"))
{
try
{
dt.Rows[0]["PCR_NO"] = TFCMODEL.PCR_NO;
if (TFCMODEL.PCR_DATE != null)
{
dt.Rows[0]["PCR_DATE"] = TFCMODEL.PCR_DATE;
}
}
catch (Exception ex)
{
ex.LogException();
}
}
frmReportViewer frmrv = new frmReportViewer(dt, "TFC-PCR");
frmrv.ShowDialog();
}
}
}
private void laporanOmsetPerkendaraan(string flagKtg)
{
try
{
this.Cursor = Cursors.WaitCursor;
List <ReportParameter> rptParams = new List <ReportParameter>();
string periodReport = txtDate1.DateValue.Value.ToString("dd-MMMM-yyyy") + " s/d " + txtDate2.DateValue.Value.ToString("dd-MMMM-yyyy");
rptParams.Add(new ReportParameter("periodeReport", periodReport));
string ttl = "Laporan Omset ";
if (flagKtg == "INTI")
{
ttl = ttl + "CUSTOMER INTI";
}
else if (flagKtg == "MITRAPS")
{
ttl = ttl + "MITRA PS";
}
else if (flagKtg == "MITRASAS")
{
ttl = ttl + "MITRA SAS";
}
ttl = ttl + " Perkendaraan";
rptParams.Add(new ReportParameter("title", ttl));
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("rsp_CSM_LaporanOmsetPertypeKendaraan"));
db.Commands[0].Parameters.Add(new Parameter("@tglStart", SqlDbType.DateTime, txtDate1.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@tglEnd", SqlDbType.DateTime, txtDate2.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@flagKtg", SqlDbType.VarChar, flagKtg));
ds = db.Commands[0].ExecuteDataSet();
}
if (ds.Tables[0].Rows.Count > 0)
{
frmReportViewer ifrmReport = new frmReportViewer("CSM.laporanOmzetPerkendaraan.rdlc", rptParams, ds.Tables[0], "dsLaporanOmzetCIPerKendaraan_PerKendaraan");
ifrmReport.Text = ttl;
ifrmReport.Show();
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void DisplayReport()
{
string periode;
string Level;
string type = "DO";
if (rdbNota.Checked)
{
type = "NOTA";
}
Level = SecurityManager.IsManager().ToString();
periode = String.Format("{0} s/d {1}", ((DateTime)rangeDateBox1.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rangeDateBox1.ToDate).ToString("dd/MM/yyyy"));
string periode2 = String.Format("{0} s/d {1}", ((DateTime)rangeDateBox2.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rangeDateBox2.ToDate).ToString("dd/MM/yyyy"));
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Manager", Level));
rptParams.Add(new ReportParameter("Periode1", periode));
rptParams.Add(new ReportParameter("Periode2", periode2));
rptParams.Add(new ReportParameter("Type", type));
rptParams.Add(new ReportParameter("TotalQty1", Convert.ToInt32(ds.Tables[1].Rows[0][0]).ToString("#,##0")));
rptParams.Add(new ReportParameter("TotalQty2", Convert.ToInt32(ds.Tables[1].Rows[0][1]).ToString("#,##0")));
//call report viewer
List <DataTable> pTable = new List <DataTable>();
pTable.Add(ds.Tables[0]);
pTable.Add(ds.Tables[0]);
pTable.Add(ds.Tables[0]);
pTable.Add(ds.Tables[0]);
pTable.Add(ds.Tables[0]);
pTable.Add(ds.Tables[0]);
pTable.Add(ds.Tables[0]);
List <string> pDatasetName = new List <string>();
pDatasetName.Add("dsSales_Data");
pDatasetName.Add("dsSales_Data1");
pDatasetName.Add("dsSales_Data2");
pDatasetName.Add("dsSales_Data3");
pDatasetName.Add("dsSales_Data4");
pDatasetName.Add("dsSales_Data5");
pDatasetName.Add("dsPinjam_Data");
frmReportViewer ifrmReport = new frmReportViewer("LapKpl.rptTargetSales.rdlc", rptParams, pTable, pDatasetName);
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
string periode;
periode = String.Format("{0} s/d {1}", ((DateTime)rngDateTextBox.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rngDateTextBox.ToDate).ToString("dd/MM/yyyy"));
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Laporan.Barang.rptRegisterJualPerKelompokBarang.rdlc", rptParams, dt, "dsNotaPenjualan_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
//construct parameter
string periode;
periode = String.Format("{0} s/d {1}", ((DateTime)rangeDateBox1.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rangeDateBox1.ToDate).ToString("dd/MM/yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
//rptParams.Add(new ReportParameter("Periode", periode));
//rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Fixrute.rptRegisterRencanaKunjungan.rdlc", rptParams, dt, "dsCetakRegisterRencanaKunjungan_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
//construct parameter
string periode;
periode = String.Format("{0} s/d {1}", ((DateTime)dateTimePicker1.Value).ToString("dd/MM/yyyy"), ((DateTime)dateTimePicker2.Value).ToString("dd/MM/yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
//rptParams.Add(new ReportParameter("Periode", periode));
//rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Fixrute.RptMonitoringFixruteSalesman.rdlc", rptParams, dt, "dsMonitoringFixruteSalesman_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
string _periode = "Periode : " + GlobalVar.DateTimeOfServer.ToString("MMM-yyyy");;
string _created = "Created by " + SecurityManager.UserID + " on " + GlobalVar.DateTimeOfServer;
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", _periode));
rptParams.Add(new ReportParameter("Created", _created));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Piutang.rptLapTokoJW.rdlc", rptParams, dt, "dsToko_TokoJW");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", tglForm.DateValue.ToString()));
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Kelompok", cboKel.Text));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Persediaan.rptStandarStokTipis.rdlc", rptParams, dt, "dsStandarStok_Data");
ifrmReport.Show();
}
private void viewReport(DataTable dt)
{
string _periode = "Periode " + ((DateTime)rangeDateBox1.FromDate).ToString("dd MMM yyyy") + " s/d " + ((DateTime)rangeDateBox1.ToDate).ToString("dd MMM yyyy");
string _userid = "Created by " + SecurityManager.UserID + " on " + GlobalVar.DateTimeOfServer;
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", _periode));
rptParams.Add(new ReportParameter("UserID", _userid));
Form frmTaskReport = new frmReportViewer("Kasir.rptLapperPeriode.rdlc", rptParams, dt, "dsSaldoperPeriode_Data");
frmTaskReport.MdiParent = this.MdiParent;
frmTaskReport.Show();
}
private void btnPrint_Click(object sender, EventArgs e)
{
string strBrachID = "";
frmReportViewer frmviewer = new frmReportViewer();
frmviewer.selector = ViewerSelector.Payables;
frmviewer.strFdate = dteToDate.Text;
frmviewer.strTdate = dteToDate.Text;
frmviewer.strLedgerName = tetReportHader.Text;
//frmviewer.strSelction = "BalanceSheet";
frmviewer.Show();
return;
}
private void DisplayReport(DataTable dt)
{
string periode = String.Format("{0} s/d {1}", ((DateTime)rangeDateBox1.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rangeDateBox1.ToDate).ToString("dd/MM/yyyy"));
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Kelompok", cboKel.Text));
rptParams.Add(new ReportParameter("Cabang", cboCab.SelectedValue.ToString()));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Laporan.Salesman.rptOmzetPerKota.rdlc", rptParams, dt, "dsNotaPenjualan_Data");
ifrmReport.Show();
}
private void BtnPreview_Click(object sender, EventArgs e)
{
if (uCPQ.PQGridView.GetFocusedRow() is PriceQuotations item)
{
item.PQDetails = item.PQDetails.OrderBy(x => x.ItemNo).ToList();
frmReportViewer frm = new frmReportViewer(new rptPurchaseQuotation(item)
{
DataSource = new List <PriceQuotations>()
{
item
}
});
frm.ShowDialog();
}
}
private void generateLaporan(DataTable dt)
{
string _periode = "Periode : " + ((DateTime)rangeDateBox1.FromDate).ToString("dd-MMM-yyyy") + " s/d " + ((DateTime)rangeDateBox1.ToDate).ToString("dd-MMM-yyyy");
string _type = "Type : " + txtStatusInden.Text;
string _created = "Created by " + SecurityManager.UserID + " on " + GlobalVar.GetServerDateTime;
List <ReportParameter> rptParam = new List <ReportParameter>();
rptParam.Add(new ReportParameter("Periode", _periode));
rptParam.Add(new ReportParameter("Type", _type));
rptParam.Add(new ReportParameter("Created", _created));
frmReportViewer ifrmReport = new frmReportViewer("Laporan.rptLaporanIndenPenjualan.rdlc", rptParam, dt, "dsIndenPenjualan_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
string _userid = "Created by " + SecurityManager.UserID + " on " + DateTime.Now;
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("fromDate", rangeDateBox1.FromDate.Value.ToString("dd-MM-yyyy")));
rptParams.Add(new ReportParameter("toDate", rangeDateBox1.ToDate.Value.ToString("dd-MM-yyyy")));
rptParams.Add(new ReportParameter("userid", _userid));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Kasir.rptIdenPengajuanBBN.rdlc", rptParams, dt, "dsIdenPengajuanBBN_Data");
ifrmReport.Show();
}
private void DisplayReport()
{
string periode;
periode = String.Format("{0} s/d {1}", ((DateTime)rangeNota.FromDate).ToString("dd/MM/yyyy"), ((DateTime)rangeNota.ToDate).ToString("dd/MM/yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
frmReportViewer ifrmReport = new frmReportViewer("Communicator.rptPenjualanNotaUploadC1.rdlc", rptParams, dsResult.Tables[2], "dsSales_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
//construct parameter
// periode = String.Format("{0} s/d {1}", ((DateTime)rgbTglDO.FromDate.Value).ToString("dd/MM/yyyy"), ((DateTime)rgbTglDO.ToDate.Value).ToString("dd/MM/yyyy"));
List <ReportParameter> rptParams = new List <ReportParameter>();
// rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("ArusStock.rptBuktiPeminjamanBarang.rdlc", rptParams, dt, "dsPinjam_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
dt.Columns["satuan"].ColumnName = "Satuan";
dt.Columns["hpp"].ColumnName = "HPP";
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Communicator.rptHPPRataRataDownload.rdlc", rptParams, dt, "AntarGudang_Data");
ifrmReport.Show();
}
private void DisplayReport(DataTable dt)
{
//construct parameter
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", SecurityManager.UserID));
rptParams.Add(new ReportParameter("Sales", GetSales()));
rptParams.Add(new ReportParameter("Catatan3", dataGridDO.SelectedCells[0].OwningRow.Cells["Catatan3"].Value.ToString()));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Penjualan.rptCetakBO.rdlc", rptParams, dt, "dsOrderPenjualan_Data");
//ifrmReport.Print();
ifrmReport.Show();
}
private void btnPrint_Click(object sender, EventArgs e)
{
string strmsg = "", strName = "All", strString = "";
int intMode = 0;
progressBar1.Value = 0;
if (txtLedgerType.Text != "All")
{
strName = txtLedgerType.Text.Substring(0, 1);
}
if (lstRight.Items.Count > 0)
{
for (int i = 0; i < lstRight.Items.Count; i++)
{
strString = strString + "'" + lstRight.Items[i].ToString() + "',";
}
if (strString != "")
{
strString = Utility.Mid(strString, 0, strString.Length - 1);
}
}
List <AccountsLedger> objLedger = accms.mFillLedgerSelection(strComID, 202, strName, strString).ToList();
if (objLedger.Count > 0)
{
progressBar1.Maximum = objLedger.Count;
foreach (AccountsLedger ooLedger in objLedger)
{
strmsg = objExtra.mInsertMpoPerformance(strComID, ooLedger.strLedgerName, dteFromDate.Text, dteToDate.Text, intMode);
int percent = (int)(((double)(progressBar1.Value - progressBar1.Minimum) / (double)(progressBar1.Maximum - progressBar1.Minimum)) * 100);
progressBar1.Refresh();
using (Graphics gr = progressBar1.CreateGraphics())
{
gr.DrawString(percent.ToString() + "%", SystemFonts.DefaultFont, Brushes.Red, new PointF(progressBar1.Width / 2 - (gr.MeasureString(percent.ToString() + "%",
SystemFonts.DefaultFont).Width / 2.0F), progressBar1.Height / 2 - (gr.MeasureString(percent.ToString() + "%", SystemFonts.DefaultFont).Height / 2.0F)));
}
progressBar1.Value += 1;
intMode += 1;
}
}
frmReportViewer frmviewer = new frmReportViewer();
frmviewer.selector = ViewerSelector.Performance;
frmviewer.strFdate = dteFromDate.Text;
frmviewer.strTdate = dteToDate.Text;
frmviewer.Show();
}
public void GetRptAcrivitiesByProjectId(int ProjID)
{
var q = SubActivityCmd.GetAllSubActivitiesByProjectID(ProjID);
ReportDataSource rs = new ReportDataSource();
List<ActivitesRecvtReportObj> ls = new List<ActivitesRecvtReportObj>();
foreach (var item in q)
{
ls.Add(new ActivitesRecvtReportObj()
{
ProjectName=item.ProjectProfile.ProjectName,
Coin=item.ProjectProfile.Coin,
ActivitesID=item.ProjectActivity.ID,
ActivitesName=item.ProjectActivity.ActivityName,
ActivitesDec=item.ProjectActivity.Description,
StartDate=item.ProjectActivity.StartDate.Value,
Enddate=item.ProjectActivity.EndDate.Value,
ActivitesCost=item.ProjectActivity.TotalCost.Value,
Progress=item.ProjectActivity.Progress.Value,
Stauts=item.ProjectActivity.Status,
////
SubActivitesName= item.SubActivityName,
SubActivitesDec=item.Description,
SubStartDate=item.Startdate.Value,
SubEnddate=item.enddate.Value,
SubCost=item.TotalCost.Value,
SubProgress=item.Progress.Value,
SubStauts=item.Status,
AllTotalActivites = ActivityCmd.GetTotalActivity(InformationsClass.ProjID),
TotalExpensess= ProjectExpensesCmd.GetTotalExpensesBySubActivity(item.ID)
});
}
rs.Name = "ActivitiesDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptActivties.rdlc";
frm.ShowDialog();
}
private void cmdYES_Click(object sender, EventArgs e)
{
DateTime _FromDate = (DateTime)rangeDateBox1.FromDate;
DateTime _ToDate = (DateTime)rangeDateBox1.ToDate;
DateTime _BulanLalu = _FromDate.AddDays(_FromDate.Day * -1);
DateTime _AwalBulan = _BulanLalu.AddDays(1);
DateTime _SblAwalPeriode = _FromDate.AddDays(-1);
string _TahunBulan = _FromDate.Year.ToString() + _FromDate.Month.ToString().PadLeft(2, '0');
using (Database db = new Database(GlobalVar.DBName))
{
db.Commands.Add(db.CreateCommand("usp_GetSaldoKas"));
db.Commands[0].Parameters.Add(new Parameter("@OwnPtRowID", SqlDbType.UniqueIdentifier, GlobalVar.PerusahaanRowID));
db.Commands[0].Parameters.Add(new Parameter("@TahunBulan", SqlDbType.VarChar, _TahunBulan));
db.Commands[0].Parameters.Add(new Parameter("@FromDate", SqlDbType.Date, _AwalBulan));
db.Commands[0].Parameters.Add(new Parameter("@ToDate", SqlDbType.Date, _SblAwalPeriode));
AwalKas = Convert.ToDouble(Tools.isNull(db.Commands[0].ExecuteScalar(), 0));
db.Commands.Clear();
db.Commands.Add(db.CreateCommand("usp_GetSaldoBukuBank"));
db.Commands[0].Parameters.Add(new Parameter("@OwnPtRowID", SqlDbType.UniqueIdentifier, GlobalVar.PerusahaanRowID));
db.Commands[0].Parameters.Add(new Parameter("@TahunBulan", SqlDbType.Char, _TahunBulan));
db.Commands[0].Parameters.Add(new Parameter("@FromDate", SqlDbType.Date, _AwalBulan));
db.Commands[0].Parameters.Add(new Parameter("@ToDate", SqlDbType.Date, _SblAwalPeriode));
AwalBank = Convert.ToDouble(Tools.isNull(db.Commands[0].ExecuteScalar(), 0));
db.Commands.Clear();
db.Commands.Add(db.CreateCommand("rsp_RekapKasBank"));
db.Commands[0].Parameters.Add(new Parameter("@FromDate", SqlDbType.Date, _FromDate));
db.Commands[0].Parameters.Add(new Parameter("@ToDate", SqlDbType.Date, _ToDate));
db.Commands[0].Parameters.Add(new Parameter("@PerusahaanRowID", SqlDbType.UniqueIdentifier, GlobalVar.PerusahaanRowID));
db.Commands[0].Parameters.Add(new Parameter("@AwalKas", SqlDbType.Money, AwalKas));
db.Commands[0].Parameters.Add(new Parameter("@AwalBank", SqlDbType.Money, AwalBank));
dt = db.Commands[0].ExecuteDataTable();
}
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("NamaPT", GlobalVar.PerusahaanName));
rptParams.Add(new ReportParameter("FromDate", _FromDate.ToString()));
rptParams.Add(new ReportParameter("ToDate", _ToDate.ToString()));
frmReportViewer ifrmReport = new frmReportViewer("Laporan.Finance.rptRekapKasBank.rdlc", rptParams, dt, "dsRekapKasBank_data");
ifrmReport.Show();
this.Close();
}
private void DisplayReport(DataTable dtLaporan, string namerdlc, string judul)
{
int i = 0;
double total = 0, jumlah;
string _Terima, _NoBukti, _Tanggal, _Lampiran, _Kasir, _Terbilang;
//Guid RowIDHeader = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value;
//Guid _RowID = (Guid)dtLaporan.Rows[0]["RowID"];
//string typePrinter = lap.GetPrinterName();
string NamaBank = gridHeader.SelectedCells[0].OwningRow.Cells["hdrNamaBank"].Value.ToString();
string NoBBM = gridHeader.SelectedCells[0].OwningRow.Cells["hdrNoVoucher"].Value.ToString();
string TglBBM = ((DateTime)gridHeader.SelectedCells[0].OwningRow.Cells["hdrTglVoucher"].Value).ToString("dd-MMM-yyyy").Trim();
//string Pembukuan = Tools.isNull(dtLaporan.Rows[0]["Dibukukan"], "").ToString().Trim();
//string Mengetahui = Tools.isNull(dtLaporan.Rows[0]["Diketahui"], "").ToString().Trim();
//string Kasir = Tools.isNull(dtLaporan.Rows[0]["Kasir"], "").ToString().Trim();
//string Penyetor = Tools.isNull(dtLaporan.Rows[0]["Penyetor"], "").ToString().Trim();
string Nomor = string.Empty;
string AsalTransfer = string.Empty;
string Bank = string.Empty;
string TglBank = string.Empty;
string TglTransfer = string.Empty;
double Jumlah = 0;
double sumJumlah = 0;
string tempJumlah = string.Empty;
string UserID = SecurityManager.UserName.ToString();
foreach (DataRow dr in dtLaporan.Rows)
{
total += Convert.ToDouble(dr["Nominal"].ToString());
}
_Terbilang = Tools.Terbilang(total);
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("UserID", string.Format("{0}, {1:dd/MM/yyyy hh:mm:ss}", SecurityManager.UserName, DateTime.Now)));
rptParams.Add(new ReportParameter("NamaBank", NamaBank));
rptParams.Add(new ReportParameter("NoBBM", NoBBM));
rptParams.Add(new ReportParameter("TglBBM", String.Format("{0:dd-MMM-yyyy}", TglBBM)));
rptParams.Add(new ReportParameter("Total", total.ToString()));
rptParams.Add(new ReportParameter("Terbilang", _Terbilang));
rptParams.Add(new ReportParameter("Judul", judul));
frmReportViewer ifrmReport = new frmReportViewer(namerdlc, rptParams, dtLaporan, "dsLapGiro_Data");
ifrmReport.Print();
////ifrmReport.Print(8.5, 6.4);
////ifrmReport.Show();
}
private void DisplayReport(DataSet ds)
{
try
{
DateTime da = new DateTime(dateTextBox1.DateValue.Value.Year, dateTextBox1.DateValue.Value.Month, 1);
DateTime da2 = dateTextBox1.DateValue.Value;
string periode = string.Empty;
periode = String.Format("{0} s/d {1}", da.ToString("dd/MM/yyyy"), da2.ToString("dd/MM/yyyy"));
DateTime d1 = (DateTime)dateTextBox1.DateValue;
this.Cursor = Cursors.WaitCursor;
List <ReportParameter> rptParams = new List <ReportParameter>();
rptParams.Add(new ReportParameter("Periode", periode));
rptParams.Add(new ReportParameter("Title", " PIUTANG JT DAN OVERDUE"));
rptParams.Add(new ReportParameter("Initial", GlobalVar.PerusahaanName + "-" + GlobalVar.Gudang));
rptParams.Add(new ReportParameter("User", SecurityManager.UserInitial + " " + DateTime.Now.ToString("dd/MM/yyyy")));
rptParams.Add(new ReportParameter("Col1", da.ToString("dd/MM/yyyy")));
rptParams.Add(new ReportParameter("Col2", "s/d " + da2.ToString("dd/MM/yyyy")));
rptParams.Add(new ReportParameter("Col3", da2.ToString("dd/MM/yyyy")));
rptParams.Add(new ReportParameter("WilID", "PIUTANG NOTA - WIL : " + wilIDComboBox1.Text));
List <ReportParameter> rptParams2 = new List <ReportParameter>();
rptParams2.Add(new ReportParameter("Periode", periode));
rptParams2.Add(new ReportParameter("Title", " REKAP REALISASI TAGIHAN "));
rptParams2.Add(new ReportParameter("Initial", GlobalVar.PerusahaanName + "-" + GlobalVar.Gudang));
rptParams2.Add(new ReportParameter("User", SecurityManager.UserInitial + " " + DateTime.Now.ToString("dd/MM/yyyy")));
rptParams2.Add(new ReportParameter("Col1", da.ToString("dd/MM/yyyy")));
rptParams2.Add(new ReportParameter("Col2", "s/d " + da2.ToString("dd/MM/yyyy")));
rptParams2.Add(new ReportParameter("Col3", da2.ToString("dd/MM/yyyy")));
rptParams2.Add(new ReportParameter("WilID", "PIUTANG GIRO TOLAK - WIL : " + wilIDComboBox1.Text));
//call report viewer
frmReportViewer ifrmReport = new frmReportViewer("Piutang.Report.rpt22KetTagihA.rdlc", rptParams, ds.Tables[0], "dsKpiutang_Data2");
ifrmReport.Text = "Lap 20 A";
ifrmReport.Show();
frmReportViewer ifrmReport2 = new frmReportViewer("Piutang.Report.rpt22KetTagihB.rdlc", rptParams2, ds.Tables[1], "dsKpiutang_Data2");
ifrmReport2.Text = "Lap 20B";
ifrmReport2.Show();
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
public void GetByProjectId(int ProjID)
{
var q1 = ProjectProfileCmd.GetProjectData(ProjID);
var q = TheDonorsProjectCmd.GetAllDonorsByproID(ProjID);
ReportDataSource rs = new ReportDataSource();
List<ProjectReportObj> ls = new List<ProjectReportObj>();
FrmMainUserPro Mainfrm = new FrmMainUserPro();
int counter = 0;
foreach (var item in q)
{
counter++;
ls.Add(new ProjectReportObj()
{
////
DonerID=counter,
DonorsName=item.TheDonor.Name,
Cost=item.TotalCost.Value,
ProjectName=item.ProjectProfile.ProjectName,
ProjectDescription=item.ProjectProfile.ProjectDescription,
progress=item.ProjectProfile.progress.Value,
TotalCost=item.ProjectProfile.TotalCost.Value,
StartDate=item.ProjectProfile.StartDate.Value,
EndDate=item.ProjectProfile.EndDate.Value,
Coin=item.ProjectProfile.Coin,
TotalExpenses=ProjectExpensesCmd.GetTotalExpensesByProject(ProjID),
TotalSalay=SalariesCmd.GetTotalSalaryByProject(ProjID),
AmountRecv=AmountsReceivedsCmd.GetTotalAmountsByProject(ProjID),
});
}
rs.Name = "ProjectDataSet";
rs.Value = ls;
frmReportViewer frm = new frmReportViewer();
frm.reportViewer1.LocalReport.DataSources.Clear();
frm.reportViewer1.LocalReport.DataSources.Add(rs);
frm.reportViewer1.LocalReport.ReportEmbeddedResource = "UcasProWindowsForm.Reports.rptProject.rdlc";
frm.ShowDialog();
}
public void GenerateReport()
{
DataSet ds = new DataSet();
string whereClause = "Where 1=1";
builder.ConnectionString = m_Conn.ConnectionString;
ModuleParaList.Add("Module ID;{Blank for All};&&&&&&&&&&& ;False;False;None;Modules List;Module ID");
frmParameter.frmParameter frmPara = new frmParameter.frmParameter();
frmPara.rptTitle = "Module List";
frmPara.rtpID = "LS001";
frmPara.ParaList = ModuleParaList;
frmPara.ShowDialog();
foreach (string value in frmPara.ParaList)
{
if (frmPara.ParaList[0].ToString() != "")
{
whereClause += " And ModuleID IN (" + value + ")";
}
}
Comm.CommandTimeout = 0;
Comm.CommandType = CommandType.Text;
string SQL = "SELECT ModuleID, mdlName, mdlType, mdlCategory, frmName, Discontinued FROM M_ERP_ModulesList";
SQL = SQL + " " + whereClause;
Comm.CommandText = SQL;
Comm.Connection = m_Conn;
Comm.Connection.Open();
SqlDataAdapter ad = new SqlDataAdapter(Comm);
ad.Fill(ds);
oReport = new ReportDocument();
oReport.Load("H:\\BMC-ERP\\ERPGUI\\ERP_Report\\Administration\\rptModuleList.rpt");
oReport.SetDatabaseLogon(builder.UserID, builder.Password);
oReport.Database.Tables[0].SetDataSource(ds);
frmReportViewer rpt = new frmReportViewer(oReport);
rpt.ShowDialog();
}
private void ConfigureCrystalReports()
{
DataSet dsBaptismalAll = new DataSet();
ParishDataManagement.Dataset.BaptismalDataSetSchema dsBaptismal = new ParishDataManagement.Dataset.BaptismalDataSetSchema();
ParishDataManagement.Dataset.SponsorDataSetSchema dsSponsor = new ParishDataManagement.Dataset.SponsorDataSetSchema();
ParishDataManagement.Reports.rptBaptismal rptBaptismal = new ParishDataManagement.Reports.rptBaptismal();
frmReportViewer newViewer = new frmReportViewer();
MySqlConnection conn = new MySqlConnection(MyConnection.connectionString);
String strQuery = "SELECT tblBaptismal.BaptismalID, CONCAT(tblPerson.Firstname,' ',tblPerson.Middlename,' ',tblPerson.Lastname) as Fullname, tblPerson.Birthdate, tblPerson.BirthPlace, " +
"tblBaptismal.DateofBaptism, tblBaptismal.PlaceofBaptism, tblBaptismal.BookID, tblBaptismal.MinisterNo, tblBaptismal.ParentsIDForFather, tblBaptismal.ParentsIDForMother FROM dbparish.tblBaptismal " +
"LEFT JOIN tblPerson ON tblBaptismal.PersonID = tblPerson.PersonID WHERE tblBaptismal.BaptismalID = '" + lstRecords.SelectedItems[0].Text + "'";
String strSponsorQuery = "SELECT tblSponsor.EventNo, CONCAT(tblPerson.Firstname,' ',tblPerson.Middlename,' ',tblPerson.Lastname) as Fullname FROM dbparish.tblPerson" +
" LEFT JOIN tblSponsor ON tblPerson.PersonID = tblSponsor.PersonID WHERE tblSponsor.EventNo IS NOT NULL AND tblSponsor.EventNo = '" + lstRecords.SelectedItems[0].Text + "'";
conn.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(strQuery, conn);
MySqlDataAdapter adapterSponsor = new MySqlDataAdapter(strSponsorQuery, conn);
// adapter.Fill(dsBaptismal, "Baptismal");
adapterSponsor.Fill(dsSponsor, "Sponsor");
// dsBaptismalAll = dsBaptismal.Copy();
dsBaptismalAll.Tables[0].Merge(dsSponsor.Tables[0], true);
rptBaptismal.SetDataSource(dsBaptismalAll.Tables[0]);
//rptBapti smal.Subreports["rptSponsor"].SetDataSource(dsSponsor.Tables[0]);
newViewer.crystalReportViewer.ReportSource = rptBaptismal;
newViewer.crystalReportViewer.Refresh();
newViewer.ShowDialog();
}
