Exemple #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                lblStaffAction.Text            = "View Staff";
                pnlViewStaff.Visible           = true;
                pnlAddStaff.Visible            = false;
                pnlUploadStaffDocument.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,EmployeeId,FullName,st.PhoneOne as PhoneOne,st.Email as Email FROM EduSphere.Staff st JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID WHERE EmployeeId>=100 AND EmploymentStatus='{0}' ORDER BY org.OrganizationName ASC", "ACTIVE");
                BD.DataBindToDataList(dlStaff, strCmd);
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                lblStaffAction.Text         = "Mark your Attendance for the Day";
                pnlViewStaff.Visible        = true;
                pnlViewStaffProfile.Visible = false;

                //Create attendatce for the day if didn't exist.
                SqlCommand cmd = new SqlCommand("spCreateAttendanceDay", BD.ConStr);
                cmd.CommandType = CommandType.StoredProcedure;
                BD.UpdateParameters(cmd);

                //Display Today Attendace Register
                DateTime AttendanceDate    = DateTime.Now;
                string   strAttendanceDate = AttendanceDate.ToString("yyyy-MM-dd");
                string   strCmd            = "";
                if (User.IsInRole("Admin"))
                {
                    strCmd = string.Format("SELECT  *,a.EmployeeId,s.FullName,s.PhoneOne,s.Email FROM EduSphere.StaffAttendance a JOIN EduSphere.Staff s ON a.EmployeeId=s.EmployeeId WHERE AttendanceDate='{0}'  ORDER BY s.FullName ASC", strAttendanceDate);
                }
                if (User.IsInRole("Manager"))
                {
                    strCmd = string.Format(@"SELECT  *,a.EmployeeId,s.FullName,s.PhoneOne,s.Email FROM EduSphere.StaffAttendance a 
                                            JOIN EduSphere.Staff s ON a.EmployeeId=s.EmployeeId 
                                            WHERE AttendanceDate='{0}' AND OrganizationID=(SELECT OrganizationId FROM EduSphere.Staff WHERE Email='{1}' )  
                                            ORDER BY s.FullName ASC", strAttendanceDate, User.Identity.Name.ToString());
                }
                if (User.IsInRole("Employee"))
                {
                    strCmd = string.Format(@"SELECT  *,a.EmployeeId,s.FullName,s.PhoneOne,s.Email FROM EduSphere.StaffAttendance a 
                                                                                                  JOIN EduSphere.Staff s ON a.EmployeeId=s.EmployeeId 
                                                      WHERE AttendanceDate='{0}' AND Email='{1}'", strAttendanceDate, User.Identity.Name.ToString());
                }

                BD.DataBindToDataList(dlStaff, strCmd);
            }
        }
Exemple #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                lblOrganizationAction.Text         = "View Organizations";
                pnlViewOrganizations.Visible       = true;
                pnlAddOrganization.Visible         = false;
                pnlEditOrganizationProfile.Visible = false;
                pnlViewOrganizationProfile.Visible = false;
                pnlOrganizationBankDetails.Visible = false;

                string strCmd = string.Format("SELECT TOP 100 * FROM EduSphere.Organizations WHERE OrganizationId>={0} ORDER BY OrganizationId DESC", 104);
                BD.DataBindToDataList(dlOrganizations, strCmd);
                //Display Count for Principle,Customer & Vendor
                lblCountCustomers.Text     = (MT.Count("spEduCentreCount")).ToString();
                lblCountCustomersHelp.Text = lblCountCustomers.Text;

                lblCountVendors.Text     = (MT.Count("spVendorsCount")).ToString();
                lblCountVendorsHelp.Text = lblCountCustomers.Text;
            }
        }
