/// <summary> /// Edit category data /// </summary> /// <param name="?"></param> /// <param name="?"></param> /// <returns></returns> public int EditCategoryData(CategoryPlus category, IList <SubCategoryPlus> subCategoryList) { int res; using (var transaction = new TransactionScope()) { res = this._repository.EditCategory(category, subCategoryList); if (res > 0) { transaction.Complete(); } } return(res); }
/// <summary> /// Edit Category /// </summary> /// <param name="category"></param> /// <returns></returns> public int EditCategory(CategoryPlus category, IList <SubCategoryPlus> subCategoryList) { int res = 0; Sql sql; if (category.category_id > 0) { IDictionary <string, object> columns = new Dictionary <string, object>() { { "category", category.category.Trim() } , { "remarks", category.remarks } , { "display_order", category.display_order } , { "upd_date", category.upd_date } , { "upd_id", category.upd_id } , { "del_flg", category.del_flg } }; IDictionary <string, object> condition = new Dictionary <string, object>() { { "category_id", category.category_id }, { "company_code", category.company_code } }; if (Update <Category>(columns, condition) > 0) { res = category.category_id; } } else { category.ins_date = category.upd_date; category.ins_id = category.upd_id; sql = new Sql(@" INSERT INTO m_category (company_code ,category ,remarks ,display_order ,ins_date ,ins_id ,upd_date ,upd_id ,del_flg) VALUES ( @company_code, @category, @remarks, @display_order, @ins_date, @ins_id, @upd_date, @upd_id, @del_flg)" , new { company_code = category.company_code } , new { category = category.category.Trim() } , new { remarks = category.remarks } , new { display_order = category.display_order } , new { ins_date = category.ins_date } , new { ins_id = category.ins_id } , new { upd_date = category.upd_date } , new { upd_id = category.upd_id } , new { del_flg = Constant.DeleteFlag.NON_DELETE } ); if (_database.Execute(sql) > 0) { var query = "select ident_current('m_category')"; res = _database.ExecuteScalar <int>(query); } } if (res > 0) { if (!EditListSubCategory(category.company_code, res, category.upd_date, category.upd_id, subCategoryList)) { res = 0; } } return(res); }
public PMS10004EditViewModel() { CATEGORY = new CategoryPlus(); LIST_SUBCATEGORY = new List <SubCategoryPlus>(); }