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) { lblStaffAction.Text = "Members"; pnlViewStaff.Visible = true; pnlAddStaff.Visible = false; pnlUploadStaffDocument.Visible = false; pnlUploadHelpDocument.Visible = false; pnlViewStaffDocuments.Visible = false; pnlEditStaffProfile.Visible = false; pnlViewStaffProfile.Visible = false; pnlAddStaff.Visible = false; //string strCmd = string.Format(@"SELECT TOP 100 org.OrganizationName as OrganizationName,MemberID,FullName,st.PhoneOne as PhoneOne,st.Email as Email // FROM EduSphere.Members m // JOIN EduSphere.Organizations o ON m.OrganizationID=o.OrganizationID // WHERE MemberID>=100 AND MembershipStatus='{0}' AND m.Email='{1}'", "ACTIVE", User.Identity.Name); //BD.DataBindToDataList(dlStaff, strCmd); //Count BD.DataBindToLabel(lblCountActive, string.Format("SELECT COUNT(MemberID) FROM EduSphere.Members WHERE MembershipStatus='{0}'", "ACTIVE")); BD.DataBindToLabel(lblCountNotActive, string.Format("SELECT COUNT(MemberID) FROM EduSphere.Members WHERE MembershipStatus='{0}'", "NOTACTIVE")); } }
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")); } }