public async Task <ICommandResult> Handle(Category_VariationTheme_Mapping_RemoveCommand message) { try { Category_VariationTheme_Mapping category_VariationTheme_Mapping = new Category_VariationTheme_Mapping(); category_VariationTheme_Mapping.Remove(message); await _variationThemeService.RemoveToDb(category_VariationTheme_Mapping); ICommandResult result = new CommandResult() { Message = "", ObjectId = category_VariationTheme_Mapping.Id, Status = CommandResult.StatusEnum.Sucess }; return(result); } catch (Exception e) { e.Data["Param"] = message; ICommandResult result = new CommandResult() { Message = e.Message, Status = CommandResult.StatusEnum.Fail }; return(result); } }
public async Task Remove(Category_VariationTheme_Mapping category_VariationTheme_Mapping) { await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@VariationThemeId", category_VariationTheme_Mapping.VariationTheme_Id, DbType.Int16); parameters.Add("@CategoryId", category_VariationTheme_Mapping.CategoryId, DbType.String); return(await connection.ExecuteAsync(ProcName.Category_VariationTheme_Mapping_Remove, parameters, commandType: CommandType.StoredProcedure)); }); }
public async Task Add(Category_VariationTheme_Mapping category_VariationTheme_Mapping) { DataTable table = new DataTable(); table.Columns.Add("VariationThemeId", typeof(int)); table.Columns.Add("CategoryId", typeof(string)); foreach (var item in category_VariationTheme_Mapping.VariationThemeId) { table.Rows.Add(item, category_VariationTheme_Mapping.CategoryId); } await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@DataMapping", table, DbType.Object); return(await connection.ExecuteAsync(ProcName.Category_VariationTheme_Mapping_Insert_List, parameters, commandType: CommandType.StoredProcedure)); }); }
public async Task AddToDb(Category_VariationTheme_Mapping category_VariationTheme_Mapping) { await _variationThemeRepository.Add(category_VariationTheme_Mapping); }
public async Task RemoveToDb(Category_VariationTheme_Mapping category_VariationTheme_Mapping) { await _variationThemeRepository.Remove(category_VariationTheme_Mapping); }