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