protected void bindfavtask()
{
objuser.userid = Session["userid"].ToString();
objuser.action = "getfavReportHTML";
ds = objuser.FavouriteReports();
StringBuilder sb = new StringBuilder();
if (ds.Tables[1].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
sb.Append("<li class='favtitle'><i class='fa fa-file'></i>" + ds.Tables[1].Rows[i]["rGroup"].ToString() + "</li>");
DataTable dt = new DataTable();
dt = filterrole("rGroup='" + ds.Tables[1].Rows[i]["rGroup"].ToString() + "'", ds);
for (int j = 0; j < dt.Rows.Count; j++)
{
sb.Append("<li><a href='" + dt.Rows[j]["rlink"].ToString() + "'><i class='reporticon'>" + dt.Rows[j]["rname"].ToString() + "</i></a></li>");
}
}
}
else
{
sb.Append("<li class='nofavtask'>No Favourite Report in this list</li>");
}
litfavtask.Text = sb.ToString();
}
public void fillfavReport()
{
objuser.userid = Session["userid"].ToString();
objuser.action = "getallreports";
ds = objuser.FavouriteReports();
StringBuilder sb = new StringBuilder();
if (ds.Tables[1].Rows.Count > 0)
{
int num = 0;
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
// sb.Append("<li><a><i>" + ds.Tables[1].Rows[i]["rGroup"].ToString() + "</i></a>");
DataTable dt = new DataTable();
dt = filterrole("rGroup='" + ds.Tables[1].Rows[i]["rGroup"].ToString() + "'", ds);
if (dt.Rows.Count > 0)
{
// ListItem li = new ListItem(ds.Tables[1].Rows[i]["rGroup"].ToString(), ds.Tables[1].Rows[i]["rGroup"].ToString());
// li.Attributes.Add("style", "color:blue");
//// li.Enabled = false;
// listcode1.Items.Insert(num, li);
// num = num + 1;
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j]["linkname"].ToString() != "")
{
string[] linkname = dt.Rows[j]["linkname"].ToString().Split('#');
string[] linkpagename = dt.Rows[j]["pages"].ToString().Split('#');
for (int k = 0; k < linkname.Length; k++)
{
ListItem li = new ListItem(linkname[k], linkpagename[k]);
li.Attributes.Add("data-category", ds.Tables[1].Rows[i]["rGroup"].ToString());
listcode1.Items.Insert(num, li);
num = num + 1;
}
}
}
}
}
}
}