private void FillDominoServerTasksGrid() { try { //DSTaskSettingsDataSet = new DataSet(); DSTasksDataTable = new DataTable(); DSTasksDataTable = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.GetAllData(); //DataTable dtcopy = DSTasksDataTable.Copy(); //dtcopy.Columns.Add("SendLoadCommand"); //dtcopy.Columns.Add("SendRestartCommand"); //dtcopy.Columns.Add("RestartOffHours"); //dtcopy.Columns.Add("SendExitCommand"); //DSTaskSettingsDataSet.Tables.Add(dtcopy); if (DSTasksDataTable.Rows.Count > 0) { Session["DominoTasks"] = DSTasksDataTable; // DSTaskSettingsDataSet.Tables[0]; DominoTasksGridView.DataSource = DSTasksDataTable; //DSTaskSettingsDataSet.Tables[0]; DominoTasksGridView.DataBind(); } } catch (Exception ex) { throw ex; } finally { } }
protected void UpdateTasksForDominoServers(int Enabled) { successDivDomino.Style.Value = "display: none"; errorDiv3.Style.Value = "display: none;"; errorDiv4.Style.Value = "display: none"; List <object> fieldValues = DominoTasksGridView.GetSelectedFieldValues(new string[] { "TaskID" });//, "SendLoadCommand", "SendRestartCommand", "RestartOffHours", "SendExitCommand" //List<object> serversSelected = ServersGridView.GetSelectedFieldValues(new string[] {"ID","ServerName" }); DataTable dt = GetSelectedDominoServers(); List <DataRow> serversSelected = dt.AsEnumerable().ToList(); //List<DataRow> list = dt.AsEnumerable().ToList(); int Update = 0; string ServerErrors = ""; if (fieldValues.Count > 0 && serversSelected.Count > 0) { foreach (DataRow server in serversSelected) { string AppliedServers = ""; for (int i = 0; i < DSTasksDataTable.Rows.Count; i++) { if (DSTasksDataTable.Rows[i]["isSelected"].ToString() == "true") { int SendLoadCommand = 0; int SendRestartCommand = 0; int RestartOffHours = 0; int SendExitCommand = 0; if (Enabled == 1) { if (DSTasksDataTable.Rows[i]["SendLoadCommand"].ToString() == "true") { SendLoadCommand = 1; } if (DSTasksDataTable.Rows[i]["SendRestartCommand"].ToString() == "true") { SendRestartCommand = 1; } if (DSTasksDataTable.Rows[i]["RestartOffHours"].ToString() == "true") { RestartOffHours = 1; } if (DSTasksDataTable.Rows[i]["SendExitCommand"].ToString() == "true") { SendExitCommand = 1; } } Update = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.UpdateDominoServerTasks(Convert.ToInt32(DSTasksDataTable.Rows[i]["TaskID"]), Convert.ToInt32(server[0]), Enabled, SendLoadCommand, SendRestartCommand, RestartOffHours, SendExitCommand); if (Update == 0) { if (ServerErrors == "") { ServerErrors += server[1].ToString(); } else { if (ServerErrors.Contains(server[1].ToString())) { } else { ServerErrors += ", " + server[1].ToString(); } } } else { //12/12/2013 NS modified if (AppliedServers == "") { AppliedServers += server[1].ToString(); } else { if (AppliedServers.Contains(server[1].ToString())) { } else { AppliedServers += ", " + server[1].ToString(); } } } if (ServerErrors != "") { errorDiv4.InnerHtml = "Settings for the server(s) " + ServerErrors + " were NOT updated."; errorDiv4.Style.Value = "display: block"; } else { int count = 0; string parameters = ""; for (int num = 0; num < DSTasksDataTable.Rows.Count; num++) { if (DSTasksDataTable.Rows[num]["isSelected"].ToString() == "true") { if (count == 0) { parameters = Convert.ToString(DSTasksDataTable.Rows[num]["TaskName"]); count++; } else { parameters += "," + Convert.ToString(DSTasksDataTable.Rows[num]["TaskName"]); } } } DominoTasksGridView.Selection.UnselectAll(); successDivDomino.InnerHtml = "The following settings for the server(s) " + AppliedServers + " were successfully updated: " + parameters; successDivDomino.Style.Value = "display: block"; } } } } } else { //12/12/2013 NS modified //lblError.Text = "Please select required Attributes and Servers"; errorDiv3.Style.Value = "display: block"; } }
private void FillDominoServerTasksGridfromSession() { try { DSTasksDataTable = new DataTable(); if (Session["DominoTasks"] != "" && Session["DominoTasks"] != null) { DSTasksDataTable = (DataTable)Session["DominoTasks"]; } if (DSTasksDataTable.Rows.Count > 0) { int startIndex = DominoTasksGridView.PageIndex * DominoTasksGridView.SettingsPager.PageSize; int endIndex = Math.Min(DominoTasksGridView.VisibleRowCount, startIndex + DominoTasksGridView.SettingsPager.PageSize); for (int i = startIndex; i < endIndex; i++) { if (DominoTasksGridView.Selection.IsRowSelected(i)) { //object o = DominoTasksGridView.GetRowValues(i, "SendLoadCommand"); DSTasksDataTable.Rows[i]["isSelected"] = "true"; ASPxCheckBox SendLoadCommand = DominoTasksGridView.FindRowCellTemplateControl(i, DominoTasksGridView.Columns[4] as GridViewDataColumn, "SendLoadCommand") as ASPxCheckBox; ASPxCheckBox SendRestartCommand = DominoTasksGridView.FindRowCellTemplateControl(i, DominoTasksGridView.Columns[5] as GridViewDataColumn, "SendRestartCommand") as ASPxCheckBox; ASPxCheckBox RestartOffHours = DominoTasksGridView.FindRowCellTemplateControl(i, DominoTasksGridView.Columns[6] as GridViewDataColumn, "RestartOffHours") as ASPxCheckBox; ASPxCheckBox SendExitCommand = DominoTasksGridView.FindRowCellTemplateControl(i, DominoTasksGridView.Columns[7] as GridViewDataColumn, "SendExitCommand") as ASPxCheckBox; if (SendLoadCommand != null && SendLoadCommand.Checked == true) { DSTasksDataTable.Rows[i]["SendLoadCommand"] = "true"; } else { DSTasksDataTable.Rows[i]["SendLoadCommand"] = "false"; } if (SendRestartCommand != null && SendRestartCommand.Checked == true) { DSTasksDataTable.Rows[i]["SendRestartCommand"] = "true"; } else { DSTasksDataTable.Rows[i]["SendRestartCommand"] = "false"; } if (RestartOffHours != null && RestartOffHours.Checked == true) { DSTasksDataTable.Rows[i]["RestartOffHours"] = "true"; } else { DSTasksDataTable.Rows[i]["RestartOffHours"] = "false"; } if (SendExitCommand != null && SendExitCommand.Checked == true) { DSTasksDataTable.Rows[i]["SendExitCommand"] = "true"; } else { DSTasksDataTable.Rows[i]["SendExitCommand"] = "false"; } } else { DSTasksDataTable.Rows[i]["isSelected"] = "false"; } } DominoTasksGridView.DataSource = DSTasksDataTable; DominoTasksGridView.DataBind(); } } catch (Exception ex) { throw ex; } finally { } }