public static void initmp(Template.ImportTemplate tmp) { if (noindex.Count == 0) { foreach (var x in tmp.ColumnMapping.Values) { if (x.Tablename.ToUpper() == "ST_DT") { string colname = x.SystemColumnShowName; if (noindex.ContainsKey(colname)) continue; noindex.Add(colname, false); } } } }
public Boolean RemoveTemplate(Template templateName) { InitDB(); using (var session = documentStore.OpenSession()) { if (templateName.Zonename == "_template") { var tc = from x in session.Query<Template>() where x.Name == templateName.Name select x; session.Delete(tc); } else { Template newTemplate = new Template(); newTemplate = session.Load<Template>(templateName.Id); session.Delete(newTemplate); } session.SaveChanges(); return true; } return false; }
public Boolean InsertTemplate(Template template) { InitDB(); using (var session = documentStore.OpenSession()) { Template newTemplate = new Template(); newTemplate.Name = template.Name; newTemplate.Description = template.Description; newTemplate.Created = DateTime.Now; newTemplate.Zonename = template.Zonename; newTemplate.Zonedescription = template.Zonedescription; newTemplate.Opacity = template.Opacity; newTemplate.X = template.X; newTemplate.Y = template.Y; newTemplate.Width = template.Width; newTemplate.Height = template.Height; if (template.Zonename == "_template") { Template newZone = new Template(); newZone.Name = template.Name; newZone.X = 0; newZone.Y = 0; newZone.Width = 1024; newZone.Height = 768; newZone.Opacity = 1; newZone.Zonename = "Background"; newZone.Zonedescription = "Template Background"; session.Store(newZone); } session.Store(newTemplate); session.SaveChanges(); return true; } return false; }
public ObservableCollection<Template> CollectZonesForTemplate(Template zone) { InitDB(); try { using (var session = documentStore.OpenSession()) { var lc = from x in session.Query<Template>() where x.Name == zone.Name && x.Zonename != "_template" select x; return new ObservableCollection<Template>(lc); } } catch (Exception ex) { } return null; }
public ObservableCollection<LoopContent> CollectLoopContentForZone(Template zone, Loop loop) { InitDB(); using (var session = documentStore.OpenSession()) { var lc = from x in session.Query<LoopContent>() where x.Zoneid == zone.Id && x.Loopid == loop.Id select x; return new ObservableCollection<LoopContent>(lc); } return null; }
public Boolean ChangeTemplate(Template templateName) { InitDB(); Template newTemplate = new Template(); using (var session = documentStore.OpenSession()) { newTemplate = session.Load<Template>(templateName.Id); newTemplate.Name = templateName.Name; newTemplate.Description = templateName.Description; newTemplate.Zonename = templateName.Zonename; newTemplate.Zonedescription = templateName.Zonedescription; newTemplate.X = templateName.X; newTemplate.Y = templateName.Y; newTemplate.Width = templateName.Width; newTemplate.Height = templateName.Height; newTemplate.Opacity = templateName.Opacity; session.Store(newTemplate); session.SaveChanges(); return true; } return false; }
public string ChangeMedia(Content mediaName) { InitDB(); Template newTemplate = new Template(); Content newMedia = new Content(); string functionResult = "0"; using (var session = documentStore.OpenSession()) { newMedia = session.Load<Content>(mediaName.Id); newMedia.Contenttype = mediaName.Contenttype; newMedia.Metadata1 = mediaName.Metadata1; newMedia.Metadata2 = mediaName.Metadata2; newMedia.Metadata3 = mediaName.Metadata3; newMedia.Metadata4 = mediaName.Metadata4; newMedia.Metadata5 = mediaName.Metadata5; newMedia.Metadata6 = mediaName.Metadata6; newMedia.Metadata7 = mediaName.Metadata7; newMedia.Metadata8 = mediaName.Metadata8; newMedia.Metadata9 = mediaName.Metadata9; newMedia.Importdate = mediaName.Importdate; newMedia.Filesize = mediaName.Filesize; newMedia.Filelocation = mediaName.Filelocation; newMedia.Description = mediaName.Description; newMedia.Name = mediaName.Name; newMedia.Snapshot = mediaName.Snapshot; newMedia.Uploadstatus = mediaName.Uploadstatus; session.Store(newMedia); functionResult = newMedia.Id; } //newMedia.LoadByPrimaryKey((long)mediaName.Id); //AddUpdateDelta("content"); return functionResult; }