public Object ValidateDCUpdate(DominoServerTasks DSTObject) { Object ReturnValue = ""; try { if (DSTObject.TaskName == null || DSTObject.TaskName == "") { return("ER#Please enter a short, unique, name for this Server Task."); } if ((DSTObject.MaxBusyTime) < 1 && (DSTObject.FreezeDetect) == true) { return("ER#Please enter the maximum time to wait for the server task to update, in minutes."); } if (DSTObject.RetryCount < 1) { return("ER#Please enter a Retry Interval that is a positive number."); } } catch (Exception ex) { throw ex; } finally { } return(""); }
private void FillData(int ID) { try { DominoServerTasks DominoSTaskObject = new DominoServerTasks(); DominoServerTasks ReturnDSTaskObject = new DominoServerTasks(); DominoSTaskObject.TaskID = ID; ReturnDSTaskObject = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.GetDataForID(DominoSTaskObject); //DominoStatistic fields EditTaskNameTextBox.Text = ReturnDSTaskObject.TaskName.ToString(); EditIdleStringTextBox.Text = ReturnDSTaskObject.IdleString.ToString(); EditConsoleStringTextBox.Text = ReturnDSTaskObject.ConsoleString.ToString(); EditLoadCmdTextBox.Text = ReturnDSTaskObject.LoadString.ToString(); EditMaxRunTimeTextBox.Text = ReturnDSTaskObject.MaxBusyTime.ToString(); EditRetryCountTextBox.Text = ReturnDSTaskObject.RetryCount.ToString(); if (ReturnDSTaskObject.FreezeDetect == true) { EditEnableCheckBox.Checked = true; } else { EditEnableCheckBox.Checked = false; } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } }
private void UpdateDominoServerTasksData() { try { DominoServerTasks NDObj = new DominoServerTasks(); NDObj.TaskName = EditTaskNameTextBox.Text; NDObj.TaskID = ServerKey; DataTable returntable = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.GetName(NDObj); if (returntable.Rows.Count > 0) { ErrorMessageLabel.Text = "This Name is already being monitored. Please enter another or Name."; ErrorMessagePopupControl.ShowOnPageLoad = true; //IPAddressTextBox.Focus(); } else { try { Object ReturnValue = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.UpdateData(CollectDataForDominoServerTasks()); SetFocusOnError(ReturnValue); if (ReturnValue.ToString() == "True") { //1/21/2014 NS modified /* * ErrorMessageLabel.Text = "Data updated successfully."; * ErrorMessagePopupControl.HeaderText = "Information"; * ErrorMessagePopupControl.ShowCloseButton = false; * ValidationUpdatedButton.Visible = true; * ValidationOkButton.Visible = false; * ErrorMessagePopupControl.ShowOnPageLoad = true; */ Session["ServerTaskUpdateStatus"] = EditTaskNameTextBox.Text; Response.Redirect("ServerTaskDefinitions.aspx", false);//Mukund, 05Aug14, VSPLUS-844:Page redirect on callback Context.ApplicationInstance.CompleteRequest(); } } catch (Exception ex) { //10/3/2014 NS modified for VSPLUS-990 errorDiv.InnerHtml = "The following error has occurred: " + ex.Message + "<button type=\"button\" class=\"close\" data-dismiss=\"alert\"><span aria-hidden=\"true\">×</span><span class=\"sr-only\">Close</span></button>"; errorDiv.Style.Value = "display: block"; //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); } } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }
/// <summary> /// Call DAL GetDataForID /// </summary> /// <param name="DSTasksObject"></param> /// <returns></returns> public DominoServerTasks GetDataForID(DominoServerTasks DSTasksObject) { try { return(VSWebDAL.ConfiguratorDAL.DominoServerTasksDAL.Ins.GetDataForID(DSTasksObject)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Call DAL Delete Data /// </summary> /// <param name="DSTObject"></param> /// <returns></returns> public Object DeleteData(DominoServerTasks DSTObject) { try { return(VSWebDAL.ConfiguratorDAL.DominoServerTasksDAL.Ins.DeleteData(DSTObject)); } catch (Exception ex) { throw ex; } }
//public DataTable TaskName() //{ // return VSWebDAL.ConfiguratorDAL.DominoServerTasksDAL.Ins.GetTaskName(); //} public DataTable GetName(DominoServerTasks NDObj) { try { return(VSWebDAL.ConfiguratorDAL.DominoServerTasksDAL.Ins.GetName(NDObj)); } catch (Exception ex) { throw ex; } }
private void InsertDominoServerTasks() { try { DominoServerTasks NDObj = new DominoServerTasks(); NDObj.TaskName = EditTaskNameTextBox.Text; NDObj.TaskID = ServerKey; DataTable returntable = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.GetName(NDObj); if (returntable.Rows.Count > 0) { ErrorMessageLabel.Text = "This Name is already being monitored. Please enter another Name."; ErrorMessagePopupControl.ShowOnPageLoad = true; //IPAddressTextBox.Focus(); } else { try { object ReturnValue = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.InsertData(CollectDataForDominoServerTasks()); SetFocusOnError(ReturnValue); if (ReturnValue.ToString() == "True") { ErrorMessageLabel.Text = "Data inserted successfully."; ErrorMessagePopupControl.HeaderText = "Information"; ErrorMessagePopupControl.ShowCloseButton = false; ValidationUpdatedButton.Visible = true; ValidationOkButton.Visible = false; ErrorMessagePopupControl.ShowOnPageLoad = true; } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }
protected void ServerTaskDefGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { DominoServerTasks DSTObject = new DominoServerTasks(); DSTObject.TaskID = Convert.ToInt32(e.Keys[0]); //Delete row from DB Object ReturnValue = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.DeleteData(DSTObject); //Update Grid after inserting new row, refresh grid as in page load ASPxGridView gridView = (ASPxGridView)sender; gridView.CancelEdit(); e.Cancel = true; FillDominoServerTasksGrid(); }
//delete Data from DominoServerTasks Table public Object DeleteData(DominoServerTasks DSTObject) { Object Update; try { string SqlQuery = "Delete DominoServerTasks Where TaskID=" + DSTObject.TaskID; Update = objAdaptor.ExecuteNonQuery(SqlQuery); } catch { Update = false; } finally { } return(Update); }
/// <summary> /// Call to Update Data of DominoServerTasks based on Key /// </summary> /// <param name="DominoServerTasks">DominoServerTasks object</param> /// <returns>Object</returns> public Object UpdateData(DominoServerTasks DSTObject) { try { Object ReturnValue = ValidateDCUpdate(DSTObject); if (ReturnValue.ToString() == "") { return(VSWebDAL.ConfiguratorDAL.DominoServerTasksDAL.Ins.UpdateData(DSTObject)); } else { return(ReturnValue); } } catch (Exception ex) { throw ex; } }
private ServerTaskSettings CollectDataForServerTaskSettings(string Mode, DataRow STSettingsRow) { try { ServerTaskSettings STSettingsObject = new ServerTaskSettings(); STSettingsObject.Enabled = Convert.ToBoolean(STSettingsRow["Enabled"]); DominoServerTasks DSTasksObject = new DominoServerTasks(); DSTasksObject.TaskName = STSettingsRow["TaskName"].ToString(); DominoServerTasks ReturnValue; try { ReturnValue = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.GetDataForTaskName(DSTasksObject); } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } STSettingsObject.TaskID = ReturnValue.TaskID; STSettingsObject.ServerID = int.Parse(STSettingsRow["ServerID"].ToString()); STSettingsObject.SendLoadCommand = Convert.ToBoolean(STSettingsRow["SendLoadCommand"]); STSettingsObject.SendRestartCommand = Convert.ToBoolean(STSettingsRow["SendRestartCommand"]); STSettingsObject.RestartOffHours = Convert.ToBoolean(STSettingsRow["RestartOffHours"]); STSettingsObject.SendExitCommand = Convert.ToBoolean(STSettingsRow["SendExitCommand"]); STSettingsObject.Modified_By = Convert.ToInt32(Session["UserId"].ToString()); STSettingsObject.Modified_On = DateTime.Now.ToString(); if (Mode == "Update") { } return(STSettingsObject); } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } }
private DominoServerTasks CollectDataForDominoServerTasks() { try { //DominoServerTasks DominoServerTasks DominoSTasksObject = new DominoServerTasks(); DominoSTasksObject.TaskName = EditTaskNameTextBox.Text; DominoSTasksObject.IdleString = EditIdleStringTextBox.Text; DominoSTasksObject.ConsoleString = EditConsoleStringTextBox.Text; DominoSTasksObject.LoadString = EditLoadCmdTextBox.Text; DominoSTasksObject.RetryCount = int.Parse(EditRetryCountTextBox.Text); if (EditEnableCheckBox.Checked == true) { DominoSTasksObject.FreezeDetect = true; } else { DominoSTasksObject.FreezeDetect = false; } if (EditMaxRunTimeTextBox.Text != "" && EditMaxRunTimeTextBox.Text != null) { DominoSTasksObject.MaxBusyTime = int.Parse(EditMaxRunTimeTextBox.Text); } if (Mode == "Update") { DominoSTasksObject.TaskID = ServerKey; } return(DominoSTasksObject); } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } }
/// <summary> /// Get Data based on TaskName /// </summary> /// <param name="DSTasksObject"></param> /// <returns></returns> public DominoServerTasks GetDataForTaskName(DominoServerTasks DSTasksObject) { DataTable DSTasksDataTable = new DataTable(); DominoServerTasks ReturnDSTObject = new DominoServerTasks(); try { string SqlQuery = "Select * from DominoServerTasks where TaskName='" + DSTasksObject.TaskName + "'"; DSTasksDataTable = objAdaptor.FetchData(SqlQuery); //populate & return data object if (DSTasksDataTable.Rows[0]["TaskID"].ToString() != "") { ReturnDSTObject.TaskID = int.Parse(DSTasksDataTable.Rows[0]["TaskID"].ToString()); } ReturnDSTObject.TaskName = DSTasksDataTable.Rows[0]["TaskName"].ToString(); ReturnDSTObject.ConsoleString = DSTasksDataTable.Rows[0]["ConsoleString"].ToString(); if (DSTasksDataTable.Rows[0]["RetryCount"].ToString() != "") { ReturnDSTObject.RetryCount = int.Parse(DSTasksDataTable.Rows[0]["RetryCount"].ToString()); } if (DSTasksDataTable.Rows[0]["FreezeDetect"].ToString() != "") { ReturnDSTObject.FreezeDetect = bool.Parse(DSTasksDataTable.Rows[0]["FreezeDetect"].ToString()); } if (DSTasksDataTable.Rows[0]["MaxBusyTime"].ToString() != "") { ReturnDSTObject.MaxBusyTime = int.Parse(DSTasksDataTable.Rows[0]["MaxBusyTime"].ToString()); } ReturnDSTObject.IdleString = DSTasksDataTable.Rows[0]["IdleString"].ToString(); ReturnDSTObject.LoadString = DSTasksDataTable.Rows[0]["LoadString"].ToString(); } catch (Exception ex) { throw ex; } finally { } return(ReturnDSTObject); }
//public DataTable GetTaskName(string TaskName) //{ // DataTable TasknameTable=new DataTable(); // try // { // string sqlQuery = "Select from DominoServerTasks "; // TasknameTable = objAdaptor.FetchData(sqlQuery); // } // catch // { // } // return TasknameTable; //} public DataTable GetName(DominoServerTasks NDObj) { //SametimeServers SametimeObj = new SametimeServers(); DataTable NDTable = new DataTable(); try { if (NDObj.TaskID == 0) { string sqlQuery = "Select * from [DominoServerTasks] where TaskName='" + NDObj.TaskName + "' "; NDTable = objAdaptor.FetchData(sqlQuery); } else { string sqlQuery = "Select * from [DominoServerTasks] where TaskName='" + NDObj.TaskName + "' and TaskID<>" + NDObj.TaskID + " "; NDTable = objAdaptor.FetchData(sqlQuery); } } catch (Exception ex) { throw ex; } return(NDTable); }
/// <summary> /// Update data into DominoServerTasks table /// </summary> /// <param name="DSTObject">DominoServerTasks object</param> /// <returns></returns> public Object UpdateData(DominoServerTasks DSTObject) { Object Update; try { string SqlQuery = "UPDATE DominoServerTasks SET TaskName='" + DSTObject.TaskName + "',ConsoleString='" + DSTObject.ConsoleString + "',RetryCount=" + DSTObject.RetryCount + ",FreezeDetect='" + DSTObject.FreezeDetect + "',MaxBusyTime=" + DSTObject.MaxBusyTime + ",IdleString='" + DSTObject.IdleString + "',LoadString='" + DSTObject.LoadString + "'WHERE TaskID = " + DSTObject.TaskID + ""; Update = objAdaptor.ExecuteNonQuery(SqlQuery); } catch { Update = false; } finally { } return(Update); }
/// <summary> /// Insert data into DominoServerTasks table /// </summary> /// <param name="DSTObject">DominoServerTasks object</param> /// <returns></returns> public bool InsertData(DominoServerTasks DSTObject) { bool Insert = false; try { string SqlQuery = "INSERT INTO DominoServerTasks (TaskName,ConsoleString,RetryCount,FreezeDetect," + " MaxBusyTime,IdleString,LoadString)VALUES('" + DSTObject.TaskName + "','" + DSTObject.ConsoleString + "'," + DSTObject.RetryCount + ",'" + DSTObject.FreezeDetect + "'," + DSTObject.MaxBusyTime + ",'" + DSTObject.IdleString + "','" + DSTObject.LoadString + "')"; Insert = objAdaptor.ExecuteNonQuery(SqlQuery); } catch { Insert = false; } finally { } return(Insert); }
protected void AssignButton_Click(object sender, EventArgs e) { //try //{ Object ReturnValue; Servers ServersObject; DominoServerTasks DSTaskObject; ServerTaskSettings STSettings; DataTable dt; DataTable dt2; DataTable dtsrv = new DataTable(); DataTable dtsrvtask = new DataTable(); string serverid = ""; string taskid = ""; if (SrvTaskCheckBoxList.SelectedItems.Count > 0) { dtsrvtask.Columns.Add("TaskID"); dtsrvtask.Columns.Add("TaskName"); dtsrvtask.Columns.Add("ServerID"); dtsrvtask.Columns.Add("Enabled"); dtsrvtask.Columns.Add("SendLoadCommand"); dtsrvtask.Columns.Add("SendRestartCommand"); dtsrvtask.Columns.Add("SendExitCommand"); dtsrvtask.Columns.Add("RestartOffHours"); dtsrv.Columns.Add("ID"); dtsrv.Columns.Add("ServerName"); dtsrv.Columns.Add("IPAddress"); dtsrv.Columns.Add("Description"); dtsrv.Columns.Add("ServerType"); dtsrv.Columns.Add("Location"); dtsrv.Columns.Add("LocationID"); for (int j = 0; j < SrvTaskCheckBoxList.Items.Count; j++) { if (SrvTaskCheckBoxList.Items[j].Selected) { SrvCheckBoxList.SelectAll(); if (SrvCheckBoxList.SelectedItems.Count > 0) { for (int i = 0; i < SrvCheckBoxList.SelectedItems.Count; i++) { DataRow drtask = dtsrvtask.NewRow(); drtask["TaskID"] = SrvTaskIDCheckBoxList.Items[j].Text; drtask["TaskName"] = SrvTaskCheckBoxList.Items[j].Text; drtask["ServerID"] = ""; drtask["Enabled"] = "true"; drtask["SendLoadCommand"] = "false"; drtask["SendRestartCommand"] = "false"; drtask["SendExitCommand"] = "false"; drtask["RestartOffHours"] = "false"; DataRow dr = dtsrv.NewRow(); dr["ID"] = ""; dr["ServerName"] = SrvCheckBoxList.SelectedItems[i].ToString(); dr["IPAddress"] = ""; dr["Description"] = "Production"; dr["ServerType"] = "Domino"; dr["Location"] = ""; dr["LocationID"] = 0; DSTaskObject = new DominoServerTasks(); DSTaskObject.TaskName = SrvTaskCheckBoxList.Items[j].Text; try { DSTaskObjectRet = VSWebBL.ConfiguratorBL.DominoServerTasksBL.Ins.GetDataForTaskName(DSTaskObject); } catch (Exception ex) { throw ex; } ServersObject = CollectDataForServers("Insert", dr); try { dt = VSWebBL.SecurityBL.ServersBL.Ins.GetDataByName(ServersObject); } catch (Exception ex) { throw ex; } if (dt.Rows.Count > 0) { drtask["ServerID"] = dt.Rows[0]["ID"].ToString(); serverid = dt.Rows[0]["ID"].ToString(); taskid = SrvTaskIDCheckBoxList.Items[j].Text; try { dt2 = VSWebBL.ConfiguratorBL.ServerTaskSettingsBL.Ins.SelectData(serverid, taskid); } catch (Exception ex) { throw ex; } if (dt2.Rows.Count == 0) { STSettings = CollectDataForServerTaskSettings("Insert", drtask); try { ReturnValue = VSWebBL.ConfiguratorBL.ServerTaskSettingsBL.Ins.InsertData(STSettings); } catch (Exception ex) { Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } } } } } } } } //10/3/2013 NS moved the code below outside of the task selection check to allow to proceed to the next page without any selection SrvTaskCheckBoxList.UnselectAll(); SrvCheckBoxList.UnselectAll(); Response.Redirect("~/Security/ImportServers4.aspx", false); //Mukund, 05Aug14, VSPLUS-844:Page redirect on callback Context.ApplicationInstance.CompleteRequest(); //} //catch (Exception ex) //{ // throw ex; //} }