/// <summary> /// Обновляем запись /// </summary> /// <param name="material">Новость</param> /// <returns></returns> public override bool updateCmsMaterial(MaterialsModel material) { try { using (var db = new CMSdb(_context)) { using (var tran = db.BeginTransaction()) { content_materials cdMaterial = db.content_materialss .Where(p => p.id == material.Id) .SingleOrDefault(); if (cdMaterial == null) { throw new Exception("Запись с таким Id не найдена"); } cdMaterial.c_title = material.Title; cdMaterial.c_alias = material.Alias; cdMaterial.c_text = material.Text; cdMaterial.d_date = material.Date; if (material.PreviewImage != null) { cdMaterial.c_preview = material.PreviewImage.Url; } else { cdMaterial.c_preview = null; } cdMaterial.c_url = material.Url; cdMaterial.c_url_name = material.UrlName; cdMaterial.c_desc = material.Desc; cdMaterial.c_keyw = material.Keyw; cdMaterial.b_important = material.Important; cdMaterial.b_disabled = material.Disabled; cdMaterial.n_day = material.Date.Day; cdMaterial.n_month = material.Date.Month; cdMaterial.n_year = material.Date.Year; db.Update(cdMaterial); db_updateMaterialGroups(db, material.Id, material.GroupsId); var log = new LogModel() { Site = _domain, Section = LogSection.Materials, Action = LogAction.update, PageId = material.Id, PageName = material.Title, UserId = _currentUserId, IP = _ip, }; insertLog(log); tran.Commit(); return(true); } } } catch { return(false); } }
/// <summary> /// Добавляем запись /// </summary> /// <param name="material">Новость</param> /// <returns></returns> public override bool insertCmsMaterial(MaterialsModel material) { try { using (var db = new CMSdb(_context)) { using (var tran = db.BeginTransaction()) { content_materials cdMaterial = db.content_materialss .Where(p => p.id == material.Id) .SingleOrDefault(); if (cdMaterial != null) { throw new Exception("Запись с таким Id уже существует"); } cdMaterial = new content_materials { id = material.Id, c_title = material.Title, c_alias = material.Alias, c_text = material.Text, d_date = material.Date, c_preview = (material.PreviewImage != null) ? material.PreviewImage.Url : null, c_url = material.Url, c_url_name = material.UrlName, c_desc = material.Desc, c_keyw = material.Keyw, b_important = material.Important, b_disabled = material.Disabled, n_day = material.Date.Day, n_month = material.Date.Month, n_year = material.Date.Year }; db.Insert(cdMaterial); db_updateMaterialGroups(db, material.Id, material.GroupsId); var log = new LogModel() { Site = _domain, Section = LogSection.Materials, Action = LogAction.insert, PageId = material.Id, PageName = material.Title, UserId = _currentUserId, IP = _ip, }; insertLog(log); tran.Commit(); return(true); } } } catch { return(false); } }