public ActionResult BankBookReport() { //ViewBag.bankhead = context.AcHeadSelectForBank(Convert.ToInt32(Session["AcCompanyID"].ToString())); ViewBag.bankhead = context.AcHeadSelectAll(Convert.ToInt32(Session["AcCompanyID"].ToString())); return(View()); }
protected void Page_Load(object sender, EventArgs e) { //string vSupplierD = Request.QueryString["supplierId"].ToString(); if (!IsPostBack) { string accomp = "1"; int supid = 0; if (accomp == "") { supid = 0; } else { supid = Convert.ToInt32(accomp); } ReportViewer1.SizeToReportContent = true; ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/ChartOFAcount.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(); 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] = TrueBooksMVC.Models.CommanFunctions.GetShortDateFormat(DateTime.Now); dr[6] = ""; dtcompany.Rows.Add(dr); var dt = entity.AcHeadSelectAll(1).ToList(); ReportDataSource _rsource2 = new ReportDataSource("ChartOFAccount", dt); //ReportDataSource _rsource; //if (supid == 0) //{ // var dt = entity.ProCustomerLedger1(1,"01 Jan 2016","04 Apr 2016").ToList(); // _rsource = new ReportDataSource("DataSet2", dt); //} //else //{ // var dt = entity.ProCustomerLedger1(1, "01 Jan 2016", "04 Apr 2016").ToList(); // _rsource = new ReportDataSource("DataSet2", dt); //} ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany); ReportViewer1.LocalReport.DataSources.Add(_rsource2); // ReportViewer1.LocalReport.DataSources.Add(_rsource); ReportViewer1.LocalReport.DataSources.Add(_rsource1); 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 _rsource3 = new ReportDataSource("User", dtuser); ReportViewer1.LocalReport.DataSources.Add(_rsource3); ReportViewer1.LocalReport.Refresh(); } }
public List <AcHeadSelectAll_Result> AcHeadSelectAll(int branchID) { return(Context1.AcHeadSelectAll(branchID).OrderBy(x => x.AcHead).ToList()); }