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