public void fillServersTreefromSession() { DataTable DataServers = new DataTable(); try { if (Session["DataServers"] != "" && Session["DataServers"] != null) { DataServers = Session["DataServers"] as DataTable; } if (DataServers.Rows.Count > 0) { DataServers.PrimaryKey = new DataColumn[] { DataServers.Columns["ID"] }; } ServersTreeList.DataSource = DataServers; ServersTreeList.DataBind(); } catch (Exception ex) { //Log.Entry.Ins.Write(Server.MapPath("~/LogFiles/"), "VSPlusLog.txt", DateTime.Now.ToString() + " Error in Page: " + // Request.Url.AbsolutePath + ", Method: " + System.Reflection.MethodBase.GetCurrentMethod().Name + // ", Error: " + ex.ToString()); Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }
private void GetSelectedServers() { DataTable dtSel = new DataTable(); DataTable dtUnSel = new DataTable(); try { dtSel.Columns.Add("ServerID"); dtSel.Columns.Add("Name"); dtSel.Columns.Add("ServerType"); dtUnSel.Columns.Add("ServerID"); dtUnSel.Columns.Add("Name"); dtUnSel.Columns.Add("ServerType"); //string selValues = ""; TreeListNodeIterator iterator = ServersTreeList.CreateNodeIterator(); TreeListNode node; while (true) { node = iterator.GetNext(); if (node == null) { break; } if (node.Level == 2) //(node.ParentNode.Selected==false) { if (node.Selected) { DataRow dr = dtSel.NewRow(); dr["ServerID"] = node.GetValue("actid"); dr["Name"] = node.GetValue("Name"); dr["ServerType"] = node.GetValue("ServerType"); dtSel.Rows.Add(dr); } else { DataRow dr = dtUnSel.NewRow(); dr["ServerID"] = node.GetValue("actid"); dr["Name"] = node.GetValue("Name"); dr["ServerType"] = node.GetValue("ServerType"); dtUnSel.Rows.Add(dr); } } } Session["SelectedServers"] = dtSel; Session["UnSelectedServers"] = dtUnSel; } catch (Exception ex) { //Log.Entry.Ins.Write(Server.MapPath("~/LogFiles/"), "VSPlusLog.txt", DateTime.Now.ToString() + " Error in Page: " + // Request.Url.AbsolutePath + ", Method: " + System.Reflection.MethodBase.GetCurrentMethod().Name + // ", Error: " + ex.ToString()); Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }
protected void Page_Load(object sender, EventArgs e) { errorDiv.Style.Value = "display: none"; if (Request.QueryString["EventKey"] != null && Request.QueryString["EventKey"] != "") { flag = "update"; EventKey = Convert.ToInt16(Request.QueryString["EventKey"].ToString()); Session["ID"] = EventKey; if (!IsPostBack) { Session["key"] = null; fillData(EventKey); } } else { flag = "insert"; } if (!IsPostBack) { //if (flag == "update") // fillData(EventKey); FillDELSGrid(); fillServersTreeList(); ServersTreeList.CollapseAll(); if (Session["UserPreferences"] != null) { DataTable UserPreferences = (DataTable)Session["UserPreferences"]; foreach (DataRow dr in UserPreferences.Rows) { if (dr[1].ToString() == "DELS_Edit|DELSGridView") { DELSGridView.SettingsPager.PageSize = Convert.ToInt32(dr[2]); } } } } else { FillDELSGridfromSession(); fillServersTreefromSession(); ServersTreeList.CollapseAll(); } }
public void fillServersTreeList() { try { DataTable DataServersTree = VSWebBL.ConfiguratorBL.AlertsBL.Ins.GetServersFromProcedure(); string PrimaryNode = ""; DataTable ServerNodes = Session["ServerNodes"] as DataTable; if (ServerNodes != null && ServerNodes.Rows.Count > 0) { PrimaryNode = ServerNodes.Rows[0][1].ToString(); } foreach (DataRow dr in DataServersTree.Rows) { if (dr["LocId"].ToString() != "") { if (dr["MonitoredBy"].ToString() == "") { if (PrimaryNode != "") { dr["MonitoredBy"] = "Unassigned(Monitored by " + PrimaryNode + ")"; } else { dr["MonitoredBy"] = "Unassigned"; } } } } Session["DataServers"] = DataServersTree; ServersTreeList.DataSource = (DataTable)Session["DataServers"]; ServersTreeList.DataBind(); ServersTreeList.ExpandAll(); ServersTreeList.UnselectAll(); } catch (Exception ex) { //Log.Entry.Ins.Write(Server.MapPath("~/LogFiles/"), "VSPlusLog.txt", DateTime.Now.ToString() + " Error in Page: " + // Request.Url.AbsolutePath + ", Method: " + System.Reflection.MethodBase.GetCurrentMethod().Name + // ", Error: " + ex.ToString()); Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }
public void fillServersTreeList() { try { if (Session["DataServers"] == null) { DataTable DataServersTree = VSWebBL.ConfiguratorBL.AlertsBL.Ins.GetServersFromProcedure(); DataTable filteredData = DataServersTree.Select("ServerType='" + ServerTypeComboBox.Text + "' or ServerType is null").CopyToDataTable(); Session["DataServers"] = filteredData; } ServersTreeList.DataSource = (DataTable)Session["DataServers"]; ServersTreeList.DataBind(); ServersTreeList.ExpandAll(); } catch (Exception ex) { //Log.Entry.Ins.Write(Server.MapPath("~/LogFiles/"), "VSPlusLog.txt", DateTime.Now.ToString() + " Error in Page: " + // Request.Url.AbsolutePath + ", Method: " + System.Reflection.MethodBase.GetCurrentMethod().Name + // ", Error: " + ex.ToString()); } }
protected void CollapseAllSrvButton_Click(object sender, EventArgs e) { try { if (CollapseAllSrvButton.Text == "Collapse All") { ServersTreeList.CollapseAll(); CollapseAllSrvButton.Image.Url = "~/images/icons/add.png"; CollapseAllSrvButton.Text = "Expand All"; } else { ServersTreeList.ExpandAll(); CollapseAllSrvButton.Image.Url = "~/images/icons/forbidden.png"; CollapseAllSrvButton.Text = "Collapse All"; } } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); } }
public void fillServersTreefromSession() { DataTable DataServers = new DataTable(); try { if (Session["DataServers"] != "" && Session["DataServers"] != null) { DataServers = Session["DataServers"] as DataTable; } if (DataServers.Rows.Count > 0) { DataServers.PrimaryKey = new DataColumn[] { DataServers.Columns["ID"] }; } ServersTreeList.DataSource = DataServers; ServersTreeList.DataBind(); } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); } }
protected void CollapseAllButton_Click(object sender, EventArgs e) { try { if (CollapseAllButton.Text == "Collapse All") { ServersTreeList.CollapseAll(); CollapseAllButton.Image.Url = "~/images/icons/add.png"; CollapseAllButton.Text = "Expand All"; } else { ServersTreeList.ExpandAll(); CollapseAllButton.Image.Url = "~/images/icons/forbidden.png"; CollapseAllButton.Text = "Collapse All"; } } catch (Exception ex) { //Log.Entry.Ins.Write(Server.MapPath("~/LogFiles/"), "VSPlusLog.txt", DateTime.Now.ToString() + " Error in Page: " + // Request.Url.AbsolutePath + ", Method: " + System.Reflection.MethodBase.GetCurrentMethod().Name + // ", Error: " + ex.ToString()); } }
//private UserProfileMaster CollectDataForUserProfiles(string Mode, int id) //{ // try // { // UserProfileMaster UserProfilesObject = new UserProfileMaster(); // UserProfilesObject.Name = ProfileTextBox.Text;// UserProfilesRow["Name"].ToString(); // if (Mode == "Update") // UserProfilesObject.ID = id;// int.Parse(UserProfilesRow["ID"].ToString()); // return UserProfilesObject; // } // catch (Exception ex) // { throw ex; } // finally { } //} //protected void CancelButton_Click(object sender, EventArgs e) //{ // Response.Redirect("UserProfilesGrid.aspx"); //} //public void fillServersTreeListfromSession() //{ // try // { // if (Session["DataServers"] != null) // { // DataTable ServersGridViewTable = new DataTable(); // if (Session["DataServers"] != null && Session["DataServers"] != "") // { // ServersGridViewTable = (DataTable)Session["DataServers"]; // } // if (ServersGridViewTable.Rows.Count > 0) // { // ServersGridView.DataSource = (DataTable)Session["DataServers"]; // ServersGridView.DataBind(); // } // } // // DataTable DataServersTree = VSWebBL.SecurityBL.ServersBL.Ins.GetAllDataByServerType(ServerTypeComboBox.SelectedItem.Text); // // Session["DataServers"] = DataServersTree; // //} // //ServersGridView.DataSource = (DataTable)Session["DataServers"]; // //ServersGridView.DataBind(); // //DataTable dtSel = VSWebBL.ConfiguratorBL.AlertsBL.Ins.GetSelectedServers(AlertKey); // //if (dtSel.Rows.Count > 0) // //{ // // TreeListNodeIterator iterator = ServersTreeList.CreateNodeIterator(); // // TreeListNode node; // // for (int i = 0; i < dtSel.Rows.Count; i++) // // { // // if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == 0 && Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) == 0) // // { // // //select all // // while (true) // // { // // node = iterator.GetNext(); // // if (node == null) break; // // node.Selected = true; // // } // // } // // else if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == 0 && (Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) != 0)) // // { // // //parent selected // // while (true) // // { // // node = iterator.GetNext(); // // if (node == null) break; // // if ((Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) == Convert.ToInt32(node.GetValue("actid"))) && node.GetValue("tbl").ToString() == "UserProfiles") // // { // // node.Selected = true; // // } // // else if (node.GetValue("LocId").ToString() != "") // // { // // if ((Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) == Convert.ToInt32(node.GetValue("LocId"))) && node.GetValue("tbl").ToString() != "UserProfiles") // // { // // node.Selected = true; // // } // // } // // } // // } // // else if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) != 0 && (Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) != 0)) // // { // // //specific selected // // while (true) // // { // // node = iterator.GetNext(); // // if (node == null) break; // // if ((Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == Convert.ToInt32(node.GetValue("actid"))) && node.GetValue("tbl").ToString() != "UserProfiles") // // { // // node.Selected = true; // // } // // } // // } // // iterator.Reset(); // // } // //} // } // catch (Exception ex) // { // } //} //public void fillServersTreeList() //{ // try // { // if (Session["DataServers"] == null) // { // DataTable DataServersTree = VSWebBL.SecurityBL.ServersBL.Ins.GetAllDataByServerType(ServerTypeComboBox.SelectedItem.Text); // Session["DataServers"] = DataServersTree; // } // ServersGridView.DataSource = (DataTable)Session["DataServers"]; // ServersGridView.DataBind(); // //DataTable dtSel = VSWebBL.ConfiguratorBL.AlertsBL.Ins.GetSelectedServers(AlertKey); // //if (dtSel.Rows.Count > 0) // //{ // // TreeListNodeIterator iterator = ServersTreeList.CreateNodeIterator(); // // TreeListNode node; // // for (int i = 0; i < dtSel.Rows.Count; i++) // // { // // if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == 0 && Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) == 0) // // { // // //select all // // while (true) // // { // // node = iterator.GetNext(); // // if (node == null) break; // // node.Selected = true; // // } // // } // // else if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == 0 && (Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) != 0)) // // { // // //parent selected // // while (true) // // { // // node = iterator.GetNext(); // // if (node == null) break; // // if ((Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) == Convert.ToInt32(node.GetValue("actid"))) && node.GetValue("tbl").ToString() == "UserProfiles") // // { // // node.Selected = true; // // } // // else if (node.GetValue("LocId").ToString() != "") // // { // // if ((Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) == Convert.ToInt32(node.GetValue("LocId"))) && node.GetValue("tbl").ToString() != "UserProfiles") // // { // // node.Selected = true; // // } // // } // // } // // } // // else if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) != 0 && (Convert.ToInt32(dtSel.Rows[i]["UserProfileID"]) != 0)) // // { // // //specific selected // // while (true) // // { // // node = iterator.GetNext(); // // if (node == null) break; // // if ((Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == Convert.ToInt32(node.GetValue("actid"))) && node.GetValue("tbl").ToString() != "UserProfiles") // // { // // node.Selected = true; // // } // // } // // } // // iterator.Reset(); // // } // //} // } // catch (Exception ex) // { // } //} public void ApplyToServers_Click(object sender, EventArgs e) { //12/12/2013 NS added errorDiv.Style.Value = "display: none;"; errorDiv2.Style.Value = "display: none"; List <object> fieldValues = ProfilesGridView.GetSelectedFieldValues(new string[] { "RelatedField", "DefaultValue", "RelatedTable" }); //List<object> serversSelected = ServersGridView.GetSelectedFieldValues(new string[] {"ID","ServerName" }); DataTable dt = GetSelectedServers(); List <DataRow> serversSelected = dt.AsEnumerable().ToList(); //List<DataRow> list = dt.AsEnumerable().ToList(); int Update = 0; string ServerErrors = ""; if (fieldValues.Count > 0 && serversSelected.Count > 0) { GridViewDataColumn column2 = ProfilesGridView.Columns["DefaultValue"] as GridViewDataColumn; List <ProfilesMaster> list = new List <ProfilesMaster>(); int startIndex = ProfilesGridView.PageIndex * ProfilesGridView.SettingsPager.PageSize; int endIndex = Math.Min(ProfilesGridView.VisibleRowCount, startIndex + ProfilesGridView.SettingsPager.PageSize); int ProfileMasterID = 0; for (int i = 0; i < ProfilesDataTable.Rows.Count; i++) { if (ProfilesDataTable.Rows[i]["isSelected"].ToString() == "true") { ProfileMasterID = Convert.ToInt32(ProfilesDataTable.Rows[i]["ID"]); list.Add(new ProfilesMaster(0, 0, "", ProfilesDataTable.Rows[i]["AttributeName"].ToString(), "", ProfilesDataTable.Rows[i]["DefaultValue"].ToString(), ProfilesDataTable.Rows[i]["RelatedTable"].ToString(), ProfilesDataTable.Rows[i]["RelatedField"].ToString())); //list.Add(new UserProfileDetailed(i, UserProfileMasterID, ProfileMasterID, ProfilesDataTable.Rows[i]["DefaultValue"].ToString())); } } //for (int i = 0; i < ProfilesGridView.VisibleRowCount; i++) //{ // if (ProfilesGridView.Selection.IsRowSelected(i)) // { // ASPxTextBox txtValue = (ASPxTextBox)ProfilesGridView.FindRowCellTemplateControl(i, column2, "txtValue"); // int ProfileMasterID = Convert.ToInt32(ProfilesGridView.GetRowValues(i, ProfilesGridView.KeyFieldName)); // list.Add(new ProfilesMaster(0, 0, "", "", "", txtValue.Text, ProfilesGridView.GetRowValues(i, "RelatedTable").ToString(), ProfilesGridView.GetRowValues(i, "RelatedField").ToString())); // //i, UserProfileMasterID, ProfileMasterID, txtValue.Text // } //} //foreach (object[] server in serversSelected) string AppliedServers = ""; foreach (DataRow server in serversSelected) { Update = VSWebBL.SecurityBL.UserProfileMasterBL.Ins.UpdateServerSettings(Convert.ToInt32(server[0]), list); if (Update == 0) { //12/12/2013 NS modified if (ServerErrors == "") { ServerErrors += server[1].ToString(); } else { ServerErrors += ", " + server[1].ToString(); } } else { //12/12/2013 NS modified if (AppliedServers == "") { AppliedServers += server[1].ToString(); } else { AppliedServers += ", " + server[1].ToString(); } } } if (ServerErrors != "") { //12/12/2013 NS modified //lblError.Text = "Settings for servers :" + ServerErrors + " are NOT updated"; errorDiv2.InnerHtml = "Settings for the server(s) " + ServerErrors + " were NOT updated."; errorDiv2.Style.Value = "display: block"; //lblMessage.ForeColor = } else { string parameters = ""; int count = 0; foreach (ProfilesMaster fieldValue in list) { if (count == 0) { parameters += fieldValue.AttributeName + " = " + fieldValue.DefaultValue; count++; } else { parameters += ", " + fieldValue.AttributeName + " = " + fieldValue.DefaultValue; } } ProfilesGridView.Selection.UnselectAll(); ServersTreeList.UnselectAll(); //12/12/2013 NS moved the code into the else block, otherwise on unsuccessful apply //the whole server list would get wiped out //Clearing the Data Grids ServerTypeComboBox.SelectedIndex = -1; ProfilesGridView.DataSource = null; ProfilesGridView.DataBind(); //ServersGridView.DataSource = null; //ServersGridView.DataBind(); ServersTreeList.ClearNodes(); ServersTreeList.DataSource = null; ServersTreeList.DataBind(); Session["DataServers"] = null; Session["Profiles"] = null; //12/12/2013 NS modified //lblMessage.Text = "Settings: " + parameters + " for the selected servers: " + AppliedServers + " are updated"; successDiv.InnerHtml = "The following settings for the server(s) " + AppliedServers + " were successfully updated: " + parameters; successDiv.Style.Value = "display: block"; ApplyServersButton.Style.Value = "visibility: hidden"; tblServer.Style.Value = "visibility: hidden"; } } else { //12/12/2013 NS modified //lblError.Text = "Please select required Attributes and Servers"; errorDiv.Style.Value = "display: block"; } }
public void fillServersTreeList() { try { ServersTreeList.CollapseAll(); CollapseAllSrvButton.Image.Url = "~/images/icons/add.png"; CollapseAllSrvButton.Text = "Expand All"; if (Session["DataServers"] == null) { DataTable DataServersTree = VSWebBL.ConfiguratorBL.ELSBL.Ins.GetServersFromProcedure(); Session["DataServers"] = DataServersTree; } ServersTreeList.DataSource = (DataTable)Session["DataServers"]; ServersTreeList.DataBind(); DataTable dtSel = VSWebBL.ConfiguratorBL.ELSBL.Ins.GetSelectedServers(EventKey); if (dtSel.Rows.Count > 0) { TreeListNodeIterator iterator = ServersTreeList.CreateNodeIterator(); TreeListNode node; for (int i = 0; i < dtSel.Rows.Count; i++) { if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == 0 && Convert.ToInt32(dtSel.Rows[i]["LocationID"]) == 0) { //select all while (true) { node = iterator.GetNext(); if (node == null) { break; } node.Selected = true; } } else if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == 0 && (Convert.ToInt32(dtSel.Rows[i]["LocationID"]) != 0)) { //parent selected while (true) { node = iterator.GetNext(); if (node == null) { break; } if ((Convert.ToInt32(dtSel.Rows[i]["LocationID"]) == Convert.ToInt32(node.GetValue("actid"))) && node.GetValue("tbl").ToString() == "Locations") { node.Selected = true; } else if (node.GetValue("LocId").ToString() != "") { if ((Convert.ToInt32(dtSel.Rows[i]["LocationID"]) == Convert.ToInt32(node.GetValue("LocId"))) && node.GetValue("tbl").ToString() != "Locations") { node.Selected = true; } } } } else if (Convert.ToInt32(dtSel.Rows[i]["ServerID"]) != 0 && (Convert.ToInt32(dtSel.Rows[i]["LocationID"]) != 0)) { //specific selected while (true) { node = iterator.GetNext(); if (node == null) { break; } if ((Convert.ToInt32(dtSel.Rows[i]["ServerID"]) == Convert.ToInt32(node.GetValue("actid"))) && node.GetValue("tbl").ToString() != "Locations") { node.Selected = true; } } } iterator.Reset(); } } } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); } }
private DataTable GetSelectedServers(int EventKey) { DataTable dtSel = new DataTable(); try { dtSel.Columns.Add("EventKey"); dtSel.Columns.Add("ServerID"); dtSel.Columns.Add("LocationID"); dtSel.Columns.Add("ServerTypeID"); TreeListNodeIterator iterator = ServersTreeList.CreateNodeIterator(); TreeListNode node; TreeListColumn columnActid = ServersTreeList.Columns["actid"]; TreeListColumn columnSrvId = ServersTreeList.Columns["LocId"]; TreeListColumn columnTbl = ServersTreeList.Columns["tbl"]; TreeListColumn columnSrvTypeId = ServersTreeList.Columns["srvtypeid"]; while (true) { node = iterator.GetNext(); if (node == null) { break; } //if (node.Level == 1 && node.ParentNode.Selected) //{ // // root node selected ie All Servers selected // DataRow dr = dtSel.NewRow(); // dr["EventKey"] = EventKey; // dr["ServerID"] = node.GetValue("actid"); // dr["LocationID"] = node.GetValue("LocId"); // dr["ServerTypeID"] = node.GetValue("srvtypeid"); // dtSel.Rows.Add(dr); // break; //} //else if (node.Level == 1 && node.ParentNode.Selected == false && node.Selected) //{ // DataRow dr = dtSel.NewRow(); // dr["EventKey"] = EventKey; // dr["ServerID"] = node.GetValue("actid"); // dr["LocationID"] = ((System.Data.DataRowView)(node.DataItem)).Row.ItemArray[3];// node.GetValue("LocId"); // dr["ServerTypeID"] = node.GetValue("srvtypeid"); // dtSel.Rows.Add(dr); //} //else if (node.Level == 2) //(node.ParentNode.Selected==false) { if (node.Selected) { DataRow dr = dtSel.NewRow(); dr["EventKey"] = EventKey; dr["ServerID"] = node.GetValue("actid"); dr["LocationID"] = node.GetValue("LocId"); dr["ServerTypeID"] = node.GetValue("srvtypeid"); dtSel.Rows.Add(dr); } } } } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); } return(dtSel); }