public ActionResult GetDayBookreport(string fdate, string tdate, int acheadid, int?rentflag, int?montlyrent1, int?montlyrent2)
{
ViewBag.accounthead = (from a in context.AcHeads where a.AcHeadID == acheadid select a.AcHead1).FirstOrDefault();
TempData["tdate"] = tdate;
var data = context.Report_DayBook(Convert.ToInt32(Session["fyearid"].ToString()), Convert.ToInt32(Session["AcCompanyID"].ToString()), Convert.ToDateTime(fdate), Convert.ToDateTime(tdate), Convert.ToInt32(acheadid), rentflag, montlyrent1, montlyrent2).Take(0);
var voucher = data.Select(d => d.VoucherNo).Distinct();
ViewBag.acheadid = acheadid;
ViewBag.fromdate = fdate;
ViewBag.todate = tdate;
ViewBag.rentflag = rentflag;
if (montlyrent1 == null)
{
ViewBag.m1 = 0;
}
else
{
ViewBag.m1 = montlyrent1;
}
if (montlyrent2 == null)
{
ViewBag.m2 = 0;
}
else
{
ViewBag.m2 = montlyrent2;
}
return(PartialView("_GetDayBookreport", data));
//return new JsonResult
//{
// Data = new
// {
// success = true,
// view = view
// },
// JsonRequestBehavior = JsonRequestBehavior.AllowGet
//};
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int acid = Convert.ToInt32(Request.QueryString["acheadid"].ToString());
DateTime fromdate = Convert.ToDateTime(Request.QueryString["fromdate"].ToString());
DateTime todate = Convert.ToDateTime(Request.QueryString["todate"].ToString());
int rentflag = Convert.ToInt32(Request.QueryString["rentflag"].ToString());
int m1 = Convert.ToInt32(Request.QueryString["m1"].ToString());
int m2 = Convert.ToInt32(Request.QueryString["m2"].ToString());
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/DayBook.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("Todate");
dtcompany.Columns.Add("AcHead");
var company = entity.AcCompanies.FirstOrDefault();
string achead = (from c in entity.AcHeads where c.AcHeadID == acid select c.AcHead1).FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = todate;
dr[6] = achead;
dtcompany.Rows.Add(dr);
ReportDataSource _rsource;
var dt = entity.Report_DayBook(Convert.ToInt32(Session["fyearid"].ToString()), Convert.ToInt32(Session["AcCompanyID"].ToString()), fromdate, todate, acid, rentflag, m1, m2).ToList();
_rsource = new ReportDataSource("DayBook", dt);
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
DataTable dtuser = new DataTable();
dtuser.Columns.Add("UserName");
DataRow dr1 = dtuser.NewRow();
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
dtuser.Rows.Add(dr1);
ReportDataSource _rsource2 = new ReportDataSource("User", dtuser);
ReportViewer1.LocalReport.DataSources.Add(_rsource2);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
ReportViewer1.LocalReport.Refresh();
}
}
