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); } }
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; } }
//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; } }
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); } }
//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; } }