/// <summary>
/// Новая запись
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool InsertCartCategory(CartCategoryModel item)
{
using (var db = new CMSdb(_context))
{
using (var tran = db.BeginTransaction())
{
var data = db.cart_categories
.Where(s => s.id == item.Id);
if (!data.Any())
{
var newCategory = new cart_categories()
{
id = item.Id,
f_site = _siteId,
c_name = item.Title,
c_desc = item.Desc,
b_disabled = item.Disabled,
c_icon = item.Icon,
d_date_create = DateTime.Now,
c_user_create = _currentUserId.ToString()
};
db.Insert(newCategory);
var log = new LogModel()
{
PageId = item.Id,
PageName = item.Title,
Section = LogModule.Cart,
Action = LogAction.insert,
Comment = "Добавлена новая категория"
};
InsertLog(log);
tran.Commit();
return(true);
}
return(false);
}
}
}
/// <summary>
/// Новая запись
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool UpdateCartCategory(CartCategoryModel item)
{
using (var db = new CMSdb(_context))
{
using (var tran = db.BeginTransaction())
{
var data = db.cart_categories
.Where(s => s.id == item.Id);
if (data.Any())
{
var category = data.Single();
category.c_name = item.Title;
category.c_desc = item.Desc;
category.b_disabled = item.Disabled;
category.c_icon = item.Icon;
category.d_date_create = DateTime.Now;
category.c_user_create = _currentUserId.ToString();
db.Update(category);
var log = new LogModel()
{
PageId = item.Id,
PageName = item.Title,
Section = LogModule.Cart,
Action = LogAction.update,
Comment = "Изменена категория"
};
InsertLog(log);
tran.Commit();
return(true);
}
return(false);
}
}
}
