public void CanCustomRepository() { PersistentVariableRepository persistencevariableRepository = new PersistentVariableRepository(); HatCMS.CmsPersistentVariable variable = persistencevariableRepository.FetchbyName("LastPeriodicTaskStartTime_HatCms.Admin.BackgroundTasks.EmailConfigErrors"); Assert.That(variable.Name, Is.EqualTo("LastPeriodicTaskStartTime_HatCms.Admin.BackgroundTasks.EmailConfigErrors")); }
public void CanCreatePersistenVariable() { HatCMS.CmsPersistentVariable persistentvariable = new HatCMS.CmsPersistentVariable(); persistentvariable.Name = "testname"; Assert.IsNotNull(persistentvariable); Assert.That(persistentvariable.Name, Is.EqualTo("testname")); }
private static void SaveLastPeriodicTaskStartTime(CmsBackgroundTask task, DateTime startTime) { string persistentVariableName = getLastStartPersistentVariableName(task); CmsPersistentVariable v = CmsPersistentVariable.Fetch(persistentVariableName); v.Name = persistentVariableName; v.PersistedValue = startTime; v.SaveToDatabase(); }
/// <summary> /// returns DateTime.MinValue if the task has never been run, or if the last run time could not be determined. /// </summary> /// <param name="task"></param> /// <returns></returns> private static DateTime GetLastPeriodicTaskStartTime(CmsBackgroundTask task) { string persistentVariableName = getLastStartPersistentVariableName(task); CmsPersistentVariable v = CmsPersistentVariable.Fetch(persistentVariableName); if (v.Name == persistentVariableName) { return((DateTime)v.PersistedValue); } return(DateTime.MinValue); }
private CmsPersistentVariable GetFromRow(DataRow dr) { string Name = (dr["Name"]).ToString(); byte[] bytes = (byte[])dr["PersistedValue"]; CmsPersistentVariable item = new CmsPersistentVariable(Name, DeSerialize(bytes)); item.persistentvariableid = Convert.ToInt32(dr["PersistentVariableId"]); return(item); } // GetFromRow
} // constructor public virtual bool SaveToDatabase() { IRepository <CmsPersistentVariable> repository = new Repository <CmsPersistentVariable>(); CmsPersistentVariable returnPersistenVariable = repository.SaveOrUpdate(this); if (returnPersistenVariable.Id > 0) { return(true); } else { return(false); } } // SaveToDatabase
} // Insert public bool Update(CmsPersistentVariable item) { using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(ConfigUtils.getConfigValue("ConnectionString", ""))) { OpenMySqlConnection(conn); MySql.Data.MySqlClient.MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "UPDATE persistentvariables set Name = @Name, PersistedValue = @PersistedValue where PersistentVariableId = @PersistentVariableId;"; cmd.Parameters.AddWithValue("@Name", item.Name); cmd.Parameters.AddWithValue("@PersistedValue", Serialize(item.PersistedValue)); cmd.Parameters.AddWithValue("@PersistentVariableId", item.persistentvariableid); int numUpdated = cmd.ExecuteNonQuery(); if (numUpdated < 1) { return(false); } return(true); } } // Update
public bool Insert(CmsPersistentVariable item) { using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(ConfigUtils.getConfigValue("ConnectionString", ""))) { OpenMySqlConnection(conn); MySql.Data.MySqlClient.MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO persistentvariables (Name, PersistedValue) VALUES(@Name, @PersistedValue);"; cmd.Parameters.AddWithValue("@Name", item.Name); cmd.Parameters.AddWithValue("@PersistedValue", Serialize(item.PersistedValue)); int numInserted = cmd.ExecuteNonQuery(); if (numInserted < 1) { return(false); } int newId = Convert.ToInt32(cmd.LastInsertedId); item.persistentvariableid = newId; return(true); } } // Insert
public static void Delete(CmsPersistentVariable persistentVariableToDelete) { PersistentVariableRepository repository = new PersistentVariableRepository(); repository.Delete(persistentVariableToDelete); } // Delete
} // FetchAll public static bool Delete(CmsPersistentVariable persistentVariableToDelete) { return((new PersistentVariableDB()).Delete(persistentVariableToDelete.persistentvariableid)); } // Delete