protected void Page_Load(object sender, EventArgs e) { FromDate.Attributes["readonly"] = "readonly"; ToDate.Attributes["readonly"] = "readonly"; if (!(User.Identity.IsAuthenticated && User.IsInRole("Admin"))) { Response.Redirect("~/login/login"); } if (SessionManager.LanguageId == "1") { HtmlGenericControl link = new HtmlGenericControl("LINK"); link.Attributes.Add("rel", "stylesheet"); link.Attributes.Add("type", "text/css"); link.Attributes.Add("href", ResolveClientUrl("~/Content/CssAr/components-rtl.css")); HtmlGenericControl link2 = new HtmlGenericControl("LINK"); link2.Attributes.Add("rel", "stylesheet"); link2.Attributes.Add("type", "text/css"); link2.Attributes.Add("href", ResolveClientUrl("~/Content/CssAr/bootstrap-rtl.min.css")); Page.Header.Controls.Add(link); Page.Header.Controls.Add(link2); } else { HtmlGenericControl link = new HtmlGenericControl("LINK"); link.Attributes.Add("rel", "stylesheet"); link.Attributes.Add("type", "text/css"); link.Attributes.Add("href", ResolveClientUrl("~/Content/components.css")); HtmlGenericControl link2 = new HtmlGenericControl("LINK"); link2.Attributes.Add("rel", "stylesheet"); link2.Attributes.Add("type", "text/css"); link2.Attributes.Add("href", ResolveClientUrl("~/Content/bootstrap.min.css")); Page.Header.Controls.Add(link); Page.Header.Controls.Add(link2); } if (!IsPostBack) { if (SessionManager.LanguageId == "1") { UsersDrpLst.DataSource = _uow.Useres.List().ToArray().Select(item => new { UserId = item.UserId, FullName = item.FirstName + ' ' + item.LastName }); UsersDrpLst.DataTextField = "FullName"; UsersDrpLst.DataValueField = "UserId"; UsersDrpLst.DataBind(); UsersDrpLst.Items.Insert(0, "الجميع"); DepartDplst.DataSource = _uow.Departments.List().Where(x => x.IsDeleted != true).ToArray(); DepartDplst.DataTextField = "NameAr"; DepartDplst.DataValueField = "DepartmentId"; DepartDplst.DataBind(); DepartDplst.Items.Insert(0, "الجميع"); TypeDrpLst.DataSource = _uow.CorrespondentTypeNames.List().ToArray(); TypeDrpLst.DataTextField = "TypeNameAr"; TypeDrpLst.DataValueField = "CorrespondentId"; TypeDrpLst.DataBind(); TypeDrpLst.Items.Insert(0, "الجميع"); _generatedReferenceRpt = _uow.ReferenceByUserOrDeprts.List().OrderByDescending(a => a.CreatedAt).ToList(); ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/ReferenceByUserOrDeprtAr.rdlc"); ReportViewer1.LocalReport.DataSources.Clear(); ReportDataSource rdc = new ReportDataSource("DataSet1", _generatedReferenceRpt); ReportViewer1.LocalReport.DataSources.Add(rdc); ReportViewer1.LocalReport.Refresh(); } else { UsersDrpLst.DataSource = _uow.Useres.List().ToArray().Select(item => new { UserId = item.UserId, FullName = item.FirstName + ' ' + item.LastName }); UsersDrpLst.DataTextField = "FullName"; UsersDrpLst.DataValueField = "UserId"; UsersDrpLst.DataBind(); UsersDrpLst.Items.Insert(0, "All"); DepartDplst.DataSource = _uow.Departments.List().Where(x => x.IsDeleted != true).ToArray(); DepartDplst.DataTextField = "NameEn"; DepartDplst.DataValueField = "DepartmentId"; DepartDplst.DataBind(); DepartDplst.Items.Insert(0, "All"); TypeDrpLst.DataSource = _uow.CorrespondentTypeNames.List().ToArray(); TypeDrpLst.DataTextField = "TypeName"; TypeDrpLst.DataValueField = "CorrespondentId"; TypeDrpLst.DataBind(); TypeDrpLst.Items.Insert(0, "All"); _generatedReferenceRpt = _uow.ReferenceByUserOrDeprts.List().OrderByDescending(a => a.CreatedAt).ToList(); ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/ReferenceByUserOrDeprt.rdlc"); ReportViewer1.LocalReport.DataSources.Clear(); ReportDataSource rdc = new ReportDataSource("DataSet1", _generatedReferenceRpt); ReportViewer1.LocalReport.DataSources.Add(rdc); ReportViewer1.LocalReport.Refresh(); } } }
protected void Page_Load(object sender, EventArgs e) { FromDate.Attributes["readonly"] = "readonly"; ToDate.Attributes["readonly"] = "readonly"; if (!(User.Identity.IsAuthenticated && User.IsInRole("Admin"))) { Response.Redirect("~/login/login"); } if (SessionManager.LanguageId == "1") { HtmlGenericControl link = new HtmlGenericControl("LINK"); link.Attributes.Add("rel", "stylesheet"); link.Attributes.Add("type", "text/css"); link.Attributes.Add("href", ResolveClientUrl("~/Content/CssAr/components-rtl.css")); HtmlGenericControl link2 = new HtmlGenericControl("LINK"); link2.Attributes.Add("rel", "stylesheet"); link2.Attributes.Add("type", "text/css"); link2.Attributes.Add("href", ResolveClientUrl("~/Content/CssAr/bootstrap-rtl.min.css")); Page.Header.Controls.Add(link); Page.Header.Controls.Add(link2); } else { HtmlGenericControl link = new HtmlGenericControl("LINK"); link.Attributes.Add("rel", "stylesheet"); link.Attributes.Add("type", "text/css"); link.Attributes.Add("href", ResolveClientUrl("~/Content/components.css")); HtmlGenericControl link2 = new HtmlGenericControl("LINK"); link2.Attributes.Add("rel", "stylesheet"); link2.Attributes.Add("type", "text/css"); link2.Attributes.Add("href", ResolveClientUrl("~/Content/bootstrap.min.css")); Page.Header.Controls.Add(link); Page.Header.Controls.Add(link2); } if (!IsPostBack) { if (SessionManager.LanguageId == "1") { UsersDrpLst.DataSource = _uow.Useres.List().ToArray(); UsersDrpLst.DataTextField = "FirstName"; UsersDrpLst.DataValueField = "UserId"; UsersDrpLst.DataBind(); UsersDrpLst.Items.Insert(0, "الجميع"); DepartDplst.DataSource = _uow.Departments.List().ToArray(); DepartDplst.DataTextField = "NameAr"; DepartDplst.DataValueField = "DepartmentId"; DepartDplst.DataBind(); DepartDplst.Items.Insert(0, "الجميع"); TypeDrpLst.DataSource = _uow.CorrespondentTypeNames.List().ToArray(); TypeDrpLst.DataTextField = "TypeNameAr"; TypeDrpLst.DataValueField = "CorrespondentId"; TypeDrpLst.DataBind(); TypeDrpLst.Items.Insert(0, "الجميع"); _generatedReferenceRpt = _uow.ReferenceByUserOrDeprts.List().OrderBy(a => a.CreatedAt).ToList(); parameters[0] = new ReportParameter("NumberOfReference", _generatedReferenceRpt.Count().ToString()); parameters[1] = new ReportParameter("UserName", "الجميع"); parameters[2] = new ReportParameter("DepartmentName", "الجميع"); parameters[3] = new ReportParameter("From", " "); parameters[4] = new ReportParameter("To", " "); parameters[5] = new ReportParameter("Company", "الجميع"); parameters[6] = new ReportParameter("Type", "الجميع"); this.ReportViewer1.LocalReport.SetParameters(parameters); ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/NumberOfGeneratedReferencesAr.rdlc"); ReportViewer1.LocalReport.Refresh(); } else { UsersDrpLst.DataSource = _uow.Useres.List().ToArray(); UsersDrpLst.DataTextField = "FirstName"; UsersDrpLst.DataValueField = "UserId"; UsersDrpLst.DataBind(); UsersDrpLst.Items.Insert(0, "All"); DepartDplst.DataSource = _uow.Departments.List().ToArray(); DepartDplst.DataTextField = "NameEn"; DepartDplst.DataValueField = "DepartmentId"; DepartDplst.DataBind(); DepartDplst.Items.Insert(0, "All"); TypeDrpLst.DataSource = _uow.CorrespondentTypeNames.List().ToArray(); TypeDrpLst.DataTextField = "TypeName"; TypeDrpLst.DataValueField = "CorrespondentId"; TypeDrpLst.DataBind(); TypeDrpLst.Items.Insert(0, "All"); _generatedReferenceRpt = _uow.ReferenceByUserOrDeprts.List().OrderBy(a => a.CreatedAt).ToList(); parameters[0] = new ReportParameter("NumberOfReference", _generatedReferenceRpt.Count().ToString()); parameters[1] = new ReportParameter("UserName", "All"); parameters[2] = new ReportParameter("DepartmentName", "All"); parameters[3] = new ReportParameter("From", " "); parameters[4] = new ReportParameter("To", " "); parameters[5] = new ReportParameter("Company", "All"); parameters[6] = new ReportParameter("Type", "All"); this.ReportViewer1.LocalReport.SetParameters(parameters); ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/NumberOfGeneratedReferences.rdlc"); ReportViewer1.LocalReport.Refresh(); } } }