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(); }
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(); }
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(); }
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); }
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, ""); } }