private void crystalReportViewer1_Load(object sender, EventArgs e)
{
CrystalDecisions.CrystalReports.Engine.ReportClass cr = new Report.CrystalReport1();
switch (template)
{
case "1 Map":
cr = new Report.CrystalReport1();
break;
case "2 Horizontal Maps":
cr = new Report.CrystalReport2();
break;
case "2 Vertical Maps":
cr = new Report.CrystalReport2v();
break;
case "4 Maps":
cr = new Report.CrystalReport4();
break;
case "6 Maps":
cr = new Report.CrystalReport6();
break;
}
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.EnableDrillDown = false;
crystalReportViewer1.ShowGotoPageButton = true;
cr.Database.Tables["Kriging"].SetDataSource(FillDataset());
this.crystalReportViewer1.ReportSource = cr;
this.crystalReportViewer1.RefreshReport();
}
private void reports_Load(object sender, EventArgs e)
{
Reportform f = new Reportform();
if (f.b1.Content == "pp")
{
con.ConnectionString = " server=THENME-PC;integrated security=true;dataBase=store_system";
string sql = "SELECT Storeinvoice.Storeinvoice_no as PurchaseId, Storeinvoice.Storeinvoice_date as PurchaseDate,customercompany.cocuname as CompanyName,employee.empname as EmployeeName, item.item_name as ProductName,invoice_details.invoice_detailsExpirydate as ExpiryDate, invoice_details.invoice_detailsCost UnitCost, invoice_details.invoice_detailsqty Quantity, invoice_details.invoice_detailsqty * CONVERT(int, invoice_details.invoice_detailsCost) AS Total FROM item INNER JOIN invoice_details ON item.item_no = invoice_details.item_no INNER JOIN customercompany ON item.cucono = customercompany.cocuno INNER JOIN Storeinvoice ON invoice_details.Storeinvoice_no = Storeinvoice.Storeinvoice_no AND customercompany.cocuno = Storeinvoice.cocuno INNER JOIN employee ON Storeinvoice.empno = employee.empno where Storeinvoice.Storeinvoice_no= " + x;
PL.DataSet1 ds = new PL.DataSet1();
SqlDataAdapter dad = new SqlDataAdapter(sql, con);
dad.Fill(ds.Tables["DataTable1"]);
Report.CrystalReport1 cr = new Report.CrystalReport1();
cr.SetDataSource(ds.Tables["DataTable1"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
}
private void allotteeStatement_Load(object sender, EventArgs e)
{
db = new giedaEntities();
con = new Logic.connection();
//ReportDocument rdoc = new ReportDocument();
//con.dataGet("SELECT allotee_plots.id,allotee_plots.allottee_id FROM allotee_plots INNER JOIN allottees ON allotee_plots.allottee_id = allottees.id INNER JOIN plots ON allotee_plots.plot_id = plots.id");
//con.dataGet("SELECT id,name, father_name, nic FROM allottees");
//DataTable dt = new DataTable();
//con.sda.Fill(dt);
//string appPath = Application.StartupPath;
//string reportPath = @"Reports\CrystalReport1.rpt";
//string fullPath = Path.Combine(appPath, reportPath);
//string path = @"C:\Users\shahid\source\repos\gieda\gieda\Reports\CrystalReport1.rpt";
//// MessageBox.Show(fullPath);
//rdoc.Load(path);
//rdoc.SetDataSource(dt);
crystalReportViewer1.ReportSource = null;
//Reports.CrystalReport1 crpt = new Reports.CrystalReport1();
Report.CrystalReport1 crpt = new Report.CrystalReport1();
// crpt.SetDataSource(dt);
var query = db.allottees
.Join(db.allotee_plots,
c => c.id,
cm => cm.allottee_id,
(c, cm) => new { allottee = c, allotee_plots = cm })
.Select(x => new { x.allottee.id, x.allottee.pds_number, nic = x.allottee.nic.ToString(), x.allottee.name, x.allottee.father_name, x.allottee.address, plot_id = x.allotee_plots.plot_id }).Where(n => n.id == id).ToList();
var query2 = db.allottees.Select(c => new
{
id = c.id.ToString(),
name = c.name,
title = c.nic.ToString(),
pds = c.pds_number
}).ToList();
crpt.Database.Tables["allottees"].SetDataSource(query);
crpt.Database.Tables["allotee_plots"].SetDataSource(db.allotee_plots.Where(c => c.allottee_id == id).ToList());
crpt.Database.Tables["plots"].SetDataSource(db.plots.Select(c => new
{
id = c.id.ToString(),
title = c.title
}).ToList());
crpt.Database.Tables["allottee_payments"].SetDataSource(db.allottee_payments.Select(c => new
{
id = c.id.ToString(),
title = c.title,
due_amount = c.due_amount,
due_date = c.due_date.ToString(),
amount = c.amount,
paid_on = c.paid_on.ToString(),
surcharge = c.surcharge,
allottee_id = c.allottee_id
}).Where(n => n.allottee_id == id).ToList());
crpt.Database.Tables["installment_payments"].SetDataSource(db.installment_payments.Select(c => new
{
id = c.id.ToString(),
title = c.title,
due_amount = c.due_amount,
due_date = c.due_date.ToString(),
amount = c.amount,
paid_on = c.paid_on.ToString(),
surcharge = c.surcharge,
allottee_id = c.allottee_id
}).Where(n => n.allottee_id == id).ToList());
con.Select("SELECT sum(due_amount) as due_amount, sum(amount) as paid_amount,sum(surcharge) FROM[dbo].[allottee_payments] where allottee_id = " + id);
DataTable dt = new DataTable();
con.sda.Fill(dt);
int total_due_amount = 0;
int total_paid_amount = 0;
foreach (DataRow row in dt.Rows)
{
if (row["due_amount"].ToString() != "")
{
total_due_amount = Int32.Parse(row["due_amount"].ToString());
total_paid_amount = Int32.Parse(row["paid_amount"].ToString());
// crpt.SetParameterValue("total_due", row["due_amount"].ToString());
}
}
con.Select("SELECT sum(due_amount) as due_amount, sum(amount) as paid_amount,sum(surcharge) FROM[dbo].[installment_payments] where allottee_id = " + id);
DataTable dt2 = new DataTable();
con.sda.Fill(dt2);
foreach (DataRow row in dt2.Rows)
{
if (row["due_amount"].ToString() != "")
{
total_due_amount += Int32.Parse(row["due_amount"].ToString());
total_paid_amount += Int32.Parse(row["paid_amount"].ToString());
}
crpt.SetParameterValue("total_due", total_due_amount.ToString());
crpt.SetParameterValue("total_paid", total_paid_amount);
}
var margins = crpt.PrintOptions.PageMargins;
crystalReportViewer1.ReportSource = crpt;
crystalReportViewer1.EnableDrillDown = false;
}
