/// <summary>
/// Update data of ServerTaskSettings table
/// </summary>
/// <param name="objDominoServers">ServerTaskSettings object</param>
/// <returns></returns>
public Object UpdateData(ServerTaskSettings STSettingsObject)
{
Object Update;
try
{
//string SqlQuery = "Update ServerTaskSettings SET Enabled= " + STSettingsObject.Enabled +
// ", RestartOffHours=" + STSettingsObject.RestartOffHours + ", SendLoadCommand=" +
// STSettingsObject.SendLoadCommand + ", SendExitCommand=" + STSettingsObject.SendExitCommand +
// ", SendRestartCommand=" + STSettingsObject.SendRestartCommand + " " +
// "Where MyID=" + STSettingsObject.MyID + " AND TaskID=" + STSettingsObject.TaskID;
string SqlQuery = "Update ServerTaskSettings SET Enabled= '" + STSettingsObject.Enabled +
"', IsMinTasksEnabled='" + STSettingsObject.IsMinTasksEnabled + "',SendMinTasksLoadCmd='" + STSettingsObject.SendMinTasksLoadCmd + "', MinNoOfTasks=" + STSettingsObject.MinNoOfTasks + ", RestartOffHours='" + STSettingsObject.RestartOffHours + "', SendLoadCommand='" +
STSettingsObject.SendLoadCommand + "', SendExitCommand='" + STSettingsObject.SendExitCommand +
"', SendRestartCommand='" + STSettingsObject.SendRestartCommand + "',TaskID=" + STSettingsObject.TaskID +
" Where MyID=" + STSettingsObject.MyID;
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
/// <summary>
/// Call DAL Insert Data
/// </summary>
/// <param name="STSettingsObject"></param>
/// <returns></returns>
public Object InsertData(ServerTaskSettings STSettingsObject)
{
try
{
return(VSWebDAL.ConfiguratorDAL.ServerTaskSettingsDAL.Ins.InsertData(STSettingsObject));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Delete data of ServerTaskSettings table
/// </summary>
/// <param name="objDominoServers">ServerTaskSettings object</param>
/// <returns></returns>
public Object DeleteData(ServerTaskSettings STSettingsObject)
{
Object Update;
try
{
string SqlQuery = "Delete ServerTaskSettings Where MyID=" + STSettingsObject.MyID;
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
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 { }
}
/// <summary>
/// Insert data into ServerTaskSettings table
/// </summary>
/// <param name="objDominoServers">ServerTaskSettings object</param>
/// <returns></returns>
public Object InsertData(ServerTaskSettings STSettingsObject)
{
Object Update;
try
{
string SqlQuery = "INSERT INTO ServerTaskSettings(TaskID ,ServerID,[Enabled],SendLoadCommand,SendRestartCommand," +
"SendExitCommand,RestartOffHours,MinNoOfTasks,IsMinTasksEnabled,SendMinTasksLoadCmd)" +
" VALUES(" + STSettingsObject.TaskID + "," + STSettingsObject.ServerID +
",'" + STSettingsObject.Enabled + "','" + STSettingsObject.SendLoadCommand +
"','" + STSettingsObject.SendRestartCommand + "','" + STSettingsObject.SendExitCommand +
"','" + STSettingsObject.RestartOffHours + "'," + STSettingsObject.MinNoOfTasks +
",'" + STSettingsObject.IsMinTasksEnabled + "','" + STSettingsObject.SendMinTasksLoadCmd + "')";
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
