public async Task <DaoResultMessage> Add2Account(string accountId, TranscodeTemplateEntity entity) { DaoResultMessage message = new DaoResultMessage(); try { using (var context = new DjLiveCpContext()) { var dbentity = context.Account.FirstOrDefault(obj => obj.Id == accountId); if (dbentity != null) { entity.AccountEntities.Add(dbentity); context.TranscodeTemplate.Add(entity); await context.SaveChangesAsync(); } else { message.Code = DaoResultCode.ItemNotExist; message.Message = "修改失败,对象不存在!"; } } } catch (Exception e) { LogHelper.Error(e.Message, e); message.Code = DaoResultCode.UnExpectError; message.Message = e.Message; } return(message); }
public async Task <int> GetTranscodeTemplatesCount(string userId, TranscodeTemplateEntity entityDelta) { try { using (var context = new DjLiveCpContext()) { var sql = $@"SELECT Count(0) FROM sys_transcodetemplate"; var paraObjects = new object[] { }; if (!string.IsNullOrEmpty(userId)) { sql = $@"SELECT Count(0) FROM sys_transcodetemplate as b join sys_alli_account_transcodetemplate as c on c.AccountId = {"{0}"} and b.Id = c.TemplateId"; paraObjects = new object[] { userId }; } var objs = context.Database.SqlQuery <int>(sql, paraObjects); return(await objs.FirstOrDefaultAsync()); } } catch (Exception e) { LogHelper.Error(e.Message, e); return(0); } }
public async Task <List <TranscodeTemplateModel> > GetSimpleTranscodeTemplates(string userId, int page, int countPerPage, TranscodeTemplateModel delta) { try { TranscodeTemplateEntity entityDelta = null; if (delta != null) { entityDelta = new TranscodeTemplateEntity() { Name = delta.Name }; } var entities = await TranscodeDao.GetTranscodeTemplateEntitys(page, countPerPage, userId, entityDelta); return(entities?.Select(item => new TranscodeTemplateModel() { Id = item.Id, Name = item.Name, AppName = item.AppName, Description = item.Name, }).ToList()); } catch (Exception e) { throw; } }
public async Task <int> GetTranscodeTemplatesCount(string userId, TranscodeTemplateModel delta) { try { TranscodeTemplateEntity entityDelta = null; if (delta != null) { entityDelta = new TranscodeTemplateEntity() { Name = delta.Name }; } return(await TranscodeDao.GetTranscodeTemplatesCount(userId, entityDelta)); } catch (Exception e) { throw; } }
public async Task <DaoResultMessage> UpdateTranscodeTemplateEntity(string id, TranscodeTemplateEntity entity) { DaoResultMessage message = new DaoResultMessage(); try { using (var context = new DjLiveCpContext()) { var dbentity = context.TranscodeTemplate.FirstOrDefault(obj => obj.Id == id); if (dbentity != null && entity != null) { dbentity.AudioOption = string.IsNullOrEmpty(entity.AudioOption) ? dbentity.AudioOption : entity.AudioOption; dbentity.VideoOption = string.IsNullOrEmpty(entity.VideoOption) ? dbentity.VideoOption : entity.VideoOption; dbentity.Name = string.IsNullOrEmpty(entity.Name) ? dbentity.Name : entity.Name; context.TranscodeTemplate.Attach(dbentity); context.Entry(dbentity).Property(x => x.Id).IsModified = false; context.Entry(dbentity).Property(x => x.AudioOption).IsModified = true; context.Entry(dbentity).Property(x => x.VideoOption).IsModified = true; context.Entry(dbentity).Property(x => x.Name).IsModified = true; await context.SaveChangesAsync(); message.Code = DaoResultCode.Success; message.Message = "修改成功!"; message.para = entity; } else { message.Code = DaoResultCode.ItemNotExist; message.Message = "修改失败,对象不存在!"; } } } catch (Exception e) { LogHelper.Error(e.Message, e); message.Code = DaoResultCode.UnExpectError; message.Message = e.Message; } return(message); }
public async Task <DaoResultMessage> CreateTranscodeTemplateEntity(string id, TranscodeTemplateEntity entity) { DaoResultMessage message = new DaoResultMessage(); try { using (var context = new DjLiveCpContext()) { entity.Id = id; var item = context.TranscodeTemplate.Add(entity); await context.SaveChangesAsync(); message.Code = DaoResultCode.Success; message.Message = "添加成功!"; message.para = item; } } catch (Exception e) { LogHelper.Error(e.Message, e); message.Code = DaoResultCode.UnExpectError; message.Message = e.Message; } return(message); }
public async Task <List <TranscodeTemplateEntity> > GetTranscodeTemplateEntitys(int page, int countPerPage, string userId = "", TranscodeTemplateEntity delta = null) { try { using (var context = new DjLiveCpContext()) { var sql = $@"SELECT * FROM sys_transcodetemplate limit {(page - 1) * countPerPage},{countPerPage}"; var paraObjects = new object[] { }; if (!string.IsNullOrEmpty(userId)) { sql = $@"SELECT * FROM sys_transcodetemplate as b join sys_alli_account_transcodetemplate as c on c.AccountId = {"{0}"} and b.Id = c.TemplateId limit {(page - 1) * countPerPage},{countPerPage}"; paraObjects = new object[] { userId }; } var objs = context.Database.SqlQuery <TranscodeTemplateEntity>(sql, paraObjects); return(await objs.ToListAsync()); } } catch (Exception e) { LogHelper.Error(e.Message, e); return(null); } }