protected void ReportTo(string rpt)
{
string xxRPT = rpt;
if (xxRPT.ToString() == "Management")
{
xStr = "select Code, PlannerName from fp_Planner p where PlannerRole=(Select Code from fp_ComboDetail where Name='Admin')";
}
if (xxRPT.ToString() == "Planner")
{
xStr = "select Code, PlannerName from fp_Planner p where PlannerRole in (Select Code from fp_ComboDetail where Name<>'Operator')";
}
if (xxRPT.ToString() == "Operator")
{
xStr = "select Code, PlannerName from fp_Planner p where PlannerRole in (Select Code from fp_ComboDetail where Name<>'Planner')";
}
SqlDataAdapter RDA2 = new SqlDataAdapter(xStr, Con);
DataSet RDS2 = new DataSet();
Con.Open();
RDA2.Fill(RDS2);
Con.Close();
DropDownReportTo.DataSource = RDS2;
DropDownReportTo.DataTextField = "PlannerName";
DropDownReportTo.DataValueField = "Code";
DropDownReportTo.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if ((string)Session["AdminSessionID"] != null)
{
ViewState["xCode"] = Session["AdminSessionID"].ToString();
ViewState["xPRole"] = Session["LoginRole"].ToString();
// Code for Planner Role
SqlDataAdapter RDA = new SqlDataAdapter(" " +
" select * from fp_ComboDetail where comboCode=15 " +
" ", Con);
DataSet RDS = new DataSet();
Con.Open();
RDA.Fill(RDS);
Con.Close();
DDPlannerRole.DataSource = RDS;
DDPlannerRole.DataTextField = "Name";
DDPlannerRole.DataValueField = "Code";
DDPlannerRole.DataBind();
DDPlannerRole.Items.Insert(0, new ListItem("Select Role", "0"));
// Code for Report To
SqlDataAdapter RDA2 = new SqlDataAdapter(" " +
" select Code, ReportName=PlannerName from fp_Planner order by PlannerName " +
//" where PlannerRole=(Select Code from fp_ComboDetail where Name='Management' ) " +
" ", Con);
DataSet RDS2 = new DataSet();
Con.Open();
RDA2.Fill(RDS2);
Con.Close();
DropDownReportTo.DataSource = RDS2;
DropDownReportTo.DataTextField = "ReportName";
DropDownReportTo.DataValueField = "Code";
DropDownReportTo.DataBind();
}
else
{
Response.Redirect("SessionExpired.aspx");
}
FillGrid_User();
}
}
