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