//public void DeleteServer(int ServerID)
//{
// objclsBALApplication = new clsBALApplication();
// objclsBALApplication.DeleteServer(ServerID);
// lblSuccess.Text = "Server deleted successfully.";
//}
public void DeleteDBServer(int ServerID)
{
objclsBALApplication = new clsBALApplication();
objclsBALApplication.DeleteServerDB(ServerID);
lblSuccess.Text = "Server deleted successfully.";
}
//public bool SaveApplicationMapping(int AppID, string Database, int serverid)
//{
// clsBALApplication objclsBALApplication = new clsBALApplication();
// bool bln = objclsBALApplication.SaveDBApplicationMapping(AppID, Database, serverid);
// return bln;
//}
public bool SaveDBApplicationMapping(int AppID, string Database, int serverid)
{
clsBALApplication objclsBALApplication = new clsBALApplication();
bool bln = objclsBALApplication.SaveDBApplicationMapping(AppID, Database, serverid);
return(bln);
}
public bool CheckIfMappingexists(int AppID, int databaseID)
{
objclsBALApplication = new clsBALApplication();
bool bln = objclsBALApplication.CheckIfMappingExists(AppID, databaseID);
return(bln);
}
public bool CheckIFDBServerExists1(string strServerName, int servertypeID)
{
objclsBALApplication = new clsBALApplication();
bool bln = objclsBALApplication.CheckIfDBServerExists1(strServerName, servertypeID);
return(bln);
}
public bool CheckIFServerExists(string strServerName)
{
objclsBALApplication = new clsBALApplication();
bool bln = objclsBALApplication.CheckIfServerExists(strServerName);
return(bln);
}
public bool SaveApplicationMapping(int AppID, int ShareID)
{
clsBALApplication objclsBALApplication = new clsBALApplication();
// bool bln = objclsBALApplication.SaveApplicationMapping(AppID, ShareID);
return(true);
}
//protected void gvServer_RowUpdating(object sender, GridViewUpdateEventArgs e)
//{
// try
// {
// Label lblServerID = (Label)gvServer.Rows[e.RowIndex].FindControl("lblServerID");
// int ServerID = Convert.ToInt16(lblServerID.Text.ToString());
// TextBox txtServerName = (TextBox)gvServer.Rows[e.RowIndex].FindControl("txtServerName");
// string strServerName = txtServerName.Text.ToString();
// if (strServerName != "")
// {
// bool flag = CheckIFDBServerExists(strServerName);
// if (flag == false)
// {
// objclsBALApplication = new clsBALApplication();
// objclsBALApplication.UpdateDBServer(ServerID, strServerName);
// gvServer.EditIndex = -1;
// PopulateGrid();
// if (ViewState["SortExpression"] != null && ViewState["sortDirection"] != null)
// {
// SortGridView(ViewState["SortExpression"].ToString(), ViewState["sortDirection"].ToString());
// }
// lblSuccess.Text = "Database server updated successfully.";
// }
// else
// {
// if (Session["serverName"].ToString() == strServerName)
// {
// lblError.Text = "There is no change in server name.";
// // gvServer.EditIndex = -1;
// }
// else
// {
// lblError.Text = "Database server already exists.";
// // gvServer.EditIndex = -1;
// }
// }
// }
// else
// {
// lblError.Text = "Please fill database server name.";
// }
// }
// 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 gvServer_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
Label lblServerID = (Label)gvServer.Rows[e.RowIndex].FindControl("lblServerID");
int ServerID = Convert.ToInt16(lblServerID.Text.ToString());
TextBox txtServerName = (TextBox)gvServer.Rows[e.RowIndex].FindControl("txtServerName");
string strServerName = txtServerName.Text.ToString();
DropDownList ddlDBServerType = (DropDownList)gvServer.Rows[e.RowIndex].FindControl("ddlGridServerType");
if (ddlDBServerType.SelectedValue.ToString().Trim() != "0")
{
int ServerType_ID = int.Parse(ddlDBServerType.SelectedValue.ToString());
if (strServerName != "")
{
//bool flag = CheckIFDBServerExists(strServerName);
bool flag = false;
if (flag == false)
{
objclsBALApplication = new clsBALApplication();
objclsBALApplication.UpdateDBServer(ServerID, strServerName, ServerType_ID);
gvServer.EditIndex = -1;
PopulateGrid();
if (ViewState["SortExpression"] != null && ViewState["sortDirection"] != null)
{
SortGridView(ViewState["SortExpression"].ToString(), ViewState["sortDirection"].ToString());
}
lblSuccess.Text = "Database server updated successfully.";
}
else
{
if (Session["serverName"].ToString() == strServerName)
{
lblError.Text = "There is no change in server name.";
// gvServer.EditIndex = -1;
}
else
{
lblError.Text = "Database server already exists.";
// gvServer.EditIndex = -1;
}
}
}
else
{
lblError.Text = "Please fill database server name.";
}
}
}
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 PopulateGrid()
{
objclsBALApplication = new clsBALApplication();
DataSet ds = objclsBALApplication.GetAppShareMapping();
gvAppShare.DataSource = ds;
gvAppShare.DataBind();
Session[clsEALSession.Applications] = ds;
}
public void PopulateServerType()
{
objclsBALApplication = new clsBALApplication();
DataSet ds = objclsBALApplication.GetServerTypes();
ddlDBServerType.DataSource = ds;
ddlDBServerType.DataTextField = "ServerType";
ddlDBServerType.DataValueField = "ServerTypeID";
ddlDBServerType.DataBind();
ddlDBServerType.Items.Insert(0, new ListItem("-- Select --", "0"));
}
public void PopulateAppDropDown(DropDownList ddlGridAppName)
{
objclsBALApplication = new clsBALApplication();
DataSet ds = objclsBALApplication.GetAllApplications();
ddlGridAppName.DataSource = ds;
ddlGridAppName.DataTextField = "ApplicationName";
ddlGridAppName.DataValueField = "ApplicationID";
ddlGridAppName.DataBind();
ddlGridAppName.Items.Insert(0, new ListItem("-- Select --", "0"));
}
protected DataSet FetchApplication(string strUserSid, string[] strRole, string strQaurter)
{
DataSet ds = null;
clsBALApplication objclsBALApplication = new clsBALApplication();
ds = objclsBALApplication.GetAllApplicationList(strUserSid, strRole, strQaurter);
return(ds);
}
public void PopulateServerDropDown(DropDownList ddlGridSereverName)
{
objclsBALApplication = new clsBALApplication();
DataSet ds = objclsBALApplication.GetDBServerLists();
ddlGridSereverName.DataSource = ds;
ddlGridSereverName.DataTextField = "ServerName";
ddlGridSereverName.DataValueField = "ServerID";
ddlGridSereverName.DataBind();
ddlGridSereverName.Items.Insert(0, new ListItem("-- Select --", "0"));
}
public void PopulateServerType(DropDownList ddlGridServerType)
{
objclsBALApplication = new clsBALApplication();
DataSet ds1 = new DataSet();
ds1 = objclsBALApplication.GetDBServerTypes();
ddlGridServerType.DataSource = ds1;
ddlGridServerType.DataTextField = "servertype";
ddlGridServerType.DataValueField = "servertypeid";
ddlGridServerType.DataBind();
ddlGridServerType.Items.Insert(0, new ListItem("-- Select --", "0"));
}
public void PopulateShareDropDown()
{
objclsBALApplication = new clsBALApplication();
DataSet ds = new DataSet();
ds = objclsBALApplication.GetAllShares();
ddlShare.DataSource = ds;
ddlShare.DataTextField = "ShareName";
ddlShare.DataValueField = "ShareID";
ddlShare.DataBind();
ddlShare.Items.Insert(0, new ListItem("-- Select --", "0"));
}
public void PopulateGrid()
{
objclsBALApplication = new clsBALApplication();
DataSet ds = objclsBALApplication.GetServerLists();
gvServer.DataSource = ds;
gvServer.DataBind();
Session[clsEALSession.Servers] = ds;
if (ViewState["SortExpression"] != null && ViewState["sortDirection"] != null)
{
SortGridView(ViewState["SortExpression"].ToString(), ViewState["sortDirection"].ToString());
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
lblError.Text = "";
lblSuccess.Text = "";
try
{
if (txtServer.Text.ToString().Trim() != "")
{
objclsBALApplication = new clsBALApplication();
string strServerName = txtServer.Text.ToString();
int servertypeID = Convert.ToInt32(ddlDBServerType.SelectedValue);
bool flag = CheckIFDBServerExists(strServerName, servertypeID);
if (flag == true)
{
bool flag1 = CheckIFDBServerExists1(strServerName, servertypeID);
if (flag1 == true)
{
bool bln = objclsBALApplication.UpdateDBServerStatus(strServerName, servertypeID);
lblError.Text = "Database server saved successfully";
PopulateGrid();
}
else
{
lblError.Text = "Database server already exist";
}
}
else
{
bool bln = objclsBALApplication.SaveDBServer(strServerName, servertypeID);
lblSuccess.Text = "Database server saved successfully";
txtServer.Text = "";
PopulateGrid();
}
}
else
{
lblError.Text = "Please fill server name.";
}
}
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";
}
}
}
public bool DeleteInitiave(int initiative)
{
objclsBALApplication = new clsBALApplication();
bool flag = objclsBALApplication.DeleteInitiative(initiative);
if (flag == true)
{
lblError.Text = "Initiative is associated with applications.";
}
else
{
lblSuccess.Text = "Initiative deleted successfully.";
}
return(flag);
}
public bool DeleteServer(int ServerID)
{
objclsBALApplication = new clsBALApplication();
bool flag = objclsBALApplication.DeleteServer(ServerID, objclsEALLoggedInUser.StrUserADID);
if (flag == true)
{
lblError.Text = "Server is associated with share.";
}
else
{
lblSuccess.Text = "Server deleted successfully.";
}
return(flag);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
lblError.Text = "";
lblSuccess.Text = "";
try
{
if (txtIntitiative.Text.ToString().Trim() != "")
{
objclsBALApplication = new clsBALApplication();
string strInitiativeNm = txtIntitiative.Text.ToString();
bool blnUpdate = false;
bool blnVisible = false;
if (chkUpdate.Checked)
{
blnUpdate = true;
}
if (chkVisible.Checked)
{
blnVisible = true;
}
bool blnExists = objclsBALApplication.SaveInitiative(strInitiativeNm, blnUpdate, blnVisible);
if (!blnExists)
{
lblSuccess.Text = "Initiative saved successfully.";
PopulateGrid();
}
else
{
lblError.Text = "Initiatives already exists.";
}
}
else
{
lblError.Text = "Please fill Initiative Name.";
}
}
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 PopulateGrid()
{
txtIntitiative.Text = "";
chkUpdate.Checked = false;
chkVisible.Checked = false;
objclsBALApplication = new clsBALApplication();
DataTable dt = objclsBALApplication.GetInitiativeDetails();
gvInitiative.DataSource = dt;
gvInitiative.DataBind();
Session[clsEALSession.Initiatives] = dt;
if (ViewState["SortExpression"] != null && ViewState["sortDirection"] != null)
{
SortGridView(ViewState["SortExpression"].ToString(), ViewState["sortDirection"].ToString());
}
}
public bool UpdateAppMapping(int Appid, int Shareid, int RowID)
{
objclsBALApplication = new clsBALApplication();
bool flag = CheckIfMappingexists(Appid, Shareid);
if (flag == true)
{
lblError.Text = "Mapping already exists.";
}
else
{
bool bln = objclsBALApplication.UpdateAppShareMapping(Appid, Shareid, RowID);
lblSuccess.Text = "Mapping updated sucessfully.";
}
return(true);
}
// gd drp
public void PopulateAppDropDown(DropDownList ddlGridApp)
{
if (ddlGridApp != null)
{
objclsBALApplication = new clsBALApplication();
DataSet ds = new DataSet();
ds = objclsBALApplication.GetAllApplications();
ddlGridApp.DataSource = ds;
ddlGridApp.DataTextField = "ApplicationName";
ddlGridApp.DataValueField = "ApplicationID";
ddlGridApp.DataBind();
// ddlGridApp.SelectedItem.Value = AppNm;
ddlGridApp.Items.Insert(0, new ListItem("-- Select --", "0"));
}
}
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 gvInitiative_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
btnAdd.Enabled = true;
RadioButton rbtnUpdateTrue = (RadioButton)gvInitiative.Rows[e.RowIndex].FindControl("rbtnUpdateTrue");
RadioButton rbtnUpdateFalse = (RadioButton)gvInitiative.Rows[e.RowIndex].FindControl("rbtnUpdateFalse");
RadioButton rbtnVisibleTrue = (RadioButton)gvInitiative.Rows[e.RowIndex].FindControl("rbtnVisibleTrue");
RadioButton rbtnVisibleFalse = (RadioButton)gvInitiative.Rows[e.RowIndex].FindControl("rbtnVisibleFalse");
bool flagUpdate = false;
bool flagVisible = false;
if (rbtnUpdateTrue.Checked)
{
flagUpdate = true;
}
if (rbtnVisibleTrue.Checked)
{
flagVisible = true;
}
Label lblInitiativeID = (Label)gvInitiative.Rows[e.RowIndex].FindControl("lblInitiativeID");
int initiativeID = Convert.ToInt16(lblInitiativeID.Text.ToString());
objclsBALApplication = new clsBALApplication();
objclsBALApplication.UpdateInitiatives(initiativeID, flagUpdate, flagVisible);
gvInitiative.EditIndex = -1;
PopulateGrid();
if (ViewState["SortExpression"] != null && ViewState["sortDirection"] != null)
{
SortGridView(ViewState["SortExpression"].ToString(), ViewState["sortDirection"].ToString());
}
lblSuccess.Text = "Initiative updated successfully.";
}
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 string FetchApplicationStatus(string[] strRole, string strQaurter, int intAppId)
{
string strStatus = null;
string strReturn = null;
clsBALApplication objclsBALApplication = new clsBALApplication();
strStatus = objclsBALApplication.GetAllApplicationStatus(strRole, strQaurter, intAppId);
if (strStatus == "1")
{
strReturn = "Pending";
}
else
{
strReturn = "Submitted";
}
return(strReturn);
}
public bool CheckIfMappingexists(int AppID, int ShareID)
{
objclsBALApplication = new clsBALApplication();
//bool bln = objclsBALApplication.CheckIfMappingExists(AppID, ShareID);
return(true);
}
public void DeleteMapping(int appid, int shareid)
{
objclsBALApplication = new clsBALApplication();
objclsBALApplication.DeleteAppShareMapping(appid, shareid, objclsEALLoggedInUser.StrUserADID);
}
public void DeleteMapping(int appid, int DatabaseMappingID)
{
objclsBALApplication = new clsBALApplication();
objclsBALApplication.DeleteAppDatabaseMapping(appid, DatabaseMappingID);
}
public void LockOut()
{
objclsBALUsers = new clsBALUsers();
DataSet ds = objclsBALUsers.GetLockOut();
if (ds.Tables[0].Rows.Count > 0)
{
Session["lockout"] = ds.Tables[0].Rows[0][0].ToString();
}
if (role != null)
{
#region Admin
if (role.Contains <string>(clsEALRoles.ComplianceAdmin))
{
//pnlLockOut.Visible = true;
lblLockout.Visible = true;
chkLock.Visible = true;
if (Session["lockout"] != null)
{
//chkLock.Checked = bool.Parse(ds.Tables[0].Rows[0][0].ToString());
chkLock.Checked = bool.Parse(Session["lockout"].ToString());
}
// }
}
#endregion
#region approver
if (role.Contains <string>(clsEALRoles.Approver))
{
string str = Session["lockout"].ToString();
if (str == "True")
{
string LoggedInUserID = "";
if (Session["LoggedInUserID"] != null)
{
LoggedInUserID = Session["LoggedInUserID"].ToString();
}
clsBALApplication objclsBALApplication = new clsBALApplication();
DataTable dt = objclsBALApplication.GetUnlockApprover(LoggedInUserID);
bool approverUnlock = false;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["UnlockApp"].ToString().ToLower() == "true")
{
approverUnlock = true;
break;
}
}
}
if (approverUnlock)
{
Session["lockout"] = "False";
}
}
}
#endregion
#region Control Owner
if (role.Contains <string>(clsEALRoles.ControlOwner))
{
string str = Session["lockout"].ToString();
if (str == "True")
{
string LoggedInUserID = "";
if (Session["LoggedInUserID"] != null)
{
LoggedInUserID = Session["LoggedInUserID"].ToString();
}
clsBALApplication objclsBALApplication = new clsBALApplication();
DataTable dtCO = objclsBALApplication.GetUnlockCO(LoggedInUserID);
bool coUnlock = false;
if (dtCO.Rows.Count > 0)
{
for (int i = 0; i < dtCO.Rows.Count; i++)
{
if (dtCO.Rows[i]["UnlockApp"].ToString().ToLower() == "true")
{
coUnlock = true;
break;
}
}
}
if (coUnlock)
{
Session["lockout"] = "False";
}
if (role.Contains <string>(clsEALRoles.GlobalApprover) && role.Contains <string>(clsEALRoles.ControlOwner))
{
rdGA.Enabled = false;
}
}
}
#endregion
}
}
