-
Notifications
You must be signed in to change notification settings - Fork 0
/
ReportSARPage.aspx.cs
119 lines (94 loc) · 3.46 KB
/
ReportSARPage.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using Microsoft.Reporting.WebForms;
using System.Configuration;
using System.Data;
public partial class ReportSARPage : System.Web.UI.Page
{
DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!User.Identity.IsAuthenticated)
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
else
{
reLoadSession();
}
BindReport();
}
}
private void reLoadSession()
{
if (Session["userType"] == null || Session["aGENT"] != null || Session["lOCATION"] != null)
{
USERINFO userInfo = new USERINFO();
userInfo = USERINFOManager.GetUSERINFOByUserNameType("Agent", User.Identity.Name);//"Agent" is dami in database i have not use the
if (userInfo != null)
{
Session["userType"] = userInfo.Type.ToString();
Session["userInfoID"] = userInfo.USERINFOID.ToString();
Session["userName"] = userInfo.UserName.ToString();
//if (userInfo.Agent_LocationID.ToString() == ddlAgent.SelectedItem.Value.ToString())
if (userInfo.Type == "Agent")
{
Session["aGENT"] = AGENTManager.GetAGENTByID(userInfo.Agent_LocationID);
Session["role"] = "Agent";
}
else if (userInfo.Type == "Location")
{
Session["lOCATION"] = LOCATIONGROUPManager.GetLOCATIONGROUPByID(userInfo.Agent_LocationID);
Session["role"] = "Location";
}
}
}
}
public void BindReport()
{
ReportDataSource rds = new ReportDataSource();
rds.Name = "dsSAR_dtSAR";
rds.Value = FetchCustomer();
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reports/rptSAR.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
//ReportViewer1.LocalReport.EnableExternalImages = true;
//ReportParameter rptParam1 = new ReportParameter("ReportTitle", "Asp.Net Local Report Demo");
//ReportParameter rptParam2 = new ReportParameter("ReportLogo",
// "http://" + Request.Url.Host + "/" + ResolveUrl("aspdotnetcodes.gif"));
//ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rptParam1, rptParam2 });
//ReportViewer1.LocalReport.Refresh();
}
public DataTable FetchCustomer()
{
dt = new DataTable();
dt.Columns.Add(new DataColumn("Test", typeof(String)));
DataRow dr = dt.NewRow();
for (int i = 0; i <= 5; i++)
{
dr = dt.NewRow();
dr[0] = "Name_" + i.ToString();
dt.Rows.Add(dr);
dr = dt.NewRow();
}
return dt;
//dt = new DataTable();
//DataRow dr = dt.NewRow();
////dt = postalCodeManager.GetAllDistinctState();
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// dr = dt.NewRow();
// dr[0] = dt.Rows[i]["ProvinceName"].ToString();
// dt.Rows.Add(dr);
// dr = dt.NewRow();
//}
//return dt;
}
}