Esempio n. 1
0
        public static void SaveSetting(string machineName, string applicationName,
                                       string groupName, string name, string value, string tag)
        {
            machineName     = machineName ?? PlayoutDbContext.DefaultName;
            applicationName = applicationName ?? PlayoutDbContext.DefaultName;

            using (var context = new PlayoutDbContext())
            {
                var scope = context.SettingScopes.Single(i => i.MachineName == machineName && i.ApplicationName == applicationName);
                groupName = groupName ?? PlayoutDbContext.DefaultName;

                var dbEntity = context.Settings.SingleOrDefault(s => s.ScopeId == scope.Id && s.Name == name && s.GroupName == groupName);
                if (dbEntity != null)
                {
                    dbEntity.Value = value;
                    dbEntity.Tag   = tag;
                }
                else
                {
                    var setting = new SettingInfo
                    {
                        ScopeId   = scope.Id,
                        GroupName = groupName,
                        Name      = name,
                        Value     = value,
                        Tag       = tag
                    };

                    context.Settings.Add(setting);
                }

                context.SaveChanges();
            }
        }
Esempio n. 2
0
        public static void DeleteMediaFile(MediaFileEntity entity, string applicationName, Guid userId, string userName)
        {
            using (var context = new PlayoutDbContext())
            {
                var item = context.MediaFiles.SingleOrDefault(i => i.Id == entity.Id);
                if (item != null)
                {
                    item.Deleted    = true;
                    item.DeleteTime = DateTime.Now;

                    var action = new UserAction();

                    action.ApplicationName = applicationName;

                    action.Category = UserActionCategory.Remove;
                    //action.Data=
                    action.Description = string.Format("素材ID:{3}, 标题:{0},原始文件名:{1},时长:{2}。",
                                                       entity.Title, entity.OriginalFileName, TimeSpan.FromSeconds(entity.Duration), entity.Id);

                    action.Name = "删除素材";
                    //action.Tag = "";
                    action.UserId   = userId;
                    action.UserName = userName;

                    context.UserActions.Add(action);
                    context.SaveChanges();
                }
            }
        }
Esempio n. 3
0
        public static void AddMediaFile(MediaFileEntity entity, string applicationName, Guid userId, string userName)
        {
            using (var context = new PlayoutDbContext())
            {
                entity.CreatorId        = userId;
                entity.OriginalFileName = System.IO.Path.GetFileName(entity.OriginalFileName);

                context.MediaFiles.Add(entity);
                var action = new UserAction();

                action.ApplicationName = applicationName;

                action.Category = UserActionCategory.Add;
                //action.Data=
                action.Description = string.Format("标题:{0},原始文件名:{1},时长:{2}。",
                                                   entity.Title, entity.OriginalFileName, TimeSpan.FromSeconds(entity.Duration));

                action.Name = "导入素材";
                //action.Tag = "";
                action.UserId   = userId;
                action.UserName = userName;
                context.UserActions.Add(action);

                context.SaveChanges();
            }
        }
Esempio n. 4
0
        public static void Save(IEnumerable <ChannelInfo> newItems, List <ChannelInfo> updatedItems, List <ChannelInfo> removeItems)
        {
            using (var context = new PlayoutDbContext())
            {
                //var allItems = context.ChannelInfos.ToArray();

                foreach (var item in newItems)
                {
                    context.ChannelInfos.Add(item);
                }

                foreach (var item in updatedItems)
                {
                    context.Entry(item).State = EntityState.Modified;
                }

                foreach (var item in removeItems)
                {
                    context.Entry(item).State = EntityState.Deleted;
                }

                try
                {
                    context.SaveChanges();
                }
                catch (Exception ex)
                {
                }
            }
        }
Esempio n. 5
0
 public static Guid AddPlayRecord(PlayRecord playRecord)
 {
     using (var context = new PlayoutDbContext())
     {
         context.PlayRecords.Add(playRecord);
         context.SaveChanges();
         return(playRecord.Id);
     }
 }
