/// <summary> /// create a mapping /// </summary> public void CreateMappings(List<KeyValuePair<string, string>> keyvaluePairs, int mappingTypeId) { using (var context = new MappingModelContainer()) { var lastMappingId = GetLastMappingId(); foreach (var keyValuePair in keyvaluePairs) { var m = Mapping.CreateMapping(++lastMappingId, keyValuePair.Key, keyValuePair.Value, mappingTypeId); context.AddToMapping(m); context.SaveChanges(); } } }
///// <summary> ///// Reads the XML. ///// </summary> ///// <param name="path">The path.</param> //public void ReadXml(string path) //{ // var serializer = new DataContractSerializer((typeof(List<KeyValuePair<string, string>>))); // _encodingCharacterMap = serializer.ReadObject(XmlReader.Create(path)) as List<KeyValuePair<string, string>>; //} ///// <summary> ///// Writes the XML. ///// </summary> //public void WriteXml() //{ // var dataContractSerializer = new DataContractSerializer(typeof(List<KeyValuePair<string, string>>)); // using (XmlWriter writer = XmlWriter.Create((_path))) // { // dataContractSerializer.WriteObject(writer, GetCharacterMap()); // } //} //entity framework /// <summary> /// Creates the type of the mapping. /// </summary> /// <param name="id">The id.</param> /// <param name="mappingTypeName">Name of the mapping type.</param> public void CreateMappingType(int id, string mappingTypeName) { using (var context = new MappingModelContainer()) { context.AddToMappingType(MappingType.CreateMappingType(id, mappingTypeName)); context.SaveChanges(); } }
/// <summary> /// Gets the last mapping id. /// TODO: Get once this method and cache this /// </summary> /// <returns></returns> private int GetLastMappingId() { using (var context = new MappingModelContainer()) { var result = (from c in context.Mapping select c).OrderByDescending(m => m.ID).FirstOrDefault(); return result == null ? 0 : result.ID; } }
/// <summary> /// Clears all Mappings from database /// </summary> private void ClearMappings(int mappingTypeId) { using (var context = new MappingModelContainer()) { foreach (Mapping map in GetMappings(mappingTypeId)) { Mapping mappings = CqMappingById.Invoke(context, map.ID); context.Mapping.DeleteObject(mappings); context.SaveChanges(); } } }
public List<MappingType> GetMappingTypes() { using (var context = new MappingModelContainer()) { return (from c in context.MappingType select c).ToList(); } }
/// <summary> /// get all mappings /// </summary> /// <returns></returns> public List<Mapping> GetMappings(int mappingTypeId) { using (var context = new MappingModelContainer()) { List<Mapping> res = (from c in context.Mapping where c.MappingTypeId == mappingTypeId select c).ToList(); return res; } }