internal static void MultipleDeletePage(int[] ids) { if (ids.Length > 0) { DefaultRepository.Delete <PageDAL>(ids); } }
internal static ContentForm UpdateForm(ContentForm form) { var dal = MapperFacade.ContentFormMapper.GetDalObject(form); dal = DefaultRepository.SimpleUpdate(dal); return(MapperFacade.ContentFormMapper.GetBizObject(dal)); }
internal static void MultipleDeleteObjectFormatVersion(int[] ids) { if (ids.Length > 0) { DefaultRepository.Delete <ObjectFormatVersionDAL>(ids); } }
public static void MultipleDelete(int[] ids) { if (ids.Length > 0) { DefaultRepository.Delete <NotificationsDAL>(ids); } }
internal static Container UpdateContainer(Container container) { var dal = MapperFacade.ContainerMapper.GetDalObject(container); dal = DefaultRepository.SimpleUpdate(dal); return(MapperFacade.ContainerMapper.GetBizObject(dal)); }
internal static void Delete(int id) { using (var scope = new QPConnectionScope()) { if (QPContext.DatabaseType == DatabaseType.SqlServer) { ChangeDeleteBindingsTriggerState(false); } var bindings = QPContext.EFContext.ContentWorkflowBindSet.Where(n => n.WorkflowId == id).ToArray(); DefaultRepository.SimpleDeleteBulk(bindings); var bindings2 = QPContext.EFContext.ArticleWorkflowBindSet.Where(n => n.WorkflowId == id).ToArray(); DefaultRepository.SimpleDeleteBulk(bindings2); var waits = QPContext.EFContext.WaitingForApprovalSet.Include(n => n.Article.WorkflowBinding) .Where(n => n.Article.WorkflowBinding.WorkflowId == id).ToArray(); DefaultRepository.SimpleDeleteBulk(waits); DefaultRepository.Delete <WorkflowDAL>(id); if (QPContext.DatabaseType == DatabaseType.SqlServer) { ChangeDeleteBindingsTriggerState(true); } } }
public static void Delete(ContentConstraint constraint) { if (constraint == null) { throw new ArgumentNullException(nameof(constraint)); } if (constraint.IsNew) { throw new ArgumentException("Метод вызван для несуществующего в БД ContentConstraint"); } using (var scope = new QPConnectionScope()) { try { if (QPContext.DatabaseType == DatabaseType.SqlServer) { ChangeContentIndexesTriggerState(scope.DbConnection, false); } var dal = MapperFacade.ContentConstraintMapper.GetDalObject(constraint); Common.DropComplexIndex(scope.DbConnection, dal); DefaultRepository.Delete <ContentConstraintDAL>(constraint.Id); } finally { if (QPContext.DatabaseType == DatabaseType.SqlServer) { ChangeContentIndexesTriggerState(scope.DbConnection, true); } } } }
internal static void RemoveUserQuerySourcesInfo(Content uqVirtualContent) { var virtualContentId = uqVirtualContent.Id; var recToRemove = QPContext.EFContext.UserQueryContentsSet.Where(u => u.VirtualContentId == virtualContentId).ToArray(); DefaultRepository.SimpleDelete(recToRemove); }
/// <summary> /// Добавляет новый сайт /// </summary> /// <param name="site">информация о сайте</param> /// <returns>информация о сайте</returns> internal static Site Save(Site site) { using (var scope = new QPConnectionScope()) { if (QPContext.DatabaseType == DatabaseType.SqlServer) { ChangeInsertAccessTriggerState(false); ChangeInsertDefaultTriggerState(false); DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.Site, site); } var fieldValues = site.QpPluginFieldValues; var result = DefaultRepository.Save <Site, SiteDAL>(site); CommonSecurity.CreateSiteAccess(scope.DbConnection, result.Id); CreateDefaultStatuses(result); CreateDefaultNotificationTemplate(result); CreateDefaultGroup(result); UpdatePluginValues(fieldValues, result.Id); if (QPContext.DatabaseType == DatabaseType.SqlServer) { DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.Site); ChangeInsertAccessTriggerState(true); ChangeInsertDefaultTriggerState(true); } return(result); } }
public IEnumerable <BackendActionLog> Save(IEnumerable <BackendActionLog> logs) { IEnumerable <BackendActionLogDAL> toSave = MapperFacade.BackendActionLogMapper.GetDalList(logs.ToList()); var saved = DefaultRepository.SimpleSaveBulk(toSave); return(MapperFacade.BackendActionLogMapper.GetBizList(saved.ToList())); }
public SessionsLog Update(SessionsLog session) { var sessionsLogDal = MapperFacade.SessionsLogMapper.GetDalObject(session); sessionsLogDal = DefaultRepository.SimpleUpdate(sessionsLogDal); return(MapperFacade.SessionsLogMapper.GetBizObject(sessionsLogDal)); }
internal static void RemoveUnionSourcesInfo(Content virtualContent) { var virtualContentId = virtualContent.Id; var context = QPContext.EFContext; var recToRemove = context.UnionContentsSet.Where(u => u.VirtualContentId == virtualContentId).ToArray(); DefaultRepository.SimpleDeleteBulk(recToRemove, context); }
internal static Notification SaveProperties(Notification notification) { DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.Notification, notification); var result = DefaultRepository.Save <Notification, NotificationsDAL>(notification); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.Notification); return(result); }
/// <summary> /// Обновляет информацию о сайте /// </summary> /// <param name="site">информация о сайте</param> /// <returns>информация о сайте</returns> internal static Site Update(Site site) { var fieldValues = site.QpPluginFieldValues; var result = DefaultRepository.Update <Site, SiteDAL>(site); UpdatePluginValues(fieldValues, result.Id); return(result); }
internal static VisualEditorStyle SaveStyleProperties(VisualEditorStyle visualEditorStyle) { DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.VisualEditorStyle, visualEditorStyle); var result = DefaultRepository.Save <VisualEditorStyle, VeStyleDAL>(visualEditorStyle); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.VisualEditorStyle); return(result); }
/// <summary> /// Добавляет новый сайт /// </summary> /// <param name="site">информация о сайте</param> /// <returns>информация о сайте</returns> internal static Site Save(Site site) { DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.Site, site); var result = DefaultRepository.Save <Site, SiteDAL>(site); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.Site); return(result); }
internal static Field Save(Field item) { DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.Field, item); var newItem = DefaultRepository.Save <Field, FieldDAL>(item); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.Field); return(newItem); }
/// <summary> /// Добавляет новый виртуальный контент /// </summary> internal static Content Save(Content content) { DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.Content, content); var newContent = DefaultRepository.Save <Content, ContentDAL>(content); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.Content); return(newContent); }
internal static StatusType SaveProperties(StatusType statusType) { DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.StatusType); var result = DefaultRepository.Save <StatusType, StatusTypeDAL>(statusType); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.StatusType); return(result); }
protected override Folder UpdateInDb(Folder folder) { using (var scope = new QPConnectionScope()) { Common.UpdateContentSubFoldersPath(scope.DbConnection, folder.Id, folder.Path, QPContext.CurrentUserId, DateTime.Now); } return(DefaultRepository.Update <ContentFolder, ContentFolderDAL>((ContentFolder)folder)); }
private static void CreateDefaultGroup(Site site) { var group = new ContentGroupDAL() { Name = ContentGroup.DefaultName, SiteId = site.Id }; DefaultRepository.SimpleSave(group); }
internal static void SaveAppSettings(IEnumerable <AppSettingsItem> values) { var result = values.Select(n => new AppSettingsDAL() { Key = n.Key, Value = n.Value }).ToList(); DefaultRepository.SimpleSaveBulk(result); }
public static Db Update(Db db) { var result = DefaultRepository.Update <Db, DbDAL>(db); DeleteAppSettings(); SaveAppSettings(db.AppSettings); result.AppSettings = db.AppSettings; return(result); }
internal static Workflow SaveProperties(Workflow workflow) { using (new QPConnectionScope()) { var entities = QPContext.EFContext; UpdateRuleOrder(workflow); var forceIds = workflow.ForceRulesIds == null ? null : new Queue <int>(workflow.ForceRulesIds); workflow.LastModifiedBy = QPContext.CurrentUserId; workflow.Created = Common.GetSqlDate(QPConnectionScope.Current.DbConnection); workflow.Modified = workflow.Created; if (workflow.ForceId > 0) { workflow.Id = workflow.ForceId; } var dal = MapperFacade.WorkflowMapper.GetDalObject(workflow); entities.Entry(dal).State = EntityState.Added; if (QPContext.DatabaseType == DatabaseType.SqlServer) { DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.Workflow, workflow); ChangeInsertAccessTriggerState(false); } entities.SaveChanges(); workflow.Id = (int)dal.Id; CommonSecurity.CreateWorkflowAccess(QPConnectionScope.Current.DbConnection, workflow.Id); if (QPContext.DatabaseType == DatabaseType.SqlServer) { DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.Workflow); ChangeInsertAccessTriggerState(true); } foreach (var rule in workflow.WorkflowRules) { rule.WorkflowId = workflow.Id; if (forceIds != null) { rule.Id = forceIds.Dequeue(); } var dalRule = MapperFacade.WorkFlowRuleMapper.GetDalObject(rule); entities.Entry(dalRule).State = EntityState.Added; } DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.WorkflowRule); entities.SaveChanges(); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.WorkflowRule); return(MapperFacade.WorkflowMapper.GetBizObject(dal)); } }
internal static void Delete(int id) { using (var scope = new QPConnectionScope()) { ChangeDeleteValuesTriggerState(scope.DbConnection, false); DefaultRepository.Delete <PluginDAL>(id); Common.DropPluginTables(scope.DbConnection, id); ChangeDeleteValuesTriggerState(scope.DbConnection, true); } }
internal static QpPlugin SaveProperties(QpPlugin plugin) { var entities = QPContext.EFContext; DateTime timeStamp; using (var scope = new QPConnectionScope()) { timeStamp = Common.GetSqlDate(scope.DbConnection); var dal = MapperFacade.QpPluginMapper.GetDalObject(plugin); dal.LastModifiedBy = QPContext.CurrentUserId; dal.Modified = timeStamp; dal.Created = timeStamp; entities.Entry(dal).State = EntityState.Added; DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.QpPlugin, plugin); if (plugin.ForceId != 0) { dal.Id = plugin.ForceId; } entities.SaveChanges(); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.QpPlugin); Common.CreatePluginTables(scope.DbConnection, (int)dal.Id); var forceIds = plugin.ForceFieldIds == null ? null : new Queue <int>(plugin.ForceFieldIds); var fields = new List <PluginFieldDAL>(); foreach (var field in plugin.Fields) { var dalField = MapperFacade.QpPluginFieldMapper.GetDalObject(field); dalField.PluginId = dal.Id; if (forceIds != null) { dalField.Id = forceIds.Dequeue(); } entities.Entry(dalField).State = EntityState.Added; fields.Add(dalField); } DefaultRepository.TurnIdentityInsertOn(EntityTypeCode.QpPluginField); entities.SaveChanges(); DefaultRepository.TurnIdentityInsertOff(EntityTypeCode.QpPluginField); foreach (var field in fields) { Common.AddPluginColumn(scope.DbConnection, field); } return(MapperFacade.QpPluginMapper.GetBizObject(dal)); } }
internal static BllObject UpdateObjectProperties(BllObject bllObject) { var oldObject = GetObjectPropertiesById(bllObject.Id); var result = DefaultRepository.Update <BllObject, ObjectDAL>(bllObject); ManageObjectType(bllObject, oldObject, result); DeleteDefaultValues(result.Id); SetDefaultValues(bllObject.DefaultValues, result.Id); return(result); }
private static void CreateDefaultStatuses(Site site) { var statuses = new StatusTypeDAL[] { GetNewBuiltInStatus(site, 10, "Created", "Article has been created"), GetNewBuiltInStatus(site, 50, "Approved", "Article has been approved"), GetNewBuiltInStatus(site, 100, "Published", "Article has been published"), GetNewBuiltInStatus(site, 0, "None", "No Status has been assigned") }; DefaultRepository.SimpleSaveBulk(statuses); }
/// <summary> /// Сохранить записи в таблице union_contents /// </summary> internal static void RecreateUserQuerySourcesInfo(Content uqVirtualContent) { var virtualContentId = uqVirtualContent.Id; RemoveUserQuerySourcesInfo(uqVirtualContent); DefaultRepository.SimpleSave(uqVirtualContent.UserQueryContentViewSchema.SelectUniqContentIDs().Select(id => new UserQueryContentsDAL { IsIdSource = false, RealContentId = id, VirtualContentId = virtualContentId })); }
public static void Delete(ContentConstraint constraint) { if (constraint == null) { throw new ArgumentNullException(nameof(constraint)); } if (constraint.IsNew) { throw new ArgumentException("Метод вызван для несуществующего в БД ContentConstraint"); } DefaultRepository.Delete <ContentConstraintDAL>(constraint.Id); }