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