protected void Page_Load(object sender, EventArgs e)
        {
            //RadPanelBar1.Items[0].Expanded = true;
            if (Session["EmployeeID"].ToString() == "")
            {
                Response.Redirect("~/Login2.aspx");
            }
            else
            {
                if (Session["EmployeeType"].ToString() == "Admin")
                {
                    this.Master.FindControl("tblLinksAdmin").Visible = true;
                    this.Master.FindControl("tblLinksReps").Visible  = false;
                }
                else if (Session["EmployeeType"].ToString() == "Rep")
                {
                    this.Master.FindControl("tblLinksAdmin").Visible = false;
                    this.Master.FindControl("tblLinksReps").Visible  = true;
                }
            }

            dvApp = (DataView)(ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty));
            dtApp = dvApp.ToTable();

            lblAppsCount.Text  = dtApp.Rows.Count.ToString();
            lblClassA_App.Text = dtApp.Select("PhysicianClass = 'A'").Length.ToString();
            lblClassB_App.Text = dtApp.Select("PhysicianClass = 'B'").Length.ToString();
            lblClassC_App.Text = dtApp.Select("PhysicianClass = 'C'").Length.ToString();
        }
Esempio n. 2
0
        protected void FillAppsHeader()
        {
            RadPanelItem item = RadPanelBar1.Items[0];
            Label        lT   = (Label)item.Header.FindControl("lblAppsTotal");
            Label        lA   = (Label)item.Header.FindControl("lblAppsClassA");
            Label        lB   = (Label)item.Header.FindControl("lblAppsClassB");

            //Comment until finishing Sales Director Partt in Dataset
            lT.Text = "All Appointments:            " + ((DataView)ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty)).ToTable().Rows.Count.ToString();
            lA.Text = "Class A: " + ((DataView)ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty)).ToTable().Select("PhysicianClass = 'A'").Length.ToString();
            lB.Text = "Class B: " + ((DataView)ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty)).ToTable().Select("PhysicianClass = 'B'").Length.ToString();
            //lC.Text = "Class C: " + ((DataView)ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty)).ToTable().Select("PhysicianClass = 'C'").Length.ToString();
        }
Esempio n. 3
0
        protected void FillAppsHeader()
        {
            RadPanelItem item = RadPanelBar1.Items[3];
            Label        lT   = (Label)item.Header.FindControl("lblAppsTotal");
            Label        lA   = (Label)item.Header.FindControl("lblAppsClassA");
            Label        lB   = (Label)item.Header.FindControl("lblAppsClassB");

            //Label lC = (Label)item.Header.FindControl("lblAppsClassC");

            lT.Text = "Doctor’s Visits / Planned:            " + ((DataView)ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty)).ToTable().Rows.Count.ToString();
            lA.Text = "Class A+: " + ((DataView)ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty)).ToTable().Select("PhysicianClass = 'A+'").Length.ToString();
            lB.Text = "Class A: " + ((DataView)ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty)).ToTable().Select("PhysicianClass = 'A'").Length.ToString();
            //lC.Text = "Class C: " + ((DataView)ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty)).ToTable().Select("PhysicianClass = 'C'").Length.ToString();
        }
Esempio n. 4
0
 protected void btnGet_Click(object sender, EventArgs e)
 {
     ListOfAppointmentsDS.SelectCommand += " Where AppointmentID > 0";
     if (ddlCycles.SelectedValue != null && ddlCycles.SelectedValue != "Select")
     {
         ListOfAppointmentsDS.SelectCommand += " AND CycleID = " + int.Parse(ddlCycles.SelectedValue);
     }
     if (ddlLines.SelectedValue != null && ddlLines.SelectedValue != "Select")
     {
         ListOfAppointmentsDS.SelectCommand += " AND NewLineID = " + int.Parse(ddlLines.SelectedValue);
     }
     if (ddlRegions.SelectedValue != null && ddlRegions.SelectedValue != "Select")
     {
         ListOfAppointmentsDS.SelectCommand += " AND NewMgtAreaName = '" + ddlRegions.SelectedValue + "'";
     }
     ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty);
 }
Esempio n. 5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                //RadPanelBar1.Items[0].Expanded = true;
                if (Session["EmployeeIDFromDM"].ToString() == "")
                {
                    Response.Redirect("~/Login2.aspx");
                }
                else
                {
                    if (Session["EmployeeType"].ToString() == "Admin")
                    {
                        this.Master.FindControl("tblLinksAdmin").Visible = true;
                        this.Master.FindControl("tblLinksReps").Visible  = false;
                    }
                    else if (Session["EmployeeType"].ToString() == "Rep")
                    {
                        this.Master.FindControl("tblLinksAdmin").Visible = false;
                        this.Master.FindControl("tblLinksReps").Visible  = true;
                    }
                }

                //dvApp = (DataView)(ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty));
                dvApp = (DataView)(ListOfAppointmentsDS.Select(DataSourceSelectArguments.Empty));
                dtApp = dvApp.ToTable();

                lblAppsCount.Text  = dtApp.Select("CycleID = " + int.Parse(Session["CycleIDFromDM"].ToString())).Length.ToString();
                lblClassA_App.Text = dtApp.Select("PhysicianClass = 'A' AND CycleID = " + int.Parse(Session["CycleIDFromDM"].ToString())).Length.ToString();
                lblClassB_App.Text = dtApp.Select("PhysicianClass = 'B' AND CycleID = " + int.Parse(Session["CycleIDFromDM"].ToString())).Length.ToString();
                lblClassC_App.Text = dtApp.Select("PhysicianClass = 'C' AND CycleID = " + int.Parse(Session["CycleIDFromDM"].ToString())).Length.ToString();
            }
            catch (Exception)
            {
                RadWindowManager1.RadAlert("Time Exceeded. Please try again after a while or contact your line manager", 400, 200, "Alert!", null, "");
            }
        }