//Manage Panel Visibilty for Placements protected void ManageVisibility(object sender, CommandEventArgs e) { string cmdName = e.CommandName.ToString(); switch (cmdName) { case "ViewPlacementDrives": lblPlacementAction.Text = "Placements /Drives"; pnlPlacementDrives.Visible = true; string drivCmd = string.Format(@"SELECT * FROM EduSphere.PlacementDrives d JOIN EduSphere.Organizations o ON d.EmployerID=o.OrganizationID JOIN EduSphere.Staff s ON d.CoordinatorID=s.EmployeeID ORDER BY DriveDate DESC"); BD.DataBindToGridView(gvPlacementDrives, drivCmd, "NA"); BD.DataBindToDropDownList(ddlEmployerID, string.Format("SELECT OrganizationID,OrganizationName FROM EduSphere.Organizations WHERE OrganizationType='{0}'", "EMPLOYER")); BD.DataBindToDropDownList(ddlCoordinatorID, string.Format("SELECT EmployeeID,FullName FROM EduSphere.Staff")); break; case "ReturnToPlacements": Response.Redirect("Placements.aspx"); break; default: break; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { User.ToString(); //SP.Speak("Welcome to lead management"); lblEnquiryAction.Text = "View Leads"; pnlViewEnquiry.Visible = true; pnlViewEnquiryProfile.Visible = false; pnlEditEnquiryProfile.Visible = false; pnlEnquiryStatusModifications.Visible = false; pnlAddEnquiry.Visible = false; BD.DataBindToDropDownList(ddlFilterOrganizationName, string.Format("SELECT OrganizationName,OrganizationId FROM EduSphere.Organizations WHERE OrganizationType='{0}'", "FRANCHISEE")); string EnquiryViewSelect; //if (User.IsInRole("L1")) // EnquiryViewSelect = string.Format("SELECT TOP 100 *, po.OrganizationName as Principle,co.OrganizationName as Customer,vo.OrganizationName as Vendor FROM EduSphere.Enquiries Enquiry JOIN EduSphere.Organizations po ON Enquiry.FranchiseeID=po.OrganizationId JOIN EduSphere.Organizations co ON Enquiry.CustomerId=co.OrganizationId JOIN EduSphere.Organizations vo ON Enquiry.VendorId=vo.OrganizationId WHERE Enquiry.RaisedById='{0}' ORDER BY RaisedOn DESC", User.Identity.Name); //else EnquiryViewSelect = string.Format(@"SELECT TOP 1000 *, o.FullName as Owner,a.FullName as Assigned, (SELECT TOP 1 ModificationComments FROM EduSphere.EnquiryStatusModifications m WHERE m.EnquiryId=e.EnquiryId ORDER BY ModificationId DESC) AS Comments FROM EduSphere.Enquiries e JOIN EduSphere.Organizations org ON e.FranchiseeID=org.OrganizationId JOIN EduSphere.Staff o ON e.OwnerEmployeeId=o.EmployeeId JOIN EduSphere.Staff a ON e.AssignedEmployeeId=a.EmployeeId JOIN eduSphere.Programs p ON e.ProgramID=p.ProgramID ORDER BY RaisedOn DESC"); BD.DataBindToGridView(gvEnquiry, EnquiryViewSelect, "NA"); BD.DataBindToLabel(lblCountEnquiries, string.Format("SELECT COUNT(EnquiryId) FROM EduSphere.Enquiries WHERE EnquiryStatus='{0}'", "NEW")); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { User.ToString(); //SP.Speak("Welcome to lead management"); lblRoleRequestsAction.Text = "View Requests"; pnlViewRoleRequests.Visible = true; pnlViewRoleRequestsProfile.Visible = false; pnlEditRoleRequestsProfile.Visible = false; pnlRoleRequestsStatusModifications.Visible = false; pnlAddRoleRequests.Visible = false; BD.DataBindToDropDownList(ddlFilterOrganizationName, string.Format("SELECT OrganizationName,OrganizationId FROM EduSphere.Organizations WHERE OrganizationType='{0}'", "FRANCHISEE")); string queryRoleRequests; //Allow Manager to view the role request of her/his Organization only ONLY...shivmani 8th April 2020. if (User.IsInRole("Admin")) { queryRoleRequests = string.Format(@"SELECT TOP 1000 * FROM EduSphere.RoleRequests r JOIN EduSphere.States p ON r.RequesterState=p.StateID JOIN EduSphere.Organizations o on r.OrganizationID=o.OrganizationID ORDER BY RequestID DESC"); } else { queryRoleRequests = string.Format(@"SELECT TOP 1000 * FROM EduSphere.RoleRequests r JOIN EduSphere.States p ON r.RequesterState=p.StateID JOIN EduSphere.Organizations o on r.OrganizationID=o.OrganizationID WHERE r.OrganizationID=(SELECT OrganizationID FROM EduSphere.Staff WHERE Email='{0}') ORDER BY RequestID DESC", User.Identity.Name.ToString()); } BD.DataBindToGridView(gvRoleRequests, queryRoleRequests, "NA"); //Displya Count BD.DataBindToLabel(lblCountRequests, string.Format("SELECT COUNT(RequestID) FROM EduSphere.RoleRequests WHERE RequestApprovalStatus='{0}'", "NEW")); BD.DataBindToLabel(lblCountRequestsApproved, string.Format("SELECT COUNT(RequestID) FROM EduSphere.RoleRequests WHERE RequestApprovalStatus='{0}'", "APPROVED")); } }
//Manage Staff Panel Displays protected void ManageStaffVisibility(object sender, CommandEventArgs e) { string cmdName, strCmd = ""; int intEmployeeId; cmdName = e.CommandName.ToString(); switch (cmdName) { case "AddStaff": lblStaffAction.Text = "Add New Staff"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = true; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlViewStaffProfile.Visible = false; pnlEditStaffProfile.Visible = false; BD.DataBindToDropDownList(ddlOrgId, string.Format("SELECT OrganizationID,OrganizationName FROM EduSphere.Organizations")); BD.DataBindToDropDownList(ddlManagerId, string.Format("SELECT FUllName,EmployeeId FROM EduSphere.Staff")); break; case "UploadStaffDocument": lblStaffAction.Text = "Upload Staff Document"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = true; pnlViewStaffDocuments.Visible = false; pnlEditStaffProfile.Visible = false; pnlViewStaffProfile.Visible = false; lblEmployeeId.Text = e.CommandArgument.ToString(); break; case "ViewStaffDocument": lblStaffAction.Text = "View Staff Document"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = true; pnlEditStaffProfile.Visible = false; pnlViewStaffProfile.Visible = false; intEmployeeId = Convert.ToInt32(e.CommandArgument.ToString()); string docQuery = string.Format("SELECT * FROM EduSphere.StaffDocuments WHERE EmployeeId='{0}'", intEmployeeId); BD.DataBindToGridView(gvStaffDocuments, docQuery, "NA"); break; case "SearchStaff": case "FilterStaff": lblStaffAction.Text = "Search Staff"; pnlViewStaff.Visible = true; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlViewStaffProfile.Visible = false; pnlEditStaffProfile.Visible = false; pnlAddStaff.Visible = false; if (cmdName == "FilterStaff") { string strEmploymentStatus = ddlFilterEmploymentStatus.SelectedValue.ToString(); strCmd = string.Format("SELECT OrganizationName,EmployeeId,FullName,st.PhoneOne,st.Email FROM EduSphere.Staff st JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID WHERE EmploymentStatus='{0}' ORDER BY st.FullName ASC", strEmploymentStatus); } if (cmdName == "SearchStaff") { string strSerachParam = txtBoxSearchStaff.Text; strCmd = string.Format("SELECT OrganizationName,EmployeeId,FullName,PhoneOne,Email FROM EduSphere.Staff st JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID WHERE FullName LIKE '%{0}%' OR EmployeeId LIKE '%{0}%' ORDER BY st.FullName ASC", strSerachParam); } BD.DataBindToDataList(dlStaff, strCmd); break; case "ViewProfile": lblStaffAction.Text = "Staff Details"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlViewStaffProfile.Visible = true; pnlEditStaffProfile.Visible = false; pnlAddStaff.Visible = false; if (cmdName == "ViewProfile") { intEmployeeId = Convert.ToInt32(e.CommandArgument.ToString()); strCmd = string.Format("SELECT *,(SELECT FullName FROM EduSphere.Staff WHERE EmployeeId=(SELECT ManagerID FROM EduSphere.Staff WHERE EmployeeId='{0}')) AS ManagerName FROM EduSphere.Staff WHERE EmployeeId='{0}'", intEmployeeId, "ManagerName"); BD.DataBindToDataList(dlStaffDetails, strCmd); } break; case "EditProfile": lblStaffAction.Text = "Edit Staff Details"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlViewStaffProfile.Visible = false; pnlEditStaffProfile.Visible = true; pnlAddStaff.Visible = false; BD.DataBindToDataList(dlEditStaffProfile, string.Format("SELECT * FROM EduSphere.Staff WHERE EmployeeId='{0}'", Convert.ToInt32(e.CommandArgument.ToString()))); DropDownList ddlOrg = new DropDownList(); DropDownList ddlManager = new DropDownList(); foreach (DataListItem li in dlEditStaffProfile.Items) { ddlOrg = (DropDownList)li.FindControl("ddlEditOrgId"); ddlManager = (DropDownList)li.FindControl("ddlEditManagerId"); } BD.DataBindToDropDownList(ddlOrg, string.Format("SELECT OrganizationName, OrganizationID FROM EduSphere.Organizations")); BD.DataBindToDropDownList(ddlManager, string.Format("SELECT EmployeeId, FullName FROM EduSphere.Staff")); break; case "ReturnToViewStaff": Response.Redirect("Staff.aspx"); break; default: break; } }
//Populate City,State.Country based on PinCode //protected void FillAddress(object sender, EventArgs e) //{ // txtBoxCity.Text = hdCity.Value; // txtBoxState.Text = hdState.Value; // txtBoxCountry.Text = hdCountry.Value; //} //Manage Staff Panel Displays protected void ManageStaffVisibility(object sender, CommandEventArgs e) { string cmdName, strCmd = ""; int intEmployeeId; cmdName = e.CommandName.ToString(); switch (cmdName) { case "AddStaff": lblStaffAction.Text = "Add New Staff"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = true; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlHelp.Visible = false; pnlViewStaffProfile.Visible = false; pnlEditStaffProfile.Visible = false; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = false; BD.DataBindToDropDownList(ddlOrgId, string.Format("SELECT OrganizationID,OrganizationName FROM EduSphere.Organizations")); BD.DataBindToDropDownList(ddlManagerId, string.Format("SELECT FUllName,MemberID FROM EduSphere.Members")); break; case "UploadStaffDocument": lblStaffAction.Text = "Upload Staff Document"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = true; pnlViewStaffDocuments.Visible = false; pnlHelp.Visible = false; pnlEditStaffProfile.Visible = false; pnlViewStaffProfile.Visible = false; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = false; lblEmployeeId.Text = e.CommandArgument.ToString(); break; case "ViewStaffDocument": lblStaffAction.Text = "View Document"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = true; pnlHelp.Visible = false; pnlEditStaffProfile.Visible = false; pnlViewStaffProfile.Visible = false; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = false; intEmployeeId = Convert.ToInt32(e.CommandArgument.ToString()); string docQuery = string.Format("SELECT * FROM EduSphere.MemberDocuments WHERE MemberID='{0}'", intEmployeeId); BD.DataBindToGridView(gvStaffDocuments, docQuery, "NA"); break; case "ViewHelp": lblStaffAction.Text = "View Document"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlHelp.Visible = true; pnlEditStaffProfile.Visible = false; pnlViewStaffProfile.Visible = false; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = false; //intEmployeeId = Convert.ToInt32(e.CommandArgument.ToString()); string helpQuery = string.Format("SELECT * FROM EduSphere.HelpDocuments"); BD.DataBindToGridView(gvHelpDocuments, helpQuery, "NA"); break; case "AcademicDetails": string acadQuery = string.Format("SELECT * FROM EduSphere.MemberAcademics where MemberID='{0}'", Convert.ToInt32(e.CommandArgument.ToString())); BD.DataBindToDataList(dlAcademicDetails, acadQuery); lblEID.Text = e.CommandArgument.ToString(); pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlHelp.Visible = false; pnlEditStaffProfile.Visible = false; pnlViewStaffProfile.Visible = false; pnlNeuroAcademics.Visible = true; break; case "PublicationDetails": string pubQuery = string.Format("SELECT * FROM EduSphere.Publications WHERE MemberID='{0}'", Convert.ToInt32(e.CommandArgument.ToString())); BD.DataBindToDataList(dlNeuroPublications, pubQuery); lblPubEID.Text = e.CommandArgument.ToString(); pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlHelp.Visible = false; pnlEditStaffProfile.Visible = false; pnlViewStaffProfile.Visible = false; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = true; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = true; break; case "SearchStaff": case "FilterStaff": lblStaffAction.Text = "Search Staff"; pnlViewStaff.Visible = true; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlHelp.Visible = false; pnlViewStaffProfile.Visible = false; pnlEditStaffProfile.Visible = false; pnlAddStaff.Visible = false; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = false; if (cmdName == "FilterStaff") { string strEmploymentStatus = ddlFilterEmploymentStatus.SelectedValue.ToString(); //Membership will be visible if its in ACTIVE Status, set by ADMIN //string strEmploymentStatus = "ACTIVE"; //strCmd = string.Format(@"SELECT OrganizationName,MemberID,FullName,st.PhoneOne,st.Email // FROM EduSphere.Members st // JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID // WHERE MembershipStatus='{0}' AND st.Email='{1}' ORDER BY st.FullName ASC", strEmploymentStatus,User.Identity.Name.ToString()); strCmd = string.Format(@"SELECT OrganizationName,MemberID,FullName,st.PhoneOne,st.Email,st.MembershipStatus FROM EduSphere.Members st JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID WHERE MembershipStatus='{0}' AND st.Email='{1}' ORDER BY st.FullName ASC", strEmploymentStatus, User.Identity.Name.ToString()); } if (cmdName == "SearchStaff") { string strSerachParam = txtBoxSearchStaff.Text; //strCmd = string.Format("SELECT OrganizationName,MemberID,FullName,PhoneOne,Email FROM EduSphere.Members st JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID WHERE FullName LIKE '%{0}%' OR MemberID LIKE '%{0}%' ORDER BY st.FullName ASC", strSerachParam); } BD.DataBindToDataList(dlStaff, strCmd); break; case "ViewProfile": lblStaffAction.Text = "Staff Details"; pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlViewStaffDocuments.Visible = true; //display document alongwith profile pnlHelp.Visible = false; pnlViewStaffProfile.Visible = true; //display profile details pnlEditStaffProfile.Visible = false; pnlAddStaff.Visible = false; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = false; if (cmdName == "ViewProfile") { intEmployeeId = Convert.ToInt32(e.CommandArgument.ToString()); strCmd = string.Format(@"SELECT *,(SELECT FullName FROM EduSphere.Members WHERE MemberID=(SELECT MentorID FROM EduSphere.Members WHERE MemberID='{0}')) AS MentorName FROM EduSphere.Members n JOIN EduSphere.Programs p ON n.ProgramID=p.ProgramID JOIN EduSphere.Organizations edu ON n.OrganizationID=edu.OrganizationID WHERE n.MemberID='{0}' AND n.Email='{1}'", intEmployeeId, User.Identity.Name.ToString()); BD.DataBindToDataList(dlStaffDetails, strCmd); BD.DataBindToGridView(gvPostalAddresses, string.Format("Select * FROM EduSphere.PostalAddresses WHERE MemberID={0}", intEmployeeId), "NA"); //Display Documents too string docQ = string.Format("SELECT * FROM EduSphere.MemberDocuments WHERE MemberID='{0}'", intEmployeeId); BD.DataBindToGridView(gvStaffDocuments, docQ, "NA"); //Display Academics string acadQ = string.Format("SELECT * FROM EduSphere.MemberAcademics where MemberID='{0}'", Convert.ToInt32(e.CommandArgument.ToString())); BD.DataBindToGridView(gvViewAcademics, acadQ, "NA"); lblEID.Text = e.CommandArgument.ToString(); } break; case "EditProfile": lblStaffAction.Text = "Edit Profile"; lblNeutherapistID.Text = e.CommandArgument.ToString(); pnlViewStaff.Visible = false; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlHelp.Visible = false; pnlViewStaffDocuments.Visible = false; pnlViewStaffProfile.Visible = false; pnlEditStaffProfile.Visible = true; pnlAddStaff.Visible = false; pnlNeuroAcademics.Visible = false; pnlNeuroPublications.Visible = false; BD.DataBindToDataList(dlEditStaffProfile, string.Format(@"SELECT * FROM EduSphere.Members n JOIN EduSphere.Programs p ON n.ProgramID=p.ProgramID JOIN EduSphere.Organizations o ON n.OrganizationID=o.OrganizationID WHERE n.MemberID='{0}'", Convert.ToInt32(e.CommandArgument.ToString()))); DropDownList ddlOrg = new DropDownList(); DropDownList ddlEditProgram = new DropDownList(); DropDownList ddlManager = new DropDownList(); foreach (DataListItem li in dlEditStaffProfile.Items) { ddlOrg = (DropDownList)li.FindControl("ddlEditOrgId"); ddlEditProgram = (DropDownList)li.FindControl("ddlEditProgram"); ddlManager = (DropDownList)li.FindControl("ddlEditManagerId"); } BD.DataBindToDropDownList(ddlOrg, string.Format("SELECT OrganizationName, OrganizationID FROM EduSphere.Organizations")); BD.DataBindToDropDownList(ddlEditProgram, string.Format("SELECT ProgramTitle, ProgramID FROM EduSphere.Programs")); BD.DataBindToDropDownList(ddlManager, string.Format("SELECT MemberID, FullName FROM EduSphere.Members")); break; case "ViewEnrolmentCertificate": //PG.EnrolmentCertificate(102); string strTemplate = "~/Artifacts/Members/MembershipTemplate.pdf"; int intMemberID = Convert.ToInt32(e.CommandArgument.ToString()); PG.GeneratePdfFromPdfTemplate(strTemplate, intMemberID); break; case "TopnlProfileEditFrompnlUploadStaffDocument": pnlUploadStaffDocument.Visible = false; pnlEditStaffProfile.Visible = true; break; case "TopnlProfileEditFrompnlNeuroAcademics": pnlNeuroAcademics.Visible = false; pnlEditStaffProfile.Visible = true; break; case "ReturnToViewStaff": Response.Redirect("Admission.aspx"); break; default: break; } }
public void ManageDashboardPanels(object sender, CommandEventArgs e) { string strCmd; strCmd = e.CommandName.ToString(); switch (strCmd) { case "pnlServicesDashboard": pnlServicesDashboard.Visible = true; pnlIndicatorsDashboard.Visible = false; pnlAttendanceDashboard.Visible = false; pnlStudentAttendanceDashboard.Visible = false; pnlStudentAcademicsDashboard.Visible = false; pnlCustomerDashoard.Visible = false; pnlExpensesDashboard.Visible = false; lblDashboardAction.Text = "Service Revenue"; SetSalonVisibility(ddlSalon, ddlConsultant); break; case "pnlIndicatorsDashboard": pnlServicesDashboard.Visible = false; pnlIndicatorsDashboard.Visible = true; pnlAttendanceDashboard.Visible = false; pnlStudentAttendanceDashboard.Visible = false; pnlStudentAcademicsDashboard.Visible = false; pnlCustomerDashoard.Visible = false; pnlExpensesDashboard.Visible = false; string cmdArgument = e.CommandArgument.ToString(); DateTime dtIndicatorDate = DateTime.Now.Date; int intOrganizationID = 101; if (cmdArgument == "today") { dtIndicatorDate = DateTime.Now.Date; txtBoxIndicatorDate.Text = "dd/MM/yyyy"; BD.DataBindToDropDownList(ddlSalonSite, string.Format("SELECT OrganizationID,OrganizationName FROM EduSphere.Organizations")); } if (cmdArgument == "specificDate") { dtIndicatorDate = DateTime.ParseExact(txtBoxIndicatorDate.Text.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture); intOrganizationID = Convert.ToInt32(ddlSalonSite.SelectedValue.ToString()); } List <int> list = ShowIndicatorsDashboard(dtIndicatorDate, intOrganizationID); lblTodaysServiceBills.Text = list[0].ToString(); lblTodaysExpenseBills.Text = list[1].ToString(); lblTodaysServiceReceipts.Text = list[2].ToString(); lblMonthlyServiceBills.Text = list[3].ToString(); lblMonthlyExpenseBills.Text = list[4].ToString(); lblMonthlyServiceReceipts.Text = list[5].ToString(); //SetSalonVisibility(strRole, User.Identity.Name, ddlStoreLocation, ddlSeller); //Payment Modes string strDayServicePaymentMode = string.Format(@"SELECT SUM(CreditAmount) AS ReceivedAmount, PaymentMode AS ModeOfReceipt FROM EduSphere.MemberAccount WHERE CAST(TxDate AS DATE)=CAST('{1}' AS DATE) AND TxLocation='{2}' GROUP BY PaymentMode ORDER BY PaymentMode DESC", " ", dtIndicatorDate.ToString("MM/dd/yyyy"), intOrganizationID); BD.DataBindToGridView(gvServicePaymentMode, strDayServicePaymentMode, "NA"); //Dispaly staff Level Day Indicators for service & Product string strDayServiceIndicatorCmd = string.Format(@"SELECT SUM(DebitAmount) AS BillAmount,a.ConsultantOneID AS EmployeeID,e.FullName AS Name FROM EduSphere.MemberAccount a JOIN EduSphere.Staff e ON a.ConsultantOneID=e.EmployeeID WHERE CAST(a.TxDate AS DATE)=CAST('{1}' AS DATE) AND TxLocation='{2}' GROUP BY a.ConsultantOneID,e.FullName ORDER BY SUM(DebitAmount) DESC", " ", dtIndicatorDate.ToString("MM/dd/yyyy"), intOrganizationID); BD.DataBindToGridView(gvStaffDayServiceIndicators, strDayServiceIndicatorCmd, "NA"); //Display staff Level Month Indicators for service & products string strMonthServiceIndicatorCmd = string.Format(@"SELECT SUM(DebitAmount) AS BillAmount, a.ConsultantOneID AS EmployeeID,year(a.TxDate),month(a.TxDate), e.FullName AS Name FROM EduSphere.MemberAccount a JOIN EduSphere.Staff e ON a.ConsultantOneID=e.EmployeeID WHERE month(a.TxDate)=month('{1}') AND TxLocation='{2}' GROUP BY a.ConsultantOneID,e.FullName,year(a.TxDate),month(a.TxDate) ORDER BY SUM(DebitAmount) DESC", " ", dtIndicatorDate.ToString("MM/dd/yyyy"), intOrganizationID); BD.DataBindToGridView(gvStaffMonthServiceIndicators, strMonthServiceIndicatorCmd, "NA"); break; case "pnlAttendanceDashboard": lblDashboardAction.Text = "Staff Attendance"; pnlServicesDashboard.Visible = false; pnlIndicatorsDashboard.Visible = false; pnlAttendanceDashboard.Visible = true; pnlStudentAttendanceDashboard.Visible = false; pnlStudentAcademicsDashboard.Visible = false; pnlCustomerDashoard.Visible = false; pnlExpensesDashboard.Visible = false; BD.DataBindToDropDownList(ddlStaff, string.Format("SELECT FullName,EmployeeID FROM EduSphere.Staff WHERE EmploymentStatus='{0}'", "ACTIVE")); lblDate.Text = DateTime.Today.ToString("yyyy-MMM"); //hide staff attendace details grid while displying all staff attendance summary gvStaffAttendanceDetails.Visible = false; string strCmdMonthAttendance = string.Format("SELECT s.FullName AS Name, SUM(DaysPresentFor) AS Number FROM EduSphere.StaffAttendance a JOIN EduSphere.Staff s ON a.EmployeeID=s.EmployeeID WHERE DATEPART(MM,AttendanceDate)=DATEPART(MM,GETDATE()) AND DATEPART(YYYY,AttendanceDate)=DATEPART(YYYY,GETDATE()) GROUP BY s.FullName ORDER BY s.FullName"); BD.DataBindToGridView(gvAttendanceDashboard, strCmdMonthAttendance, "NA"); //Day Count //string strMonthAttendance = string.Format("SELECT s.FullName, DaysPresentFor, AttendanceDate, Remarks FROM EduSphere.StaffAttendance a JOIN EduSphere.Staff s ON a.EmployeeID=s.EmployeeID WHERE DATEPART(MM,AttendanceDate)=DATEPART(MM,GETDATE()) AND DATEPART(YYYY,AttendanceDate)=DATEPART(YYYY,GETDATE()) ORDER BY s.FullName, AttendanceDate ASC"); //BD.DataBindToGridView(gvMonthAttendance, strMonthAttendance, "NA"); //PIVOT Table GenerateMonthlyAttendaceReportPvt(DateTime.Today.ToString("MM/dd/yyyy")); break; case "pnlStudentAttendanceDashboard": lblDashboardAction.Text = "Student Attendance"; pnlServicesDashboard.Visible = false; pnlIndicatorsDashboard.Visible = false; pnlAttendanceDashboard.Visible = false; pnlStudentAttendanceDashboard.Visible = true; pnlStudentAcademicsDashboard.Visible = false; pnlCustomerDashoard.Visible = false; pnlExpensesDashboard.Visible = false; BD.DataBindToDropDownList(ddlAttendanceBatchFilter, string.Format("SELECT BatchCode,BatchID FROM EduSphere.ProgramBatch")); lblDate.Text = DateTime.Today.ToString("yyyy-MMM"); //PIVOT Table GenerateBatchAttendanceReportPvt(101); //testing break; case "pnlStudentAcademicsDashboard": lblDashboardAction.Text = "Student Academics"; pnlServicesDashboard.Visible = false; pnlIndicatorsDashboard.Visible = false; pnlAttendanceDashboard.Visible = false; pnlStudentAttendanceDashboard.Visible = false; pnlStudentAcademicsDashboard.Visible = true; pnlCustomerDashoard.Visible = false; pnlExpensesDashboard.Visible = false; BD.DataBindToDropDownList(ddlAcademicsBatchFilter, string.Format("SELECT BatchCode,BatchID FROM EduSphere.ProgramBatch")); //PIVOT Table GenerateBatchAcademicsReportPvt(101); //testing break; case "pnlCustomerDashboard": lblDashboardAction.Text = "Student Outstandings"; pnlServicesDashboard.Visible = false; pnlIndicatorsDashboard.Visible = false; pnlAttendanceDashboard.Visible = false; pnlStudentAttendanceDashboard.Visible = false; pnlStudentAcademicsDashboard.Visible = false; pnlCustomerDashoard.Visible = true; pnlExpensesDashboard.Visible = false; BD.DataBindToDropDownList(ddlLocation, string.Format("SELECT OrganizationName,OrganizationID FROM EduSphere.Organizations WHERE OrganizationID>={0} AND OrganizationType='{1}'", 100, "EDUCATION-CENTRE")); break; case "pnlExpensesDashboard": lblDashboardAction.Text = "Expenses"; pnlServicesDashboard.Visible = false; pnlIndicatorsDashboard.Visible = false; pnlAttendanceDashboard.Visible = false; pnlStudentAttendanceDashboard.Visible = false; pnlStudentAcademicsDashboard.Visible = false; pnlCustomerDashoard.Visible = false; pnlExpensesDashboard.Visible = true; //string spender = string.Format("SELECT FullName+'{0}'+Gender as FullName,EmployeeID FROM EduSphere.Staff", " "); //BD.DataBindToDropDownList(ddlSpender, spender); //Make all stores visible only to admin. The manager can see only his/her store SetSalonVisibility(ddlSite, ddlSpender); break; case "FromPnlServicesRevenueToNoPanel": pnlServicesDashboard.Visible = false; pnlIndicatorsDashboard.Visible = false; pnlAttendanceDashboard.Visible = false; pnlStudentAttendanceDashboard.Visible = false; pnlStudentAcademicsDashboard.Visible = false; pnlCustomerDashoard.Visible = false; pnlExpensesDashboard.Visible = false; break; default: break; } }