Esempio n. 6
0
        public static void SavePlaybill(PlaybillEntity billEntity, IList <PlayItemEntity> playItemEntities, IUser currentUser)
        {
            // NOTE:节目单时间冲突验证是通过数据库触发器来实现的。
            using (var context = new PlayoutDbContext())
            {
                if (billEntity.PlaybillItems != null)
                {
                    billEntity.PlaybillItems.Clear();
                }
                else
                {
                    billEntity.PlaybillItems = new List <PlaybillItemEntity>();
                }

                PlaybillEntity entity = billEntity;
                if (entity.Id != Guid.Empty)
                {
                    context.Database.ExecuteSqlCommand("delete from PlaybillItems where PlaybillId=@p0", billEntity.Id);

                    entity = context.Playbills.SingleOrDefault(i => i.Id == billEntity.Id);
                    if (entity == null)
                    {
                        return;
                    }
                    entity.PlaybillItems = new List <PlaybillItemEntity>();
                    entity.StartTime     = billEntity.StartTime;
                    entity.Duration      = billEntity.Duration;

                    entity.LastEditorId = currentUser.Id;
                }
                else
                {
                    entity.CreatorId    = currentUser.Id;
                    entity.LastEditorId = currentUser.Id;

                    context.Playbills.Add(entity);
                }

                for (int i = 0; i < playItemEntities.Count; i++)
                {
                    var playItemEntity = playItemEntities[i];
                    if (!entity.PlaybillItems.Contains(playItemEntity.PlaybillItem))
                    {
                        playItemEntity.PlaybillItem.Playbill = entity;
                        entity.PlaybillItems.Add(playItemEntity.PlaybillItem);
                    }
                    context.PlayItems.Add(playItemEntity);
                }

                // TODO: add action
                context.SaveChanges();
                if (billEntity.Id == Guid.Empty)
                {
                    billEntity.Id = entity.Id;
                }
            }
        }
Esempio n. 7
0
        public static void AddAction(UserAction action)
        {
            //action.CreationTime = DateTime.Now;

            using (var context = new PlayoutDbContext())
            {
                context.UserActions.Add(action);
                context.SaveChanges();
            }
        }
Esempio n. 8
0
        public static void Save(IEnumerable <BMDSwitcherInfo> newItems, List <BMDSwitcherInfo> updatedItems, List <BMDSwitcherInfo> removeItems,
                                Func <BMDSwitcherInfo, IEnumerable <BMDSwitcherInputInfo> > factory)
        {
            using (var context = new PlayoutDbContext())
            {
                var allItems = context.BMDSwitchers.ToArray();

                foreach (var item in newItems)
                {
                    context.BMDSwitchers.Add(item);

                    foreach (var inputItem in factory(item))
                    {
                        item.InputInfos.Add(inputItem);
                    }
                }


                foreach (var item in updatedItems)
                {
                    var updateItem = allItems.SingleOrDefault(i => i.Id == item.Id);
                    if (updateItem != null)
                    {
                        updateItem.Name    = item.Name;
                        updateItem.Address = item.Address;
                    }
                }

                foreach (var item in removeItems)
                {
                    var removeItem = allItems.SingleOrDefault(i => i.Id == item.Id);
                    if (removeItem != null)
                    {
                        context.BMDSwitchers.Remove(removeItem);
                    }
                }
                context.SaveChanges();
            }
        }
Esempio n. 9
0
        public static void Save(Guid switcherId, IEnumerable <BMDSwitcherInputInfo> switcherInputInfos)
        {
            using (var context = new PlayoutDbContext())
            {
                var dbEntities = context.BMDSwitchers.Include("InputInfos")
                                 .Single(i => i.Id == switcherId).InputInfos; // context.BMDSwitcherInputs.Where(i=>i.SwitcherId==switcherId).ToArray();
                foreach (var info in switcherInputInfos)
                {
                    var dbEntity = dbEntities.SingleOrDefault(i => i.Id == info.Id);
                    if (dbEntity != null && dbEntity.ChannelId != info.ChannelId)
                    {
                        dbEntity.ChannelId = info.ChannelId;
                    }
                }

                try
                {
                    context.SaveChanges();
                }
                catch (Exception ex)
                {
                }
            }
        }
Esempio n. 10
0
        public static void Register(string machineName, string applicationName)
        {
            using (var context = new PlayoutDbContext())
            {
                bool        changed    = false;
                var         machines   = context.Machines.ToList();
                var         machine    = machines.SingleOrDefault(m => m.Name == machineName);
                MachineInfo newMachine = null;
                if (machine == null)
                {
                    newMachine = new MachineInfo {
                        Name = machineName
                    };
                    context.Machines.Add(newMachine);

                    foreach (var app in context.Applications)
                    {
                        context.SettingScopes.Add(new SettingScope {
                            ApplicationName = app.Name, MachineName = machineName
                        });
                    }
                    changed = true;
                }

                var application = context.Applications.SingleOrDefault(a => a.Name == applicationName);
                if (application == null)
                {
                    context.Applications.Add(new ApplicationInfo {
                        Name = applicationName
                    });
                    bool found = false;
                    foreach (var mac in context.Machines.Local)
                    {
                        if (mac == newMachine)
                        {
                            found = true;
                        }
                        context.SettingScopes.Add(new SettingScope {
                            ApplicationName = applicationName, MachineName = mac.Name
                        });
                    }

                    if (newMachine != null && !found)
                    {
                        Debug.WriteLine("未发现新的MachineName");

                        context.SettingScopes.Add(new SettingScope {
                            ApplicationName = applicationName, MachineName = machineName
                        });
                    }
                    else
                    {
                        Debug.WriteLine("已发现新的MachineName");
                    }
                    changed = true;
                }

                if (changed)
                {
                    context.SaveChanges();
                }
            }
        }