public static void Main(string[] args)
{
ReportCreation oReportCreation = new ReportCreation();
DbCon CSDB = new DbCon();
DataTable myDataset = new DataTable();
myDataset = CSDB.Execute_Of_Query_Function_dataSet("Exec sp_tblFiles_Selct");
if (myDataset.Rows.Count > 0)
{
for (int i = 0; i < myDataset.Rows.Count; i++)
{
oReportCreation.LoadDataTable(@"" + myDataset.Rows[i]["vchrPath"].ToString() + "", myDataset.Rows[i]["vchrFileName"].ToString(), Convert.ToInt32(myDataset.Rows[i]["intFileSerial"]), Convert.ToInt32(myDataset.Rows[i]["intProjectSerial"]));
}
}
}
public ActionResult Report(ReportCreation c)
{
if (c.select == "Monthly salary Given to staff")
{
ReportDocument rd = new ReportDocument();
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlDataAdapter ada = new SqlDataAdapter("select Staff.Username,Staff.Contact,staff.Email,Staff.Address,Salary.SalaryAmount,Salary.Bonus from staff join Salary on Staff.Id=Salary.StaffId where MONTH(Salary.Month) = MONTH(GETDATE())", con);
DataSetSalry dat = new DataSetSalry();
DataTable T = new DataTable();
ada.Fill(T);
dat.Tables[0].Merge(T, true, MissingSchemaAction.Ignore);
rd.Load(System.IO.Path.Combine(Server.MapPath("~/Report"), "Salaryreposrt.rpt"));
rd.SetDataSource(dat);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
System.IO.Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, System.IO.SeekOrigin.Begin);
return(File(stream, "salary/pdf", "staff_salary.pdf"));
}
catch
{
return(RedirectToAction("Report"));
}
}
else if (c.select == "yearly Report of salary")
{
ReportDocument rd = new ReportDocument();
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlDataAdapter ada = new SqlDataAdapter("select staff.Username,Salary.SalaryAmount,Salary.Bonus,Salary.[Month],Year(Salary.[Month]) as [Year]from Staff join Salary on Staff.Id=Salary.StaffId group by YEAR(Salary.[Month]),Staff.Username,Salary.SalaryAmount,Salary.Bonus,Salary.Month", con);
yearlydata dat = new yearlydata();
DataTable T = new DataTable();
ada.Fill(T);
dat.Tables[0].Merge(T, true, MissingSchemaAction.Ignore);
rd.Load(System.IO.Path.Combine(Server.MapPath("~/Report"), "yearlyReport.rpt"));
rd.SetDataSource(dat);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
System.IO.Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, System.IO.SeekOrigin.Begin);
return(File(stream, "salary/pdf", "yearlyf_salary.pdf"));
}
catch
{
return(RedirectToAction("Report"));
}
//MessageBox.Show(dat.Tables[0].Rows.Count.ToString());
/* rpt.Load(@"C:\Users\FINEC\Documents\Visual Studio 2015\Projects\databaseproject\databaseproject\CrystalReport1.rpt");
* rpt.SetDataSource(dat);
* crystalReportViewer1.ReportSource = rpt;*/
}
return(View());
}
