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