public bool SaveUserRole(clsEALUser objclsUser, string userRole, string StrUserADID)
{
objclsDALUsers = new clsDALUsers();
bool bln = objclsDALUsers.SaveUserRole(objclsUser, userRole, StrUserADID);
return(bln);
}
public DataSet GetApproverByApplication(string[] role, clsEALUser objclsEALLoggedInUser, string strCurrentQuarter)
{
objclsDALApplication = new clsDALApplication();
DataSet ds = objclsDALApplication.GetApproverByApplication(role, objclsEALLoggedInUser, strCurrentQuarter);
return(ds);
}
protected void Page_Load(object sender, EventArgs e)
{
Session[clsEALSession.ValuePath] = "Reports";
Session[clsEALSession.Display] = "All Reports";
GetLoggedInUserName();
clsBALCommon objclsBALCommon = new clsBALCommon();
objclsEALLoggedInUser = objclsBALCommon.FetchUserDetailsFromAD(LoggedInUser);
strUserName = objclsEALLoggedInUser.StrUserName;
strUserSID = objclsEALLoggedInUser.StrUserSID;
Session[clsEALSession.UserSID] = strUserSID;
Session[clsEALSession.CurrentUser] = strUserName;
lblError.Text = "";
lblSuccess.Text = "";
GetCurrentUserRole();
if (!IsPostBack)
{
try
{
if (role != null)
{
if (role.Contains <string>(clsEALRoles.ComplianceAdmin) || role.Contains <string>(clsEALRoles.ComplianceAuditor) || role.Contains <string>(clsEALRoles.ComplianceTester) || role.Contains <string>(clsEALRoles.ControlOwner) || role.Contains <string>(clsEALRoles.GlobalApprover) || role.Contains <string>(clsEALRoles.Approver))
{
lblPeriod.Visible = true;
ddlQuarter.Visible = true;
lblMsg.Visible = false;
QuarterDropDown();
//if (ddlQuarter.SelectedIndex != 0)
//{
// BindAppGrid();
//}
//else
//{
// lblError.Text = "Please select quarter.";
//}
}
else
{
strQuarterSelected = "";
Session[clsEALSession.SelectedQuarter] = strQuarterSelected;
BindAppGrid();
}
}
}
catch (NullReferenceException)
{
Response.Redirect("wfrmErrorPage.aspx", true);
}
catch (Exception ex)
{
HttpContext Context = HttpContext.Current;
LogException objLogException = new LogException();
objLogException.LogErrorInDataBase(ex, Context);
Response.Redirect("wfrmErrorPage.aspx", true);
}
}
}
public DataSet GetAllApproversByApplication(string[] role, clsEALUser objclsEALUserApp)
{
objclsDALApplication = new clsDALApplication();
DataSet ds = objclsDALApplication.GetAllApproversByApplication(role, objclsEALUserApp);
return(ds);
}
public bool SaveApplicationDetails(string role, clsEALUser objclsAppOwner, string AppName, string strInitiatives, bool admin, bool MultipleApprovals, bool ExcludeGA, bool UnlockApp, string StrUserADID, string procycle, string quarters)
{
objclsDALApplication = new clsDALApplication();
bool bln = objclsDALApplication.SaveApplicationDetails(role, objclsAppOwner, AppName, strInitiatives, admin, MultipleApprovals, ExcludeGA, UnlockApp, StrUserADID, procycle, quarters);
return(bln);
}
public bool SaveApplicationStatus(clsEALUser objclsAppOwner, int AppId, string strQuarter)
{
objclsDALApplication = new clsDALApplication();
bool bln = objclsDALApplication.SaveApplicationStatus(objclsAppOwner, AppId, strQuarter);
return(bln);
}
public void SignOffPSIUsers(string uName, string strStatus_PSI, clsEALUser objclsEALApprover, string strQuarter, string strUserID)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffPSIUsers(uName, strStatus_PSI, objclsEALApprover, strQuarter, strUserID);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByGlobal_SecGrp(string uID, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, string strServer)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffUsersByGlobal_SecGrp(uID, signoffstatus, objclsEALApprover, Quarter, strServer);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByGlobal_Linux(string uID, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, string strServer, string loginstatus, string strgroup)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffUsersByGlobal_Linux(uID, signoffstatus, objclsEALApprover, Quarter, strServer, loginstatus, strgroup);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByGlobal_SQL(string uName, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, bool IsAdminUpdate, bool IsAdmin, string strDBType, string strRole, string strDB, string strServer)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffUsersByGlobal_SQL(uName, signoffstatus, objclsEALApprover, Quarter, IsAdminUpdate, IsAdmin, strDBType, strRole, strDB, strServer);
}
catch (Exception ex)
{
throw ex;
}
}
public void SubmitReport(Int32 ReportID, clsEALUser objApprover)
{
try
{
objclsDALReports = new clsDALReports();
objclsDALReports.SubmitReport(ReportID, objApprover);
}
catch (Exception ex)
{
throw ex;
}
}
public void SubmitDBReport(Int32 ReportID, clsEALUser objApprover, string quarter, string strrepType)
{
try
{
objclsDALReports = new clsDALReports();
objclsDALReports.SubmitDBReport(ReportID, objApprover, quarter, strrepType);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateCOCompletionStatus(string role, clsEALUser objclsEALApprover, Int32 ApplicationiD, string Quarter, bool status, bool COSignOff)
{
try
{
objclsDALApplication = new clsDALApplication();
objclsDALApplication.updateCOCompletionStatus(role, objclsEALApprover, ApplicationiD, Quarter, status, COSignOff);
}
catch (Exception ex)
{
throw ex;
}
}
public bool GetApplicationCompletionStatus(string role, clsEALUser objclsEALUser, string Quarter, Int32 ApplicationID)
{
try
{
objclsDALApplication = new clsDALApplication();
bool status = objclsDALApplication.GetApplicationCompletionStatus(role, objclsEALUser, Quarter, ApplicationID);
return(status);
}
catch (Exception ex)
{
throw ex;
}
}
public string GetUserRoleBYApplication(clsEALUser objclsEALUser, int ApplicationID)
{
try
{
objclsDALUsers = new clsDALUsers();
string role = objclsDALUsers.GetUserRoleByApplication(objclsEALUser, ApplicationID);
return(role);
}
catch (Exception ex)
{
throw ex;
}
}
protected void RestrictFilters()
{
string[] role = Session[clsEALSession.UserRole] as string[];
userRole = role[0];
if (userRole != "Compliance Administrator")
{
var userDetails = Session[clsEALSession.CurrentUser];
clsEALUser objDet = userDetails as clsEALUser;
userName = objDet.StrUserName;
}
lblApprover.Visible = false;
ddlApprover.Visible = false;
}
protected void gvRole_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
lblError.Text = "";
lblSuccess.Text = "";
try
{
Label lblUserADID = (Label)gvRole.Rows[e.RowIndex].FindControl("lblUserADID");
string strUsersADID = lblUserADID.Text.ToString();
DropDownList ddlGridRole = (DropDownList)gvRole.Rows[e.RowIndex].FindControl("ddlGridRole");
clsEALUser objclsEALuser = new clsEALUser();
objclsBALCommon = new clsBALCommon();
objclsEALuser = objclsBALCommon.FetchUserDetailsFromAD(strUsersADID);
string strUserRole = ddlGridRole.SelectedItem.Value;
if (objclsEALuser != null)
{
if (ddlGridRole.SelectedIndex != 0)
{
objclsBALUsers = new clsBALUsers();
objclsBALUsers.UpdateUser(objclsEALuser, strUserRole, objclsEALLoggedInUser.StrUserADID);
lblSuccess.Text = "User's role updated successfully.";
gvRole.EditIndex = -1;
PopulateGrid();
if (ViewState["SortExpression"] != null && ViewState["sortDirection"] != null)
{
SortGridView(ViewState["SortExpression"].ToString(), ViewState["sortDirection"].ToString());
}
}
else
{
lblError.Text = "select role for user.";
}
}
else
{
lblError.Text = "User Not Found.";
}
}
catch (NullReferenceException)
{
Response.Redirect("wfrmErrorPage.aspx", true);
}
catch (Exception ex)
{
HttpContext context = HttpContext.Current;
LogException objclsLogException = new LogException();
objclsLogException.LogErrorInDataBase(ex, context);
Response.Redirect("wfrmErrorPage.aspx", true);
}
}
protected void gvApplications_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
bool CompletionStatus = false;
Label lblSatus = (Label)e.Row.FindControl("lblStatus");
Label lblAppId = (Label)e.Row.FindControl("lblAppID");
String selectedQuarter = (ddlQuarter.SelectedIndex.Equals(0)) ? String.Empty : ddlQuarter.SelectedItem.Text.Trim();
Label lblControlOwner1 = (Label)e.Row.FindControl("lblControlOwner");
//lblSatus.Text = FetchApplicationStatus(role, selectedQuarter, Convert.ToInt32(lblAppId.Text));
clsBALApplication objclsBALApplication = new clsBALApplication();
clsEALUser objController = new clsEALUser();
//objController = objclsBALCommon.FetchUserDetailsFromAD(lblControlOwner1.Text.ToString());
clsBALCommon objclsBALCommon1 = new clsBALCommon();
DataSet dsCO = objclsBALCommon1.GetAppControlOwnerInfo(Convert.ToInt32(lblAppId.Text));
if (dsCO != null)
{
if (dsCO.Tables[0].Rows.Count > 0)
{
objController = objclsBALCommon1.FetchUserDetailsFromAD(dsCO.Tables[0].Rows[0][5].ToString());
if (objController != null)
{
if (role.Contains <string>(clsEALRoles.ComplianceAdmin))
{
CompletionStatus = objclsBALApplication.GetApplicationCompletionStatus(clsEALRoles.ComplianceAdmin, objController, selectedQuarter, Convert.ToInt32(lblAppId.Text));
}
else
{
CompletionStatus = objclsBALApplication.GetApplicationCompletionStatus(clsEALRoles.ControlOwner, objController, selectedQuarter, Convert.ToInt32(lblAppId.Text));
}
}
if (CompletionStatus)
{
lblSatus.Text = "Completed";
}
else
{
lblSatus.Text = "Pending";
}
}
}
if (lblSatus.Text == "Status")
{
lblSatus.Text = "Pending";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
GetLoggedInUserName();
clsBALCommon objclsBALCommon = new clsBALCommon();
objclsEALLoggedInUser = objclsBALCommon.FetchUserDetailsFromAD(LoggedInUser);
Session[clsEALSession.CurrentUser] = objclsEALLoggedInUser;
strUserName = objclsEALLoggedInUser.StrUserName;
strUserSID = objclsEALLoggedInUser.StrUserSID;
GetCurrentUserRole();
if (!IsPostBack)
{
PopulateMenu();
}
}
protected void PopuateApplications()
{
gvApplication1.AllowPaging = true;
objclsBALApplication = new clsBALApplication();
if (Session[clsEALSession.UserRole] != null)
{
role = (string[])Session[clsEALSession.UserRole];
}
if (role.Contains <string>(clsEALRoles.ComplianceTester) || role.Contains <string>(clsEALRoles.ComplianceAdmin))
{
objclsEALLoggedInUser = (clsEALUser)(Session[clsEALSession.CurrentUser]);
ds = objclsBALApplication.GetAllApproversByApplication(role, objclsEALLoggedInUser);
gvApplication1.DataSource = ds;
gvApplication1.DataBind();
Session[clsEALSession.Applications] = ds;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session[clsEALSession.ValuePath] = "Home";
GetLoggedInUserName();
clsBALCommon objclsBALCommon = new clsBALCommon();
objclsEALLoggedInUser = objclsBALCommon.FetchUserDetailsFromAD(LoggedInUser);
strUserName = objclsEALLoggedInUser.StrUserName;
strUserSID = objclsEALLoggedInUser.StrUserSID;
Session[clsEALSession.CurrentUser] = strUserName;
btnSave.Visible = false;
GetCurrentUserRole();
if (!IsPostBack)
{
AdminHomeFun();
GetHomePageText();
}
}
private void GetLoggedInuser()
{
LoggedInUser = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["ADIDTemp"]);
if (LoggedInUser != null)
{
if (LoggedInUser.Length < 1)
{
LoggedInUser = HttpContext.Current.User.Identity.Name;
}
}
else
{
LoggedInUser = HttpContext.Current.User.Identity.Name;
}
clsBALCommon objclsBALCommon = new clsBALCommon();
objclsEALLoggedInUser = objclsBALCommon.FetchUserDetailsFromAD(LoggedInUser);
Session[clsEALSession.CurrentUser] = objclsEALLoggedInUser;
}
private bool CheckUserRoles(clsEALUser objclsEALUser)
{
objclsBALUsers = new clsBALUsers();
string[] userRole = null;
userRole = objclsBALUsers.GetCurrentUserRole(objclsEALUser);
//Session[clsEALSession.UserRole] = userRole;
bool flag = true;
//string strRole = "";
//for(int i=0;i<userRole.Length ;i++)
//{
// strRole = userRole[i];
//}
if (userRole != null)
{
if (!userRole.Contains <string>(clsEALRoles.ComplianceAdmin) && !userRole.Contains <string>(clsEALRoles.ComplianceAuditor) && !userRole.Contains <string>(clsEALRoles.ComplianceTester) && !userRole.Contains <string>(clsEALRoles.GlobalApprover))
{
if (!userRole.Contains <string>(clsEALRoles.ControlOwner) && !userRole.Contains <string>(clsEALRoles.Approver))
{
flag = false;//can assign role
}
else
{
flag = true;//cant assign role
lblError.Text = "User is either Approver or Control Owner for some applications.";
}
}
else
{
flag = true;//cant assign role
lblError.Text = "User has already been assigned a role.";
}
}
else
{
flag = false;//can assign role
}
return(flag);
}
protected void gvRole_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
lblError.Text = "";
lblSuccess.Text = "";
gvRole.EditIndex = -1;
try
{
Label lblUserADID = (Label)gvRole.Rows[e.RowIndex].FindControl("lblUserADID");
Label lblUserName = (Label)gvRole.Rows[e.RowIndex].FindControl("lblUserName");
Label lblUserID = (Label)gvRole.Rows[e.RowIndex].FindControl("lblUserID");
string strUserADID = lblUserADID.Text.ToString();
objclsBALCommon = new clsBALCommon();
clsEALUser objclsEALUser = new clsEALUser();
objclsEALUser = objclsBALCommon.FetchUserDetailsFromAD(strUserADID);
if (objclsEALUser != null)
{
SortGridViewOnEditDelete();
DeleteUserRole(objclsEALUser);
//objclsBALUsers.DeleteUser(objclsEALUser);
lblSuccess.Text = "User role deleted successfully.";
PopulateGrid();
}
else
{
lblError.Text = "User Not Found.";
}
}
catch (NullReferenceException)
{
Response.Redirect("wfrmErrorPage.aspx", true);
}
catch (Exception ex)
{
HttpContext context = HttpContext.Current;
LogException objclsLogException = new LogException();
objclsLogException.LogErrorInDataBase(ex, context);
Response.Redirect("wfrmErrorPage.aspx", true);
}
}
public void deleteUserNotExisting()
{
objclsBALUsers = new clsBALUsers();
DataSet ds = objclsBALUsers.GetUserDetails();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string strUSERADID = ds.Tables[0].Rows[i][4].ToString();
clsEALUser objclsEALUser = new clsEALUser();
clsBALCommon objclsBALCommon = new clsBALCommon();
objclsEALUser = objclsBALCommon.FetchUserDetailsFromAD(strUSERADID);
if (objclsEALUser == null)
{
objclsBALUsers.DeleteUserFromDb(strUSERADID);
}
}
}
}
}
public void BindAppGrid()
{
objclsBALUsers = new clsBALUsers();
//role = objclsBALUsers.GetCurrentUserRole(objclsEALLoggedInUser);
Session[clsEALSession.UserRole] = role;
clsEALUser objclsEALUser = new clsEALUser();
DataSet ds = FetchApplication(strUserSID, role, strQuarterSelected);
if (ds != null)
{
if (ds.Tables.Count >= 1)
{
gvApplications.DataSource = ds.Tables[0];
gvApplications.DataBind();
Session[clsEALSession.Applications] = ds;
}
}
else
{
lblError.Text = "No application found.";
}
}
public bool CheckIfApplicationExistsForUpdate(string AppNm, string Initiatives, clsEALUser objControlOwner)
{
objclsDALApplication = new clsDALApplication();
bool bln = objclsDALApplication.CheckIfApplicationExistsForUpdate(AppNm, Initiatives, objControlOwner);
return(bln);
}
public bool UpdateAppDetails(string strRole, int Appid, string AppNm, string Initiative, clsEALUser objControlOwner, bool Admin, bool MultipleApprovals, bool flagExclude, bool flagUnlockApp, string Proccycle, string quarter)
{
objclsDALApplication = new clsDALApplication();
bool bln = objclsDALApplication.UpdateApplicationDetails(strRole, Appid, AppNm, Initiative, objControlOwner, Admin, MultipleApprovals, flagExclude, flagUnlockApp, Proccycle, quarter);
return(bln);
}
public bool UpdateApplicationDetails(string AppID, string AppName, string Initiative, clsEALUser objControlOwner)
{
return(true);
}
public bool GetAppCompletionStatus(clsEALUser objClsEALUser, string Quarter)
{
return(true);
}
