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