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