Exemple #4
0
        //Buttone Clicks on list of leads ViewDetails,Edit,ViewEditHistory
        protected void gvRoleRequests_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            string cmdName = e.CommandName.ToString();

            string[] commandArgs = new string[3];
            int      intRequestID;

            switch (cmdName)
            {
            case "ViewProfile":
                lblRoleRequestsAction.Text                 = "RoleRequests Details";
                pnlViewRoleRequests.Visible                = false;
                pnlViewRoleRequestsProfile.Visible         = true;
                pnlEditRoleRequestsProfile.Visible         = false;
                pnlRoleRequestsStatusModifications.Visible = false;
                pnlAddRoleRequests.Visible                 = false;
                if (cmdName == "ViewProfile")
                {
                    commandArgs  = e.CommandArgument.ToString().Split(';');
                    intRequestID = Convert.ToInt32(commandArgs[0].ToString());
                    string strCmd = string.Format(@"SELECT * FROM EduSphere.RoleRequests r 
                                                                JOIN EduSphere.Organizations o ON r.OrgnanizationID=o.OrganizationID
                                                                WHERE RequestID={0}", intRequestID);
                    BD.DataBindToDataList(dlRoleRequestsDetails, strCmd);
                    //Display Age
                    List <int> list = MS.GetAge(commandArgs[1].ToString(), "spGetAge");
                    RoleRequestsAgeYears.Text  = list[0].ToString();
                    RoleRequestsAgeMonths.Text = list[1].ToString();
                    RoleRequestsAgeDays.Text   = list[2].ToString();
                }
                //Play Sound

                break;

            case "DeleteRequest":
                commandArgs  = e.CommandArgument.ToString().Split(';');
                intRequestID = Convert.ToInt32(commandArgs[0].ToString());
                string     strDelCmd = string.Format("DELETE FROM EduSphere.RoleRequests WHERE RequestID={0}", intRequestID);
                SqlCommand delCmd    = new SqlCommand(strDelCmd, BD.ConStr);
                BD.UpdateParameters(delCmd);
                BD.DataBindToGridView(gvRoleRequests, string.Format(@"SELECT * FROM EduSphere.RoleRequests r 
                                                                JOIN EduSphere.Organizations o ON r.OrgnanizationID = o.OrganizationID WHERE RequestApprovalStatus='NEW'"), "NA");
                break;

            case "EditProfile":
                lblRoleRequestsAction.Text                 = "Approve Deny Access";
                pnlViewRoleRequests.Visible                = false;
                pnlViewRoleRequestsProfile.Visible         = false;
                pnlEditRoleRequestsProfile.Visible         = true;
                pnlRoleRequestsStatusModifications.Visible = false;
                pnlAddRoleRequests.Visible                 = false;
                //
                BD.DataBindToDataList(dlEditRoleRequestsProfile, string.Format(@"SELECT  * FROM EduSphere.RoleRequests r JOIN EduSphere.States p ON r.RequesterState=p.StateID
                                                                JOIN EduSphere.Organizations o ON r.OrganizationID=o.OrganizationID
                                                                WHERE RequestID='{0}'", Convert.ToInt32(e.CommandArgument.ToString())));
                //DropDownList ddlEditRequestApprovalStatus = new DropDownList();
                //DropDownList ddlEditRole = new DropDownList();

                //foreach (DataListItem li in dlEditRoleRequestsProfile.Items)
                //{
                //    ddlEditRequestApprovalStatus = (DropDownList)li.FindControl("ddlEditRequestApprovalStatus");
                //    ddlEditRole                  = (DropDownList)li.FindControl("ddlEditRole");
                //}

                break;

            case "ViewRoleRequestsStatusModifications":
                lblRoleRequestsAction.Text                 = "RoleRequests Modifications History";
                pnlViewRoleRequests.Visible                = false;
                pnlViewRoleRequestsProfile.Visible         = false;
                pnlEditRoleRequestsProfile.Visible         = true;
                pnlRoleRequestsStatusModifications.Visible = true;
                pnlAddRoleRequests.Visible                 = false;
                //Display RoleRequestsStatusModifications History
                intRequestID = Convert.ToInt32(e.CommandArgument.ToString());
                string cmdStr = string.Format(@"SELECT *,a.FullName Assigned,own.FullName AS Owner FROM EduSphere.RoleRequestsStatusModifications mod 
                                                             JOIN EduSphere.Organizations org ON mod.FranchiseeId=org.OrganizationId 
                                                             JOIN EduSphere.Staff a ON mod.AssignedEmployeeId=a.EmployeeId
                                                             JOIN EduSphere.Staff own ON mod.AssignedEmployeeId=own.EmployeeId 
                                                    WHERE RequestID={0}", intRequestID);
                BD.DataBindToGridView(gvRoleRequestsStatusModifications, cmdStr, "NA");

                break;

            default:
                break;
            }
        }
        //Buttone Clicks on list of leads ViewDetails,Edit,ViewEditHistory
        protected void gvEnquiry_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            string cmdName = e.CommandName.ToString();
            int    intEnquiryId;

            switch (cmdName)
            {
            case "ViewProfile":
                lblEnquiryAction.Text                 = "Enquiry Details";
                pnlViewEnquiry.Visible                = false;
                pnlViewEnquiryProfile.Visible         = true;
                pnlEditEnquiryProfile.Visible         = false;
                pnlEnquiryStatusModifications.Visible = false;
                pnlAddEnquiry.Visible                 = false;
                if (cmdName == "ViewProfile")
                {
                    string[] commandArgs = new string[3];
                    commandArgs  = e.CommandArgument.ToString().Split(';');
                    intEnquiryId = Convert.ToInt32(commandArgs[0].ToString());
                    string strCmd = string.Format(@"{0} WHERE EnquiryId={1}", stdEnquiry, intEnquiryId);
                    BD.DataBindToDataList(dlEnquiryDetails, strCmd);
                    //Display Age
                    List <int> list = MS.GetAge(commandArgs[1].ToString(), "spGetAge");
                    EnquiryAgeYears.Text  = list[0].ToString();
                    EnquiryAgeMonths.Text = list[1].ToString();
                    EnquiryAgeDays.Text   = list[2].ToString();
                }
                //Play Sound

                break;

            case "EditProfile":
                lblEnquiryAction.Text                 = "Update Enquiry Status";
                pnlViewEnquiry.Visible                = false;
                pnlViewEnquiryProfile.Visible         = false;
                pnlEditEnquiryProfile.Visible         = true;
                pnlEnquiryStatusModifications.Visible = false;
                pnlAddEnquiry.Visible                 = false;
                //
                BD.DataBindToDataList(dlEditEnquiryProfile, string.Format(@"SELECT  * ,f.OrganizationName as Centre,a.FullName AS Assigned,o.FullName AS Owner 
                                                                               FROM EduSphere.Enquiries e JOIN EduSphere.Staff a ON e.AssignedEmployeeId=a.EmployeeId
                                                                                                          JOIN EduSphere.Organizations f ON e.FranchiseeId=f.OrganizationId 
                                                                                                          JOIN EduSphere.Staff o ON e.OwnerEmployeeId=o.EmployeeId WHERE EnquiryId='{0}'", Convert.ToInt32(e.CommandArgument.ToString())));
                DropDownList ddlEditOwnerEmployeeId      = new DropDownList();
                DropDownList ddlEditAssignedEmployeeId   = new DropDownList();
                DropDownList ddlEditFranchiseeId         = new DropDownList();
                DropDownList ddlEditModifiedByEmployeeId = new DropDownList();
                foreach (DataListItem li in dlEditEnquiryProfile.Items)
                {
                    ddlEditOwnerEmployeeId      = (DropDownList)li.FindControl("ddlEditOwnerEmployeeId");
                    ddlEditAssignedEmployeeId   = (DropDownList)li.FindControl("ddlEditAssignedEmployeeId");
                    ddlEditFranchiseeId         = (DropDownList)li.FindControl("ddlEditFranchiseeId");
                    ddlEditModifiedByEmployeeId = (DropDownList)li.FindControl("ddlEditModifiedByEmployeeId");
                }
                BD.DataBindToDropDownList(ddlEditOwnerEmployeeId, string.Format("SELECT FullName, EmployeeId FROM EduSphere.Staff"));

                BD.DataBindToDropDownList(ddlEditAssignedEmployeeId, string.Format("SELECT EmployeeId, FullName FROM EduSphere.Staff"));
                BD.DataBindToDropDownList(ddlEditFranchiseeId, string.Format("SELECT OrganizationId,OrganizationName FROM EduSphere.Organizations WHERE OrganizationType='{0}'", "FRANCHISEE"));
                BD.DataBindToDropDownList(ddlEditModifiedByEmployeeId, string.Format("SELECT FullName, EmployeeId FROM EduSphere.Staff"));
                break;

            case "ViewEnquiryStatusModifications":
                lblEnquiryAction.Text                 = "Enquiry Modifications History";
                pnlViewEnquiry.Visible                = false;
                pnlViewEnquiryProfile.Visible         = false;
                pnlEditEnquiryProfile.Visible         = true;
                pnlEnquiryStatusModifications.Visible = true;
                pnlAddEnquiry.Visible                 = false;
                //Display EnquiryStatusModifications History
                intEnquiryId = Convert.ToInt32(e.CommandArgument.ToString());
                string cmdStr = string.Format(@"SELECT *,a.FullName Assigned,own.FullName AS Owner FROM EduSphere.EnquiryStatusModifications mod 
                                                             JOIN EduSphere.Organizations org ON mod.FranchiseeId=org.OrganizationId 
                                                             JOIN EduSphere.Staff a ON mod.AssignedEmployeeId=a.EmployeeId
                                                             JOIN EduSphere.Staff own ON mod.AssignedEmployeeId=own.EmployeeId 
                                                    WHERE EnquiryId={0}", intEnquiryId);
                BD.DataBindToGridView(gvEnquiryStatusModifications, cmdStr, "NA");

                break;

            default:
                break;
            }
        }
Exemple #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                lblStaffAction.Text            = "View Staff";
                pnlViewStaff.Visible           = true;
                pnlAddStaff.Visible            = false;
                pnlUploadStaffDocument.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 st 
                                                JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID 
                                                WHERE MemberID>=100 AND MembershipStatus='{0}' AND st.Email='{1}'", "ACTIVE", User.Identity.Name.ToString());
                BD.DataBindToDataList(dlStaff, strCmd);
            }
        }
Exemple #7
0
        //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;
                pnlUploadHelpDocument.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;
                pnlUploadHelpDocument.Visible  = false;
                pnlViewStaffDocuments.Visible  = false;
                pnlEditStaffProfile.Visible    = false;
                pnlViewStaffProfile.Visible    = false;
                pnlNeuroAcademics.Visible      = false;
                pnlNeuroPublications.Visible   = false;
                lblEmployeeId.Text             = e.CommandArgument.ToString();
                break;

            case "UploadHelpDocument":
                lblStaffAction.Text            = "Upload Staff Document";
                pnlViewStaff.Visible           = false;
                pnlAddStaff.Visible            = false;
                pnlUploadStaffDocument.Visible = false;
                pnlUploadHelpDocument.Visible  = true;
                pnlViewStaffDocuments.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;
                pnlUploadHelpDocument.Visible  = false;
                pnlViewStaffDocuments.Visible  = true;
                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 "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;
                pnlUploadHelpDocument.Visible  = false;
                pnlViewStaffDocuments.Visible  = false;
                pnlEditStaffProfile.Visible    = false;
                pnlViewStaffProfile.Visible    = false;
                pnlNeuroAcademics.Visible      = true;

                break;

            case "PublicationDetails":
                string pubQuery = string.Format("SELECT * FROM EduSphere.MemberPublications 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;
                pnlUploadHelpDocument.Visible  = false;
                pnlViewStaffDocuments.Visible  = false;
                pnlEditStaffProfile.Visible    = false;
                pnlViewStaffProfile.Visible    = false;
                pnlNeuroAcademics.Visible      = false;
                pnlNeuroPublications.Visible   = true;
                pnlNeuroAcademics.Visible      = false;
                pnlNeuroPublications.Visible   = true;
                break;

            case "SearchEnquiry":
            case "FilterStaff":
                lblStaffAction.Text            = "Search Member";
                pnlViewStaff.Visible           = true;
                pnlAddStaff.Visible            = false;
                pnlUploadStaffDocument.Visible = false;
                pnlUploadHelpDocument.Visible  = false;
                pnlViewStaffDocuments.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();
                    string strMemType          = ddlMembershipType.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());
                    //if(strMemType=="STUDENT")
                    strCmd = string.Format(@"SELECT OrganizationName,MemberID,FullName,st.PhoneOne,st.Email,st.MembershipStatus,st.AadhaarNumber,st.PanNumber,st.AcademicExamStatus 
                                                 FROM EduSphere.Members st 
                                                 JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID 
                                                  WHERE MembershipStatus='{0}' AND MembershipType='{1}' 
                                                  ORDER BY st.MemberID DESC", strEmploymentStatus, strMemType);
                    //else
                    //    strCmd = string.Format(@"SELECT OrganizationName,MemberID,FullName,st.PhoneOne,st.Email,st.MembershipStatus,st.AadhaarNumber,st.PanNumber,st.AcademicExamStatus
                    //                         FROM EduSphere.Members st
                    //                         JOIN EduSphere.Organizations org ON st.OrganizationID=org.OrganizationID
                    //                          WHERE MembershipStatus='{0}' AND MembershipType!='{1}' OR MembershipType is null
                    //                          ORDER BY st.MemberID DESC", strEmploymentStatus, "STUDENT");
                }
                if (cmdName == "SearchEnquiry")
                {
                    string strSerachParam = txtBoxSearchStaff.Text;
                    strCmd = string.Format("SELECT OrganizationName,MemberID,FullName,st.PhoneOne,st.Email,st.MembershipStatus,st.AadhaarNumber,st.PanNumber,st.AcademicExamStatus 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            = "View Profile";
                pnlViewStaff.Visible           = false;
                pnlAddStaff.Visible            = false;
                pnlUploadStaffDocument.Visible = false;
                pnlUploadHelpDocument.Visible  = false;
                pnlViewStaffDocuments.Visible  = true; //display uploaded documents
                pnlViewStaffProfile.Visible    = true; //display profile
                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
                                                 WHERE MemberID='{0}'", intEmployeeId);
                    BD.DataBindToDataList(dlStaffDetails, strCmd);
                    //Display Addresses
                    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 Member Details";
                lblNeutherapistID.Text         = e.CommandArgument.ToString();
                pnlViewStaff.Visible           = false;
                pnlAddStaff.Visible            = false;
                pnlUploadStaffDocument.Visible = false;
                pnlUploadHelpDocument.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 WHERE MemberID='{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 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("Members.aspx");
                break;

            default:
                break;
            }
        }