/// <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);
}
}
