public void Delete(IRoleDetailModel model) { var dataAccessStatus = new DataAccessStatus(); try { using (var context = new DbContext()) { string queryStr = "DELETE FROM role_detail WHERE (role_kode = @kode AND menu_name = @parent) " + "OR (role_kode = @kode AND menu_parent = @parent)"; context.Conn.Execute(queryStr, new { kode = model.role_kode, menu = model.menu_parent, parent = model.menu_parent }); } } catch (MySqlException ex) { dataAccessStatus = SetDataAccessValues(ex, ErrorMessageType.Update); throw new DataAccessException(message: ex.Message, innerException: ex.InnerException, dataAccessStatus: dataAccessStatus); } }
public void Insert(IRoleDetailModel model) { var dataAccessStatus = new DataAccessStatus(); try { using (var context = new DbContext()) { context.Conn.Insert((RoleDetailModel)model); } } catch (MySqlException ex) { dataAccessStatus = SetDataAccessValues(ex, ErrorMessageType.Update); throw new DataAccessException(message: ex.Message, innerException: ex.InnerException, dataAccessStatus: dataAccessStatus); } }
public void Delete(IRoleDetailModel model) { _repo.Delete(model); }
public void Insert(IRoleDetailModel model) { _repo.Insert(model); }