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(); } }
public static ChannelInfo GetChannelInfo(Guid id) { using (var context = new PlayoutDbContext()) { return(context.ChannelInfos.SingleOrDefault(i => i.Id == id)); } }
public static IEnumerable <BMDSwitcherInfo> GetBMDSwitcherInfos() { using (var context = new PlayoutDbContext()) { return(context.BMDSwitchers.ToArray()); } }
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) { } } }
public static UserEntity GetUser(string name, string password) { using (var context = new PlayoutDbContext()) { return(context.Users.Include(u => u.Roles).SingleOrDefault(u => u.Name == name && u.Password == password && !u.Locked)); } }
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(); } }